Closed (fixed)
Project:
Forum Thread
Version:
5.x-1.0-beta
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
22 Apr 2008 at 15:07 UTC
Updated:
10 May 2008 at 21:44 UTC
Hi !
I get this error message when I call http://website.com/forum :
* user warning: 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 'LEFT JOIN vm_localizernode loc ON loc.nid=n.nid LEFT JOIN(SELECT -100 AS weight,' at line 1 query: SELECT tid from vm_forum group by tid LEFT JOIN vm_localizernode loc ON loc.nid=n.nid LEFT JOIN(SELECT -100 AS weight, CAST('de' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from vm_localizernode loc2 LEFT JOIN (SELECT -100 AS weight, CAST('de' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) in /www/htdocs/vocalmus/includes/database.mysql.inc on line 172.
* user warning: 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 'LEFT JOIN vm_localizernode loc ON loc.nid=n.nid LEFT JOIN(SELECT -100 AS weight,' at line 1 query: SELECT tid from vm_forum group by tid LEFT JOIN vm_localizernode loc ON loc.nid=n.nid LEFT JOIN(SELECT -100 AS weight, CAST('de' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from vm_localizernode loc2 LEFT JOIN (SELECT -100 AS weight, CAST('de' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) LIMIT 0, 25 in /www/htdocs/vocalmus/includes/database.mysql.inc on line 172.
Any idea ?
When I directly call acategory, everything works as expected.
Volker
Comments
Comment #1
jbrauer commentedIf you would try upgrading to the Dev version it has several fixes which fix some database things as well as many other cleanup items.
Comment #2
jbrauer commentedComment #3
acappellamaniac commentedJust installed the dev snapshot - everything works fine!!
Thanks a lot
Comment #4
jbrauer commentedfixed with newer version.
Comment #5
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.