Uninstall zen cart lightbox when table prefix has been used
Hi I am using the latest version of light box 1.6.2 and had some difficulty installing it due to the fact that after following advice on forum about putting a prefix before database tables for added security I had to ring up my server provider and they walked me through it. Now my client does not want any product images and I am trying to uninstall lightbox but of course I am getting the same error message
#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 'uninstall.sql' at line 1
As there are only 2 lines in the uninstall file
DELETE FROM `configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
I thought that there may be an easy way to insert the table prefix like this
DELETE FROM `???_configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `???_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
but am a bit nervous about executing that command and would like your expert opinions.
Re: Uninstall zen cart lightbox when table prefix has been used
Quote:
Originally Posted by
wotnow
Hi I am using the latest version of light box 1.6.2 and had some difficulty installing it due to the fact that after following advice on forum about putting a prefix before database tables for added security I had to ring up my server provider and they walked me through it. Now my client does not want any product images and I am trying to uninstall lightbox but of course I am getting the same error message
#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 'uninstall.sql' at line 1
As there are only 2 lines in the uninstall file
DELETE FROM `configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
I thought that there may be an easy way to insert the table prefix like this
DELETE FROM `???_configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `???_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
but am a bit nervous about executing that command and would like your expert opinions.
yes, Thant is right if you make prefix then you need to add it when you want to uninstall.
It 'll work fine if you do it
Re: Uninstall zen cart lightbox when table prefix has been used
If you inserted a database prefix upon installation, then you must insert the exact same database prefeix upon uninstallation.
I don't know if your ??? are replacements for the prefix name you used, or if you literally mean to use ???.
The answer is, don't use ???. Use the exact same prefix you used to install when you uninstall.
Quote:
Originally Posted by
wotnow
Hi I am using the latest version of light box 1.6.2 and had some difficulty installing it due to the fact that after following advice on forum about putting a prefix before database tables for added security I had to ring up my server provider and they walked me through it. Now my client does not want any product images and I am trying to uninstall lightbox but of course I am getting the same error message
#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 'uninstall.sql' at line 1
As there are only 2 lines in the uninstall file
DELETE FROM `configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
I thought that there may be an easy way to insert the table prefix like this
DELETE FROM `???_configuration` WHERE `configuration_key` LIKE 'ZEN_LIGHTBOX_%';
DELETE FROM `???_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
but am a bit nervous about executing that command and would like your expert opinions.