When I click "EvalWF Settings" tab (...node/5/evalwf), I get:
user warning: Unknown column 'email' in 'field list' query: SELECT nid, cid, pid, form_key, name, type, value, extra, mandatory, email, weight FROM webform_component WHERE nid=5 ORDER BY pid,weight in /home/**removed**/public_html/sites/all/modules/evalwf/evalwf.class on line 671.
And when I click "EvalWF Condition" tab (...node/5/evalwf_cond), I get:
* user warning: Unknown column 'email' in 'field list' query: SELECT nid, cid, pid, form_key, name, type, value, extra, mandatory, email, weight FROM webform_component WHERE nid=5 ORDER BY pid,weight in /home/**removed**/public_html/sites/all/modules/evalwf/evalwf.class on line 671.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/**removed**/public_html/sites/all/modules/evalwf/evalwf.class on line 941.
* warning: Invalid argument supplied for foreach() in /home/**removed**/public_html/includes/form.inc on line 1429.
Using latest Webform (6.x-3.0-beta5)
Drupal 6.15
MySQL 5.0.51a
PHP 5.2.6-1+lenny3
PHP memory limit 128M
PHP register globals Off
Upload progress Enabled (PECL uploadprogress)
Web-server Apache
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | evalwf-6-1-webform6x-3x.patch | 4.35 KB | tis |
Comments
Comment #1
tis commentedThank you for your observation.
I haven't tried out my module with the new Webform yet. You should switch off warning messages until I check it up.
Comment #2
tis commentedYou need to use a patch for evalwf-6.x-1.0 if you use webform 6.x-3.x.
Comment #3
7magnus commentedI applied your patch and got this instead when I try to add a condition:
* warning: htmlspecialchars() [function.htmlspecialchars]: Invalid multibyte sequence in argument in /usr/local/pem/vhosts/122234/webspace/httpdocs/somr/includes/bootstrap.inc on line 857.
* user warning: in /usr/local/pem/vhosts/122234/webspace/httpdocs/somr/sites/all/modules/evalwf/evalwf.module on line 623.
I am using webform 6.x-3.2
Comment #4
tis commentedI can't cause this problem, please give me more info.
EvalWF version
Drupal version
PHP version
A screenshot with your datas, which cause this problem.
Thanks
Comment #5
7magnus commentedHello again!
This is one of my first post so please excuse me if I seem confused. I am not at all sure what caused my problem. The last one was probably partly because I did not run update properly. I have tried to reinstall Eval WF and the patch. Everything seems fine until I try to add a condition. Now I get this message:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fields,high,url) VALUES ( 90, 0, 1, 'a:1:{i:0;s:27:\"Total (sum of all elements)' at line 1 query: INSERT INTO evalwf_conditions (nid,weight,low,fields,high,url) VALUES ( 90, 0, 1, 'a:1:{i:0;s:27:\"Total (sum of all elements)\";}', 3, 'http://www.sture.motiverandesamtal.org/sjalvhjalp' ) in /usr/local/pem/vhosts/122234/webspace/httpdocs/somr/sites/all/modules/evalwf/evalwf.module on line 656.
I do not consider this a bug in your module but would be most thankfull for any suggestions.
evalwf 6.x-1.x-dev (latest)
drupal 6.19
MySQL-database 4.1.22
PHP 5.2.9
PHP: memory limit 128M
Comment #6
tis commentedMaybe my MySQL command isn't compatible with your MySQL version. I think, the problem comes from the auto_increment-ed field.
If you have any time, you should modify evalwf.module at line 656.
original: $query = "INSERT INTO {evalwf_conditions} (nid,weight,low,fields,high,url) VALUES ( %d, %d, %d, '%s', %d, '%s' )";
suggested: $query = "INSERT INTO {evalwf_conditions} (nid,fid,weight,low,fields,high,url) VALUES ( %d, NULL, %d, %d, '%s', %d, '%s' )";
Comment #7
7magnus commentedThanks for your suggestion. No big difference after this change:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fields,high,url) VALUES ( 90, NULL, 0, 1, 'a:1:{i:0;s:27:\"Total (sum of all ele' at line 1 query: INSERT INTO evalwf_conditions (nid,weight,low,fields,high,url) VALUES ( 90, NULL, 0, 1, 'a:1:{i:0;s:27:\"Total (sum of all elements)\";}', 3, 'http://www.sture.motiverandesamtal.org/sjalvhjalp' ) in /usr/local/pem/vhosts/122234/webspace/httpdocs/somr/sites/all/modules/evalwf/evalwf.module on line 656.
Comment #8
tis commentedI think, maybe you forgot to insert fid column among nid and weight.
suggested: $query = "INSERT INTO {evalwf_conditions} (nid,fid,weight,low,fields,high,url) VALUES ( %d, NULL, %d, %d, '%s', %d, '%s' )";
Comment #9
7magnus commentedHello again!
I tried your suggestion in #8 but no difference. I have worked on other solutions for a while but now I wanted to give this another try.
I have made a fresh install of drupal with only webform and your module. New database. Aplied your patches....
And I get the same problem :(
This is what it says:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fields,high,url) VALUES ( 1, 0, 3, a:1:{i:0;s:27:\"Total (sum of all elements)\"' at line 1 query: INSERT INTO evalwf_conditions (nid,weight,low,fields,high,url) VALUES ( 1, 0, 3, a:1:{i:0;s:27:\"Total (sum of all elements)\";}, 6, 'http://www.alkoholprofilen.se/' ) in /usr/local/pem/vhosts/122234/webspace/httpdocs/virtuell/sites/all/modules/evalwf/evalwf.module on line 656.
all the values look fine exept the one for fields:
a:1:{i:0;s:27:\"Total (sum of all elements)\";}
that does not look right to me.
Could I do anything about it? I really would like this to work!
Comment #10
tis commented