jaychan2013:
Hi balihr, I've got the same problem as posts of #126 and #431. But I'm using 1.5.1zencart.
I would like to run sql inside myphpadmin, but I don't know what to do, which SQL area to run. My database is "JAYCHAN", does it run here for the whole sql code?
What group id should I replace?
What should I do for "Don't forget to add the DB prefix"?
You're in the right place to run the query. But first, you need to find out which configuration_group_id you're going to use (assuming THAT part of the SQL statement did execute). Go to Structure tab and click configuration_group table to browse it. The entry will probably be on the last page. Find "ZX Slideshow" under "configuration_group_title" and see what ID was assigned. For example, let's say it's 52. NOTE: this is NOT your value, it's just an example I'm using here.
Now, open the install SQL file (install-v1.5.x.sql) and use lines 10-30 for your SQL tab in phpmyadmin. Copy/paste those lines, but change @ZXconfig with your configuration_group_id (in our example, 52). Your SQL statement should now look something like this:
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
(NULL, 'ZX Slideshow', 'ZX_SLIDESHOW_STATUS', 'false', 'Activate ZX Slideshow for the main page', 52, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Slideshow Theme', 'ZX_SLIDESHOW_THEME', 'default', 'Select your theme', 52, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'default\', \'light\', \'dark\', \'bar\'),'),
(NULL, ' Effect', 'ZX_SLIDESHOW_EFFECT', 'fade', 'Effect used for image transition', 52, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'sliceDown\', \'sliceDownLeft\', \'sliceUp\', \'sliceUpLeft\', \'sliceUpDown\', \'sliceUpDownLeft\', \'fold\', \'fade\', \'random\', \'slideInRight\', \'slideInLeft\', \'boxRandom\', \'boxRain\', \'boxRainReverse\', \'boxRainGrow\', \'boxRainGrowReverse\'),'),
(NULL, 'Slideshow Animation Speed', 'ZX_SLIDESHOW_ANIM_SPEED', '500', 'Slide transition speed in miliseconds', 52, 4, NOW(), NULL, NULL),
(NULL, 'Slideshow Pause Time', 'ZX_SLIDESHOW_PAUSE', '4000', 'How long each slide will show in miliseconds', 52, 5, NOW(), NULL, NULL),
(NULL, 'Slideshow Navigation Arrows', 'ZX_SLIDESHOW_NAV', 'true', 'Show Prev/Next navigation arrows', 52, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Slideshow Navigation Hide', 'ZX_SLIDESHOW_NAV_HIDE', 'true', 'Show Prev/Next navigation arrows only on hover', 52, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Slideshow Numbered Navigation', 'ZX_SLIDESHOW_CONTROL_NAV', 'true', 'Show 1,2,3... navigation', 52, 8, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Slideshow Pause on Hover', 'ZX_SLIDESHOW_HOVER_PAUSE', 'true', 'Stop animation while hovering', 52, 9, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Banner Display Groups - Slide1', 'ZX_SLIDESHOW_BANNERS_GROUP_SET9', 'slide1', 'Slide 1', 52, 30, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide2', 'ZX_SLIDESHOW_BANNERS_GROUP_SET10', 'slide2', 'Slide 2', 52, 31, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide3', 'ZX_SLIDESHOW_BANNERS_GROUP_SET11', 'slide3', 'Slide 3', 52, 32, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide4', 'ZX_SLIDESHOW_BANNERS_GROUP_SET12', 'slide4', 'Slide 4', 52, 33, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide5', 'ZX_SLIDESHOW_BANNERS_GROUP_SET13', 'slide5', 'Slide 5', 52, 34, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide6', 'ZX_SLIDESHOW_BANNERS_GROUP_SET14', 'slide6', 'Slide 6', 52, 35, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide7', 'ZX_SLIDESHOW_BANNERS_GROUP_SET15', 'slide7', 'Slide 7', 52, 36, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide8', 'ZX_SLIDESHOW_BANNERS_GROUP_SET16', 'slide8', 'Slide 8', 52, 37, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide9', 'ZX_SLIDESHOW_BANNERS_GROUP_SET17', 'slide9', 'Slide 9', 52, 38, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide10', 'ZX_SLIDESHOW_BANNERS_GROUP_SET18', 'slide10', 'Slide 10', 52, 39, NOW(), NULL, NULL),
(NULL, 'ZX Slideshow Version', 'ZX_SLIDESHOW_VERSION', '2.1', 'Currently using: <strong>v2.0</strong><br />Module brought to you by <a href="http://www.zenexpert.com" target="_blank">ZenExpert</a>', 52, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'2.1\'),');
I've highlighted the change - keep in mind that 52 is JUST AN EXAMPLE, your ID might be different.
As for DB prefix - if (and only if) you're using a DB prefix, you'll have to change the first line of the SQL query from
INSERT INTO configuration (con...
to ```
INSERT INTO zen_configuration (con...
or whatever prefix you're using. You'll see it in step 1 when you're looking for configuration_group table. If it's called zen_configuration_group, your prefix is zen_ :smile:
Have fun!
