SMF Support > Install and Upgrade Help

Upgrade fail - Converting "membergroups"... Unsuccessful!

(1/4) > >>

madfiddler:
This query:
INSERT IGNORE INTO fiddleforum_membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (1, 'Forum Owner', '#FF0000', -1, '5#staradmin.gif'),
(2, 'Global Moderator', '#0000FF', -1, '5#stargmod.gif'),
(3, 'Moderator', '', -1, '5#starmod.gif'),
(4, 'Newbie', '', 0, '1#star.gif'),
(5, 'Jr. Member', '', , '2#star.gif'),
(6, 'Full Member', '', , '3#star.gif'),
(7, 'Sr. Member', '', , '4#star.gif'),
(8, 'Fiddle God', '', , '5#star.gif'),
(42, 'Fiddle Hell Organiser', '', -1, ''),
(41, 'Forum Committee', '', -1, ''),
(40, 'HonouraryModerator', '', -1, ''),
(43, 'Forum Sponsor', '', -1, '');
Caused the 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 ' '2#star.gif'),
(6, 'Full Member', '', , '3#star.gif'),

madfiddler:
Click try again, and it worked. But... did it?

Bouminok:
http://www.simplemachines.org/community/index.php?topic=7200.0

Chris Cromer:
His isn't exactly the same as that one.

You need to remove the ', ' from all of those group names admin the admin center. Then you can re-add them after the upgrade.

Bouminok:

--- Quote from: Chris Cromer on March 14, 2004, 12:54:30 PM ---His isn't exactly the same as that one.

You need to remove the ', ' from all of those group names admin the admin center. Then you can re-add them after the upgrade.

--- End quote ---

Oh right, sorry, only looked at first glance :-[

Navigation

[0] Message Index

[#] Next page

Go to full version