Quote
Converting...
Converting ranks... Unsuccessful!
This query:
DELETE FROM `siren_phpb12`.smf_membergroups
WHERE groupName LIKE 'phpBB %';
Caused the error:
Table 'siren_phpb12.smf_membergroups' doesn't exist
This was the first section of the conversion process, and, the first error :D
If anyone could help me i'd be very grateful, haven't got a clue what I'm doing :-[
Thank you for any help offered.
Which converter where you using?
Does that table exist in the SMF database (It should).
If it isn't, Run this as a SQL query
CREATE TABLE smf_membergroups (
ID_GROUP smallint(5) unsigned NOT NULL auto_increment,
groupName varchar(80) NOT NULL default '',
onlineColor varchar(20) NOT NULL default '',
minPosts mediumint(9) NOT NULL default '-1',
maxMessages smallint(5) unsigned NOT NULL default '0',
stars tinytext NOT NULL,
PRIMARY KEY (ID_GROUP),
KEY minPosts (minPosts)
) TYPE=MyISAM;
#
# Dumping data for table `membergroups`
#
INSERT INTO smf_membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (1, '{$default_administrator_group}', '#FF0000', -1, '5#staradmin.gif'),
(2, '{$default_global_moderator_group}', '#0000FF', -1, '5#stargmod.gif'),
(3, '{$default_moderator_group}', '', -1, '5#starmod.gif'),
(4, '{$default_newbie_group}', '', 0, '1#star.gif'),
(5, '{$default_junior_group}', '', 50, '2#star.gif'),
(6, '{$default_full_group}', '', 100, '3#star.gif'),
(7, '{$default_senior_group}', '', 250, '4#star.gif'),
(8, '{$default_hero_group}', '', 500, '5#star.gif');
# --------------------------------------------------------