SQL db error being thrown when some members read their PM's

Started by ginjack, September 25, 2009, 01:46:54 PM

Previous topic - Next topic

ginjack

Database Error: 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 '1)' at line 3

SELECT id_group, group_name, stars, online_color
FROM smf_membergroups
WHERE id_group IN (,1)


I haven't made many recent changes to my forums, only addition of some new star images... not sure what caused this error to start generating.  We're using SMF 2.0 RC1.2

I'm attaching my load.php and sub-members.php in the hope that it helps to pin this down.

Any help or suggestions are greatly appreciated!


Currently running:

   Mod Name     Version     
1.    SMF Media Gallery    2.0 beta 6    
2.    Admin member list registration date    1.0
3.    More Genders    1.0.0    
4.    Arcadeworld Template    2.3
5.    E-Arcade    Beta4-SMF2rc1    
6.    PM Attachments    1.4    
7.    SimplePortal    2.3    
8.    SMG Slideshow Addon    1.0    
9.    Aeva ~ Auto-Embed Video & Audio    6.9.101    
10.    Topic Solved    1.1    
11.    Custom Fields On Memberlist    1.0    
12.    The Rules    1.2
13.    Hack's Park Shoutbox    2.0.1    
14.    WAP Mod By BxK    1.0.1    
15.    Birthday Posts    0.10.2 Beta    
16.    SMF Project Tools    0.3003    
17.    Treasury    2.36    [ Uninstall ]
18.    WoW - World of Warcraft Tooltips    1.1    
19.    Muppets Avatars    1.0    
20.    PM to New Members    1.2    
21.    Stars And Badges    2.1
22.    Profile Fields & Icons Mod    1.0
23.    SMF Arcade    2.5 Beta 6    
24.    Activate account redirection    0.1    
25.    Default_Membergroup    1.0.0.2    
26.    Geek Avatars V1.1    1.0
27.    game avatars    1.0

Xavi-Nena

I had the same thing just happen to me when updating manually my load.php for my smf media gallery update and i had to copy my back up load.php~ file.

H

If you still require assistance with this, you can try removing the "Default Membergroup" mod :)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

JBlaze

Can you check your error log in the admin panel for this error? It should show which file and line where this query is, and can help debug it.
Jason Clemons
Former Team Member 2009 - 2012

Advertisement: