Trouble with Layout Boxes Controller

Found a bug?

In layout Boxes Controller. When any sidebox is selected to be edited, the sidebox at the top of the list is automatically the sidebox being edited.

No box can be individually edited without the same changes happening to the rest.

When it is turned off/on, it cause all the boxes to do the same. So all Left off, or all right on. or both.

Admin Reset for Responsive Classic works, and then side boxes do not show up..

Where in the DB or files can I change this as I only have 155 files uploaded?

Thx

This is not a bug or at least i can't replicate it nor is it related to the responsive_classic theme.

Make sure that you have replaced the ADMIN > layout_controller.php file with the newest available within v1.5.5.

* @version $Id: Author: DrByte  Sat Aug 1 18:01:55 2015 -0400 Modified in v1.5.5 $

Some previous responsive versions altered this file and those changes were not ported to 1.5.5

rbarbour:

This is not a bug or at least i can't replicate it nor is it related to the responsive_classic theme.

Make sure that you have replaced the ADMIN > layout_controller.php file with the newest available within v1.5.5.

• @version $Id: Author: DrByte Sat Aug 1 18:01:55 2015 -0400 Modified in v1.5.5 $

> 
> Some previous responsive versions altered this file and those changes were not ported to 1.5.5

Right on. Snagged from todays 155 update: @version $Id: Author: DrByte  Sat Aug 1 18:01:55 2015 -0400 Modified in v1.5.5

Manually replacing the files didn't help anything. Somethings whacked.

This doesn't feel like an issue with the Responsive Classic template specifically.

The admin/layout_controller.php file doesn't rely on much else. But I suppose if you've got something intercepting the $_GET['cID'] parameters, or if you've got something that's altered a bunch of /admin/includes/functions/.php or /admin/includes/classes/.php, or /includes/functions/.php or /includes/classes/.php files, then that could cause weirdness in various places.

Thank you for your reply.

I failed to mentioned in the default money green template, all the boxes work including the footer banners I left on.

In the Responsive_Classic template I got blank side columns.

Thus, the hunch on my back made me believe it was a template issue.

Fresh install.

Can you recommend a thread to move my Layout Box concerns to besides the round sidebox next to your desk?

In your database, is the layout_id field of the layout_boxes table set as an "integer" and as an "auto increment" field?

Are all the layout_id values unique, or are they all set to 0, particularly for the newest entries?

However zc installer set up the db. Ill verify when I get to a computer.

I had this issue after the fresh install and before importing the old db tables.

Integers

