Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: nam37 on April 17, 2007, 02:00:43 PM

Title: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 02:00:43 PM
I've got a problem I'm hoping you guys can help with. 

I have a YABB2.1 site I'm converting to SMF. I ran some tests on a Linux/Apache server and everything was fine, however I'm now working the production machine which will be a Windows/IIS6.0/PHP machine.

On this new machine the conversion process isn't working.  In fact, it's not even starting.  It's almost as if the conversion script isn't doing anything.  No matter what info I put into the conversion form (even a wrong MySQL password) it always says it is "successful" but actually it just didn't do anything at all.

I've tried moving the source files around for permissions reasons, and nothing seems to make a difference.

Any ideas?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 02:49:46 PM
Well I made some progress... I had the same "session.save_path" issue I saw mentioned in a different thread.  My issue now is:

Converting...
Converting members... Unsuccessful!
This query:

Code: [Select]
INSERT INTO `smf`.smf_members
(memberName, passwd, realName, emailAddress, websiteTitle, websiteUrl, signature, posts, ID_GROUP, ICQ, AIM, YIM, MSN, gender, personalText, avatar, dateRegistered, location, birthdate, hideEmail, lastLogin, pm_email_notify, karmaGood, karmaBad, lngfile, buddy_list, pm_ignore_list, messageLabels, timeFormat, usertitle, memberIP, memberIP2, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt)
VALUES ('NAME-REMOVED', 'e9d9ef1c4db2ab2876c832ba57e0c996', '0-bull', 'floboy@webtv.net', '', '', '', '0', '0', '', '', '', '', '', 'I love YaBB 1G - SP1!', 'blank.gif', '', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '7535035113d48c5449860c2707592926', '02hawk21', 'bcsolo99@yahoo.com', '', '', '', '0', '0', '', '', '', '', '', 'Go Bulls!', 'blank.gif', '', '', '', '0', '1160527032', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '8996147546dad4c6d7fa76de67c0642d', '1-2-3firstdown', 'chipperbones10@yahoo.com', '', '', 'Sec. 125 &nbsp;Row 1.<br /><br />Sometimes when I reflect on all the beer I drink, I feel ashamed. &nbsp;Then I look into the glass and think about the workers in the brewery and all of their hopes and dreams. &nbsp;If I didn&#039;t drink this beer, they ', '5', '0', '', 'fuel2thefire8', '', '', '1', 'If u cant see .... STAND UP!', 'OurHouse.jpg', '', 'springhill', '1980-05-14', '1', '1158628303', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '09f8316e29649a7f795f414ba3860fc0', '10yrbull', 'gelmblad@rjfs.com', '', '', '', '63', '0', '', '', '', '', '1', '', 'BullBackers.jpg', '', 'x0||||||', '0001-01-01', '1', '1176745447', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '1ae7bbaaeb999fe74e9ffcffa98dad18', '12NCs', 'bwell1123@alltel.net', '', '', '', '157', '0', '', '', '', '', '1', 'I love YaBB 1G - SP1!', 'AlabamaCrimsonTide.gif', '', 'x0|County of Cork|Ireland||0|0|', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '1ad634fda21bd7154c5ca3c5bf6ffa80', '13frain', 'brendan.mcgauran@verizon.net', '', '', '', '0', '0', '', '', '', '', '', 'Go Bulls!', 'blank.gif', '', '', '', '0', '1169955365', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '7bca5cb5dd59397e94478dffdcaf3df5', '19usf96', 'usfgrad96@yahoo.com', '', '', '[color=green]For BE News/Talk, Visit: http://bigeastboards.com[/color]<br />', '103', '0', '', '', '', '', '1', 'U..S..F..BULLS. ..BULLS...BULLS !!!', 'BullBackers.jpg', '', 'x1|Weston|USA|florida|455|357|', '0001-01-01', '1', '1166191568', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '532619426cbaad17a4ca84c5de51c0a7', '1Bullsfan', 'xvikramer@yahoo.com', '', '', '', '82', '0', '', '', '', '', '1', 'Go Bulls!', 'blank.gif', '', 'Tampa, FL', '1978-05-25', '0', '1176072711', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', 'ef7971d6f6e1dfd6b294821519ad84a4', '1heifer', 'admin@usasa.com', '', '', '', '0', '0', '', '', '', '', '', 'I love YaBB 1G - SP1!', 'blank.gif', '', '', '', '1', '1167859652', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '1dc2e0d5a93418766d7b564790035bc1', '1majorbullfan', 'cjewel@success.usf.edu', '', '', '', '0', '0', '', '', '', '', '', 'Go Bulls!', 'blank.gif', '', '', '', '1', '1175704283', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
Caused the error:

Incorrect integer value: '' for column 'gender' at row 1

Any ideas?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: JayBachatero on April 17, 2007, 04:27:33 PM
Is MySQL running in strict mode?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 04:32:02 PM
Is MySQL running in strict mode?
To be honest, I'm not positive.  How do I check that?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: JayBachatero on April 17, 2007, 04:36:24 PM
Ok open the yabb21_to_smf.php file.
Code: (find) [Select]
            'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',

Code: (replace) [Select]
            'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? '1' : ($data['gender'] == 'Female' ? '2' : '0')) : '0',
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 04:37:10 PM
Is MySQL running in strict mode?

It looks like I am. My "my.ini" shows:

"sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION""
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 04:40:38 PM
Well that worked... but now I'm getting:

"Out of range value adjusted for column 'dateRegistered' at row 1"

:)

