Check out the SMF Function DB!
Started by JayBachatero, January 13, 2007, 02:47:08 AM
QuoteConverting...Converting ranks... Successful.Converting groups... Successful.Converting members... Unsuccessful!This query: INSERT INTO `smf`.smf_members (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2) VALUES ('503', 'FousaSandFase', ................................. and etc.....Caused the error: Incorrect integer value: '' for column 'ID_GROUP' at row 1
QuoteEDIT ---I was able to fix this error and a few other ones that had poped up. It seams that there is a bug in mysql 5.Xand so sence i had access to the my.ini file i changed this linesql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"to this linesql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"and it fixed all error and inserted every thing just fine.
Quote from: JayBachatero on January 13, 2007, 02:47:08 AMSoftware: phpBBVersion: 2.0.19 and upThis is the official support topic for phpBB converter. Use this topic to ask for support for this converter. I merged all the changes that were floating around. Lets use this topic to get a final working version.Changelog! Convert smileys. (phpbb2_to_smf.sql)! When converting attachments cast width and height as a string. (phpbb2_to_smf.sql)! Merged all the small changes floating around into one file. (phpbb2_to_smf.sql)! When converting attachments set the width and height for images (phpbb2_to_smf.sql)! Bug in signature conversion. (phpbb2_to_smf.sql)convert.phpUse this convert.php with the .sql file attached in this topic.
Quote from: JayBachatero on January 15, 2008, 01:36:15 PMDid you try the convert.php here? http://www.simplemachines.org/community/index.php?topic=140741.0