Author Topic: error no: 500 Service currently not available  (Read 3052 times)

Offline aaron_88

  • Newbie
  • *
  • Posts: 1
error no: 500 Service currently not available
« on: February 27, 2011, 09:17:25 AM »
Hi all,

I have uploaded roundcube to my webmail folder in my shared hosting.
but although I did everything correctly in setup process I get this error.

here is the error log:

B Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1b2dd0d6ec28542f1e3b6a6260ad83f349e407752 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?']
[Native code: 1146]
[Native message: Table 'adver88_roundcube.session' doesn't exist]
 in /home/adver88/public_html/webmail/program/include/rcube_mdb2.php on line 268 (GET /)

I guess it is related to tables in sql. I checked from phpmyadmin and there were nothing about  tabIes.

I dont have enogh info about how sql works. any help appreciated. thanks..

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,456
error no: 500 Service currently not available
« Reply #1 on: February 27, 2011, 10:31:22 AM »
sounds like you haven't run the mysql.initial.sql file in [rc root]/sql/ to actually create all the tables.

if you copy the contents of the file and just paste it into the SQL box after you have selected the adver88_roundcube database in phpmyadmin it should do the job.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and moreā€¦