My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 1: Query faalt bij login op MySQL 5
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  trenchcoat.philosopher@gmail.com
Closed:  Oct 2008


 
Project Member Reported by trenchcoat.philosopher@gmail.com, Oct 24, 2008
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
De datum in de query moest tussen enkele aanhalingstekens staan om in MySQL 5 te werken.
Status: Fixed

Powered by Google Project Hosting