I'm having trouble installing the under construction page to my store. I'm trying to follow this contribution instructions: http://addons.oscommerce.com/info/2424
It says to do the following:
:thumbsup: insert to your mysql database with PHPMyADMIN or whatever you prefer
this line:
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', '<b>Under Construction Pages</b>', 'UNDER_CONSTRUCTION_PAGES', 'account, advanced_search.php', 'Set the filenames of the files that will be under construction for the public, seperate them by \'<b>, </b>\' (without quotes)<br>Example:<br>checkout, advanced_search.php', 1, 100, NULL, now(), NULL, '');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Under Construction Pages<br><b>Admin IP</b>', 'ADMIN_ACCESS_IP', '0.0.0.0', 'This IP gives still access to the Locked Pages. Enter your IP address.', 1, 100, now(), now(), NULL, NULL); <_<
I'm familar with how to upload databases using my myphpadmin, but I'm inexperienced when it comes to adding lines to the databases. Can someone do a quick step-by-step on how to insert the above in to my configuration file?
I gave it a try, but failed... Basically what i did was logged into myphpadmin, clicked on configuration, clicked SQL, copied and paste the code above, and clicked Go. see attachment
this is the error msg i received:
Error
SQL query:
SELECT*
FROM`configuration`
WHERE 1
INSERTINTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES (
'','<b>Under Construction Pages</b>','UNDER_CONSTRUCTION_PAGES','account, advanced_search.php','Set the filenames of the files that will be under construction for the public, seperate them by \'<b>, </b>\' (without quotes)<br>Example:<br>checkout, advanced_search.php', 1, 100,NULL , now() ,NULL ,''
);
MySQL said:
#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 'INSERT INTO configuration (configuration_id, configuration_title, configuration_' at line 2