problem getting slide show to activate in Responsive_All_Business

I am posting in here because the template is no longer supported.
Template is responsive_all_business by picaflor azul - using v1.5.1

issue - cannot get slide show to activate
reason - needs to be activated in admin/configuration/responsive_all_business
problem - admin/configuration/responsive_all_business doesn't exist - due to either version upgrades or some other reason

.sql file responsive_all_business.sql will not load, get "error-please refresh page and try again" - so I deleted the .sql file from the data base and then re-uploaded the.sql file only to get that error message HOWEVER the .sql file appears in data base (under different table number to one deleted) so I assume some other file is preventing it from working.

So I have no way to say to the slide show 'you can activate'

Possible solution?? may be in the jscript file if it was modified to tell the slider template that it is active ???? is this possible??

looking forward to some advice please, cheers Mike

jscript file

<script type="text/javascript">

/*
  SlidesJS 3.0.4 [URL]http://slidesjs.com[/URL]
  (c) 2013 by Nathan Searles [URL]http://nathansearles.com[/URL]
  Updated: June 26th, 2013
  Apache License: [URL]http://www.apache.org/licenses/LICENSE-2.0[/URL]
*/
   (function(){(function(e,t,n){var r,i,s;s="slidesjs";i={width:940,height:528,start:1,navigation:{active:!0,effect:"slide"},pagination:{active:!0,effect:"slide"},play:{active:!1,effect:"slide",interval:5e3,auto:!1,swap:!0,pauseOnHover:!1,restartDelay:2500},effect:{slide:{speed:500},fade:{speed:300,crossfade:!0}},callback:{loaded:function(){},start:function(){},complete:function(){}}};r=function(){function t(t,n){this.element=t;this.options=e.extend(!0,{},i,n);this._defaults=i;this._name=s;this.init()}return t}();r.prototype.init=function(){var n,r,i,s,o,u,a=this;n=e(this.element);this.data=e.data(this);e.data(this,"animating",!1);e.data(this,"total",n.children().not(".slidesjs-navigation",n).length);e.data(this,"current",this.options.start-1);e.data(this,"vendorPrefix",this._getVendorPrefix());if(typeof TouchEvent!="undefined"){e.data(this,"touch",!0);this.options.effect.slide.speed=this.options.effect.slide.speed/2}n.css({overflow:"hidden"});n.slidesContainer=n.children().not(".slidesjs-navigation",n).wrapAll("<div class='slidesjs-container'>",n).parent().css({overflow:"hidden",position:"relative"});e(".slidesjs-container",n).wrapInner("<div class='slidesjs-control'>",n).children();e(".slidesjs-control",n).css({position:"relative",left:0});e(".slidesjs-control",n).children().addClass("slidesjs-slide").css({position:"absolute",top:0,left:0,width:"100%",zIndex:0,display:"none",webkitBackfaceVisibility:"hidden"});e.each(e(".slidesjs-control",n).children(),function(t){var n;n=e(this);return n.attr("slidesjs-index",t)});if(this.data.touch){e(".slidesjs-control",n).on("touchstart",function(e){return a._touchstart(e)});e(".slidesjs-control",n).on("touchmove",function(e){return a._touchmove(e)});e(".slidesjs-control",n).on("touchend",function(e){return a._touchend(e)})}n.fadeIn(0);this.update();this.data.touch&&this._setuptouch();e(".slidesjs-control",n).children(":eq("+this.data.current+")").eq(0).fadeIn(0,function(){return e(this).css({zIndex:10})});if(this.options.navigation.active){o=e("<a>",{"class":"slidesjs-previous slidesjs-navigation",href:"#",title:"Previous",text:"Previous"}).appendTo(n);r=e("<a>",{"class":"slidesjs-next slidesjs-navigation",href:"#",title:"Next",text:"Next"}).appendTo(n)}e(".slidesjs-next",n).click(function(e){e.preventDefault();a.stop(!0);return a.next(a.options.navigation.effect)});e(".slidesjs-previous",n).click(function(e){e.preventDefault();a.stop(!0);return a.previous(a.options.navigation.effect)});if(this.options.play.active){s=e("<a>",{"class":"slidesjs-play slidesjs-navigation",href:"#",title:"Play",text:"Play"}).appendTo(n);u=e("<a>",{"class":"slidesjs-stop slidesjs-navigation",href:"#",title:"Stop",text:"Stop"}).appendTo(n);s.click(function(e){e.preventDefault();return a.play(!0)});u.click(function(e){e.preventDefault();return a.stop(!0)});this.options.play.swap&&u.css({display:"none"})}if(this.options.pagination.active){i=e("<ul>",{"class":"slidesjs-pagination"}).appendTo(n);e.each(new Array(this.data.total),function(t){var n,r;n=e("<li>",{"class":"slidesjs-pagination-item"}).appendTo(i);r=e("<a>",{href:"#","data-slidesjs-item":t,html:t+1}).appendTo(n);return r.click(function(t){t.preventDefault();a.stop(!0);return a.goto(e(t.currentTarget).attr("data-slidesjs-item")*1+1)})})}e(t).bind("resize",function(){return a.update()});this._setActive();this.options.play.auto&&this.play();return this.options.callback.loaded(this.options.start)};r.prototype._setActive=function(t){var n,r;n=e(this.element);this.data=e.data(this);r=t>-1?t:this.data.current;e(".active",n).removeClass("active");return e(".slidesjs-pagination li:eq("+r+") a",n).addClass("active")};r.prototype.update=function(){var t,n,r;t=e(this.element);this.data=e.data(this);e(".slidesjs-control",t).children(":not(:eq("+this.data.current+"))").css({display:"none",left:0,zIndex:0});r=t.width();n=this.options.height/this.options.width*r;this.options.width=r;this.options.height=n;return e(".slidesjs-control, .slidesjs-container",t).css({width:r,height:n})};r.prototype.next=function(t){var n;n=e(this.element);this.data=e.data(this);e.data(this,"direction","next");t===void 0&&(t=this.options.navigation.effect);return t==="fade"?this._fade():this._slide()};r.prototype.previous=function(t){var n;n=e(this.element);this.data=e.data(this);e.data(this,"direction","previous");t===void 0&&(t=this.options.navigation.effect);return t==="fade"?this._fade():this._slide()};r.prototype.goto=function(t){var n,r;n=e(this.element);this.data=e.data(this);r===void 0&&(r=this.options.pagination.effect);t>this.data.total?t=this.data.total:t<1&&(t=1);if(typeof t=="number")return r==="fade"?this._fade(t):this._slide(t);if(typeof t=="string"){if(t==="first")return r==="fade"?this._fade(0):this._slide(0);if(t==="last")return r==="fade"?this._fade(this.data.total):this._slide(this.data.total)}};r.prototype._setuptouch=function(){var t,n,r,i;t=e(this.element);this.data=e.data(this);i=e(".slidesjs-control",t);n=this.data.current+1;r=this.data.current-1;r<0&&(r=this.data.total-1);n>this.data.total-1&&(n=0);i.children(":eq("+n+")").css({display:"block",left:this.options.width});return i.children(":eq("+r+")").css({display:"block",left:-this.options.width})};r.prototype._touchstart=function(t){var n,r;n=e(this.element);this.data=e.data(this);r=t.originalEvent.touches[0];this._setuptouch();e.data(this,"touchtimer",Number(new Date));e.data(this,"touchstartx",r.pageX);e.data(this,"touchstarty",r.pageY);return t.stopPropagation()};r.prototype._touchend=function(t){var n,r,i,s,o,u,a,f=this;n=e(this.element);this.data=e.data(this);u=t.originalEvent.touches[0];s=e(".slidesjs-control",n);if(s.position().left>this.options.width*.5||s.position().left>this.options.width*.1&&Number(new Date)-this.data.touchtimer<250){e.data(this,"direction","previous");this._slide()}else if(s.position().left<-(this.options.width*.5)||s.position().left<-(this.options.width*.1)&&Number(new Date)-this.data.touchtimer<250){e.data(this,"direction","next");this._slide()}else{i=this.data.vendorPrefix;a=i+"Transform";r=i+"TransitionDuration";o=i+"TransitionTimingFunction";s[0].style[a]="translateX(0px)";s[0].style[r]=this.options.effect.slide.speed*.85+"ms"}s.on("transitionend webkitTransitionEnd oTransitionEnd otransitionend MSTransitionEnd",function(){i=f.data.vendorPrefix;a=i+"Transform";r=i+"TransitionDuration";o=i+"TransitionTimingFunction";s[0].style[a]="";s[0].style[r]="";return s[0].style[o]=""});return t.stopPropagation()};r.prototype._touchmove=function(t){var n,r,i,s,o;n=e(this.element);this.data=e.data(this);s=t.originalEvent.touches[0];r=this.data.vendorPrefix;i=e(".slidesjs-control",n);o=r+"Transform";e.data(this,"scrolling",Math.abs(s.pageX-this.data.touchstartx)<Math.abs(s.pageY-this.data.touchstarty));if(!this.data.animating&&!this.data.scrolling){t.preventDefault();this._setuptouch();i[0].style[o]="translateX("+(s.pageX-this.data.touchstartx)+"px)"}return t.stopPropagation()};r.prototype.play=function(t){var n,r,i,s=this;n=e(this.element);this.data=e.data(this);if(!this.data.playInterval){if(t){r=this.data.current;this.data.direction="next";this.options.play.effect==="fade"?this._fade():this._slide()}e.data(this,"playInterval",setInterval(function(){r=s.data.current;s.data.direction="next";return s.options.play.effect==="fade"?s._fade():s._slide()},this.options.play.interval));i=e(".slidesjs-container",n);if(this.options.play.pauseOnHover){i.unbind();i.bind("mouseenter",function(){return s.stop()});i.bind("mouseleave",function(){return s.options.play.restartDelay?e.data(s,"restartDelay",setTimeout(function(){return s.play(!0)},s.options.play.restartDelay)):s.play()})}e.data(this,"playing",!0);e(".slidesjs-play",n).addClass("slidesjs-playing");if(this.options.play.swap){e(".slidesjs-play",n).hide();return e(".slidesjs-stop",n).show()}}};r.prototype.stop=function(t){var n;n=e(this.element);this.data=e.data(this);clearInterval(this.data.playInterval);this.options.play.pauseOnHover&&t&&e(".slidesjs-container",n).unbind();e.data(this,"playInterval",null);e.data(this,"playing",!1);e(".slidesjs-play",n).removeClass("slidesjs-playing");if(this.options.play.swap){e(".slidesjs-stop",n).hide();return e(".slidesjs-play",n).show()}};r.prototype._slide=function(t){var n,r,i,s,o,u,a,f,l,c,h=this;n=e(this.element);this.data=e.data(this);if(!this.data.animating&&t!==this.data.current+1){e.data(this,"animating",!0);r=this.data.current;if(t>-1){t-=1;c=t>r?1:-1;i=t>r?-this.options.width:this.options.width;o=t}else{c=this.data.direction==="next"?1:-1;i=this.data.direction==="next"?-this.options.width:this.options.width;o=r+c}o===-1&&(o=this.data.total-1);o===this.data.total&&(o=0);this._setActive(o);a=e(".slidesjs-control",n);t>-1&&a.children(":not(:eq("+r+"))").css({display:"none",left:0,zIndex:0});a.children(":eq("+o+")").css({display:"block",left:c*this.options.width,zIndex:10});this.options.callback.start(r+1);if(this.data.vendorPrefix){u=this.data.vendorPrefix;l=u+"Transform";s=u+"TransitionDuration";f=u+"TransitionTimingFunction";a[0].style[l]="translateX("+i+"px)";a[0].style[s]=this.options.effect.slide.speed+"ms";return a.on("transitionend webkitTransitionEnd oTransitionEnd otransitionend MSTransitionEnd",function(){a[0].style[l]="";a[0].style[s]="";a.children(":eq("+o+")").css({left:0});a.children(":eq("+r+")").css({display:"none",left:0,zIndex:0});e.data(h,"current",o);e.data(h,"animating",!1);a.unbind("transitionend webkitTransitionEnd oTransitionEnd otransitionend MSTransitionEnd");a.children(":not(:eq("+o+"))").css({display:"none",left:0,zIndex:0});h.data.touch&&h._setuptouch();return h.options.callback.complete(o+1)})}return a.stop().animate({left:i},this.options.effect.slide.speed,function(){a.css({left:0});a.children(":eq("+o+")").css({left:0});return a.children(":eq("+r+")").css({display:"none",left:0,zIndex:0},e.data(h,"current",o),e.data(h,"animating",!1),h.options.callback.complete(o+1))})}};r.prototype._fade=function(t){var n,r,i,s,o,u=this;n=e(this.element);this.data=e.data(this);if(!this.data.animating&&t!==this.data.current+1){e.data(this,"animating",!0);r=this.data.current;if(t){t-=1;o=t>r?1:-1;i=t}else{o=this.data.direction==="next"?1:-1;i=r+o}i===-1&&(i=this.data.total-1);i===this.data.total&&(i=0);this._setActive(i);s=e(".slidesjs-control",n);s.children(":eq("+i+")").css({display:"none",left:0,zIndex:10});this.options.callback.start(r+1);if(this.options.effect.fade.crossfade){s.children(":eq("+this.data.current+")").stop().fadeOut(this.options.effect.fade.speed);return s.children(":eq("+i+")").stop().fadeIn(this.options.effect.fade.speed,function(){s.children(":eq("+i+")").css({zIndex:0});e.data(u,"animating",!1);e.data(u,"current",i);return u.options.callback.complete(i+1)})}return s.children(":eq("+r+")").stop().fadeOut(this.options.effect.fade.speed,function(){s.children(":eq("+i+")").stop().fadeIn(u.options.effect.fade.speed,function(){return s.children(":eq("+i+")").css({zIndex:10})});e.data(u,"animating",!1);e.data(u,"current",i);return u.options.callback.complete(i+1)})}};r.prototype._getVendorPrefix=function(){var e,t,r,i,s;e=n.body||n.documentElement;r=e.style;i="transition";s=["Moz","Webkit","Khtml","O","ms"];i=i.charAt(0).toUpperCase()+i.substr(1);t=0;while(t<s.length){if(typeof r[s[t]+i]=="string")return s[t];t++}return!1};return e.fn[s]=function(t){return this.each(function(){if(!e.data(this,"plugin_"+s))return e.data(this,"plugin_"+s,new r(this,t))})}})(jQuery,window,document)}).call(this);
