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
-
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'),
-
Click try again, and it worked. But... did it?
-
http://www.simplemachines.org/community/index.php?topic=7200.0
-
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.
-
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 :-[
-
How do I do that? via myphpadmin?
-
In the admin center. Edit your member groups and remove the apastrophe's from them.
-
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.
-
Go into the membergroups table and remove the apastrophe's from those rows manually then if you can't access the admin center.
-
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');
-
Well - is it working yet? If not then on your *converted* forum using phpmyadmin empty the membergroups table and run this:
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...
-
The problem seems to be that it isn't inserting the minPosts for some reason. :-\
-
Aha, yes, you're right. I'll do it by hand... This is a supermod board btw.
-
Supermod isn't supported by SMF or YSE... wouldn't surprise me if it being a supermod board is behind this. :-\
-
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
-
Well supermod gets farther and farther away from the YaBBSE codebase as versions increase because they add more mods and changes and stuff.
-
This should no longer be a problem in the cvs...
-[Unknown]