Critical error on node type form submit (PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064...) [#1203962]

Installed current version from git and confirmed on two sites. Here is full 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 'WHERE (cid = 'page_title:settings')' at line 1: DELETE FROM {} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => page_title:settings ) in cache_clear_all() (line 169 of ...\includes\cache.inc).

Comments

Comment #1

nicholasthompson

English

commented 29 June 2011 at 15:06

:-(

/me looks into problem

How did you cause the error? (ie how do I reproduce?)

Comment #2

nicholasthompson

English

commented 29 June 2011 at 15:09

I have pushed an update the 7.x-2.x-dev - could you do a "git pull" and test please?

I think this was the issue....


[nthompson@centosdev page_title]$ git diff
diff --git a/page_title.module b/page_title.module
index f462a1a..fc216e5 100644
--- a/page_title.module
+++ b/page_title.module
@@ -739,7 +739,7 @@ function page_title_get_settings($flush = FALSE) {
   // Flush the settings, if set.
   if ($flush) {
     $settings = NULL;
-    cache_clear_all('page_title:settings');
+    cache_clear_all('page_title:settings', 'cache');
   }

   // If we have it statically cached, return it.