Fatal error on running upgrade.php in 1.8

I have successfully upgraded to elgg 1.8b1, but there is a problem: Whenever I run upgrade.php, it says:

Fatal Error.

There were a number of issues: Duplicate column name 'time_created'

QUERY: ALTER TABLE `elgg_entity_relationships` ADD COLUMN `time_created` int(11) NOT NULL AFTER `guid_two`;;

---------------------

Although, when I return back to my site, the site seems upgraded.

  • What version are you upgrading from?

  • I also just experienced a fatal error on a upgrade. I upgraded a 1.7.4 site to 1.7.9 and then to 1.8.0 and got this error:

    Fatal Error.

    Duplicate column name 'admin'

    QUERY: ALTER TABLE elgg_users_entity ADD admin ENUM('yes', 'no') NOT NULL DEFAULT 'no' AFTER `banned`

     

    The version listed in db after the 2nd upgrade is 2010033101.

    The processed_upgrades in the db are a:8:{i:0;s:14:"2008100701.php";i:1;s:14:"2008101303.php";i:2;s:14:"2009022701.php"; i:3;s:14:"2009041701.php";i:4;s:14:"2009070101.php";i:5;s:14:"2009102801.php"; i:6;s:14:"2010010501.php";i:7;s:14:"2010033101.php";}

    The version before the 1.7.4 to 1.7.9 upgrade was 2010071002. I did not check the version in the db after the 1.7.9 upgrade.

    I think we're going to need a ticket on this and we need to hear from anyone else who experienced a problem upgrading from 1.7.x to the 1.8 beta.

  • I didn't check the ver numbers but I did what Cash did. I upgraded from 1.7.6 to 1.7.9 then to 1.8b. Got the same fatal error. I Can dig up more info it helps

  • I just created a ticket for this: http://trac.elgg.org/ticket/3554

    Please report problems there. Relevant info to report is:

    • Upgrade from version
    • The value processed_upgrades in the elgg_datalists table after the failed upgrade
    • The value version in the elgg_datalists table after the failed upgrade.
    Thanks!
Feedback and Planning

Feedback and Planning

Discussions about the past, present, and future of Elgg and this community site.