• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Upgrading from 9.2.3 to 10.1.1

Problem after same upgrade (9.2.3 to 10.1.1) Must get fixed!!!

We have done the knowledgebase "fix" and yet after all that still receive:

Error
Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

When trying to view Domains, Subscriptions, or Customers,
In addition we get an "Internal Error" when trying to add a new reseller.

Here is relevant output (truncated) of LAST bootstrapper.sh repair (shows everything ok - but it is NOT ok!)


root:/usr/local/psa/bootstrapper/pp10.10.1-bootstrapper> ./bootstrapper.sh repair

**** Product repair started.

Trying to start service mysqld... done
Checking for the system groups and users necessary for Apache...
Checking for the group 'apache'...
Group 'apache' already exists

Checking for the user 'apache'...
User 'apache' already exists


===> Checking for the necessary system accounts
Checking for the system groups and users necessary for MySQL...
Checking for the group 'mysql'...
Group 'mysql' already exists

Checking for the user 'mysql'...
User 'mysql' already exists

Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'apache'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists


===> Preparing upgrade
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.10.1-10.10.1.20110203-120717.dump.gz
Stopping psa... done
Stopping mail handlers tmpfs storage
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

Create PPSB support group
Checking for the group 'psasb'...
Group 'psasb' already exists

Checking for the group 'psasb'...
Trying to add supplementary group 'psasb' for user 'psaadm'... already there
Checking for the group 'psasb'...
Trying to add supplementary group 'psasb' for user 'apache'... already there
psa is stopped
Stopping psa... done
Stopping mail handlers tmpfs storage

===> Performing safe prep-install database actions

===> Checking MySQL DB consistency
They all say OK (truncated for post)

===> Upgrading database

Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to find psa database... version is 010101
Version is OK, no need to create psa database.
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.10.1-10.10.1.20110203-120718.dump.gz
===> Cumulative database upgrade has been started
===> Upgrade completed.
Trying to set psa database version to 010101... Warning: there are no bootstrapper prep_install actions for component 'horde'
===> Installing psa database
Trying to start service mysqld... done
Trying to define valid mysql credentials... Trying to establish test connection... connected
done
Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to check psa database... Trying to find psa database... version is 010101
Version is OK, no need to create psa database.
I: nothing to change in /etc/my.cnf
Trying to restart service mysqld... Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
done
Trying to insert Hostname to the MySQL database... done


Congratulations!
All stages of the upgrade were successful.
psa is now running on your system.
To complete the system configuration process, please proceed to URL:
https://xxxxx.xxxxxxxx.com:8443/ or
https://<deleted>8443/
Use 'admin' and '<YOUR ADMIN PASSWORD>' as login name and password.

Further, use the following commands to start and stop the system:
/etc/init.d/psa start and
/etc/init.d/psa stop respectively.


**** Product repair completed successfully.
 
I could fix this issue by dropping table Subscriptions from the psa database and re-creating it. Sql statement for this table is provided in /usr/local/psa/bootstrapper/pp10.10.1-bootstrapper/db/psa_db.sql, this recreates table with missing 'custom' and 'uuid' fields.
 
Catastrophe, but solved.

I could fix this issue by dropping table Subscriptions from the psa database and re-creating it. Sql statement for this table is provided in /usr/local/psa/bootstrapper/pp10.10.1-bootstrapper/db/psa_db.sql, this recreates table with missing 'custom' and 'uuid' fields.

Catastrophe! I migrated from Suse 10.3 Plesk 5.4 to Plesk 10.1. Took me 2 days. I'll never do this again and I hope that there are soon other products in the market. More or less I had to delete some PSA modules with YAST and then install new. The migration process started automatically with errors, of course. One of the last thing I had to do was inserting two more fields in the table Subsrciptions in order to make the Panel work.

Thanks a lot to the editor of the message above, which finally brought me on the right way.
 
Hi Igor, please can you help ? i try this http://kb.parallels.com/en/9330

in the first step-- on change the passwor appears this error : Specified column "imNumber" is not in the row

but my password does not have any +, so i pass to the second step, but nothing happens when i run : /usr/local/psa/bootstrapper/pp10.9.0-bootstrapper/bootstrapper.sh repair

and i dont know how to apply hotfix ... the instructions are to apply to this path: $PRODUCT_ROOT_D/admin/smb/application/library/Smb/Application/Cli/DbManager.php

but i did not have the Cli directory..

what can i do?

thanks


EDIT: PLEASE TELL ME STEP BY STEP, HOW CAN I DO THIS :

I could fix this issue by dropping table Subscriptions from the psa database and re-creating it. Sql statement for this table is provided in /usr/local/psa/bootstrapper/pp10.10.1-bootstrapper/db/psa_db.sql, this recreates table with missing 'custom' and 'uuid' fields.
 
Last edited:
Back
Top