pammydee Posted September 20, 2012 Share Posted September 20, 2012 Please forgive my ignorance....I downloaded and installed the Dynamic_Template_System_V2_EN, and immediately stumbled on the first instruction: ♦ Step 1 : Execute SQL-en.sql file in php-my-admin. Being unsure of how to do this, I uploaded the SQL-en.sql file to by osc database. All attempts to run sql query resulted in errors. I went ahead followed the rest of the instructions in the contributions. When I go to my store I get HTTP 500 error. Initally I just received a blank page-now the error is showing. Apparently I am the only 'dummy' to this because the support thread for this download shows no one with this issue. Your help will be greatly appreciated. Sincerely, Pam Quote Link to comment Share on other sites More sharing options...
pammydee Posted September 20, 2012 Author Share Posted September 20, 2012 (edited) i would like to update my sql query error code i am now getting this: There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 190 STR: \\\ SQL: INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `set_function`) VALUES (\\\'display in pages.\\\', \\\'MODULE_BOXES_BEST_SELLERS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_CATEGORIES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_CURRENCIES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_INFORMATION_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_LANGUAGES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_MANUFACTURER_INFO_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_MANUFACTURERS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_ORDER_HISTORY_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_PRODUCT_NOTIFICATIONS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_REVIEWS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SEARCH_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SHOPPING_CART_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SPECIALS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_WHATS_NEW_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'# SQL query: INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `set_function`) VALUES (\\\'display in pages.\\\', \\\'MODULE_BOXES_BEST_SELLERS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_CATEGORIES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_CURRENCIES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_INFORMATION_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_LANGUAGES_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_MANUFACTURER_INFO_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_MANUFACTURERS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_ORDER_HISTORY_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages#\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_PRODUCT_NOTIFICATIONS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_REVIEWS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SEARCH_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SHOPPING_CART_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_SPECIALS_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'#, #\\\'display in pages.\\\', \\\'MODULE_BOXES_WHATS_NEW_DISPLAY_PAGES\\\', \\\'all\\\', \\\'select pages where this box should be displayed. \\\', 6, 0, \\\'tep_cfg_select_pages(\\\'# 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 '\\\'display in pages.\\\', \\\'MODULE_BOXES_BEST_SELLERS_DISPLAY_PAGES\\\', \\\'' at line 2 Edited September 20, 2012 by pammydee Quote Link to comment Share on other sites More sharing options...
multimixer Posted September 20, 2012 Share Posted September 20, 2012 Where are all that slashes (///) coming from? Did you open the .sql file in anything else than a plain text editor? Download a fresh sql file and go on as follows - open phpMyAdmin - select your database - click "import" on top - press the "choose file" button and select the sql file on your computer - press "go" Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
pammydee Posted September 20, 2012 Author Share Posted September 20, 2012 (edited) That is exactly what I originally did. I never opened the file in any program, I only imported to db and pressed go. I repeated the process, the results are.. Inserted rows: 15 Inserted row id: 375 (Query took 0.0119 sec) in the next box- Run SQL query on database/databases: is shows like this... INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `set_function`) VALUES (\'display in pages.\', \'MODULE_BOXES_BEST_SELLERS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_CATEGORIES_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_CURRENCIES_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_INFORMATION_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_LANGUAGES_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_MANUFACTURER_INFO_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_MANUFACTURERS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_ORDER_HISTORY_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_PRODUCT_NOTIFICATIONS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_REVIEWS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_SEARCH_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_SHOPPING_CART_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_SPECIALS_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\'), (\'display in pages.\', \'MODULE_BOXES_WHATS_NEW_DISPLAY_PAGES\', \'all\', \'select pages where this box should be displayed. \', 6, 0, \'tep_cfg_select_pages(\') Do i press GO again to run query? The first time I attempted this I DID press GO to run query and received the error (as posted above) Edited September 20, 2012 by pammydee Quote Link to comment Share on other sites More sharing options...
multimixer Posted September 20, 2012 Share Posted September 20, 2012 Well, fact is that the slashes are causing the issue, maybe better you post in the addons support topic Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
pammydee Posted September 20, 2012 Author Share Posted September 20, 2012 Thank you for your help! I truly appreciate your time. I reposted this thread link in the add-on support thread as you suggested. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.