Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I tried editing the settings for Update Frequency and Old Messages in Chat and received this error:
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 'WHERE nid = 35' at line 8 query: UPDATE chatroom SET poll_freq = 10000, idle_freq = 60000, old_msg_count = 10, kicked_out_message = '', banned_message = '', WHERE nid = 35 in /home3/sites/all/modules/chatroom/chatroom.module on line 157.
The settings I changed also did not take.
Comment | File | Size | Author |
---|---|---|---|
#7 | 328089.patch | 379 bytes | Paul Natsuo Kishimoto |
Comments
Comment #1
pbc CreditAttribution: pbc commentedif i understand it right, there are excessive commas in chatroom.module, function chatroom_update, at the end of lines 148 and 156.
when i removed them, the update in table chatroom succeeded.
(however, when re-entering the edit panel to check the freshly entered values, the kicked out message and banned message are not displayed. so my answer provokes another question ;-)
Comment #2
Babalu CreditAttribution: Babalu commentedi have the same error
Comment #3
miahawk CreditAttribution: miahawk commentedI do as well, running drupal 6.6 on php 5.2.
Comment #4
korvus CreditAttribution: korvus commentedSame here with Drupal 6.8. The error is actually just an extra comma on line 148 (before the "WHERE" on the next line). The comma on 157 is just a style thing (and I believe should be there, according to Drupal coding standards).
Comment #5
CKIDOWSame problem here :O
Comment #6
Max_Headroom CreditAttribution: Max_Headroom commentedConfirm. #4 sorts out the problem.
Comment #7
Paul Natsuo Kishimoto CreditAttribution: Paul Natsuo Kishimoto commentedAn actual patch! Originally posted to #335713: user warning on update...
Comment #8
neofutur CreditAttribution: neofutur commentedI confirm this patch is ok ( removing the last comma )
Comment #9
Anonymous (not verified) CreditAttribution: Anonymous commenteddoes this apply to the 6.x-2 branch?
Comment #10
Anonymous (not verified) CreditAttribution: Anonymous commentedComment #11
sachinrastogi CreditAttribution: sachinrastogi commentedhi any one please resolve one query related to SQL
If i have a table with 3 column Like (Name, Age, DepID) and there values are
Dan 20 1
Dan 20 1
Dan 20 2
Dan 20 1
Chal 20 10
Chal 20 10
Dan 20 1
Tan 20 2
Dan 20 1
I want to get distinct record with there RowID how i m getting