Task for upgrade APS 1.2 Application
osCommerce(Site Application) failed with error, like:
`ALTER TABLE `customers_info` CHANGE `password_reset_key` `password_reset_key` char(40) COLLATE utf8_unicode_ci NULL after `global_product_notifications` , ENGINE=InnoDB, DEFAULT CHARSET='utf8' ): Unknown column 'password_reset_key' in 'customers_info'`
Note: The mentioned error could appear in case of upgrade
osCommerce, for example, from version
password_reset_keydoes not contain column
password_reset_keyif check it with database client. For example:
mysql> DESC `customers_info` customers_info_id int(11) NO PRI NULL customers_info_date_of_last_logon datetime YES NULL customers_info_number_of_logons int(5) YES NULL customers_info_date_account_created datetime YES NULL customers_info_date_account_last_modified datetime YES NULL global_product_notifications int(1) YES 0
Package vendor issue. Required SQL routines are missing for upgrade from particular
osCommerce versions to latest available.
- Connect to
osCommerceMySQL database as DB owner/MySQL administrator.
Alter database structure with following queries:
alter table customers_info add password_reset_key char(40); alter table customers_info add password_reset_date datetime;
- Restart failed task for upgrade application instance from Provider Control Panel >
Please, contact Plesk to resolve the issue completely.