-->
</script>
```<!--
 ____

slider template

<div class="container"> <div id="slides"> <?php if (SHOW_BANNERS_GROUP_SETRAB1 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SETRAB1)) { if ($banner->RecordCount() > 0) { echo zen_display_banner('static', $banner); } } ?> <?php if (SHOW_BANNERS_GROUP_SETRAB2 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SETRAB2)) { if ($banner->RecordCount() > 0) { echo zen_display_banner('static', $banner); } } ?> <?php if (SHOW_BANNERS_GROUP_SETRAB3 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SETRAB3)) { if ($banner->RecordCount() > 0) { echo zen_display_banner('static', $banner); } } ?> <?php if (SHOW_BANNERS_GROUP_SETRAB4 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SETRAB4)) { if ($banner->RecordCount() > 0) { echo zen_display_banner('static', $banner); } } ?> <?php if (SHOW_BANNERS_GROUP_SETRAB5 != '' && $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SETRAB5)) { if ($banner->RecordCount() > 0) { echo zen_display_banner('static', $banner); } } ?>

</div>

</div> ```<!--

Posted this thread in templates forum with 46 views to date but no responses - anyone prepared to give this a shot?? :smile:

https://www.zen-cart.com/showthread.php?222048-problem-getting-slide-show-to-activate-in-Responsive_All_Business

