Ticket #1485289 (closed Bugs: worksforme)

Opened 5 months ago

Last modified 5 months ago

Addressbook cause damage to MySQL access

Reported by: tr0n Owned by:
Priority: 5 Milestone: 0.2-beta
Component: Client Scripts Version: 0.2-alpha
Severity: major Keywords:
Cc:

Description

Hello there.

I have a bug in my RC: when a user add a contact using the [+] sign in mail addresses the contact successfully adds to DB, but then new mail and contacts sections shows me this message:

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

And the log in my server says me this:

[20-Aug-2008 19:52:06] MDB2 Error: syntax error (-2): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_491f62b95adc718728fe5985e37d8d3b00f6d8746 FROM 'SELECT * FROM contacts\n WHERE del<>1AND user_id=? ORDER BY name LIMIT 0, 1000'] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id=? ORDER BY name LIMIT 0, 1000' at line 1]

[20-Aug-2008 20:22:06 -0400] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_491f62b95adc718728fe5985e37d8d3b00f6d8746 FROM 'SELECT * FROM contacts\n WHERE del<>1AND user_id=? ORDER BY name LIMIT 0, 1000'] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id=? ORDER BY name LIMIT 0, 1000' at line 1]

in /var/www/webmail/program/include/rcube_mdb2.php on line 259

Change History

Changed 5 months ago by alec

  • status changed from new to closed
  • resolution set to worksforme
  • milestone changed from later to 0.2-beta

I think it was fixed. Try SVN version. Works for me.

Note: See TracTickets for help on using tickets.