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?
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:
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', '[email protected]', '', '', '', '0', '0', '', '', '', '', '', 'I love YaBB 1G - SP1!', 'blank.gif', '', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '7535035113d48c5449860c2707592926', '02hawk21', '[email protected]', '', '', '', '0', '0', '', '', '', '', '', 'Go Bulls!', 'blank.gif', '', '', '', '0', '1160527032', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '8996147546dad4c6d7fa76de67c0642d', '1-2-3firstdown', '[email protected]', '', '', 'Sec. 125 Row 1.<br /><br />Sometimes when I reflect on all the beer I drink, I feel ashamed. Then I look into the glass and think about the workers in the brewery and all of their hopes and dreams. If I didn'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', '[email protected]', '', '', '', '63', '0', '', '', '', '', '1', '', 'BullBackers.jpg', '', 'x0||||||', '0001-01-01', '1', '1176745447', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '1ae7bbaaeb999fe74e9ffcffa98dad18', '12NCs', '[email protected]', '', '', '', '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', '[email protected]', '', '', '', '0', '0', '', '', '', '', '', 'Go Bulls!', 'blank.gif', '', '', '', '0', '1169955365', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '7bca5cb5dd59397e94478dffdcaf3df5', '19usf96', '[email protected]', '', '', '[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', '[email protected]', '', '', '', '82', '0', '', '', '', '', '1', 'Go Bulls!', 'blank.gif', '', 'Tampa, FL', '1978-05-25', '0', '1176072711', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', 'ef7971d6f6e1dfd6b294821519ad84a4', '1heifer', '[email protected]', '', '', '', '0', '0', '', '', '', '', '', 'I love YaBB 1G - SP1!', 'blank.gif', '', '', '', '1', '1167859652', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('NAME-REMOVED', '1dc2e0d5a93418766d7b564790035bc1', '1majorbullfan', '[email protected]', '', '', '', '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?
Is MySQL running in strict mode?
Quote from: JayBachatero on April 17, 2007, 04:27:33 PM
Is MySQL running in strict mode?
To be honest, I'm not positive. How do I check that?
Ok open the yabb21_to_smf.php file.
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? '1' : ($data['gender'] == 'Female' ? '2' : '0')) : '0',
Quote from: JayBachatero on April 17, 2007, 04:27:33 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""
Well that worked... but now I'm getting:
"Out of range value adjusted for column 'dateRegistered' at row 1"
:)
Thanks for all your help!
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?
Ummm the date registered should be a time stamp in YaBB. Do you have any mods installed?
Quote from: 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?
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 '' (Null).
Do you have any ideas about:
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
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!!
Check to see if its adding the indeces to the tables.