cheers, Mike

Part of solving your problem relates back to a basic troubleshooting FAQ: https://www.zen-cart.com/content.php?311

mc12345678:

Part of solving your problem relates back to a basic troubleshooting FAQ: https://www.zen-cart.com/content.php?311

Thanks MC - there are no error logs pertaining to this issue - I am hoping someone familiar with code can say either 'yes to get it to activate change settings xyz to abc in the .php file', or 'sorry changing settings will not do it'. :smile:

cheers, Mike

Does this help any at all?

https://www.zen-cart.com/showthread.php?219801-Making-v154-DIY-Picaflor-Azul-templates-work-with-v1-5-5

The responsive_all_business.sql file can load fine, if none of the settings it tries to install are already present. It's possible that you've already installed other picaflor templates and thus have conflicts with settings or structural changes using the same name.
If you're still using features from those other templates then it wouldn't be wise to run an uninstall to remove those features; instead you'd need to manually run individual changes; but the script is built to run automatically, and splitting it apart to run manually requires some technical understanding about how config groups and ids are managed.

In an effort to figure out what specific things are breaking, since you say there are no debug logs present (which suggests other problems), trying to read-backwards thru your long post, I find myself very confused ...

shags38:

.sql file responsive_all_business.sql will not load, get "error-please refresh page and try again" - so I deleted the .sql file from the data base and then re-uploaded the.sql file only to get that error message HOWEVER the .sql file appears in data base (under different table number to one deleted) so I assume some other file is preventing it from working.

