MySQL and phpMyAdmin

[Guest]

I am trying to install the non-members checkout contribution in OSC.

Heres my problem ....I am a complete newbie with MySQL and phpMyAdmin

First i open my database with phpMydmin and in the left side column i click on configuration to insert:

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow NonMember Checkout', 'NON_MEMBER_OK', 'False', 'Allows Non Members to use checkout features','1','19', 'tep_cfg_select_option(array('true', 'false'), ', now());

 

and this is what i get after i click on the GO button:

Error



SQL-query :  



( 



configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added

) VALUES ( 

'Allow NonMember Checkout', 'NON_MEMBER_OK', 'False', 'Allows Non Members to use checkout features', '1', '19', 'tep_cfg_select_option(array('true', 'false'), ', now( ) 

) 



MySQL said: 





You have an error in your SQL syntax near '(configuration_title, configuration_key, configuration_value, configuration_desc' at line 1





Back

 

What is wrong with MySQL or probably ....what am I doing wrong ?

 

Regards

[mattice]

you are missing a part of the query... needs to say

insert into tablename:

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow NonMember Checkout', 'NON_MEMBER_OK', 'False', 'Allows Non Members to use checkout features','1','19', 'tep_cfg_select_option(array('true', 'false'), ', now());

[Guest]

Thanks Mattice worked like a charm :D

 

Regards