Jump to content
Sign in to follow this  
pammydee

Help with Dynamic Template System by FoxP2

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 by pammydee

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

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 by pammydee

Share this post


Link to post
Share on other sites

Thank you for your help! I truly appreciate your time. I reposted this thread link in the add-on support thread as you suggested.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×