Thanks for all your help!
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 05:03:15 PM
Well I figured out how to turn off "Strict Mode" and I'm making more progress.. I got to:

Quote
Converting...
Converting personal messages... Unsuccessful!
This query:
INSERT INTO `smf`.smf_pm_recipients
(ID_PM, ID_MEMBER, labels, is_read)
SELECT pm.ID_PM, mem.ID_MEMBER, -1 AS labels, 1 AS is_read
FROM (`smf`.smf_personal_messages AS pm, `smf`.smf_members AS mem)
WHERE mem.memberName = pm.temp_toName
AND pm.temp_toName != '';
Caused the error:

Duplicate entry '1-1' for key 1

Also note that the "Date Registered"s are all "1969-12-31" now. :(  I assume this is due to a date format difference.

Any thoughts?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: JayBachatero on April 17, 2007, 05:34:26 PM
Ummm the date registered should be a time stamp in YaBB.  Do you have any mods installed?
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: nam37 on April 17, 2007, 05:42:53 PM
Ummm the date registered should be a time stamp in YaBB.&nbsp; Do you have any mods installed?
There were some MOD applies before I was involved in the project, but you can see the data above.... if I'm reading it right, I think it's showing the date registered as ''&nbsp; (Null).

Do you have any ideas about:

Code: [Select]
Converting...
Converting personal messages... Unsuccessful!
This query:
INSERT INTO `smf`.smf_pm_recipients
(ID_PM, ID_MEMBER, labels, is_read)
SELECT pm.ID_PM, mem.ID_MEMBER, -1 AS labels, 1 AS is_read
FROM (`smf`.smf_personal_messages AS pm, `smf`.smf_members AS mem)
WHERE mem.memberName = pm.temp_toName
AND pm.temp_toName != '';
Caused the error:

Duplicate entry '1-1' for key 1
Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: JimUSFSig on April 18, 2007, 07:53:50 PM
Okay. I am helping NAM37 with the conversion... we are making progress, but we've run into a snag.

It seems to stop at the Conversion of posts, part 2. (convertStep11)...

The conversion program seems to freeze ... (the substep in the URL doesn't change as the page re-loads)... and others have looked at the server and notes that nothing is happening.

Now, I'm not a perfect PHP/MySQL programmer... but I can't see where the problem is.

Is this enough information to suggest where to look??

Should we let just the converter continue running??

Any help would be appreciated!!

Title: Re: YABB 2.1 to SMF (Windows/IIS/PHP)
Post by: JayBachatero on April 21, 2007, 02:11:00 AM
Check to see if its adding the indeces to the tables.