Author Topic: RC 0.5 Adressbook error  (Read 3206 times)

Offline olesj

  • Jr. Member
  • **
  • Posts: 16
RC 0.5 Adressbook error
« on: January 24, 2011, 01:53:26 AM »
Hi

After installing a RC5.0 I've got a problem with Address Book.
When I click adressbook icon I get this error:

SERVICE Currently Not Available!

Error No.. [500]



I guess there is something missing in my SQL but how can I fix it.
Here is the error coming from the log.

[24-Jan-2011 07:46:43 +0100]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_39f87b2f5d9429b00b6aa99404fba87c6a92fce52 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 C:\Programmer\Apache Software Foundation\Apache2.2\htdocs\RC50\program\include\rcube_mdb2.php on line 268 (GET /rc50/?_task=addressbook)

:confused::confused:

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
RC 0.5 Adressbook error
« Reply #1 on: January 24, 2011, 03:40:28 AM »
The SQL upgrade didn't work, try running it manually.

Offline olesj

  • Jr. Member
  • **
  • Posts: 16
RC 0.5 Adressbook error
« Reply #2 on: January 24, 2011, 07:28:25 AM »
Thanks for you´r reply ...


Is there a guide how to do .

I found the mysql.update.sql file but don know what to do ..

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
RC 0.5 Adressbook error
« Reply #3 on: January 24, 2011, 07:54:13 AM »

Offline olesj

  • Jr. Member
  • **
  • Posts: 16
RC 0.5 Adressbook error
« Reply #4 on: January 24, 2011, 10:57:01 AM »
Quote from: skaero;32696
Here's the update guide: Howto_Upgrade ? Roundcube Webmail

Where I need help is enough to run the script in my MySql database.

What and where should I start ..

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
RC 0.5 Adressbook error
« Reply #5 on: January 24, 2011, 11:18:34 AM »
Copy all of the the lines under the version your updating from in the update sql file from and run in your RoundCube database. The easiest way would be to use phpMyAdmin to run the queries.