The data column is 'text' which only holds 65535 characters in MySQL, and I've run into that limit twice already.

CommentFileSizeAuthor
#7 panels_object_cache-longtext.patch823 bytesjohn morahan

Comments

gracearoha’s picture

gracearoha commented

Could this be contributing to the problem of not being able to add additional panes to a panels page?

john morahan’s picture

john morahan commented

Quite possibly; that was indeed how the problem manifested itself for me. Is there an issue for that already?

Try this:

SELECT MAX(LENGTH(data)) FROM panels_object_cache;

If you get 65535, chances are you're running into this limit. If you get something else, you have a different problem.

gracearoha’s picture

gracearoha commented

As i'm adding panes to pages i am now finding that i can add 7 to 8 panes before the panels page stops saving, but then i can go on to start another panels page and add approximately the same number of panes before it stops saving. During these first few panes, the mysql limit had started at a little over 61,000 characters in the panels_object_cache. When i got to the 5th view, after 7 panes i finally (again) received the "invalid input" error when i tried to add a pane. I again checked the character count in the panels_object_cache and found that it was 65535.

I went out of the panels edit page, returned to it and was then able to add the pane that had previously brought up the "invalid input" error and then tried to add the ninth pane and again it wouldn't save. I then went in and added my sixth panel page and was again able to add 7 panes before it stopped saving. the cache character count now read 61836. I again added another panels page and added panes until it would no longer save anymore. the cache counter read only 62079.

So i don't know what the deal is.

I also posted on this issue here: http://drupal.org/node/207158
and have seen a similiar issue here: http://drupal.org/node/222869

john morahan’s picture

john morahan commented

Okay, try this and see if it helps:

ALTER TABLE panels_object_cache CHANGE COLUMN data data longtext;

Sorry I don't have time to roll a proper patch right now.

gracearoha’s picture

gracearoha commented

Ureka! That's it. After three weeks of hell, it was something so simple.
Thanks so much for your help!

I will also post this solution on the other threads mentioned in #3.

vanderlip’s picture

vanderlip commented

I have a similar problem as outline in #3, unfortunately I applied the suggestion in #4 and it did not resolve the problem. I still get "invalid input" errors in the pop up window when trying to add another pane. I am using a Panel to create node overrides for 7 different node types each with a number of panels. I believe that merlin indicated in another thread that there should not be a limit to the number of panes that can be added to a panel. Any assistance would be greatly appreciated.

Thanks

john morahan’s picture

john morahan commented
Status: Active » Needs review
StatusFileSize
new panels_object_cache-longtext.patch823 bytes

Only changing the MySQL case, as 'text' is supposedly big enough in pgsql (although I haven't tested).

john morahan’s picture

john morahan commented
Status: Needs review » Closed (duplicate)

Moving to the older issue.
http://drupal.org/node/207158

vanderlip’s picture

vanderlip commented

Thanks John, this appears to have done the trick. I appreciate the help.