8.2.1 mysql database changes

[wendy.mathis]

What are the database changes with this upgrade?

I upgraded my ples to 8.2.1 and had some difficulties. My provider tried to help but I think they just messed me up more. I am now getting an error:

Internal Plesk error occurred: MySQL query failed: Unknown column 'fastcgi' in 'field list'

and another error

Internal Plesk error occurred: MySQL query failed: Unknown column 'uid' in 'field list'

I need to know what the database structure should be in 8.2.1 or I need a utility to update my database to the correct structure.

I have almost gotten Plesk back to a worable state. I hope anyway.

 

[Amin Taheri]

try

rpm -Uvh --force --nodeps /root/swsoft/PSA_8.2.1/dist-rpm-RedHat-el4-i386/base/*.rpm

 

[wendy.mathis]

I tried running that but it would not upgrade the database. my provider rolled back my database to 8.0.1.

How can i roll back my installation to 8.0.1 and then re-upgrade?

 

[Amin Taheri]

Doing that should also then upgrade the database, since the core rpms do the database upgrade....

 

[wendy.mathis]

I have been trying to use the command that you reccomend but it is not helping. it gives me a database error.

Previous product version is 8.2.1, but previous database version is 0801. In most case it is result of previous upgrade failure. Please, restore previous version from backup, and try again or cantact technical support.

I know that that is my problem. That is exactly why i ran your command in the first place.

So how do i manually upgrade the database or how do I roll back my installation to an 8.0.1 installation so i can reinstall the whole thing?

I don't have a backup to restore as the error message suggests that i use.