Upgrading to 2.0.25 admin error... Database?

[SWH Support]

I ran the upgrade script just fine and it seemed to update the database.

But now I have the following text on my main page

To modify the content of this page, go to the admin panel and click on the Catalog link. Then click on the Define MainPage link. It will open a wysiwyg editor where you can easily add new content.
------------------------------------------------------------
This is osCMax v2.0.25, the power e-commerce shopping cart system.

The official osCMax Support Site is osCMax - osCommerce Maximized | osCmax shopping cart software . There are very active support forums, the documentation, downloads, and everything else related to osCMax.


and the admin area wont log me in. I have the correct username (which is an email address) and password. When I login it gives me the following error.

1054 - Unknown column 'admin_username' in 'field list'

select admin_id as login_id, admin_groups_id as login_groups_id, admin_username as login_username, admin_password as login_password, admin_modified as login_modified, admin_logdate as login_logdate, admin_lognum as login_lognum from admin where admin_username = 'bersh31@hotmail.com'

[TEP STOP]


Upon further investigation I looked at the database and I only have these Colums.

admin_id admin_groups_id admin_firstname admin_lastname admin_email_address admin_password admin_created admin_modified admin_logdate admin_lognum

Obviously I didn't paste the values. But it never references a username... Just the email.

Did I miss something during the upgrade?

[michael_s]

What version are you upgrading from? 2.0 stable? 2.0.15? Older than 2.0 stable (like RC3, etc...).

[SWH Support]

I want to say it was 2.0 stable. May have been 2.15 but I'm leaning more towards 2.0. Wish I could go back and check

[michael_s]

If you made a backup as is recommended before doing upgrades, you can go back and check. You did make a backup, right?

Ok, Assuming 2.0 stable, it looks like something was missed in your admin upgrade. You may need to manually update the structure and data for your admin table.


Having the default main page text means you overwrote your custom main page text. If you have a backup, you can just replace the main page file with your backup to resolve that.

[SWH Support]

Ok, Assuming 2.0 stable, it looks like something was missed in your admin upgrade. You may need to manually update the structure and data for your admin table.

How would I go about doing that?

[SWH Support]

Does anybody know the answer? My site is pretty much broke until this gets a answer

[michael_s]

Manually modify your admin table to have the correct fields. Look at the upgrade .sql file and find the query that updates the admin table and manually make the changes using phpmyadmin or other mysql gui front-end (or the command line if you know how). Add the missing columns and make any other changes that are needed.

Once you have all the columns in place check to see that whatever admin users you have records for have all the fields filled in properly except for the password. Then note the username (if none is present, add one via phpmyadmin). Then go to your admin login screen and use the "Forgot Password" dialog to have a new password generated and issued to you. Once you get the new password, login and get back to work.

[SWH Support]

Manually modify your admin table to have the correct fields. Look at the upgrade .sql file and find the query that updates the admin table and manually make the changes using phpmyadmin or other mysql gui front-end (or the command line if you know how). Add the missing columns and make any other changes that are needed.

Once you have all the columns in place check to see that whatever admin users you have records for have all the fields filled in properly except for the password. Then note the username (if none is present, add one via phpmyadmin). Then go to your admin login screen and use the "Forgot Password" dialog to have a new password generated and issued to you. Once you get the new password, login and get back to work.

That all sounds great, but I can't seem to figure out how to insert the extra column. I redid the upgrade and the same thing happens to where there is no admin_username field in the database.

Can you give me more detailed instructions on how to update the database?