News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

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: