V
viperman67
Guest
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.
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.