Author Topic: SERVICE CURRENTLY NOT AVAILABLE! Error No. [500]  (Read 3417 times)

Offline pdembro

  • Newbie
  • *
  • Posts: 1
SERVICE CURRENTLY NOT AVAILABLE! Error No. [500]
« on: May 28, 2010, 03:12:19 PM »
We are having a problem with this message when customer tries to access the address book.....

SERVICE CURRENTLY NOT AVAILABLE!

Error No. [500]


Any thoughts?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,628
    • http://SKaero.com/
SERVICE CURRENTLY NOT AVAILABLE! Error No. [500]
« Reply #1 on: May 29, 2010, 01:48:38 AM »
Whats in your error log?

Offline umarzuki

  • Newbie
  • *
  • Posts: 2
SERVICE CURRENTLY NOT AVAILABLE! Error No. [500]
« Reply #2 on: June 01, 2010, 12:49:09 AM »
i got the same error on version 0.4b

last 10 lines of roundcube's error log

Code: [Select]
[01-Jun-2010 20:13:10] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_362854e01e622c9eadb19f5de03f3f93df46f31aa FROM 'SELECT * FROM contactgroups WHERE del<>1 AND user_id=? ORDER BY name']
[Native code: 1146]
[Native message: Table 'roundcubemail.contactgroups' doesn't exist]

[01-Jun-2010 20:13:10 +0800]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_362854e01e622c9eadb19f5de03f3f93df46f31aa FROM 'SELECT * FROM contactgroups WHERE del<>1 AND user_id=? ORDER BY name']
[Native code: 1146]
[Native message: Table 'roundcubemail.contactgroups' doesn't exist]
 in /var/www/html/roundcube/program/include/rcube_mdb2.php on line 272 (GET /roundcube/?_task=addressbook)


here's how i nailed it:
* note that i'm upgrading from 0.3.1 to 0.4b

i go to roundcube's installer folder (copy it back from tarball if already deleted it)
there will be updated min.inc.php and db.inc.php, replace it with the current one, note its permission bit
uncomment everything in SQL/mysql.update.sql except for your last version ie: i'm "upgrade from 0.3.1"

finally run
Quote
mysql roundcubemail -u roundcubeuser -p < /var/www/html/roundcube/SQL/mysql.update.sql
if your roundcube database user is roundcubeuser