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.
Re: Zen Lightbox... Images Not showing in Firefox or Opera
Zen Cart v1.3.9h
Zen Lightbox v1.6.2
I've been trudging along building a site for the last 3 days and being dumb I've just been going along loading the site in Chrome.
So today I go and test it with Firefox and no images are showing at all! Not even the thumbnails.
It's been doing fine in Chrome, working perfectly.
In Opera hit or miss depending on box.
PC-1
Windows7
Firefox v7.0.1 - Nogo, nothing
Opera v11.52 - No Picts, but have frames
IE8 - Works
Chrome - Works
Linux Box
Chrome - Works
Firefox v3.6.17 - Nogo, nothing
Opera v11.0 - Works
PC-2
WinXPsp3
Firefox v8.0 - Nogo, nothing
IE8 - Works
Chrome - Works
I've searched for a half hour, going to go for a walk and clear out the gray matter... *SIGH*...
Thanks,
_mr
Re: Zen Lightbox... Images Not showing in Firefox or Opera
Quote:
Originally Posted by
middle_road
Zen Cart v1.3.9h
Zen Lightbox v1.6.2
I've been trudging along building a site for the last 3 days and being dumb I've just been going along loading the site in Chrome.
So today I go and test it with Firefox and no images are showing at all! Not even the thumbnails.
It's been doing fine in Chrome, working perfectly.
In Opera hit or miss depending on box.
PC-1
Windows7
Firefox v7.0.1 - Nogo, nothing
Opera v11.52 - No Picts, but have frames
IE8 - Works
Chrome - Works
Linux Box
Chrome - Works
Firefox v3.6.17 - Nogo, nothing
Opera v11.0 - Works
PC-2
WinXPsp3
Firefox v8.0 - Nogo, nothing
IE8 - Works
Chrome - Works
I've searched for a half hour, going to go for a walk and clear out the gray matter... *SIGH*...
Thanks,
_mr
first off you will get better help with posting a link so we can see what you see and test things out.
secondly---should have been first--- this is most likely NOT a lightbox thing...especially since you said it has been working right in the one browser....but have you any other mods installed?
You may need to uninstall everything and go back to just the bare store...do them all one at a time ---then test in each browser before going to the next mod.
worst case is that it is not the mods but something in the actual browsers.
Re: Thread for operating Zen Lightbox...
Hi,
I have uploaded and installed zen lightbox. Now I am wondering how it works. Not sure. Could anyone give me a clue or point me to a tutorial thread.
Thanks,
Nick
Re: Thread for operating Zen Lightbox...
Quote:
Originally Posted by
nickydubya
Hi,
I have uploaded and installed zen lightbox. Now I am wondering how it works. Not sure. Could anyone give me a clue or point me to a tutorial thread.
Thanks,
Nick
1. go to admin/configuration/zen lightbox and make sure it is turned on with the settings( IF I recall it is automatically done)
2. now go to the store, any product description page and click on the main image
it should open into the blacked ot window with the image dead center for viewing larger one.
that is it, if they don't open up into the "shut off the lights" type of window then it is not uploaded right...come back with link to your site for help
also before I forget again...READ the readme file included in the zip---the ENTIRE read me.
Re: Zen Lightbox... Images Not showing in Firefox or Opera
Quote:
Originally Posted by
DarkAngel
first off you will get better help with posting a link so we can see what you see and test things out.
secondly---should have been first--- this is most likely NOT a lightbox thing...especially since you said it has been working right in the one browser....but have you any other mods installed?
You may need to uninstall everything and go back to just the bare store...do them all one at a time ---then test in each browser before going to the next mod.
worst case is that it is not the mods but something in the actual browsers.
Thanks for the quick reply! Finally got back to it last night, and I think
that is was a bad import on my part.
The only other mod that I have installed is Apsona Site Admin that I'm
using for importing/exporting.
I believe I messed up when I went to do a quick import of 6 items
and I was copying from the .CSV file into Apsona.
I had a typo in the pathnames for the images. It appears that those 6
may have cause something to choke with the browsers.
I exported all 226 items and verified the images field and then performed an import/update
on just that table, and all the display probs are gone.
""/operator error"" I should have sat back and done a re-think before posting.
Zen Lightbox is working great, and the client really liked this method of displaying
multiple images.
Thanks again,
_mr
Re: Zen Lightbox... Images Not showing in Firefox or Opera
Quote:
Originally Posted by
middle_road
Thanks for the quick reply! Finally got back to it last night, and I think
that is was a bad import on my part.
The only other mod that I have installed is Apsona Site Admin that I'm
using for importing/exporting.
I believe I messed up when I went to do a quick import of 6 items
and I was copying from the .CSV file into Apsona.
I had a typo in the pathnames for the images. It appears that those 6
may have cause something to choke with the browsers.
I exported all 226 items and verified the images field and then performed an import/update
on just that table, and all the display probs are gone.
""/operator error"" I should have sat back and done a re-think before posting.
Zen Lightbox is working great, and the client really liked this method of displaying
multiple images.
Thanks again,
_mr
LOL operator error --- that culprit hits my house too and first I panic and sometimes come here then stop and think...thinking gets me into trouble though so try not to do it often.
glad it got straitened out for you but remember always post link to store so we can help even better.
Re: Zen Lightbox... Images Not showing in Firefox or Opera
Quote:
Originally Posted by
middle_road
Zen Cart v1.3.9h
Zen Lightbox v1.6.2
I've been trudging along building a site for the last 3 days and being dumb I've just been going along loading the site in Chrome.
So today I go and test it with Firefox and no images are showing at all! Not even the thumbnails.
It's been doing fine in Chrome, working perfectly.
In Opera hit or miss depending on box.
PC-1
Windows7
Firefox v7.0.1 - Nogo, nothing
Opera v11.52 - No Picts, but have frames
IE8 - Works
Chrome - Works
Linux Box
Chrome - Works
Firefox v3.6.17 - Nogo, nothing
Opera v11.0 - Works
PC-2
WinXPsp3
Firefox v8.0 - Nogo, nothing
IE8 - Works
Chrome - Works
I've searched for a half hour, going to go for a walk and clear out the gray matter... *SIGH*...
Thanks,
_mr
Do you have Firebug installed in Firefox? If so, remove it. It causes problems with image handling add-ons.