Installing SQL patches

[maraud]

Under Tools > Install SQL Patches,

what's the purpose of the "upload file" and when files are uploaded, where are they placed?

[kuroi]

The upload file option allows you to point the SQL patch installer to a file rather than pasting instructions into the box above. The files uploaded are executed, rather than "placed".

[all4coffee]

I have the HoverBox patch installed and I want it removed. Here is the initial code used for installation:

1. Copy & Paste the following SQL statement into "Enter the query to be executed"

   1. INSERT INTO `configuration_group` VALUES (50, 'HoverBox²', 'Settings for your HoverBox²', 4.50, 1);
      INSERT INTO `configuration` VALUES (721, 'Should I display the title of your product?', 'HOVERBOX_DISPLAY_TITLE', 'Yes', 'This let''s me know whether or not I should display the title of your product. Either select yes or no. I''ll handle the rest.', 50, 2, NULL, '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'',''No''), ');
      INSERT INTO `configuration` VALUES (720, 'Would you like to put me to work for you?', 'HOVERBOX_ENABLED', 'Yes', 'This let''s me know if I should be taking control over the display of your product images.', 50, 1, '2007-07-15 02:14:06', '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
      INSERT INTO `configuration` VALUES (722, 'And lastly, should I display your product''s price to your customers?', 'HOVERBOX_DISPLAY_PRICE', 'Yes', 'This one just lets me know if I should be displaying the price of your products to your customers.', 50, 3, NULL, '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'', ''No''),');

I removed all the mode's files already but it still shows up in Admin. I want my ZenCart as "clean" as possible... Anyone could help?

[poolprorich]

Hello,
Paste this in your sql patches and it will remove hover cart please modify it if you use and prefixes for you database

DELETE FROM `configuration_group` WHERE `configuration_group`, `configuration_group_id`=50 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=721 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=720 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=722 LIMIT 1

Hope this helps

Rich

[all4coffee]

Thanks, I will try it tomorrow.

[all4coffee]

Hello,
Paste this in your sql patches and it will remove hover cart please modify it if you use and prefixes for you database

DELETE FROM `configuration_group` WHERE `configuration_group`, `configuration_group_id`=50 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=721 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=720 LIMIT 1
DELETE FROM `configuration` WHERE `configuration`, `configuration_group_id`=722 LIMIT 1

Hope this helps

Rich

Since I'm not sure what a prefix is - I think I understood the concept from the code you provided and went directly to database via Heidi and manually removed ids 50, 720,721 and 722. I made a backup first just in case. The HoverBox entries from Admin are gone and everything seems to be working fine. Could you please confirm if what I did was acceptable way to handle this issue? instead of the patch?

[poolprorich]

Yep That works That is the same as the Statement
Good job

For future a prefix would be
database table
customers
would look like this with a prefix
Zen_customers

so you would have had to add zen_ to the front of configuration
hope it helps

Rich