Hi all,
I was trying to upgrade my system from 4.0.1 to 4.2.2 with an automated upgrade script, but I get an error on the 4.0.4 upgrade. The error I am getting is:
Run script: Update the suite database table
ERROR /usr/bin/php '/home/websites/mysource_matrix/packages/squiz_suite/scripts/upgrade_suiteid.php' '/home/websites/mysource_matrix' returned error code 255
Can anyone help?
Thanks,
Anton.
This script is supposed to be run only from 4.0.3 => 4.0.4
Are you sure it gets run from 4.0.1 => 4.0.2?
Is there anything is the Matrix error log? data/private/conf/error.log
What happens when you try to execute the script directly?
The upgrade steps for 4.0.1 to 4.0.2 is all defined in this file under automatic upgrade directory, can you check if it looks same as the file I attached?
defs/4-0-1_to_4-0-2.xml
4-0-1_to_4-0-2.xml (1.56 KB)
Hi Edison,
Thank you for your reply.
Yes, the XML is identical.
I did manage to successfully upgrade from 4.0.1 to 4.0.3 using the script.
upgrade_suiteid.php doesn't exist in 4.0.3, so it is a little hard to test.
There is something interesting happening now as well. I am getting cron deadlocks on "Sync Squiz Suite Products Cron Job". Looking at the cron log I think I may have a few columns missing in the database:
[08-May-2011 06:45:04] PHP Fatal error: Uncaught exception 'DALException' with message 'SQLSTATE[42703]: Undefined column: 7 ERROR: column p1.is_current does not exist
LINE 2: p1.systemid, p1.type, p1.status, p1.is_current, p1.conne…
^' in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc:658
Stack trace:
#0 /home/websites/mysource_matrix/core/lib/DAL/DAL.inc(234): DAL::executePdoAssoc(Object(PDOStatement), NULL)
#1 /home/websites/mysource_matrix/core/lib/MatrixDAL/MatrixDAL.inc(150): DAL::getAssoc(Object(Query), NULL)
#2 /home/websites/mysource_matrix/packages/squiz_suite/suite_manager/suite_manager.inc(342): MatrixDAL::executeAssoc('squiz_suite_pac…', 'getCurrentProdu…', Array)
#3 /home/websites/mysource_matrix/packages/squiz_suite/cron_jobs/cron_job_sync_suite_products/cron_job_sync_suite_products.inc(165): Suite_Manager->getCurrentProduct()
#4 /home/websites/mysource_matrix/core/assets/system/cron/cron_job/cron_job.inc(597): Cron_Job_Sync_Suite_Products->_exec('')
#5 /home/websites/mysou in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc on line 658
Maybe the upgrade failure is related to the missing columns. A bit stuck now.
[quote]
This script is supposed to be run only from 4.0.3 => 4.0.4
Are you sure it gets run from 4.0.1 => 4.0.2?
Is there anything is the Matrix error log? data/private/conf/error.log
What happens when you try to execute the script directly?
The upgrade steps for 4.0.1 to 4.0.2 is all defined in this file under automatic upgrade directory, can you check if it looks same as the file I attached?
defs/4-0-1_to_4-0-2.xml
[/quote]
OK!
I have figured out which columns were missing. There were 3 added in the 4.0.1 upgrade and I didn't add ; at the end of the alters so they were not created.
Once I added the 3 missing columns the upgrade went fine and I am now on 4.2.2!