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

merlinofchaos’s picture

merlinofchaos commented
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?

damatmadeforcom’s picture

damatmadeforcom commented

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.

damatmadeforcom’s picture

damatmadeforcom commented

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

merlinofchaos’s picture

merlinofchaos commented

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.

damatmadeforcom’s picture

damatmadeforcom commented

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.

merlinofchaos’s picture

merlinofchaos commented

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?

eljay’s picture

eljay commented

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.

esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Active
summit’s picture

summit commented
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

djdevin’s picture

djdevin
he/him
Primary language English
Location Philadelphia
commented

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.

djdevin’s picture

djdevin
he/him
Primary language English
Location Philadelphia
commented

Yep this is why. There was a custom module calling a ctools info/include very early on. When it was disabled everything was fine.

japerry’s picture

japerry
Location KOMK
commented
Issue summary: View changes
Status: Active » Closed (outdated)

Drupal 7 is no longer supported, closing.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.