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

[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?

[bostasp]

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.

[bostasp]

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

[madfiddler]

How do I do that? via myphpadmin?

[Chris Cromer]

In the admin center. Edit your member groups and remove the apastrophe's from them.

[madfiddler]

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.

[Chris Cromer]

Go into the membergroups table and remove the apastrophe's from those rows manually then if you can't access the admin center.

[madfiddler]

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');

[Grudge]

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...

[Chris Cromer]

The problem seems to be that it isn't inserting the minPosts for some reason.

[madfiddler]

Aha, yes, you're right. I'll do it by hand... This is a supermod board btw.

[Chris Cromer]

Supermod isn't supported by SMF or YSE... wouldn't surprise me if it being a supermod board is behind this.

[madfiddler]

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

[Chris Cromer]

Well supermod gets farther and farther away from the YaBBSE codebase as versions increase because they add more mods and changes and stuff.

[[Unknown]]

This should no longer be a problem in the cvs...

-[Unknown]