Problem with php script using webform_get_submission() after upgrade to webform-6.x-2.1

Hi again,

Now I am in a real mess!

I downgraded from webform-6.x-2.1 to webform-6.x-2.0-beta6 and for a while everything (including my php script wf.php) worked fine. Then I tried to upgrade some other modules, primarily cck. This upgrade had nothing to do with my previous webform upgrade attempt. I just wanted to do an upgrade of some of the modules which I had not upgraded for quite some time. The upgrade of cck did not work at all (update.php gave lots of errors which I unfortuenatly did not record). I changed back to the previous version of cck but then when I run update.php I get this fatal error regarding webform:

------------------------------------------------------------------------------------------------
Updating

An unrecoverable error has occurred. You can find the error message below. It is advised to copy it to the clipboard for reference.
Please continue to the error page
An error occurred. http://example.com/update.php?id=25&op=do
Fatal error: Call to undefined function _system_update_utf8() in /var/www/drupal/sites/all/modules/webform/webform.install on line 362

------------------------------------------------------------------------------------------------

I cannot find any function system_update_utf8() anywhere in the drupal directory on the server.
The error page mentioned in the message above contains this:

------------------------------------------------------------------------------------------------
Drupal database update

The update process was aborted prematurely while running update #3 in webform.module. All errors have been logged. You may need to check the watchdog database table manually.
------------------------------------------------------------------------------------------------

There is also logged entries with errors most likely related to this problem:

------------------------------------------------------------------------------------------------
Unknown column 'ws.name' in 'field list' query: SELECT ws.nid, ws.sid, wc.cid, ws.name, ws.data FROM webform_submitted_data ws, webform_component wc WHERE ws.nid = wc.nid AND ws.name = wc.name in /var/www/drupal/sites/all/modules/webform/webform.install on line 310.
------------------------------------------------------------------------------------------------

and

------------------------------------------------------------------------------------------------
Table 'webform_submissions' already exists query: CREATE TABLE webform_submissions ( nid int(10) unsigned NOT NULL default '0', sid int(10) unsigned NOT NULL default '0', submitted int(11) NOT NULL default '0', PRIMARY KEY (nid, sid) ) in /var/www/drupal/sites/all/modules/webform/webform.install on line 332.
------------------------------------------------------------------------------------------------

Now I have lost all webform submissions. They might still be in the system if I can run update.php without any errors, but I have no idea how to solve my problem. Please help!

JN

Hi again,

I recovered by reverting to a drupal/mysql setup as it was before I tried to update the webform-6.x-2.1. We are now back online with everything working as before.

At some point I would like to install the latest version of the webform module. I will post a new message then, if my php script for making a table of the webform submissions still does not work.

JN

Hi,

For security reasons I had to upgrade to drupal-6.4 and then I also decided to upgrade all the installed contributed modules, including webform. I am now using webform-6.x-2.1.3. I still have the same problem with my php script (attached as wf.php_.txt in my first posting. If you have time please have a look at the script and tell me how I should modify it to produce the table of the webform submissions.

JN

Hi,

This issue is still unsolved. Please help...

JN

I'm sorry to bug you again with this, but I cannot solve the problem myself. Can you give me some advice how to try to fix it?

JN