An error in your SQL syntax

Mindaugasu - October 15, 2009 - 20:17
Project:Quotes
Version:6.x-1.40
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

After upgrading from 6.x-1.30 to 1.40 Sql error is showing and quotes block disappeared.

x-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 ''. r USING(uid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND (r.' at line 1 query: SELECT n.nid FROM quotes q INNER JOIN node n ON q.vid=n.vid LEFT JOIN users_roles '. r USING(uid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND (r.rid IN (3) OR (1 IN (3) AND n.uid = 0)) AND n.uid IN (3) ORDER BY n.created DESC LIMIT 0, 1 in /home/......./sites/all/modules/quotes/quotes.module on line 1308.

#1

NancyDru - October 17, 2009 - 15:17
Status:active» fixed

Committed to 6.x-1.x-dev

#2

System Message - October 31, 2009 - 15:20
Status:fixed» closed

Automatically closed -- issue fixed for 2 weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.