Advertisement:

Author Topic: Problem creating new Membergroups -RC2-  (Read 6346 times)

Offline lindawww

  • Newbie
  • *
  • Posts: 3
Problem creating new Membergroups -RC2-
« on: December 31, 2005, 01:35:48 PM »
I try to add a  new Membergroup  and....

"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 3
File: /home/infonel/public_html/estuinfo/Sources/ManageMembergroups.php
Line: 264 "


I cannot create a new Membergroup

Offline Fizzy

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,676
  • Gender: Male
  • SMF World Domination
Re: Problem creating new Membergroups -RC2-
« Reply #1 on: December 31, 2005, 01:46:46 PM »
Hi,

Can you confirm that your file looks like

Code: [Select]
db_query("
INSERT INTO {$db_prefix}membergroups
(ID_GROUP, groupName, minPosts, stars, onlineColor)
VALUES ($ID_GROUP, SUBSTRING('$_POST[group_name], 1, 80)', " . ($postCountBasedGroup ? (int) $_POST['min_posts'] : '-1') . ", '1#star.gif', '')", __FILE__, __LINE__);

Lines 261 to 264
"Reality is merely an illusion, albeit a very persistent one." - A.E.


Offline Fizzy

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,676
  • Gender: Male
  • SMF World Domination
Re: Problem creating new Membergroups -RC2-
« Reply #2 on: December 31, 2005, 01:49:17 PM »
The Boss has a fix for this

Please use the attached file
"Reality is merely an illusion, albeit a very persistent one." - A.E.


Offline lindawww

  • Newbie
  • *
  • Posts: 3
Re: Problem creating new Membergroups -RC2-
« Reply #3 on: December 31, 2005, 01:54:06 PM »
Thanks!

Offline Fizzy

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,676
  • Gender: Male
  • SMF World Domination
Re: Problem creating new Membergroups -RC2-
« Reply #4 on: December 31, 2005, 02:17:27 PM »
Please don't thank me ...

Thank "The Man who Can"  Mr Grudge ;)



"Reality is merely an illusion, albeit a very persistent one." - A.E.


Offline Skipdawg

  • Sr. Member
  • ****
  • Posts: 895
  • Gender: Male
  • SMF Über Fan!
    • Skipdawg Central
Re: Problem creating new Membergroups -RC2-
« Reply #5 on: January 05, 2006, 12:44:46 PM »
The Boss has a fix for this

Please use the attached file

Well I'm glad there is a fix and some folks know what to do with it but! What do i do with this file?
I see a ManageMembergroups.template.php file there. Do we add this someplace or replace something or what? Come on folks were not all coders.
Skipdawg's Community

Powered by SMF 1.1.3

Offline Skipdawg

  • Sr. Member
  • ****
  • Posts: 895
  • Gender: Male
  • SMF Über Fan!
    • Skipdawg Central
Re: Problem creating new Membergroups -RC2-
« Reply #6 on: January 05, 2006, 12:53:14 PM »
LOL answer my own question here.
http://www.simplemachines.org/community/index.php?topic=63164.0

SMF search is awesome!  :) ;)
Skipdawg's Community

Powered by SMF 1.1.3