Forums

mysql syntax error during upgrade

Permalink
5.2.1 to 5.3.2:

"Error occurred while upgrading: mysql error: [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 1] in EXECUTE("select cvID from CollectionVersions where cID = ?")
"

no idea what to do with this.
walkermacy
 
walkermacy replied on at Permalink Reply
walkermacy
the line in question is in the "collection_version.php" file in the "concrete>models" directory, in the definition of the "refresh_cache" function.
walkermacy replied on at Permalink Reply
walkermacy
i don't see any reason that this wouldn't work, but here's the code in question (starting at line 67):

public function refreshCache() {
         $db = Loader::db();
         $cID = $this->cID;
         $cvIDs = $db->GetCol("select cvID from CollectionVersions where cID = ?", $this->cID);
         foreach($cvIDs as $cvID) {
            Cache::delete('page', $cID . ':' . $cvID);
            Cache::delete('collection_version', $cID . ':' . $cvID);
            Cache::delete('collection_version_id', $cID . ':' . $cvID);
            Cache::delete('collection_version_id', $cID . ':RECENT');
            Cache::delete('collection_version_id', $cID . ':ACTIVE');
         }
      }


i'm using MySQL version 5.1.49