Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I have this :
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 '' at line 1 query: SELECT c.timestamp, c.cid, c.subject AS comment_title FROM comments c WHERE c.status = 0 AND c.subject LIKE '%%' ORDER BY in /.../modules/commentreference/commentreference.module on line 533.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | 485248.patch | 2.72 KB | swentel |
Comments
Comment #1
swentel commentedSo, this is after submitting a new field which is comment reference ?
Did you choose autocomplete or select box ? And did you provide a default value ?
Comment #2
swentel commentedOk, I can reproduce the error when I choose the default_value with an autocomplete widget.
Note, it doesn't happen if you re-edit the field, looking for a solution now.
Comment #3
swentel commentedCan you try out the patch attached, should fix the issue. Note, only happens on creation, autocomplete en trying to select a default value.
Comment #4
pixelpreview@gmail.com commentedyes i will try the patch, you are right
the warning is only when i create the cck after it disappear definitively
Comment #5
pixelpreview@gmail.com commentedthank you the patch it is perfect :-)
It will be fine in the future to have a little admin to modify the display for the comment reference module.
actualy i have modified your theme function because i want all the comment (user name, date, comment and title) with no link on the display.
I use your comment module to pick up a comment and show it in my body like a super comment :-)
thank you for your rapidity :-)
Comment #6
swentel commentedHmm, that's actually a nice feature, can you post that theming function otherwhise, I'll add an extra formatter function to include in the next release!
Comment #7
swentel commentedFix committed to drupal 6 branch.