[SMF Converter] Yabb - 2.1

Started by JayBachatero, October 24, 2006, 12:07:33 PM

Previous topic - Next topic

b4sakenxx

#380
--EDIT2--

I found a post where someone just increased the cstep when they came up with the same error which then allowed them to continue.  Tried it and it worked.  Conversion finished.  I just wonder what happened with the poll vote stuff.  The polls seem fine though....

--EDIT--

No go.  Same error as before, right at Poll Vote conversion.  Do you think it might be a problem with the polls on my current forum?

------------

Don't click on continue.  Try that file.  No double posts.  Okie doke.
Thanks for the help!

JayBachatero

Ok you got me lost.  Did it work at the end or still no go?
Follow me on Twitter

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

trmxplat

Hallo,

i got the following error message when converting from YaBB 2.1 at hxxp:forum.ersterkontakt.com/cgi-bin/yabb2/YaBB.pl: [nonactive]

Converting poll votes... Unsuccessful!
This query:
INSERT INTO `db213434341`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('1', '268', '0'),
('1', '282', '0'),
('1', '243', '0,1,2'),
('1', '216', '0'),
('1', '290', '1,2'),
('1', '31', '0,1,2'),
('2', '199', '0'),
('2', '1', '1'),
('2', '136', '0'),
('2', '282', '0'),
('2', '137', '0'),
('2', '243', '0'),
('2', '31', '0'),
('2', '216', '0'),
('3', '261', '6'),
('3', '0', '3,6'),
('3', '254', '3,4,6'),
('3', '0', '6'),
('3', '1', '7'),
('3', '199', '5'),
('3', '0', '3,4'),
('3', '0', '4,6,7'),
('3', '0', '4'),
('3', '195', '2'),
('3', '0', '4'),
('3', '0', '6'),
('3', '162', '5'),
('3', '10', '0'),
('3', '0', '4'),
('3', '86', '4'),
('3', '245', '5'),
('4', '86', '1
'),
('4', '0', ''),
('4', '107', '1
'),
('4', '0', ''),
('4', '0', '1
'),
('4', '0', ''),
('4', '0', '0
'),
('4', '0', ''),
('4', '9', '0
'),
('4', '0', ''),
('4', '47', '1
'),
('5', '0', '6'),
('5', '0', ''),
('5', '107', '3'),
('5', '0', ''),
('5', '86', '6'),
('5', '0', ''),
('5', '106', '6'),
('5', '0', ''),
('5', '55', '5'),
('5', '0', ''),
('5', '122', '4'),
('5', '0', ''),
('5', '146', '4'),
('5', '0', ''),
('5', '9', '4'),
('5', '0', ''),
('5', '13', '3'),
('5', '0', ''),
('5', '2', '5'),
('5', '0', ''),
('5', '137', '2'),
('5', '0', ''),
('5', '136', '6'),
('5', '0', ''),
('5', '82', '5'),
('5', '0', ''),
('5', '118', '6'),
('5', '0', ''),
('5', '0', '4'),
('5', '0', ''),
('5', '47', '2'),
('5', '0', ''),
('5', '108', '3'),
('5', '0', ''),
('5', '11', '6');
Caused the error:

Duplicate entry '3-0-3' for key 1

I dont know what to do :) Any help is appreciated!

Thanks in forward!

plat

SleePy

Where you using the .php file attached to the first post in this topic?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

evgenydeep

Please, help me with converting my big forum! ^-)
I almost lost my hope to move from Yabb 2.1 to SMF :-(

SleePy

What errors are you getting?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

evgenydeep

I already described my problems previously.
Look on my previous posts, please:
http://www.simplemachines.org/community/index.php?action=profile;u=152194;sa=showPosts

The main problem is that I have pretty big forum
~ 1 500 000 messages, (we regularly delete messeges)
~ 30 000 threads
~ 13 000 users
~ 400 000 personal messages (unsure in that, may be more...)

I runned converter successfully, but after 3 days processing I lost my patience.
As i saw in DB, converting script become run very slowly after ~ 140 000 rows.
"After ~140 000 rows convert sript began work very slow and insert ~100rows each 25 seconds"

JayBachatero kindly agreed to help me... but it looks he is very busy with his main job tasks.
I prepeared account where is possible to look on my buckuped forum and try to convert it.

If quick convert of such big forum is not possible, then is it possible to divide convertion to several steps(= can be runned on several computers simultaneously).

SleePy

Are you using the command line conversion process?

There might be a bug with how it is pulling how many rows it needs to process left and is doing the math wrong. I would have to look into it in detail later on
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

evgenydeep

Quote from: SleePy on May 15, 2008, 12:00:20 PM
Are you using the command line conversion process?

There might be a bug with how it is pulling how many rows it needs to process left and is doing the math wrong. I would have to look into it in detail later on
No, I used web-interface through browser.

SleePy

Do you have access to use command line/SSH on your forum?
Your host can let you know if you got access to this. It would help with the conversion process as we wouldn't be bothered by apache during the conversion which would mean it wouldn't need to worry about the timeout protection.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vemani

#390
hello,

I am trying to convert YaBB 2.1 to SMF 1.1.4. And I'm using the latest conversion scripts from JayBachatero. Actually I did a test conversion 1,5 months ago and
everything went just fine then. But now when I try the final conversion, I get
error when converting Polls. I even inserted new column (tempId, Int) to smf_log_polls table. But nothing helps.

Converting poll votes... Unsuccessful!
This query:
INSERT IGNORE INTO `forzahjk_smf`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE, tempID)
VALUES ('0', '197', '0', '1194113451'),
('0', '225', '1', '1194113451'),
('0', '312', '1', '1194113451'),
('0', '106', '0', '1194113451'),
('0', '167', '1', '1194113451'),
('0', '41', '1', '1194113451'),
('0', '329', '0', '1194113451'),
('0', '210', '0', '1194113451'),
('0', '32', '1', '1194113451'),
('0', '151', '0', '1194113451'),
('0', '119', '1', '1194113451'),
('0', '53', '0', '1194113451'),
('3', '284', '0'),
('3', '167', '0'),
('3', '240', '1'),
-- snip

Caused the error:

Column count doesn't match value count at row 13

What can I do with this Error ? Conversion is almost finished when this happens ..

EDIT: solved. that poll was somehow damaged. and when It was removed from topic, everything was Ok.
          Thanks  for good conversion scripts !! our new SMF-forum is now running ...

evgenydeep

Quote from: SleePy on May 16, 2008, 01:58:55 PM
Do you have access to use command line/SSH on your forum?
Your host can let you know if you got access to this. It would help with the conversion process as we wouldn't be bothered by apache during the conversion which would mean it wouldn't need to worry about the timeout protection.
Yes, I have SSH acceess.
Moreover, my forum is runned on my personal dedicated server with CPanel.
But how this can help me?

SleePy

evgenydeep.

the conversion script has to pause now and then to prevent overloading the server during the conversion. If you are using it via command line you are avoiding this (since there is is no apache to worry about).
I am wondering if the timeout is causing it to get the number of posts wrong it has to convert.

vemani,
That is very interesting. I asked jay to look at it as I am not quiet sure myself why the poll ids are coming up blank :(
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

evgenydeep

Quote from: SleePy on May 19, 2008, 11:53:04 AM
evgenydeep.

the conversion script has to pause now and then to prevent overloading the server during the conversion. If you are using it via command line you are avoiding this (since there is is no apache to worry about).
I am wondering if the timeout is causing it to get the number of posts wrong it has to convert.

Sorry, I'm not understand how to corretly run convert.php from command line. I suppose convert.php is supposed to be used in browser. From command line I tried to use Lynx locally on server, but it not helped.

As I wrote, I have prepeared special account with buckup of my forum.
JayBachatero promised to look on it, but he seems to be too much busy last 1,5 month.
If you could try to help me, I'll send you PM with account data.

evgenydeep

I saw new version of SMF and convert files has been updated, so
I have tried to convert my forum again... unseccessfull.

I used converters from this threads:
http://www.simplemachines.org/community/index.php?topic=140741.0
http://www.simplemachines.org/community/index.php?topic=122338.0

SleePy

You would run it by doing this in shell:
Quotephp -f /path/to/convert.php

Once you do that it will tell you the options for the convert script. Just fill that info in :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

b4sakenxx

hello powers that be.
i'm trying to convert a forum locally and i got this error at converting members. 

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


any help would be greatly appreciated

SleePy

What version of mysql are you using?
This is the second time I have seen this error and wonder if its related to a mysql version.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

b4sakenxx

i recently installed version 5 to my test bed.

and actually i just deleted many many many users who had not been on in over 2 years to see what would happen (files are backed up).
now it says:

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

SleePy

Do you have a more specific version? A php info would help

To fix that latest error you posted.
Open the .php file.

Find:
                'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',

Replace:
                'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '0',
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: