Column layout grid install problem

[majyk]

I am running Zen Cart 1.3.7,PHP Version 4.4.2, phpMyAdmin - 2.9.0.2, MySQL client version: 4.1.10 and Server version: 4.0.27-standard

When I try to run the sql script to install it gives me this error message:

Error
SQL query:

## The following can be run via phpMyAdmin, or by Admin->Tools->Install SQLPatch:
## The following is used only to remove this mod:
#delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');
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:<br />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"),'
);


MySQL said:

#1146 - Table 'treasure_zc1.configuration' doesn't exist


Help and thanks!

[kuroi]

Would I be right in thinking that you are trying to run this patch through phpMyAdmin and are using a database prefix. If so, you will need to manually edit the script to add-in the database prefix.

[majyk]

Would I be right in thinking that you are trying to run this patch through phpMyAdmin and are using a database prefix. If so, you will need to manually edit the script to add-in the database prefix.

Yes, I am. What would the database prefix syntax be? I am not a programmer but get through pretty well most of the time.

Thanks for the help!

[kuroi]

An easier route would be to install the patch via Admin > Tools > Install SQL Patches facility and it will take care of the database prefix for you.