Author Topic: Unable to activate cache  (Read 18750 times)

Offline aberrio

  • Jr. Member
  • **
  • Posts: 24
Unable to activate cache
« 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
« Last Edit: October 13, 2010, 08:18:23 PM by aberrio »

Online SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Unable to activate cache
« Reply #1 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

Offline aberrio

  • Jr. Member
  • **
  • Posts: 24
Unable to activate cache
« Reply #2 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

Online SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Unable to activate cache
« Reply #3 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?

Offline aberrio

  • Jr. Member
  • **
  • Posts: 24
Unable to activate cache
« Reply #4 on: October 15, 2010, 08:29:22 PM »
Hello,

I will try.

Kind regards,

Al
« Last Edit: October 15, 2010, 09:40:31 PM by aberrio »