Opened 5 years ago

Closed 5 years ago

#1485289 closed Bugs (worksforme)

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 (1)

comment:1 Changed 5 years ago by alec

  • Milestone changed from later to 0.2-beta
  • Resolution set to worksforme
  • Status changed from new to closed

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

Note: See TracTickets for help on using tickets.