This seems like a pretty major issue to me, it's actually preventing me from creating content. I just enabled the module, and hadn't done any configuration. I'll see if configuring TAC Lite changes the error.

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 '))' at line 4: SELECT t.* FROM {taxonomy_index} r INNER JOIN {taxonomy_term_data} t ON r.tid = t.tid INNER JOIN {taxonomy_vocabulary} v ON t.vid = v.vid WHERE (r.nid = :db_condition_placeholder_0) AND (t.vid IN ()) ; Array ( [:db_condition_placeholder_0] => 54 ) in _tac_lite_get_terms() (line 460 of /Users/Matthew/TheInstitute/one-by-one/web/trunk/sites/all/modules/tac_lite/tac_lite.module).

Here's a screenshot of the page creation that's causing the error: https://skitch.com/idlewilder/r7rte/create-article-one-by-one

Disabling the "Taxonomy Access Control Lite Create" module did not affect the error.

Comments

safetypin’s picture

Title: PDOException Error » Content cannot be created if there is no access control configuration
Priority: Major » Normal

Okay, after completing minimal configuration (I just edited the "Scheme 1" and added a few "view" permissions for some of the terms/roles), this error did not appear and content was created successfully.

SchwebDesign’s picture

subscribing, experienced this error as well when rebuilding content permissions right after installing 7.x-1.x-dev

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /JOSHUA/drupal/?q=batch&id=12&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 '))' at line 4: SELECT t.* FROM {taxonomy_index} r INNER JOIN {taxonomy_term_data} t ON r.tid = t.tid INNER JOIN {taxonomy_vocabulary} v ON t.vid = v.vid WHERE (r.nid = :db_condition_placeholder_0) AND (t.vid IN ()) ; Array ( [:db_condition_placeholder_0] => 1 ) in _tac_lite_get_terms() (line 460 of /var/www/html/JOSHUA/drupal/sites/all/modules/tac_lite/tac_lite.module).
mckinleymedia’s picture

subscribe
I have the same issue.

Dave Cohen’s picture

Status: Active » Fixed

Should be fixed now.

Status: Fixed » Closed (fixed)

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