This is very confusing ...

You seem to think that the "data base" is actually the files on your webserver.

How EXACTLY did you do each of these steps? Please explain each one in painstakingly tiny details, naming exactly which software programs you used, and web pages you visited, and options you clicked on, etc. Pretend I've never used a computer before, and teach me how to do exactly what you said you did, so that I can do it on my own computer, as if I had access to your server. Skip passwords of course.

1. so I deleted the .sql file from the data base

• how exactly did you do that? Since the "data base" doesn't hold files, this statement doesn't make sense. Did you use FTP? Did you use phpMyAdmin? something else? how exactly?

2. then re-uploaded the.sql file

• how? what software? or was it a web page? what menu options?

3. only to get that error message

• HOW did you get that error message? Probably a dozen steps missing here?

4. HOWEVER the .sql file appears in data base

• what do you mean by "sql file appears in data base"? again, the database doesn't contain files. What program is showing you this? How did you get to that view?

5. (under different table number to one deleted)

• um, what's a 'table number'?

You're using some odd terminology here ... which probably lends to fewer responses, since it takes a long time to figure out what you're really meaning to say. It took me 10 minutes just to write all this out and try to find a way to get you to accurately describe what you're really doing.

TIP: I recommend that you specifically avoid using the terms "database" and "table" and "upload". Use different words to explain it, like:

