D7.0.7 Upgrade error "`sys_acl_levels`"

I am getting this error when running upgrade script:

"7.0.6-7.0.7 upgrade can be applied

ALTER TABLE `sys_acl_levels` ADD `Order` int(11) NOT NULL default '0';: Duplicate column name 'Order'"

I cannot proceed beyond this point.

Any advice would be appreciated!

Stuart

Well the duplicate column it is complaining about is not suppose to be in sys_acl_levels is not suppose to be there yet the upgrade script says it is. So perhaps one of your mods added this field.

So to fix, edit the database with phpMyAdmin. Go to the table sys_acl_levels and remove the Order column.

How do I remove the order column?

Open phpMyAdmin. Open your dolphin database. On the left side click the table sys_acl_levels

That will show you the structure of the table. On the right windows under the field column go down to where it says Order and click the red x on that same line. If will ask you to confirm that you want to remove that field. So read it and may sure it's the right one before you confirm.

Hello Deano, This is a column as opposed to a row, there is no red x. See attached jpg.

You need to navigate to phpMyAdmin > Database > Structure to edit the actual table structure.

Got it! Excellent.

Many thanks for your help guy's!!

Stuart

Sorry. Gues there are differences in the versions of phpMyAdmin.

My version opens the structure the moment i select the table.

Upgrade went real smooth :-)

Now I will have to check everything and do a few code updates...

Many thanks Deano and Nathon!

Stuart

Different problem. Please make a new topic.

So I get an error message "ALTER TABLE `sys_acl_levels` ADD `Order` int(11) NOT NULL default '0';: Duplicate column name 'Order'"

I go into the phpmyadmin and drop the order table. I click upgrade again, and the order table comes back again in the DB. For some reason everytime i drop the order column, its keeps re-adding it back in everything i re-try to run the upgrade script.