SQL Syntax error managemembergroups.php

[G6Cad]

Know this is a SMF support question, but they are not all that good in responding on the questions there as we are here 

I get this error when i try to change the stars from the original to other colors. I choose the badge instead of the stars, the badge show up, i click the "done" button and come to this error screen, and the same error comes up in the error log.  Im running on 1.1Rc2 and TP V0.91. Arcade mod installed and configured by eeek at smfarcade.net.  Anyone know how i can fix this? 

Code Select Expand

http://www.familjegodis.se/forum/index.php?action=membergroups;sa=edit;group=1
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 'WHERE ID_GROUP = 1
LIMIT 1' at line 4
File: /*******/*******/******/*****/forum/Sources/ManageMembergroups.php
Line: 456

The code look like this at the line the error are at. Last line in the code are the 456

Code Select Expand

// Do the update of the membergroup settings.
      db_query("
         UPDATE {$db_prefix}membergroups
         SET groupName = '$_POST[group_name]', onlineColor = '$_POST[online_color]',
            maxMessages = $_POST[max_messages], minPosts = $_POST[min_posts], stars = '$_POST[stars]', showAddBadge = $_POST[showAddBadge]
         WHERE ID_GROUP = " . (int) $_REQUEST['group'] . "
         LIMIT 1", __FILE__, __LINE__);

[eeek]

Was there not a problem with RC2 soon after it was released?

2 files were released to fix a problem, Im sure it was something to do with groups..??

Id think the package would have been changed and would depend when you downloaded your version of RC2.

Might be worth downloading the package and overwriting ManageMembergroups.php

[G6Cad]

I have the latest files released there 

I have replaced the file with one from my testsite, and that one seem to be good though, i have compared the two files, and they seem idetical even to the compare program. So I'm quite lost there, but the error with the other file is gone... Very strange