• "I used my PC's file transfer program to copy the ____ file to my website, into the //____ directory"
• "I went to my Zen Cart Admin screen, and chose menu option: Tools->Install SQL Patch, and then clicked on ____ then I did ____ and ____ and clicked ____"
• "I saw the file at ____ place, by using ____ software program"

DrByte:

In an effort to figure out what specific things are breaking, since you say there are no debug logs present (which suggests other problems), trying to read-backwards thru your long post, I find myself very confused ...

This is very confusing ...

You seem to think that the "data base" is actually the files on your webserver.

How EXACTLY did you do each of these steps? Please explain each one in painstakingly tiny details, naming exactly which software programs you used, and web pages you visited, and options you clicked on, etc. Pretend I've never used a computer before, and teach me how to do exactly what you said you did, so that I can do it on my own computer, as if I had access to your server. Skip passwords of course.

1. so I deleted the .sql file from the data base

• how exactly did you do that? Since the "data base" doesn't hold files, this statement doesn't make sense. Did you use FTP? Did you use phpMyAdmin? something else? how exactly?

2. then re-uploaded the.sql file

• how? what software? or was it a web page? what menu options?

3. only to get that error message

• HOW did you get that error message? Probably a dozen steps missing here?

4. HOWEVER the .sql file appears in data base

• what do you mean by "sql file appears in data base"? again, the database doesn't contain files. What program is showing you this? How did you get to that view?

5. (under different table number to one deleted)

• um, what's a 'table number'?

