Author Topic: Error No. [0x01F4]  (Read 8215 times)

Offline Yann

  • Jr. Member
  • **
  • Posts: 46
Error No. [0x01F4]
« on: February 01, 2009, 12:11:34 AM »
I can not access my mails, I've got "SERVICE CURRENTLY NOT AVAILABLE!
Error No. [0x01F4]". Does anyone know how to fix this. I'm using RC 0.2 beta.

The log shows DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1e49ffe97670fd08792b29a5d177083d84388901d FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 145]
[Native message: Table './mymail/session' is marked as crashed and should be repaired]
 in /home/mydomain/public_html/web/users/my_mail/program/include/rcube_mdb2.php on line 248 (GET /web/users/my_mail/)


Thanks
« Last Edit: February 01, 2009, 12:19:00 AM by Yann »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Error No. [0x01F4]
« Reply #1 on: February 01, 2009, 12:52:13 AM »
Well, the log reports that roundcube database session table is corrupt. I would try to delete the table and to re-create it by ...

Code: [Select]

-- Table structure for table `session`

CREATE TABLE `session` (
 `sess_id` varchar(40) NOT NULL,
 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `ip` varchar(40) NOT NULL,
 `vars` text NOT NULL,
 PRIMARY KEY(`sess_id`),
 INDEX `changed_index` (`changed`)
) TYPE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;


Maybe you have to restart mysql service. Then try again.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Yann

  • Jr. Member
  • **
  • Posts: 46
Error No. [0x01F4]
« Reply #2 on: February 01, 2009, 07:59:48 AM »
I woke up this morning and gave it a try again and the last thing i knew was it came back to normal by itself. That was weird though. I think the problem was my host, weird things happened with them the last 2 days around the same time, I could not access my DBs and MySQL was unavailable (came up with error message) and they told me to wait 15-30mn. Since then I noticed everything related to DB has a kind of problem. Thanks for your prompt response Rosali.
« Last Edit: February 01, 2009, 09:12:08 AM by Yann »

Offline Romulux

  • Jr. Member
  • **
  • Posts: 11
Error No. [0x01F4]
« Reply #3 on: March 11, 2009, 11:27:38 AM »
@rosali
thanks for code (create table 'session'), this solved one of my problems. But there is still the same problem with the table 'xyz.users", which doesn't exist. Could you possibly post a similar code for creating the table users, pls? I guess I have to set up all tables manually in the database, because after installation of roundcube the database was empty.
thx

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Error No. [0x01F4]
« Reply #4 on: March 11, 2009, 11:29:13 AM »
Please post error logs! Thnx.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Romulux

  • Jr. Member
  • **
  • Posts: 11
Error No. [0x01F4]
« Reply #5 on: March 11, 2009, 11:36:08 AM »
Klar:

[11-Mar-2009 15:46:38 +0100] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3e2693427521efcc7a3b3db751cb806823694281a FROM 'SELECT * FROM users WHERE mail_host=? AND username=?']
[Native code: 1146]
[Native message: Table 'roundcube.users' doesn't exist]
 in /home/www/xxxx/html/mail/program/include/rcube_mdb2.php on line 255 (POST /mail/?_task=&_action=login)

Thank you for your help

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Error No. [0x01F4]
« Reply #6 on: March 11, 2009, 12:56:28 PM »
... hmmm?

Code: [Select]

[Native message: Table 'roundcube.users' doesn't exist]


Do you use default RoundCube or my customized MyRoundCube?

It looks like your roundcube database is "roundcube". By default it is "roundcubemail". Is there a special reason not to use the defaults?

Try to adjust ./config/db.inc.php ==>

$rcmail_config
['db_dsnw'] = 'mysql://roundcube:pass@localhost/here goes your roundcube database, default is ==> roundcubemail';
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Romulux

  • Jr. Member
  • **
  • Posts: 11
Error No. [0x01F4]
« Reply #7 on: March 11, 2009, 01:27:18 PM »
not solved, still getting Error No. [0x01F4] at login:
- I use default roundcube v0.2.1 from yesterday, March 10th
- name of database is not "roundcubemail". Reason: Name of db is given from my provider when creating a new db.
- the name of db was correctly entered into ./config/db.inc.php ($rcmail_config['db_dsnw']) during installation.

My database doesnt have a table 'users'. I expect that a "Create Table Code" should fix that (as your code did it with the missing 'session' table).

Any ideas?

Thank you

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Error No. [0x01F4]
« Reply #8 on: March 11, 2009, 02:03:23 PM »
Look into ./SQL folder. You'll find there initial Database setup sripts for default roundcube. Can you access ./installer/index.php ? It should setup your database properly ...
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Romulux

  • Jr. Member
  • **
  • Posts: 11
Error No. [0x01F4]
« Reply #9 on: March 11, 2009, 02:41:21 PM »
Worked! Thanx a lot.
In ./sql folder i found "mysql.initial". With these codes i could set up the missing tables
- users
- messages
- cache
- contacts
- identities
The installer didn't do that.
Thank you for your help indeed - now i can access my inbox. Well, the inbox is the only folder i get, but that's probably another issue - i'll google that first.
Vielen Dank und schönen Abend!

Offline piden68

  • Newbie
  • *
  • Posts: 1
Error No. [0x01F4] how to solve it?
« Reply #10 on: May 15, 2009, 03:28:39 PM »
I'm got problem.

SERVICE CURRENTLY NOT AVAILABLE!
Error No. [0x01F4]

Quote
[16-May-2009 01:57:13 +0800] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_15e49078c84c20e498e3b1607979d92dca6111a8d FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'ukhwahfi_roundcubemail.session' doesn't exist]
 in /home/xxxxx/public_html/lain2/roundcubemail/program/include/rcube_mdb2.php on line 255 (GET /)




i'm still can't solve this problem. somebody please help me...
what will i do with this kind of problem?

Regard
Far East

Offline genov80

  • Newbie
  • *
  • Posts: 1
Error No. [0x01F4] how to solve it?
« Reply #11 on: May 21, 2009, 05:30:53 AM »
It's the same with me too. Can you tell me please what should I write in 'mysql.initial.sql'.
Thanks!

Offline Romulux

  • Jr. Member
  • **
  • Posts: 11
Error No. [0x01F4]
« Reply #12 on: August 12, 2009, 03:17:26 AM »
There's nothing to be written into 'mysql.initial.sql'. This file provides the code for creating the missing tables in your empty database:
- session
- users
- messages
- cache
- contacts
- identities
The installer had a problem with creating those tables in earlier versions of RC. This should be fixed in the meantime (0.2.2 or later). Use the latest version of RC to avoid this problem.
Procedure for 0.2.1: Enter the code you found in 'mysql.initial.sql' into your php-editor and execute it on your database. That's the way how you can create all missing tables, one after the other. Good luck and sorry for the late reply.
« Last Edit: August 12, 2009, 03:20:01 AM by Romulux »