Hello All, This is my first post to this list and i am very happy with Roundcube .. I am having a problem while setting up markasjunk2 plugin which is using sa_blacklist Driver. I am also using sauserprefs plugin which is working perfectly and all my setting being stored in mysql database. Can any one help me here is the error while clicking on spam button in webmail :-
Server Error! Service Currently Not available
Logs shows :-
[09-Nov-2010 17:48:06 +0530]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_63b151dc0daee21713d7035ee522a47b0ac33e46b FROM 'SELECT idx, headers, structure FROM messages WHERE user_id=? AND cache_key=? AND uid=?'] [Native code: 1146] [Native message: Table 'spamassassin_db.messages' doesn't exist] in /var/www/webmail/program/include/rcube_mdb2.php on line 264 (POST /webmail/?_task=mail&_action=plugin.markasjunk2.junk?_task=&_action=) [09-Nov-2010 17:48:06] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_74fe23ef195e80e644264d2fe2bc403c233a11967 FROM 'UPDATE cache SET created=now(), data=? WHERE user_id=? AND cache_key=?'] [Native code: 1146] [Native message: Table 'spamassassin_db.cache' doesn't exist]
[09-Nov-2010 17:48:06 +0530]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_74fe23ef195e80e644264d2fe2bc403c233a11967 FROM 'UPDATE cache SET created=now(), data=? WHERE user_id=? AND cache_key=?'] [Native code: 1146] [Native message: Table 'spamassassin_db.cache' doesn't exist] in /var/www/webmail/program/include/rcube_mdb2.php on line 264 (POST /webmail/?_task=mail&_action=plugin.markasjunk2.junk?_task=&_action=)
Here is the config.inc.php contents:-
$rcmail_config['markasjunk2_learning_driver'] = 'sa_blacklist'; $rcmail_config['markasjunk2_read_spam'] = true; $rcmail_config['markasjunk2_unread_ham'] = false; $rcmail_config['markasjunk2_detach_ham'] = true; $rcmail_config['markasjunk2_spam_flag'] = 'null'; $rcmail_config['markasjunk2_ham_flag'] = null; $rcmail_config['markasjunk2_debug'] = false; $rcmail_config['markasjunk2_mb_toolbar'] = true; $rcmail_config['markasjunk2_sauserprefs_config'] = '../sauserprefs/config.inc.php'; _______________________________________________ List info: http://lists.roundcube.net/users/ BT/9b404e9e
On 09.11.2010 13:25, Joy wrote:
Hello All, This is my first post to this list and i am very happy with Roundcube .. I am having a problem while setting up markasjunk2 plugin which is using sa_blacklist Driver. I am also using sauserprefs plugin which is working perfectly and all my setting being stored in mysql database. Can any one help me here is the error while clicking on spam button in webmail :-
[Native message: Table 'spamassassin_db.cache' doesn't exist]
I don't know this plugin, but I can guess that it connects to sa database and the doesn't reconnect. Find DSN configuration in its config file and add ?new_link=true at the end of DSN string. Finally, you may try to disable caching.
p.s. it's not standard Roundcube plugin, so better try to contact with plugin's author (I think he maybe didn't test it with enable_caching=true).