You're using some odd terminology here ... which probably lends to fewer responses, since it takes a long time to figure out what you're really meaning to say. It took me 10 minutes just to write all this out and try to find a way to get you to accurately describe what you're really doing.

TIP: I recommend that you specifically avoid using the terms "database" and "table" and "upload". Use different words to explain it, like:

• "I used my PC's file transfer program to copy the ____ file to my website, into the //____ directory"
• "I went to my Zen Cart Admin screen, and chose menu option: Tools->Install SQL Patch, and then clicked on ____ then I did ____ and ____ and clicked ____"
• "I saw the file at ____ place, by using ____ software program"

Thanks for taking the time to respond in such a detailed manner Doc - your response helped in that I went into phpMyAdmin to check some details for answering some of your questions and decided to look 'further' - I now have the slider working albeit 'Responsive All Business' still doesn't show under admin/configuration - I looked in phpMyAdmin under 'configuration' and found a line titled 'Slides JS Slideshow RAB_SLIDES_STATUS false Activate Slides JS Slideshow' and changed it to true and all is now good - it just means if I want to turn the slide show off at any point I will need to go back into phpMyAdmin and alter that line. I am not even going to try to figure how to get Responsive All Business to show up under admin/configuration, I will be satisfied with this result for now.

As a courtesy to you here are answers to your questions ... and yes my terminologies are incorrect - I will use the suggestions you made in future.

many, many thanks for your help
cheers, Mike

1. so I deleted the .sql file from the data base

• how exactly did you do that? Since the "data base" doesn't hold files, this statement doesn't make sense. Did you use FTP? Did you use phpMyAdmin? something else? how exactly?

I deleted 'responsive_all_business' from configuration_groups inphpMyAdmin

2. then re-uploaded the.sql file

• how? what software? or was it a web page? what menu options?

uploaded .sql file via admin/tools/install_sql_patches

3. only to get that error message

• HOW did you get that error message? Probably a dozen steps missing here?

error message was immediate after attempted upload via above method - appeared instead of successful 'x' statements uploaded

4. HOWEVER the .sql file appears in data base

• what do you mean by "sql file appears in data base"? again, the database doesn't contain files. What program is showing you this? How did you get to that view?

'responsive_all_business' appeared again in configuration_groups under a different 'line' number in phpMyAdmin

5. (under different table number to one deleted)

• um, what's a 'table number'?

different line number in same table in phpMyAdmin

thanks for responding Rick - issue 'was' in v1.5.1 - now fixed - see above

Mike,

Here's how configuration entries work:

• each "configuration" table record has 3 important pieces: configuration_key, configuration_value, and configuration_group_id
• the configuration_group_id must match an id in the configuration_groups table, else there cannot be a menu entry for it
• if the configuration_group record is deleted and recreated, it'll get a new number ... but the "configuration" table records will still have the old configuration_group_id assigned to them. If they aren't manually updated to be in sync, then the menu won't show those settings.

And then the Admin menu also requires a bunch of settings (they're in the SQL file you were using) to put the menu on the screen ... based again on the configuration_group_id being provided as the gID parameter.

(You could trick your admin menu to display by changing the URL's gID to the other group, as long as you're not logged in as a restricted admin user.)

DrByte:

Mike,

Here's how configuration entries work:

• each "configuration" table record has 3 important pieces: configuration_key, configuration_value, and configuration_group_id
• the configuration_group_id must match an id in the configuration_groups table, else there cannot be a menu entry for it
• if the configuration_group record is deleted and recreated, it'll get a new number ... but the "configuration" table records will still have the old configuration_group_id assigned to them. If they aren't manually updated to be in sync, then the menu won't show those settings.

And then the Admin menu also requires a bunch of settings (they're in the SQL file you were using) to put the menu on the screen ... based again on the configuration_group_id being provided as the gID parameter.

(You could trick your admin menu to display by changing the URL's gID to the other group, as long as you're not logged in as a restricted admin user.)

G'day Doc - many thanks for the heads up on how the configuration entries work - knowledge is such a powerful thing, right. I will endeavor to learn a bit more about such things as time permits but your explanation now gives me a good grounding.

cheers Mike