Quote Originally Posted by picaflor-azul View Post
You shouldn't have to do anything with your database prefix if your zen cart is set up correctly. The zen cart admin--tools--install sql patches utility automatically deals with any database prefixes when you run patches from it.

Thanks,

Anne
Thanks Anne.

Sorry for posting my issues in the wrong forum...I am trying to upgrade to "Responsive"

The about_us.sql patch does not install with Responsive Sheffield Blue.

I've installed several times now in a freshly installed zen_cart without any plugins or templates installed, on my test shop with mimimal plug-ins and my own template installed, and on my live shop with several plug-ins and my own template installed.

Each time I tried to install Responsive Sheffield Blue, I had to manually install the about_us.sql patch into the database. On one of the installs, the patch did insert the new records but all of the columns were one position off to the left.

Here is the code that came with the package. There are 10 elements to the INSERT INTO, one being the configuration_id (which I assume is automatically assigned during the INSERT). There are 10 elements in the VALUES and none represent the configuration_id.

The number of elements in the INSERT AND VALUES don't add up. If the ID is assigned automatically, then there should be 11 elements in the INSERT.

last_modified is missing in the INSERT INTO.

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
('Define About Us Status', 'DEFINE_ABOUT_US_STATUS', '1', 'Enable the Defined About Us Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 59, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');