SMF Support > Install and Upgrade Help

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

<< < (2/4) > >>

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

Navigation

[0] Message Index

[#] Next page

[*] Previous page