CREATE TABLE layout_boxes (
layout_id int(11) NOT NULL,
layout_template varchar(64) NOT NULL DEFAULT '',
layout_box_name varchar(64) NOT NULL DEFAULT '',
layout_box_status tinyint(1) NOT NULL DEFAULT '0',
layout_box_location tinyint(1) NOT NULL DEFAULT '0',
layout_box_sort_order int(11) NOT NULL DEFAULT '0',
layout_box_sort_order_single int(11) NOT NULL DEFAULT '0',
layout_box_status_single tinyint(4) NOT NULL DEFAULT '0',
show_box_min_width tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Hmmm...

The install SQL, all the way back to the original version, contains the auto-increment, and some indexes, but yours doesn't.
Without the auto-increment, all the insertions of records for each setting, including when the "reset" button is used, are getting a value of 0, which is why the links are giving strange results on screen.

This is how it should be, from the v155 install SQL:

CREATE TABLE layout_boxes ( 
  layout_id int(11) NOT NULL auto_increment,
  layout_template varchar(64) NOT NULL default '',
  layout_box_name varchar(64) NOT NULL default '',
  layout_box_status tinyint(1) NOT NULL default '0',
  layout_box_location tinyint(1) NOT NULL default '0',
  layout_box_sort_order int(11) NOT NULL default '0',
  layout_box_sort_order_single int(11) NOT NULL default '0',
  layout_box_status_single tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (layout_id),
  KEY idx_name_template_zen (layout_template,layout_box_name),
  KEY idx_layout_box_status_zen (layout_box_status),
  KEY idx_layout_box_sort_order_zen (layout_box_sort_order)
) ENGINE=MyISAM;

Interesting

Is show_box_min_width tinyint(1) NOT NULL DEFAULT '1' applicable to v155 or 160?

Otherwise I am prepared to import this into SQL window:

DROP TABLE IF EXISTS layout_boxes;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE layout_boxes (
layout_id int(11) NOT NULL auto_increment,
layout_template varchar(64) NOT NULL default '',
layout_box_name varchar(64) NOT NULL default '',
layout_box_status tinyint(1) NOT NULL default '0',
layout_box_location tinyint(1) NOT NULL default '0',
layout_box_sort_order int(11) NOT NULL default '0',
layout_box_sort_order_single int(11) NOT NULL default '0',
layout_box_status_single tinyint(4) NOT NULL default '0',
PRIMARY KEY (layout_id),
KEY idx_name_template_zen (layout_template,layout_box_name),
KEY idx_layout_box_status_zen (layout_box_status),
KEY idx_layout_box_sort_order_zen (layout_box_sort_order)
) ENGINE=MyISAM;
/!40101 SET character_set_client = @saved_cs_client */;

Is show_box_min_width tinyint(1) NOT NULL DEFAULT '1' applicable to v155 or 160?
That was added in earlier versions of the DIY responsive components.

It was not ported to v1.5.5

Ok. I can edit individual side boxes. Thank you.

Ability to add to cart is gone.

Do I need to run the new zc installer?

Still, *I cannot add to or edit cart again. No debugs in the logs folder.

Any advice?*

webskipper, can you put a fresh new unaltered v155 install (with demo data) into a subdirectory for us to compare against your live site?

I moved the top to the 155 Responsive feedback topic.

Oy, I don't see how this is specific to the 155 Responsive Classic template

deleted

DrByte:

Oy, I don't see how this is specific to the 155 Responsive Classic template

Me, too.

When I switch to the Classic Money green template I can turn off/on any side box.

When I switch back to the Classic Responsive template I cannot turn off/on any side box.

I am forced to use RESET and walk away.

This is disappointing. Please advise.

webskipper:

Me, too.

When I switch to the Classic Money green template I can turn off/on any side box.

When I switch back to the Classic Responsive template I cannot turn off/on any side box.

I am forced to use RESET and walk away.

This is disappointing. Please advise.
Um, we talked about this already. The auto increment on the layout_boxes table. ... you'll need to first delete all the entries with layout_box_id = 0, and then set that field to be autoincrement. Then you can do a reset to recreate all the zeros just deleted, and it should let you save changes again.

I misunderstood you the first time, Doc.

So, what you are saying is reset all int(#) to zero? For all tables as well? Right column boxes do not show.

DROP TABLE IF EXISTS layout_boxes;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE layout_boxes (
layout_id int(0) NOT NULL AUTO_INCREMENT,
layout_template varchar(64) NOT NULL DEFAULT '',
layout_box_name varchar(64) NOT NULL DEFAULT '',
layout_box_status tinyint(0) NOT NULL DEFAULT '0',
layout_box_location tinyint(0) NOT NULL DEFAULT '0',
layout_box_sort_order int(0) NOT NULL DEFAULT '0',
layout_box_sort_order_single int(0) NOT NULL DEFAULT '0',
layout_box_status_single tinyint(0) NOT NULL DEFAULT '0',
PRIMARY KEY (layout_id),
KEY idx_name_template_zen (layout_template,layout_box_name),
KEY idx_layout_box_status_zen (layout_box_status),
KEY idx_layout_box_sort_order_zen (layout_box_sort_order)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

Do you also want ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8; to be?

ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

I think I found an error on my end because downloading the backup copy of the DB does not show the changes I make i.e adding auto_increment. I delete all the lines above the first instance of DROP TABLE IF EXISTS address_book and also below the last instance of UNLOCK TABLES. Copy pasted file directly into admin sql, correct?