Problem with quotation marks
alasda - October 28, 2009 - 21:13
| Project: | Quotes |
| Version: | 6.x-1.40 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Description
Watchdog reports this error every time a quote block is viewed:
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 ''. qur USING(uid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND (' at line 1 query: SELECT DISTINCT(n.nid) FROM quotes q INNER JOIN node n ON q.vid=n.vid LEFT JOIN users_roles '. qur USING(uid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND (qur.rid IN (777) OR (1 IN (777) AND n.uid = 0)) ORDER BY RAND() LIMIT 0, 1 in /var/www/vhosts/pingv/htdocs/sites/all/modules/contrib/quotes/quotes.module on line 1224.See attached patch for fix.
| Attachment | Size |
|---|---|
| quotes.patch | 1.65 KB |