I have found discussions about this error but still am unable to find the solution. I installed lightbox yesterday using the current link. I am on step 5 in the readme file. This is the error I am getting:
Error
SQL query:
/** * Zen Lightbox * * @author Alex Clarke ([email protected]) * @copyright Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: install.sql 2008-12-17 aclarke $ */ INSERT INTO `configuration_group`
VALUES (
NULL , 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1'
);
MySQL said: Documentation
#1146 - Table 'hipdockc_znc1.configuration_group' doesn't exist
Please advise. I am new so please reply with an explanation I will understand. Thanks so much.
HipDock.com -This is my first site. Version 1.3.9h. LightBox Add-On March 2011. Thanks for your patience and help!
Hi Page,
I havent personally dealt with the prefix issue, but I just tested it and was able to reproduce your results. According to this post on the thread: Your database has a prefix before the names of the tables. you need to find out what the table prefix is:
if you open [includes/configure.php] and look for the lineyou'll want to take that part in red and then update your install.sql file as shown in the link. (all the places in red).Code:define('DB_PREFIX', 'yourPrefixHere_');
Danel
Forgot to include quote
Last edited by Page; 29 Mar 2011 at 01:36 PM. Reason: Forgot to include quote
HipDock.com -This is my first site. Version 1.3.9h. LightBox Add-On March 2011. Thanks for your patience and help!
Are you saying that I need to change the prefix in every one of these files in the table from zc to selectge_znc1? For example, start with znc_address_book and change it to selectge_znc1_address_book. Is this correct? Thank you.
Could not get screen shot small enough to attach. Here is a copy/paste of the first few line of the table.
localhost - hipdockc_znc1
Table Ascending Action Records 1 Type Collation Size Overhead
znc_address_book Browse Structure Search Insert Empty Drop 2 MyISAM latin1_general_ci 12.2 KiB -
znc_address_format Browse Structure Search Insert Empty Drop 6 MyISAM latin1_general_ci 8.6 KiB -
znc_admin Browse Structure Search Insert Empty Drop 1 MyISAM latin1_general_ci 16.1 KiB -
znc_admin_activity_log Browse Structure
HipDock.com -This is my first site. Version 1.3.9h. LightBox Add-On March 2011. Thanks for your patience and help!
Also, please explain exactly how to change the prefixes.
HipDock.com -This is my first site. Version 1.3.9h. LightBox Add-On March 2011. Thanks for your patience and help!
HipDock.com -This is my first site. Version 1.3.9h. LightBox Add-On March 2011. Thanks for your patience and help!
Can you please explain the EZ Pages functionality?
I cannot get lightbox to work on http://www.mermagica.eu/index.php?ma...mermaid_racing.
"EZ-Pages
By default the lightbox effect will be applied to all links that point to images on your EZ-Pages."
I am using the Define Pages Editor and linking it through an Easy Page... the define_mermaid_racing page has the following code: <a href="../images/mini_tail.jpg" rel="Mini Tail">Mini Tail</a>
I created an EZ Page (via define pages editor) with a link to a photo in the images directory, but it's not working. The jscript_zen_lightbox.php file is located in the following directory: /modules/pages/mermaid_racing
Any guidance is appreciated...
![]()
Bookmarks