Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: aberrio on October 13, 2010, 08:03:47 PM

Title: Unable to activate cache
Post by: aberrio on October 13, 2010, 08:03:47 PM

Hello,

I just upgrade to 0.4. but, I getting the following error when I set the caching option on..

[13-Oct-2010 17:55:42 -0500]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_6893b70b7a841ff873f011d39e529a4e320c8c8f2 FROM 'INSERT INTO messages (user_id, del, cache_key, created, idx, uid, subject, `from`, `to`, cc, date, size, headers, structure) VALUES (?, 0, ?, now(), ?, ?, ?, ?, ?, ?, FROM_UNIXTIME(1263506121), ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'structure' in 'field list']

How to upgrade my fields list to the current version?

Also, How to fix the time_zone issue in php53

[13-Oct-2010 17:59:51] PHP Warning:  mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST' instead in /srv/www/vhosts/webmail.tchosting.net/program/include/rcmail.php on line 677
[13-Oct-2010 18:00:06] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST' instead in /srv/www/vhosts/webmail.tchosting.net/program/include/main.inc on line 1005
[13-Oct-2010 18:00:06] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST' instead in /srv/www/vhosts/webmail.tchosting.net/program/include/main.inc on line 1009



Kind regards,

Al

Title: Unable to activate cache
Post by: SKaero on October 13, 2010, 11:25:40 PM

1. Just drop the messages table in the database add recreate it from the /SQL/mysql.initial.sql
2. Make sure date.timezone is set in the php.ini

Title: Unable to activate cache
Post by: aberrio on October 14, 2010, 07:22:27 PM

Hello,

I had updated the tables but I am not able to activate the cache.

$rcmail_config['enable_caching'] = false;

If I changed to true I am receiving SERVICE not ACTIVE in top but there is no error in the log file.  The data base error is gone.

Any suggestion.

Regards,

Al

Title: Unable to activate cache
Post by: SKaero on October 14, 2010, 08:04:04 PM

Can you enable sql logging in /config/main.inc.php

Code: [Select]

$rcmail_config['sql_debug'] = true; and post the log?

Title: Unable to activate cache
Post by: aberrio on October 15, 2010, 08:29:22 PM

Hello,

I will try.

Kind regards,

Al