trying to run an SQL patch, doesn't work.

[mohinder]

i'm trying to install a module that requires an SQL file to be run.

i copy and pasted all the SQL text into the box of the SQL upgrade form, and i got this message:

Not Acceptable

An appropriate representation of the requested resource /store/admin/sqlpatch.php could not be found on this server.

any ideas?

[kobra]

OK so we know that you are trying to run a sql patch for a module...

How about the detail as to what module?
What version of the module?
What version of Zen Cart?
What program you are using to open the file to copy from?

[mohinder]

OK so we know that you are trying to run a sql patch for a module...

How about the detail as to what module?
What version of the module?
What version of Zen Cart?
What program you are using to open the file to copy from?

using this: http://www.zen-cart.com/index.php?ma...products_id=77

latest version

zen cart version: 1.37
i'm using notepad to open the SQL file. i just pasted the text into the box..

[kobra]

I just ran this on a clean 1.3.7 install from the admin and pasted it from notepad
and got this result:

Query Results:
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:
Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3', 'Select the number of columns of products to show in each row in the product listing. The default setting is 3.', '8', '41', NULL, now(), NULL, NULL);

Or Success!!!

You might try using the browse to the file and an upload over the paste and see if this is more successful for you...

Alternatively, redownload the mod and try another copy of the file as there might have been a glitch when you downloaded it...it is not the file or the sql itself.

[mohinder]

ok i tried redownloading it, still doesn't work

i tried uploading the SQL file and this is what i got:
1062 Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 2
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:
Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[kobra]

OK- duplicate entry so something got loaded & does not want to load again....

Did you do a backup before this? If so restore this back to where you were and try again

[mohinder]

OK- duplicate entry so something got loaded & does not want to load again....

Did you do a backup before this? If so restore this back to where you were and try again

i got a backup from PHPmyadmin..

[kobra]

You can also run this patch from phpmyadmin

[DrByte]

Not Acceptable

An appropriate representation of the requested resource /store/admin/sqlpatch.php could not be found on this server.

This is a result of security settings on your hosting server being set to prevent you from running potentially dangerous SQL commands via web pages.

The fastest way to work around this, if your hosting configuration doesn't object, is to edit the /admin/.htaccess file and insert just this line, at the end of the file:

SecFilterEngine off

This bypassess all the security protections for any script running from your admin area.