index.php/tools/required/reindex_pending_pages throwing 500 error

Permalink
My site is throwing a 500 error when trying to call index.php/tools/required/reindex_pending_pages?. I've cleared the cache, reinstalled the core, still happening. Any ideas?

 
JohntheFish replied on at Permalink Reply
JohntheFish
How may pages are there? Could it be the host's cpu/memory limits simply being overwhelmed? (It would need to be a pretty big site on a minimal shared hosting package to run into such limits)
jero replied on at Permalink Reply
jero
Typically a 500 error would be logged into your server error log. Your best bet is to track that down and examine it.
marcus30 replied on at Permalink Reply
Thanks for your replies. Here's the error from the log:
Call to a member function getCollectionID() on a non-object in root/blocks/product/controller.php on line 201


This is obviously an error in the core_commerce package. I'll drop the question over there.
jero replied on at Permalink Reply
jero
Have you got an override in place? That path name (root/blocks/product/controller.php)doesn't look like the standard ecommerce to me.

The error is basically saying the variable that was used when calling getCollectionID isn't an object, which it should be. The problem is actually before it gets to that part of the code.
enilondevelopers replied on at Permalink Reply
I'm having the same problem. I'm seeing in the apache logs:

Call to a member function getCollectionID() on a non-object in /Users/blakemiller/Projects/xxx-concrete-dev/packages/core_commerce/blocks/product/controller.php on line 201, referer:http://xxx.dev/index.php?cID=1

If I do this in the config file:
define('ENABLE_PROGRESSIVE_PAGE_REINDEX', false);

...the error doesn't occur. The error above would indicate something is loading the ecommerce product block, and I've traced it down to this line in the /concrete/elements/page_controls_header.php file (which runs the index):

if (ENABLE_PROGRESSIVE_PAGE_REINDEX && Config::get('DO_PAGE_REINDEX_CHECK')) {
$this->addHeaderItem('<script type="text/javascript">$(function() { ccm_doPageReindexing(); });</script>');
}
kflorida78 replied on at Permalink Reply
This is a problem with a concrete5 column datatype. Took me an hour to troubleshoot.

change the meta description and keyword columns too MEDIUMTEXT... (or you can add maxlengths to the textareas inside the core code (which I wouldn't suggest).

(note: my tables are lower-case, not camelCase)

Backup your database with a dump, then Run this script.
ALTER TABLE `collectionsearchindexattributes` 
CHANGE COLUMN `ak_meta_description` `ak_meta_description` MEDIUMTEXT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL ,
CHANGE COLUMN `ak_meta_keywords` `ak_meta_keywords` MEDIUMTEXT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL ;