Making v154 DIY/Picaflor-Azul templates work with v1.5.5

[rbarbour]

@DivaVocals

Great explanation!

I would assume the errors were there even before the WP4Zen side-boxes were installed.

@soxophoneplayer

As Crystal (@DivaVocals) pointed out, the query tried to insert 10 values into 8 columns.

Removing , 0, 0 was the right option. I must have made one of my most common mistakes (copy and paste), the 10 values are actually used for my commercial templates which allows one to control the display on (Desktop, Tablet and Mobile) devices from the ADMIN Layout Boxes Controller.

I will update the GIT files to reflect.

I had success with all these edits for using Sheffield Blue Responsive template on zc 1.5.5.

But I ran into trouble when I tried to add WP4Zen mod on top of that. (posted on that forum). Trying to access the layout controller in the admin panel led to white blank page/error message.

In the end I tried taking two zero's out of the layoutcontroller.php around line #66 so it now looks like this:

// (BOF - EDIT) ZCA Responsive Components for 1.5.5

      $db->Execute("insert into " . TABLE_LAYOUT_BOXES . "
                  (layout_template, layout_box_name, layout_box_status, layout_box_location, layout_box_sort_order, layout_box_sort_order_single, layout_box_status_single, show_box_min_width)
                  values ('" . zen_db_input($template_dir) . "', '" . zen_db_input($file) . "', 0, 0, 0, 0, 0, 0)");

// (EOF - EDIT) ZCA Responsive Components for 1.5.5 

I'm just fumbling in the dark but that change seems to work - I can access/use the tools/layout controller. I hope I didn't cause other problems that I've yet to see.

Does anything jump out?

Wanted to jump in and add this..

The last two values you removed don't appear to have a corresponding column for those values in this SQL statement. (hence why you got the column count errors when activating the WP4Zen sideboxes) Without your edit the SQL statement has only 8 table columns named, but TEN values to insert. (So this SQL statement is either missing two table columns, or has too many values to insert)