Step01 and step02 seem to run fine, I'm getting a fatal error running step03.
The script gets as far as:
...
Installing Package_Manager_CMS:
0 => cron_job_manage_pending_accounts
1 => cron_job_manage_incomplete_submissions
2 => listing_engine
...
...
29 => report_asset_statuses
30 => form_submission
UPGRADING FORM SUBMISSION FROM 0.7
------------------------------------
Updating Form Submissions...
------------------------------------
+----------------------------------------------------------------------+
| PHP Warning |
|----------------------------------------------------------------------|
| File : [SYSTEM_ROOT]/packages/cms/form/form_section/form_section.inc |
| Line : 537 |
|----------------------------------------------------------------------|
| Invalid argument supplied for foreach() |
+----------------------------------------------------------------------+
dav/25/nov</....
*full form submission*
And in error.log:
[2010-03-30 15:15:47][12:Root User][2:php warning][R] (/packages/cms/form/form_section/form_section.inc:537) - Invalid argument supplied for foreach()
[2010-03-30 15:15:47][12:Root User][2:php warning][R] (/packages/cms/form/form_section/form_section.inc:537) - Invalid argument supplied for foreach()
[2010-03-30 15:15:47][12:Root User][2:php warning][R] (/packages/cms/form/form_section/form_section.inc:537) - Invalid argument supplied for foreach()
[30-Mar-2010 14:15:48] PHP Fatal error: Call to a member function getXML() on a non-object in /www/mysource_matrix_upgrade_ref/packages/cms/form/form/form.inc on line 2724
I am able to run the form cleanup script with the delete option and it completes without error.
I began to delete submissions, and then delete all submissions for the forms they were linked to, but step03 just finds the next 'broken' submission to crash on. There doesn't seem to be anything wrong with the submissions that break.
The 'upgrading form submissions' part also takes a long time, we do have heaps of submissions, but it blows out the upgrade time. Is it possible to run the upgrade form submissions part separately?
I began to delete submissions, and then delete all submissions for the forms they were linked to, but step03 just finds the next 'broken' submission to crash on. There doesn't seem to be anything wrong with the submissions that break.
The 'upgrading form submissions' part also takes a long time, we do have heaps of submissions, but it blows out the upgrade time. Is it possible to run the upgrade form submissions part separately?
[/quote]
Just check if the submission has the answers to questions that do not exist on your system. There has been a similar problem (which was fixed on 3.24.3) which could be what you are experiencing, but that is the only thing I can think of.
Thanks Ben. Yeah I think some do have incorrect answers, but some were fine. It seems pretty difficult to be able to proactively find all of these before running step_03? 28,000 submissions.
in Step_03 the 'Updating Form Submissions…' took almost 3 hours in the last run, I can't tell what it was doing and it didn't look like much was happening in the DB. Does this seem right?
[quote]
Yeah I think some do have incorrect answers, but some were fine. Itseems pretty difficult to be able to proactively find all of thesebefore running step_03? 28,000 submissions.
[/quote]
The upgrade should take care of incorrect answers if you are on 3.24.3. Maybe check the version of form_submission_management.inc matches the version in public-cvs for 3.24.3. Other than that it could be another problem very similar. If it is too much trouble, you try contacting Squiz Support for further help.
[quote]
in Step_03 the 'Updating Form Submissions…' took almost 3 hours in the last run, I can't tell what it was doing and it didn't look like much was happening in the DB. Does this seem right?
[/quote]
Yeah, it can take a while if you have a lot of form submissions.
