I am so freaking lost it is driving me nuts.  OK here is what I have.  I have mybb version 1.2.10 installed fresh. in the sub-directory "/chat" in database "jota_jota".  I also installed smf version 1.1.4 in subdirectory "/petchat" also in database "jota_jota".  I then downloaded the converter from this site.  I will assume it is the latest version of the converter because it was in the download area on this site.  After both boards were setup I then uploaded the convert.php and mybb_to_smf.sql to the subdirectory of /petchat.  I typed into my browser journeyoftheanimals.com/petchat/convert.php [nofollow]  Entered the password in the password box and clicked "continue".  I then received the following error.

QuoteConverting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `jota_chat`.mybb_users
    LIMIT 0, 500;

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 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10

I have tried everything I can think of.  Oh and if your wondering why I am installing a fresh version of mybb to convert it to smf right away, it is because I have a backup of the database that I restore before I try any converting.  I went into phpmyadmin dropped all the tables in the mybb list and then imported the backup like it says to do and everything looked fine on the mybb board before I tried to convert.


So where the heck am I going wrong?  I do not expect anyone here to say I did not supply enough information for this. hehe


So please if anyone has some tips I would be very happy.  Then after all is said and done I get to try to work on the smf / joomla bridge.  I hope that goes better then this is.

Thank you for your time and your replies

I just noticed that I seem to not be able to log into the smf forum.  Odd I know I am using the right login / password.  But just figured I would add that bit of info.

Have you got any mods installed in mybb?

It also seems that the converter on the download page is for MyBB 1.0 and not 1.2

You can try the SQL file in this topic

QuoteHave you got any mods installed in mybb?

It also seems that the converter on the download page is for MyBB 1.0 and not 1.2

You can try the SQL file in this topic

Hmmm I may have a mod or 2 on my forums.  Would those have been imported also, with the forum backup?  I guess I will have to figure out how to uninstall the mods.   I was gping to use the sql file from that post but I must be blind because I could not see where the file was attached.  Might you link me the file or tell me where on the page the attachment it?  All I see is a link to the convert.php.

Also on that page you linked it says that the converter was for version Software: MyBB Version: 1.2.x


I guess for now I will try to find out how to uninstall mods and also make sure I used the convert file on that page and wait to find out where the sql file is on that page.

OK I found that sql file.  So I am going to try this again without uninstalling the mods.  I will reply to let everyone know if it works this time <fingers crossed>

Well I got somewhere at least, but I have a new error.

QuoteConverting members... Unsuccessful!
This query:

    TRUNCATE `jota_chat`.smf_members;

Caused the error:

    Table 'jota_chat.smf_members' doesn't exist

Can someone please shine some light on this for me?  Thank you in advance.

It looks like something deleted your smf_members table. You can recreate it with phpmyadmin (See: What is phpMyAdmin?) and this query:

CREATE TABLE smf_members (
  ID_MEMBER mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  memberName varchar(80) NOT NULL DEFAULT '',
  dateRegistered int(10) UNSIGNED NOT NULL DEFAULT '0',
  posts mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  ID_GROUP smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  lngfile tinytext NOT NULL,
  lastLogin int(10) UNSIGNED NOT NULL DEFAULT '0',
  realName tinytext NOT NULL,
  instantMessages smallint(5) NOT NULL DEFAULT 0,
  unreadMessages smallint(5) NOT NULL DEFAULT 0,
  buddy_list text NOT NULL,
  pm_ignore_list tinytext NOT NULL,
  messageLabels text NOT NULL,
  passwd varchar(64) NOT NULL DEFAULT '',
  emailAddress tinytext NOT NULL,
  personalText tinytext NOT NULL,
  gender tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
  birthdate date NOT NULL DEFAULT '0001-01-01',
  websiteTitle tinytext NOT NULL,
  websiteUrl tinytext NOT NULL,
  location tinytext NOT NULL,
  ICQ tinytext NOT NULL,
  AIM varchar(16) NOT NULL DEFAULT '',
  YIM varchar(32) NOT NULL DEFAULT '',
  MSN tinytext NOT NULL,
  hideEmail tinyint(4) NOT NULL DEFAULT '0',
  showOnline tinyint(4) NOT NULL DEFAULT '1',
  timeFormat varchar(80) NOT NULL DEFAULT '',
  signature text NOT NULL,
  timeOffset float NOT NULL DEFAULT '0',
  avatar tinytext NOT NULL,
  pm_email_notify tinyint(4) NOT NULL DEFAULT '0',
  karmaBad smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  karmaGood smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  usertitle tinytext NOT NULL,
  notifyAnnouncements tinyint(4) NOT NULL DEFAULT '1',
  notifyOnce tinyint(4) NOT NULL DEFAULT '1',
  notifySendBody tinyint(4) NOT NULL DEFAULT '0',
  notifyTypes tinyint(4) NOT NULL DEFAULT '2',
  memberIP tinytext NOT NULL,
  memberIP2 tinytext NOT NULL,
  secretQuestion tinytext NOT NULL,
  secretAnswer varchar(64) NOT NULL DEFAULT '',
  ID_THEME tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
  is_activated tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  validation_code varchar(10) NOT NULL DEFAULT '',
  ID_MSG_LAST_VISIT int(10) UNSIGNED NOT NULL DEFAULT '0',
  additionalGroups tinytext NOT NULL,
  smileySet varchar(48) NOT NULL DEFAULT '',
  ID_POST_GROUP smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  totalTimeLoggedIn int(10) UNSIGNED NOT NULL DEFAULT '0',
  passwordSalt varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (ID_MEMBER),
  KEY memberName (memberName(30)),
  KEY dateRegistered (dateRegistered),
  KEY ID_GROUP (ID_GROUP),
  KEY birthdate (birthdate),
  KEY posts (posts),
  KEY lastLogin (lastLogin),
  KEY lngfile (lngfile(30)),
  KEY ID_POST_GROUP (ID_POST_GROUP)
) TYPE=MyISAM;


OK error in myphpadmin   I pasted the query in a little box that says "SQL query on database jota_chat" and then clicked "submit query"



I am looking for the answer right now but figured I qould post here too and hope for an answe while I look around

OK I was trying to run it in the wrong spot.  Got it now but with yet another error as follows.

QuoteConverting members... Successful.
Converting categories... Unsuccessful!
This query:

    TRUNCATE `jota_chat`.smf_categories;

Caused the error:

    Table 'jota_chat.smf_categories' doesn't exist

I assume that this means I need to run another query but not sure what to run this time

It looks like you might have multiple tables missing. If you use the install1_1.sql file from an SMF install archive you can then manually find each table that is missing and then re-create it through phpmyadmin (You'll need to change {$db_prefix} to smf_).

Quote from: H on December 24, 2007, 01:24:17 PM
It looks like you might have multiple tables missing. If you use the install1_1.sql file from an SMF install archive you can then manually find each table that is missing and then re-create it through phpmyadmin (You'll need to change {$db_prefix} to smf_).

Not completely sure how to do that but I will look into it.  I am starting to wonder if I should try to convert mybb into a different board like phpbb2 or something and then convert that into smf.  I want this so bad.  Just starting to really make me mad.

Well thank you everyone for you help.  The problem I believe I was having is that I change the table prefex or whatever it is called on my smf board when installing.  Looks like everything converted over wonderfully.  I can go ahead and delete the mybb directory now right?

Sure although I'd take a backup just in case you later find that something you need didn't convert!