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.