| Issue 1: | Query faalt bij login op MySQL 5 | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Blijkt dat ik nog nooit had ingelogd lokaal. Dit issue doet zich voor onder MySQL 5 en heeft waarschijnlijk weer te maken met een gereserveerd keyword dat er niet was in MySQL4. ERROR: 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 '18:56:34 AND !MAIL_TO.hasread AND !MAIL_TO.trashed AND !MAIL_TO.deleted ORDER BY' at line 6 ON QUERY: SELECT MAIL_HEADER.*, 0 FROM MAIL_HEADER INNER JOIN MAIL_TO ON MAIL_HEADER.mail_id = MAIL_TO.mail_id WHERE MAIL_TO.user_id = 92 AND sent > 2008-10-17 18:56:34 AND !MAIL_TO.hasread AND !MAIL_TO.trashed AND !MAIL_TO.deleted ORDER BY sent DESC
Oct 25, 2008
Project Member
#1
trenchcoat.philosopher@gmail.com
Status:
Fixed
|