News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

YaBB SE 1.5 to SMF 1.1 - Unsuccessful

Started by Jahntassa, August 24, 2006, 08:32:54 PM

Previous topic - Next topic

Jahntassa

Can't seem to find anything that's really helping me, and i'm not sure exactly where the issue is, but here goes.

The conversion from YaBB SE 1.5.0 to SMF 1.1 is failing on Converting Posts. Here's what it spits out under 'This Query'

INSERT INTO `pokermonster`.smf_messages
(ID_MSG, ID_TOPIC, ID_BOARD, ID_MEMBER, posterTime, posterName, posterEmail, posterIP, subject, smileysEnabled, modifiedTime, modifiedName, body, icon)
VALUES ('24', '11', '3', '7', '1051741703', 'doormat', '[email protected]', '24.234.85.110', 'prisoner puzzle', '1', '', '', 'This is not really a probability problem per se but if you can solve this, you have the imagination and strategic thinking necessary to be a great poker player! Here is the puzzle:<br />You are one of seven prisoners. The seven of you are each housed separately, and each has no contact with any others. There is a room containing two switches, each switch having two possible settings: up, or down. You have no information on the starting position; the switches<br />might currently rest in any of the four combinations.<br /><br />In a short while the authorities will begin to conduct random drawings. Each drawing will select a prisoner to go to the switching room. There, the prisoner must flip exactly one switch on each visit. Because the drawings are random it is possible for prisoners to make repeat trips,<br />or be skipped entirely for long stretches. Moreover, there is no way to draw an inference from elapsed time - you might make two trips an hour apart, then one a week later, yet no other prisoner might have made an intervening trip.<br /><br />There is a way out. As soon as one of you can state with certainty that all seven of you have made at least one trip to the switching room you will all be freed. You will be brought together before the drawings start for one strategy session. What is your strategy?<br />', 'xx')

And at the bottom,

Caused the error:

    Out of range value adjusted for column 'modifiedTime' at row 1

MySQL 5.0.22
PHP 5.1.4

Installed on IIS 6

J. Williams

Try converting to 1.0, then upgrading to 1.1 :P

1.1 Converters I think still have a few bugs :D
Joshua Jon Williams
Back in Action.

Jahntassa

Okay, here's what I get after installing 1.0.8 and using the YaBBSE 1.5.x to smf converter:

Converting members... successful.
Converting categories... successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 501

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 511
successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (receivers)... successful.
Converting board access... successful.
Converting activity logs... successful.
Converting ban logs... successful.
Converting board logs...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1416

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1426
successful.
Converting karma logs... successful.
Converting mark-read logs...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1577

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1587
successful.
Converting topic logs...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1657

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Websites\LocalUser\PokerMonsterTest\forum1\yabbse_to_smf.php on line 1667
successful.
Converting moderators... successful.
Converting banned members... successful.
Converting calendar data... successful.
Converting settings... successful.
Converting membergroups... successful.
Recalculating forum statistics... successful.
Conversion Complete

Unfortunately I end up with an empty board, but it's obvious that SOME of the stuff got converted. NOW what??

Advertisement: