News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Converting ranks... Unsuccessful!

Started by KDL, October 22, 2007, 11:41:00 AM

Previous topic - Next topic

KDL

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.

SleePy

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: