Trouble with Layout Boxes Controller

21 Mar 2016, 20:31

#1

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

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

21 Mar 2016, 20:59

#2

rbarbour

Totally Zenned

Join Date:: Feb 2010
Posts:: 2,159
Plugin Contributions:: 6

Re: Trouble with Layout Boxes Controller

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.

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

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

21 Mar 2016, 23:57

#3

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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.

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

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.

22 Mar 2016, 00:15

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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.

22 Mar 2016, 00:24

#5

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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?

22 Mar 2016, 01:19

#6

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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?

22 Mar 2016, 01:28

#7

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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.

22 Mar 2016, 06:18

#8

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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;

22 Mar 2016, 15:18

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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;

22 Mar 2016, 16:31

#10

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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 */;

22 Mar 2016, 16:34

#11

rbarbour

Totally Zenned

Join Date:: Feb 2010
Posts:: 2,159
Plugin Contributions:: 6

Re: Trouble with Layout Boxes Controller

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

22 Mar 2016, 16:44

#12

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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?

24 Mar 2016, 17:24

#13

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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

Any advice?

24 Mar 2016, 17:32

#14

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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

24 Mar 2016, 17:34

#15

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

I moved the top to the 155 Responsive feedback topic.

24 Mar 2016, 17:42

#16

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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

24 Mar 2016, 18:17

#17

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

deleted

26 Mar 2016, 03:50

#18

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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.

26 Mar 2016, 12:56

#19

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Trouble with Layout Boxes Controller

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.

26 Mar 2016, 19:05

#20

webskipper

Totally Zenned

Join Date:: Nov 2007
Posts:: 876
Plugin Contributions:: 2

Re: Trouble with Layout Boxes Controller

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?