PDO exception when going to the page management [#1516388]

Hello,
I get the next PDO exception when trying to go to the page managment.

Error message
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY c.updated ASC' at line 1: SELECT c.name, s.uid, c.updated FROM {ctools_object_cache} c INNER JOIN {sessions} s ON c.sid = s.sid WHERE c.obj = :obj AND c.name IN () ORDER BY c.updated ASC; Array ( [:obj] => page_manager_page ) in ctools_object_cache_test_objects() (line 134 of /home/madecom/sd/media/sites/all/modules/ctools/includes/object-cache.inc).

Any info solving that problem ?

Comments

Comment #1

merlinofchaos CreditAttribution: merlinofchaos commented 12 April 2012 at 16:45

Status:

Active

» Postponed (maintainer needs more info)

Well, the error here means that it is trying to retrieve something from the object cache with no name. How that's happening is a bit of a mystery.

Can you describe your setup? Does this happen on a fresh installation? Have you ever added a page manager page?

Comment #2

damatmadeforcom CreditAttribution: damatmadeforcom commented 16 April 2012 at 23:02

I'm working with a drupal 7.10 install.

This happened after an apache solr module update.
So it was long since it was a fresh install.
The page manager was clearly working before this update.

Comment #3

damatmadeforcom CreditAttribution: damatmadeforcom commented 17 April 2012 at 16:15

Very strange behavior.
after updating page manager module and reinstalling both ctools and page, the panels and page manager seemed to work again.
But after un while, maybe two or three hours it's broken again.
Now we have this error reports in the log :

Invalid plugin module/type combination requested: module page_manager and type tasks

Comment #4

merlinofchaos CreditAttribution: merlinofchaos commented 17 April 2012 at 16:42

Oh that's really weird. That indicates that somehow the results of hook_ctools_plugin_type is getting lost. I don't have any idea how that could possibly happen; it's absolutely not supposed to be possible.

Comment #5

damatmadeforcom CreditAttribution: damatmadeforcom commented 17 April 2012 at 16:44

found a track :
the empty cache causes the problem.
after reinstalling both ctools and panels, the page reappears.
If we empty the cache, we have the page management issue.

Comment #6

merlinofchaos CreditAttribution: merlinofchaos commented 17 April 2012 at 16:58

So you get bitten by the module_implements cache being cleared but somehow not being regenerated properly. That's very interesting. Maybe there's some module that's building that particular cache in a state where page manager module is somehow not loaded?

Maybe look around for modules doing a ctools_include('plugins') during hook_boot?

Comment #7

eljay CreditAttribution: eljay commented 24 April 2012 at 09:43

I had more or less the same issue. It happened after an upgrade from D6 to D7 and after a fresh D7 install and trying to import a sql file. Then I found in some thread that changing the msql.ini file, either in XAMPP or in WAMP, more specifically, changing max_upload_packets from 1M to 16M, 32M or 64M might do the trick. I tried it and voila, the PDO-exception no longer occurs.

Comment #8

esmerel CreditAttribution: esmerel commented 11 July 2012 at 18:02

Status:

Postponed (maintainer needs more info)

» Active

Comment #9

Summit CreditAttribution: Summit commented 6 May 2013 at 17:25

Version:

7.x-1.0

» 7.x-1.x-dev

Hi,
I tried this in settings.php. I am on a shared host and can't change php.ini...

ini_set('post_max_size', '10M');

But it doesn;t work...
Greetings, Martijn

Comment #10

djdevin

Philadelphia

CreditAttribution: djdevin commented 12 July 2013 at 17:02

I get about a thousand of these, after a D6->D7 migration.

Invalid plugin module/type combination requested: module page_manager and type tasks
Invalid plugin module/type combination requested: module panelizer and type entity

My guess is something already in the DB is screwing it up, or an old D6 panel in code. Panel(s/izer) is completely broken after the upgrade. It looks like the plugins just aren't building. panelizer_ctools_plugin_type() isn't even getting called before those errors appear.

The "Invalid plugin module/type combination requested: module page_manager and type tasks" is responsible for the SQL error, because there are no page manager tasks and an empty array gets passed in to a SQL in().

Still investigating.