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

Title: SQL db error being thrown when some members read their PM's
Post by: ginjack on September 25, 2009, 01:46:54 PM

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

Title: Re: SQL db error being thrown when some members read their PM's
Post by: Xavi-Nena on September 26, 2009, 07:59:17 PM

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.

Title: Re: SQL db error being thrown when some members read their PM's
Post by: H on October 08, 2009, 01:35:15 PM

If you still require assistance with this, you can try removing the "Default Membergroup" mod :)

Title: Re: SQL db error being thrown when some members read their PM's
Post by: JBlaze on October 08, 2009, 01:39:10 PM

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.

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: ginjack on September 25, 2009, 01:46:54 PM