Error message:

* user warning: Unknown column 'Pogo' in 'field list' query:
INSERT INTO profile_values (fid,uid,value) VALUES (2,3,Abc)

Doesn't the text listed in VALUES( ) need single quotes: VALUES (2,3,'Abc') ?

And, thank you for sharing this module. The function will be useful for our volunteer organization's web site.

Comments

Ashford’s picture

Ashford commented

Repeat, due to error in my typing. By the way, I am using Token values for the entry.

Error message:

* user warning: Unknown column 'Abc' in 'field list' query:
INSERT INTO profile_values (fid,uid,value) VALUES (2,3,Abc)

Doesn't the text listed in VALUES( ) need single quotes: VALUES (2,3,'Abc') ?

mr.andrey’s picture

mr.andrey commented

It probably does need quotes. Here's how I use it on our store: http://drupal.org/node/299478. "value" there stands for the field, so no need of quotes, but if you're using a specific value, you probably do need them.

Best,
Andrey.

Ashford’s picture

Ashford commented

Hi there, Andrey. I appreciate your quick reply. I tried it with the double and single quotes and it tossed out another error. Maybe there is another process to add when using Tokens?

Entered the Operation and Default Value as a CCK text token, with the single quotes.

'[node:field_app_fname-raw]'

The quotes produced the error:

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 '\'Joe\')' at line 1 query:

INSERT INTO profile_values (fid,uid,value)
VALUES (1,5,\'Joe\')

in C:\wamp\www\drupal\includes\database.mysqli.inc on line 156.

mr.andrey’s picture

mr.andrey commented

Ah, now I get what you're trying to do. You need the actual token value to be enclosed in the quotes.

Hmm... not sure about that. Maybe there's a drupal syntax for not escaping the quotes?