Trouble with Layout Boxes Controller

[Webskipper]

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;

[DrByte]

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;

[Webskipper]

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

[rbarbour]

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

[Webskipper]

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?

[Webskipper]

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

Any advice?

[DrByte]

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

[Webskipper]

deleted

[Webskipper]

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?

[DrByte]

i misunderstood you the first time, doc.

So, what you are saying is reset all int(#) to zero?

noooooooo!