hi,
I have this erro rebulding cache when no connten type is enable to show contet conplete in the completeness.
thanks

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=13&op=do StatusText: Service unavailable (with message) ResponseText: 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 ')) ) subquery' at line 1: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {node} node WHERE (type IN ()) ) subquery; Array ( ) in content_complete_rebuild_cache() (line 73 of C:\..\sites\all\modules\content_complete\content_complete.admin.inc).

CommentFileSizeAuthor
#5 content_complete_workaround-1142450-5.patch948 bytesmikeprinsloo

Comments

adamgerthel’s picture

adamgerthel commented

This happened to me as well. After activating it for a content type and trying to clear cache again I got this:

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: /batch?render=overlay&id=6&op=do StatusText: parsererror ResponseText: Fatal error: Cannot use string offset as an array in /Users/myusername/Sites/website/profiles/odddrupal/modules/contrib/date/date.field.inc on line 166

RonP’s picture

RonP commented

Same here

ptmkenny’s picture

ptmkenny commented

I just enabled content_complete for a content type and when I try to rebuild the cache I get this error:
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=18&op=do StatusText: Internal Server Error ResponseText:

I tried clearing the drupal cache twice with drush but no luck. Any ideas?

ptmkenny’s picture

ptmkenny commented

A little more information from the system log:

Location http://127.0.0.1:2011/en/batch?id=29&op=finished
Referrer http://127.0.0.1:2011/en/batch?op=start&id=29
Message Rebuild cache: error when calling operation '%s'('%s')

mikeprinsloo’s picture

mikeprinsloo commented
Version: 7.x-1.4-beta1 » 7.x-1.x-dev
Component: User interface » Code
Status: Active » Needs review
StatusFileSize
new content_complete_workaround-1142450-5.patch948 bytes

I had a similar problem when trying to rebuild the content complete cache. In my case Drupal complained that content complete was calling the function options_field_is_empty() which doesn't exist. Content complete uses the hook_field_is_empty() hook to determine whether or not a field has been filled, but the options module does not implement this hook. I think this should be fixed in Drupal core.

The options in my case were implemented by the organic groups module and I didn't want this field to be tracked by content complete anyhow. The problem is that content complete checks all fields for emptiness, not just the fields that you've selected, and this meant that it will fail for any group nodes.

I created a little workaround so it only checks selected fields for emptiness. This way I can disable any fields that might be giving me problems, and content complete won't be tripped up by them.

pvhee’s picture

pvhee commented
Status: Needs review » Fixed

Thanks for the patch mike.prinsloo. It makes sense to only check for fields that have been enabled for CC. I've committed your patch to the 7.x-1.x branch, and will soon be releasing the next beta. Thanks for the patch and apologies for the late reply.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.