visible_countries - no good SQL?

[HelleM]

Hi

This is the error I get when trying to run the SQL in PHP admin. I have NO clue what's wrong:

Helle :-(

 

 

Error

SQL-forespørgsel:

 

INSERT INTO configuration(

 

configuration_title,

configuration_key,

configuration_value,

configuration_description,

configuration_group_id,

sort_order,

set_function,

date_added

)

VALUES (

'Local Country Names', 'COUNTRY_LOCALNAME', 'false', 'Local Country

 

Names on create_account?<br><br>e.G.<br>Deutschland instead of Germany<br>Sverige instead of Sweden', '1', '30', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( )

);

 

 

 

MySQL returnerede:

 

#1064 - 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 'der,set_function, date_added) VALUES ('Local Country Names', 'C

[HelleM]

Solution

 

I had by accident deleted a country in the countries table. Reentered it - opened PHPAdmin and changed the country ID to what it was originally - then the SQL worked....

 

Just to let others know in case you are having the same SQL problem

 

Helle :-)