I decided to try out upgrading a copy of my YSE 1.5.5 forum to SMF, but on step 6 of the upgrade process I get this:
Converting "membergroups"... Unsuccessful!
This query:
INSERT IGNORE INTO yabbse_membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (1, 'Aztec Guy\'s Friend', '#FF0000', -1, '5#staradmin.gif'),
(2, 'Global Moderator', '#0000FF', -1, '5#stargmod.gif'),
(3, 'Moderator', '', -1, '5#starmod.gif'),
(4, 'Member', '', 0, '1#star.gif'),
(5, 'Member', '', 9999, '2#star.gif'),
(6, 'Full Member', '', 10000, '3#star.gif'),
(7, 'Senior Member', '', 25000, '4#star.gif'),
(8, 'AGS God', '', 50000, '5#star.gif'),
(19, 'Mittens Veteran', '', -1, ''),
(18, 'Mittens Crew', '', -1, ''),
(20, 'Mittens '02', '', -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 '02', '', -1, '')' at line 13
Presumably it's due to the fact that one of my membergroups has an apostrophe in its name - any ideas?