I found that the themes just keep accumulating in our MySQL database, seems as though the code in SMHOME/functions/db_prefs.php contains the following:
if ($this->db_type == SMDB_MYSQL) {
$query = sprintf("REPLACE INTO %s (%s, %s, %s) ".
"VALUES('%s','%s','%s')",
$this->table,
$this->user_field,
$this->key_field,
$this->val_field,
$this->dbh->quoteString($user),
$this->dbh->quoteString($key),
$this->dbh->quoteString($value)); $res = $this->dbh->simpleQuery($query);
if(DB::isError($res)) {
$this->failQuery($res);
}The "REPLACE INTO" syntax doesn't appear to be supported, I changed the line:
if ($this->db_type == SMDB_MYSQL) {to:
if ($this->db_type == SMDB_MYSQL2) {now, it uses the "delete" then "insert" logic below that covers exceptions besides "MySQL" and "PostgreSQL".
We're running MySQL on Redhat Enterprise Linux (mysql-3.23.58-2.3) - so I guess it doesn't support that syntax? Or perhaps the SQL is incorrect?
Regards, Eric Carter UCIrvine | Network & Academic Computing Services
------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt -- squirrelmail-users mailing list Posting Guidelines: http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines List Address: [email protected] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
