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

CommentFileSizeAuthor
#2 evalwf-6-1-webform6x-3x.patch4.35 KBtis

Comments

tis’s picture

Thank 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.

tis’s picture

Status: Active » Needs review
Issue tags: +webform6x-3x
StatusFileSize
new4.35 KB

You need to use a patch for evalwf-6.x-1.0 if you use webform 6.x-3.x.

7magnus’s picture

I 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

tis’s picture

Status: Needs review » Postponed (maintainer needs more info)

I 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

7magnus’s picture

Version: 6.x-1.0 »
Priority: Critical » Normal

Hello 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

tis’s picture

Maybe 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' )";

7magnus’s picture

Thanks 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.

tis’s picture

I 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' )";

7magnus’s picture

Hello 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!

tis’s picture

Version: » 6.x-1.0
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (outdated)