Advertisement:

Author Topic: YABB 2.1 to SMF (Windows/IIS/PHP)  (Read 11398 times)

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
YABB 2.1 to SMF (Windows/IIS/PHP)
« 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?

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #1 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?
« Last Edit: April 17, 2007, 03:38:17 PM by nam37 »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #2 on: April 17, 2007, 04:27:33 PM »
Is MySQL running in strict mode?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #3 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?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #4 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',
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #5 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""

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #6 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!

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #7 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?
« Last Edit: April 17, 2007, 05:05:13 PM by nam37 »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #8 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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline nam37

  • Semi-Newbie
  • *
  • Posts: 14
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #9 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

Offline JimUSFSig

  • Newbie
  • *
  • Posts: 7
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #10 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!!


Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YABB 2.1 to SMF (Windows/IIS/PHP)
« Reply #11 on: April 21, 2007, 02:11:00 AM »
Check to see if its adding the indeces to the tables.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert