• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

8.2.1 mysql database changes

W

wendy.mathis

Guest
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.
 
try

rpm -Uvh --force --nodeps /root/swsoft/PSA_8.2.1/dist-rpm-RedHat-el4-i386/base/*.rpm
 
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?
 
Doing that should also then upgrade the database, since the core rpms do the database upgrade....
 
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.
 
Back
Top