mysql> explain panels_layout;
+-------------------+--------------+------+-----+---------+----------------+
| Field             | Type         | Null | Key | Default | Extra          |
+-------------------+--------------+------+-----+---------+----------------+
| lid               | int(11)      | NO   | PRI | NULL    | auto_increment |
| name              | varchar(255) | YES  |     | NULL    |                |
| admin_title       | varchar(255) | YES  |     | NULL    |                |
| admin_description | longtext     | YES  |     | NULL    |                |
| category          | varchar(255) | YES  |     | NULL    |                |
| plugin            | varchar(255) | YES  |     | NULL    |                |
| settings          | longtext     | YES  |     | NULL    |                |
+-------------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> explain panels_display;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| did             | int(11)      | NO   | PRI | NULL    | auto_increment |
| layout          | varchar(32)  | YES  |     |         |                |
| layout_settings | longtext     | YES  |     | NULL    |                |
| panel_settings  | longtext     | YES  |     | NULL    |                |
| cache           | text         | YES  |     | NULL    |                |
| title           | varchar(255) | YES  |     |         |                |
| hide_title      | tinyint(4)   | YES  |     | 0       |                |
| title_pane      | int(11)      | YES  |     | 0       |                |
+-----------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

The name field in panels_layout is 255 characters. The layout field in panels_display should also be 255 characters.

In the event that a layout name is longer than 32 characters, you get a truncated data error when trying to save the data to the database.

Comments

DamienMcKenna’s picture