Advertisement:

Author Topic: Upgrade fail - Converting "membergroups"... Unsuccessful!  (Read 21130 times)

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Upgrade fail - Converting "membergroups"... Unsuccessful!
« 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'),

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #1 on: March 14, 2004, 12:52:12 PM »
Click try again, and it worked. But... did it?

Offline Bouminok

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,201

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #3 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.
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline Bouminok

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,201
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #4 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 :-[

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #5 on: March 14, 2004, 01:15:13 PM »
How do I do that? via myphpadmin?

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #6 on: March 14, 2004, 01:15:57 PM »
In the admin center. Edit your member groups and remove the apastrophe's from them.
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #7 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.

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #8 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.
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #9 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');

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #10 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...
I'm only a half geek really...

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #11 on: March 14, 2004, 01:35:28 PM »
The problem seems to be that it isn't inserting the minPosts for some reason. :-\
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #12 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.

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #13 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. :-\
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #14 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

Offline Chris Cromer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,745
  • Gender: Male
  • I am just a figment of your imagination!
    • Chris's AGI Web Site
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #15 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.
Chris Cromer

"I was here, here I was, was I here, sure I was" - The little voice in my head.

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: Upgrade fail - Converting "membergroups"... Unsuccessful!
« Reply #16 on: March 14, 2004, 04:46:46 PM »
This should no longer be a problem in the cvs...

-[Unknown]