Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Topic started by: madfiddler on March 14, 2004, 12:50:56 PM

Title: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 12:50:56 PM
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'),
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 12:52:12 PM
Click try again, and it worked. But... did it?
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: bostasp on March 14, 2004, 12:52:44 PM
http://www.simplemachines.org/community/index.php?topic=7200.0
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: 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.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: bostasp on March 14, 2004, 12:57:52 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.

Oh right, sorry, only looked at first glance :-[
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 01:15:13 PM
How do I do that? via myphpadmin?
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Chris Cromer on March 14, 2004, 01:15:57 PM
In the admin center. Edit your member groups and remove the apastrophe's from them.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 01:21:08 PM
mmm. trouble is, I'm going about the upgrade a strange way.

I've uploaded a clean smf install to a test directory, then uploaded the update files on top of that. So I have no access to yabbse admin to make these changes.

Strange, as the first install I did earlier today worked perfectly, apart from a calender error. Installs no good now as I managed to delete myself (the admin) from the memberlist via the membergroups page.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Chris Cromer on March 14, 2004, 01:23:49 PM
Go into the membergroups table and remove the apastrophe's from those rows manually then if you can't access the admin center.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 01:26:51 PM
Thanks for you help. This looks ok doesn't it? This is an export of the unconverted table. No quotemarks here or apast...

# --------------------------------------------------------

#
# Table structure for table `fiddleforum_membergroups`
#

DROP TABLE IF EXISTS `fiddleforum_membergroups`;
CREATE TABLE `fiddleforum_membergroups` (
  `ID_GROUP` bigint(4) NOT NULL auto_increment,
  `membergroup` tinytext NOT NULL,
  `grouptype` tinyint(1) NOT NULL default '0',
  `color` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID_GROUP`)
) TYPE=MyISAM AUTO_INCREMENT=44 ;

#
# Dumping data for table `fiddleforum_membergroups`
#

INSERT INTO `fiddleforum_membergroups` VALUES (1, 'Forum Owner', 0, 'purple');
INSERT INTO `fiddleforum_membergroups` VALUES (2, 'Moderator', 0, '');
INSERT INTO `fiddleforum_membergroups` VALUES (3, 'Newbie', 0, 'green');
INSERT INTO `fiddleforum_membergroups` VALUES (4, 'Jr. Member', 0, 'green');
INSERT INTO `fiddleforum_membergroups` VALUES (5, 'Full Member', 0, 'green');
INSERT INTO `fiddleforum_membergroups` VALUES (6, 'Sr. Member', 0, 'black');
INSERT INTO `fiddleforum_membergroups` VALUES (7, 'Fiddle God', 0, 'gold');
INSERT INTO `fiddleforum_membergroups` VALUES (8, 'Global Moderator', 0, 'purple');
INSERT INTO `fiddleforum_membergroups` VALUES (42, 'Fiddle Hell Organiser', 1, 'blue');
INSERT INTO `fiddleforum_membergroups` VALUES (41, 'Forum Committee', 1, 'blue');
INSERT INTO `fiddleforum_membergroups` VALUES (40, 'HonouraryModerator', 1, 'blue');
INSERT INTO `fiddleforum_membergroups` VALUES (43, 'Forum Sponsor', 1, 'orange');
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Grudge on March 14, 2004, 01:33:18 PM
Well - is it working yet? If not then on your *converted* forum using phpmyadmin empty the membergroups table and run this:
Code: [Select]
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', '', 50, '2#star.gif'),
(6, 'Full Member', '', 100, '3#star.gif'),
(7, 'Sr. Member', '', 250, '4#star.gif'),
(8, 'Fiddle God', '', 500, '5#star.gif'),
(42, 'Fiddle Hell Organiser', '', -1, ''),
(41, 'Forum Committee', '', -1, ''),
(40, 'HonouraryModerator', '', -1, ''),
(43, 'Forum Sponsor', '', -1, '');
You may need to mess around with it afterwards but that would make it work...
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Chris Cromer on March 14, 2004, 01:35:28 PM
The problem seems to be that it isn't inserting the minPosts for some reason. :-\
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 01:37:10 PM
Aha, yes, you're right. I'll do it by hand... This is a supermod board btw.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Chris Cromer on March 14, 2004, 01:43:05 PM
Supermod isn't supported by SMF or YSE... wouldn't surprise me if it being a supermod board is behind this. :-\
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: madfiddler on March 14, 2004, 01:56:19 PM
Yeah, I know. It's just really strange that it worked first time around. Mind you, that was with an older Smod version of my database
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: Chris Cromer on March 14, 2004, 01:58:04 PM
Well supermod gets farther and farther away from the YaBBSE codebase as versions increase because they add more mods and changes and stuff.
Title: Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
Post by: [Unknown] on March 14, 2004, 04:46:46 PM
This should no longer be a problem in the cvs...

-[Unknown]