Ok this is fresh out the oven. I just fixed the Yabb 2.1 Converter to work with SMF 1.1 RC3. Please keep in mind that if you used the old converter in the past you will have to make a fresh install of 1.1 RC3. The old converter dropped some indexes and will cause this converter to if its not a fresh install.
If everything goes good I will regenerate the converter on the converters page.
Changelog:
! Made the yabb converter more mysql strict mode friendly (yabb21_to_smf.php)
! When converting attachments set a width and height for images. (yabb21_to_smf.php)
! In some cases posts were not assigned to the correct member. (yabb21_to_smf.php)
! In some cases YaBB users ' or " in membergroups.txt causing the regular expression to fail and membergroups not to be converted. (yabb21_to_smf.php)
+ Added check to prevent duplicate columns/keys errors. (convert.php, yabb21_to_smf.php)
! It's location not locaiton (yabb21_smf.php)
+ Added allow_guestAccess to the list of settings to convert. (yabb21_to_smf.php)
! Sometimes YaBB leaves members files behind causing deleted members to be converted. (yabb21_to_smf.php)
! Mark PM's as read. (yabb21_to_smf.php)
! When converting posts in part 3 "while (true)" was giving internal server errors with some hosts and it was looping for ever. (yabb21_to_smf.php)
+ Polls are now converted. (yabb21_to_smf.php)
! In some cases categories and boards had " before the name. (yabb21_to_smf.php)
! Make sure that PM's get marked as read when converting (yabb21_to_smf.php)
! Before converting local moderators, make sure to drop the PRIMARY KEY (yabb21_to_smf.php)
! In some cases converting categories resulted in a undefined index error due to the key not being set to lower case while $tempCatID was. (yabb21_to_smf.php)
! Check that $boarddir is being parsed. If not change it to the correct path. (yabb21_to_smf.php)
! Replace ~qq and ~qw using str_replace() instead of substr. (yabb21_to_smf.php)
! Removed call to an undefined function causing modified post to have the wrong date. (yabb21_to_smf.php)
!New version with convert_table (yabb21_to_smf.php)
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .php/.sql file attached in this topic.
Hi, I downloaded and tried this. Worked fine up until the boards and categories, where a bunch of errors came up. Here's the message I received:
QuoteConverting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: reviews in /is/htdocs/wp1019876_8NUM63JY6E/www/sns/forum/yabb2_to_smf.php on line 668
Notice: Undefined index: unterdruck in /is/htdocs/wp1019876_8NUM63JY6E/www/sns/forum/yabb2_to_smf.php on line 668
Notice: Undefined index: nkr_cat in /is/htdocs/wp1019876_8NUM63JY6E/www/sns/forum/yabb2_to_smf.php on line 672
Notice: Undefined index: trolle in /is/htdocs/wp1019876_8NUM63JY6E/www/sns/forum/yabb2_to_smf.php on line 668
Notice: Undefined index: troll_cat in /is/htdocs/wp1019876_8NUM63JY6E/www/sns/forum/yabb2_to_smf.php on line 672
Unsuccessful!
This query:
INSERT INTO `db1019876-raecher`.raecher_moderators
(ID_BOARD, ID_MEMBER)
SELECT 16, ID_MEMBER
FROM `db1019876-raecher`.raecher_members
WHERE memberName IN ('admin')
LIMIT 1;
Caused the error:
Duplicate entry '16-2' for key 1
The undefined errors are due to missing boards. Seems like that when you delete a board in YaBB the forum.control file doesn't get updated and only forum.master gets updated. Causing the undefined error.
When I go to convert it brings up this message,
QuoteConverting...
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Unsuccessful!
This query:
ALTER TABLE `db_moss_smf`.smf_boards
ADD tempID tinytext,
ADD tempCatID tinytext;
Caused the error:
Duplicate column name 'tempID'
it all so said
QuoteConverting...
Unsuccessful!
This query:
ALTER TABLE `db_moss_smf`.smf_topics
CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
DROP INDEX poll,
DROP INDEX firstMessage,
DROP INDEX lastMessage,
ADD tempID int(10) unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'poll'. Check that column/key exists
I know that it does not complete the conversion but how do I fix it. Mossy
Ok did you follow the instructions and do the conversion on a NEW SMF install?
Quote from: JayBachatero on October 25, 2006, 12:38:43 AM
The undefined errors are due to missing boards. Seems like that when you delete a board in YaBB the forum.control file doesn't get updated and only forum.master gets updated. Causing the undefined error.
ah okay. So what does this imply?
btw I did a clean install just as was intructed. :)
Basically you don't have to worry about those errors. It's just caused by data left behind for when you delete a board in YaBB.
I did a clean install just as was intructed everything was new did I miss something. Mossy
Did you delete all the tables right?
I downloaded this converter package three times but it won't unzip because "the compressed folder is corrupted".
Try downloading the file located here. Did you also try the tar.gz file?
Where's "here"? I tried downloading from http://www.simplemachines.org/download/?converters - the tar.gz downloads but all I get is one file called index.php and when I open it with a text editor it shows a bunch of gobbledy-gook.
Seems like a problem on your end. Did you try using another browser?
I've tried with IE 6 and the latest FireFox. Also tried with Download Express.
This is so frustrating! I finally got the files and uploaded them to the smf folder on the host, then went to http://www.mydomain.com/smf/convert.php, filled in the correct info and passwords, and hit "Continue" button. Next page comes up immediately and says:
QuoteConverting...
Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed sucessfully... blahblahblah etc.
BUT... absolutely NOTHING HAPPENED! The installed SMF forum looked IDENTICAL to the new installation that already existed, and the old forum looks identical as well. Also, in the little note on the Step 1 page that says "Now that everything is converted over,
your SMF installation should have all the posts, boards, and members from the installation" - the part I highlighted in red, which supposedly links to the new forum, instead links only to a page that does not exist: http://www.mydomain.com/index.php
Obviously, I did something way wrong.... So I tried again. And again. And again. And again and again and again and again and .... several times I tried changing the path to the old forum, just to see if it made a difference. It didn't....
Can you please send me a PM with a link to your YaBB and SMF installations?
I sent it....
Quote from: JayBachatero on October 25, 2006, 02:37:26 PM
Basically you don't have to worry about those errors. It's just caused by data left behind for when you delete a board in YaBB.
Hi Jay. Thanks for the info.
So I'd be pretty much set,
if the converter then went on to import all the topics into the board, which it didn't do for some reason...
Any ideas?
Also, the conversion process 'deleted' the first letters of all the Board and Category names, which isn't that big a proble. Just thought I'd let you know. :)
I have some legacy boards froma YaBB forum that I would like to import into SMF. Just the messages, no users, not anything else. Is that possible? Any hints before I try to hack it to pieces? Can the converter pick out just the boards?
Quote from: practical on October 27, 2006, 11:14:29 AM
Quote from: JayBachatero on October 25, 2006, 02:37:26 PM
Basically you don't have to worry about those errors. It's just caused by data left behind for when you delete a board in YaBB.
Hi Jay. Thanks for the info.
So I'd be pretty much set, if the converter then went on to import all the topics into the board, which it didn't do for some reason...
Any ideas?
Also, the conversion process 'deleted' the first letters of all the Board and Category names, which isn't that big a proble. Just thought I'd let you know. :)
I'll have to look more into this. About the converter chopping off the first two letters I know the reason so that. For some reason the board that I converter had qq~ then the board named to I thought it was a YaBB thing. Email me your forum.master and forum.control files.
Cartoon it can be done but the problem would be assigning the posts to the users.
mail sent. 8)
Ok thanks. I'll take a look at it later on tonight when I get home from work.
! Replace ~qq and ~qw using str_replace() instead of substr. (yabb21_to_smf.php)
! Removed call to an undefined function causing modified post to have the wrong date. (yabb21_to_smf.php)
I'll commit these changes tomorrow and regenerate the download page. In the mean time you can use the file attached in the first post.
Quote from: JayBachatero on October 27, 2006, 09:55:06 PM
Cartoon it can be done but the problem would be assigning the posts to the users.
How it looks in yabb is that the user is mapped to Guest. So it looks like a Guest posted it. That would be OK for me.
It is likely not a very much needed feature, but it is for an archive of old forums from another discontinued board. So it is just the information there that would be nice to have.
If it is non-trivial to use your converter,maybe I should look for some yabb->XML converter, then I could but it into some CMS system.
It can be done actually. I'll see if I get some time and write something up.
Hey all. When i try to convert from Yabb 2.1 to SMF it gives me this error. And then it stop someone plz help me thank you in advance.
Warning: file($boarddir/Variables/Settings.pl): failed to open stream: No such file or directory in /home/lafamili/public_html/forum/yabb21_to_smf.php on line 94
Warning: Invalid argument supplied for foreach() in /home/lafamili/public_html/forum/yabb21_to_smf.php on line 95
Converting membergroups...
Warning: file($boarddir/Variables/membergroups.txt): failed to open stream: No such file or directory in /home/lafamili/public_html/forum/yabb21_to_smf.php on line 116
Warning: Invalid argument supplied for foreach() in /home/lafamili/public_html/forum/yabb21_to_smf.php on line 117
Successful.
Converting members... Unsuccessful!
This query:
ALTER TABLE `lafamili_smf1`.smf_members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists
where do you have your Settings.pl file at?
where is the convert.php file at? i downloaded the file from the first post and only yabb21_to_smf.php file is there, no convert.php file, cant convert without it :(
nvm i got it this time, dont know why it wasnt there before, but anyway, im still getting an error
QuoteConverting...
Warning: file($boarddir/Variables/Settings.pl) [function.file]: failed to open stream: No such file or directory in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 94
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 95
Converting membergroups...
Warning: file($boarddir/Variables/membergroups.txt) [function.file]: failed to open stream: No such file or directory in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 116
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 117
Successful.
Converting members... Unsuccessful!
This query:
ALTER TABLE `njoker55_smf`.smf_members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists
dont know what to do
It's not finding the Settings.pl file. Make sure that you overwrite the files you have before not resume.
Quote from: JayBachatero on November 08, 2006, 11:49:08 PM
It's not finding the Settings.pl file. Make sure that you overwrite the files you have before not resume.
how would i do that? overwrite wat files <-- me is confused lol
The Settings.pl is located in your yabb dir. The files to overwrite are the ones you downloaded. Also make sure that the paths are correct. Case matters for the dir names and such.
yea the dirs are corrent, /home/user/public_html/yabb2 of course username goes in place of user, it can read it, but i dont know why it cant find Settings.pl, i still dont get what files to overwrite lol, the yabb21_to_smf.php ??
Yes the yabb21_to_smf.php and convert.php.
lol do i have to look through the whole thing, i searched Settings.pl in yabb21_to_smf.php, it seems to be fine, what should it look like tho?
njoker555 I uploaded a new yabb21_to_smf.php converter. This one should work for you. Look at the first post in this topic.
thanks a lot man, im so freaking busy right now, gonna try again as soon as possible, may not get to try it until this weekend :(, thanks again :D
still got an error, something about a line 678, im tried to fix it, dont know what im doing lol, but help would be nice, help appreciated
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi54.photobucket.com%2Falbums%2Fg118%2Fnjoker555%2Fconverting1.jpg&hash=1c3e096911c1a23984585b72262564d9ffb70ff6)
thats the message i get, everything else is successful, except that
Don't worry about that error. Those are errors from boards that have been deleted. I'll see if I do something not to show those errors.
ok thanks, but i did go on with the conversion, not all the boards and posts got converted, but the members did, so thats good news, the yabb site is www.vitality.ej.am/yabb2 (http://www.vitality.ej.am/yabb2) and the converted smf is www.vitality.ej.am/smf (http://www.vitality.ej.am/smf)
those are just my test links, im testing them all first before i do it with the actual one, as u can see, only the first 5 boards were converted
Actually just the first category got converted. Going to have to look into this one.
Ok another update. Now categories are converting properly. Those of you that are running the converter a second time you might have to install a fresh copy of SMF. I am going to be adding checks so that you dont have to make a fresh install each time. File posted in first post.
ok thanks a lot, gonna go try it as soon as i can, appreciate it a lot :D, helps me out so much lol, was getting tired of yabb
Is anyone here having problems with post count not increasing when posting?
Hi
I got a whole load of errors when I tried to convert. the attached link takes you to a pdf that displays these errors. I started with a brand new install of SMF..
http://www.psoriasis-help.org.uk/Temp/convert.pdf (http://www.psoriasis-help.org.uk/Temp/convert.pdf)
Any ideas?
Thanks
What version of YaBB are you running?
Quote from: JayBachatero on November 18, 2006, 10:25:05 AM
What version of YaBB are you running?
Hi
I am running 2.1
Thanks
M
What mods are you running? Which convert.php are you using?
Quote from: JayBachatero on November 19, 2006, 12:08:07 PM
What mods are you running? Which convert.php are you using?
Hi
Mods are as follows:
YaBB 2.0\pint_who_is_online_y2.mod
YaBB 2.0\hotlinks_4_yabb21_10.mod
YaBB 2.0\Online_on_messagedisplay_11_YaBB2.mod
YaBB 2.0\alertmod_for_Y2.1.mod
YaBB 2.0\ChatIRC_Y2_beta1.mod
YaBB 2.0\ban_and_mod_functions_yabb2_final.mod
YaBB 2.0\fix_for_ban_and_mod_functions_v1-2.mod
YaBB 2.0\Who_is_Where_Y2.mod
I am using the convert.php from the download page:
http://www.simplemachines.org/download/?converters
Is that wrong?
Thanks again
M
And you are using the yabb21_to_smf.php from this topic?
Quote from: JayBachatero on November 20, 2006, 02:52:01 PM
And you are using the yabb21_to_smf.php from this topic?
I have tried both, first i tried the one from this post a couple of times and then I tried the one on the download page but I got the same result..
I'll try again with the one from this post and let you know. I removed and reinstalled SMF, deleted the database each time, so it was a clean working install, each time i tried it.
Thanks
OK - Just tried again with the file from this post and the converter from the download page on a fresh SMF install and exactly the same problem..
Any ideas? Is it one of the mods do you think?
Cheers
M
Send me a .dat and .vars file from the members dir.
Quote from: JayBachatero on November 20, 2006, 06:39:44 PM
Send me a .dat and .vars file from the members dir.
Email sent with some .vars files. I don;t have any .dat files..
Thanks
M
I had recently upgraded my yabb to 2.1 ...no mods installed. I have downloaded and installed smf 1-1 rc3 and that is working fine. I downloaded the yabb 2.1 converter and it will not see my yabb installation. I have checked the paths with my ISP and they are correct!?
Any help or suggestions would be greatly appreciated.
mlsred - I just checked the files you sent me and everything looks correct. Can you check the permissions for the members dir?
rastarasta - Check your Settings.pl file. It should show the paths there.
Quote from: JayBachatero on November 21, 2006, 02:36:59 PM
mlsred - I just checked the files you sent me and everything looks correct. Can you check the permissions for the members dir?
Hi
Members DIR is set to 777...
Most of the members files in it are 666 but some are 644, not sure why there is a difference..
Thanks M
I'm scratching my head over this one. Not sure what is causing this. How many members does your forum have?
Quote from: JayBachatero on November 21, 2006, 10:08:44 PM
I'm scratching my head over this one. Not sure what is causing this. How many members does your forum have?
We have 6701 registered members.
As far as I am aware yabb 2.1 doesn't have a settings.pl it uses Paths.pl. Am unable to make the convert.php see the Yabb installation. I am confused since basically the path should be very similar to the smf one .. /httpdocs/smf should be replaced with /cgi-bin/yabb and it should work as far as I can see but that is not the case :-(
Well remember that the case for the path matters. Also check the file permission.
mlsred: not sure what to tell you. Can you zip up the whole members dir and send it to me?
I have checked (and double checked) that the case is correct. What permissions are required please?
(both Yabb and smf forum are fully functional)
644 should be fine but try 777 or 755 just in case.
I tried both 755 and 777 - it still says cannot find yabb installation :'(
Am using convert.php from the Yabb 2.1 convertor from this site and the yabb21_to_smf.php from the start of this thread
Can you PM me the info and I'll give it a shot and see if I can gather some info.
Have PM'd info ... Let me know if you need any additional info.
Ok check to see where the Settings.pl and the Paths.pl files are located at. Also attached a new converter. Fixed an issue with converting boards with local moderators.
ok have downloaded new yabb21_to_smf.php (same error when running convert.php)
Paths.pl is in Yabb root (/cgi-bin/yabb)
Settings.pl is in variables folder (/cgi-bin/yabb/variables)
What are the permissions of both files?
Paths - 755
Settings - 644
.... am going to try chmoding settings to 755 ........ No change :'(
Will chmod it back to 644
Send me both files to my email.
[email protected]
Quote from: JayBachatero on November 22, 2006, 10:41:05 AM
mlsred: not sure what to tell you. Can you zip up the whole members dir and send it to me?
Hi, will do...
I'll send you the link as even zipped it is rather large.
Thanks
M
Files should be with you
mlsred I just ran the conversion on the files you sent me and it worked correctly. Not sure what is causing it.
Quote from: JayBachatero on November 22, 2006, 06:04:21 PM
mlsred I just ran the conversion on the files you sent me and it worked correctly. Not sure what is causing it.
OK Thanks. Are the error messages that I get all related to the memebers files?
Yea they are related to the members files.
Quote from: JayBachatero on November 23, 2006, 02:43:46 AM
Yea they are related to the members files.
OK thanks. I assume there is nothing more I could do then to make it work? Should I put the forum in maintenance mode before the conversion?
Yea it's recommended to be put in maintenance mode. I'll see what I can do.
I get
Converting attachments (if the mod is installed)... Unsuccessful!
This query:
SELECT ID_MSG, temp_filename
FROM `smf`.smf_messages
WHERE temp_filename != ''
LIMIT 0, 100;
Caused the error:
Unknown column 'temp_filename' in 'field list'
And the convertions stops. The users and boards are converted, but no messages.
Do you have that mod installed?
Which mod does it expect?
The attachments one.
This one (http://mods.simplemachines.org/index.php?mod=279)?
First I installed it and clicked "Try again". Then I did another fresh install of SMF and installed the mod before running the converter. Both times I got the same error as I did without the mod.
No I mean for YaBB. That is supposed to show ONLY if you have that mod installed.
I enabled attachments in YaBB a few days ago without installing any mods.
There's only a few attachments, so I can add them by editing a few posts. So I just added return; at the beginning of convertStep13(). Is that ok, or will that break something else?
At least the script completed and the messages are converted. Polls were not included, but that's not a big problem.
Adding a return; should do it.
I'll look into converting the polls. That is not supported at the moment. Can you email me some poll data? Also is this a standard feature?
Email sent. Thanks for your help!
o man, i did this before but that was settings.pl problem, now it says paths.pl
QuoteConverting...
Warning: file(/home/njoker55/public_html/yabb/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 77
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 80
Notice: Undefined index: boardsdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: datadir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: memberdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: sourcedir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: vardir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: facesdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: uploaddir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Warning: file() [function.file]: open_basedir restriction in effect. File(/Settings.pl) is not within the allowed path(s): (/home/njoker55/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 99
Warning: file(/Settings.pl) [function.file]: failed to open stream: Operation not permitted in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 99
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 100
Converting members... Unsuccessful!
This query:
ALTER IGNORE TABLE `njoker55_smf`.smf_members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists
and one more thing, those two yabb21_to_smf.php files in the first post, are they differnt? but i tried both and the one from the converter download page and still the same error
Permission denied is a permission error. Try setting the file permission to 644 or above.
Umm. Seems like when I updated the converter I forgot to remove the other one. I'll update it now.
Ok updated it.
ok thanks, i'll have to try it tomorrow after school, and i just found out that polls dont get converted, but that doesnt matter :D, still wanna go smf, but sux that i shut down my forum for 3 and a half hours trying to convert it :(
Ok so wait till tom. I'm going to try and get a crack at the polls tonight or tomorrow morning.
that'd be amazing :D, i'll HAVE to wait so ok lol, i'll try it tomorrow afternoon or night, depending on when i get home
Can you tell me the directory where polls are stored in? Is it the same as the posts?
Quote from: JayBachatero on November 23, 2006, 12:10:43 PM
Yea it's recommended to be put in maintenance mode. I'll see what I can do.
Hi
I reinstalled Yabb and added my Members & Message data to the new clean Yabb 2.1 install (no mods installed) and tried to run the converter again..
I still got a whole load of errors, although initially it looked good..
It ended with
Warning: implode(): Bad arguments. in /home/psorias1/public_html/forum/yabb21_to_smf.php on line 1507
Unsuccessful!
This query:
INSERT INTO `psorias1_smf`.smf_members
()
VALUES ('sleeps', 'f43a206693c2ea22d52d635c1957f2e2', 'sleeps', '
[email protected]', '', '', '', '0', '0', '', '', '', '', '1', 'Member of the UK Psoriasis Help Forum', 'blank.gif', '1090582271', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('kath138', '8744c53672906143e20538f6ac3deadb', 'kath138', '
[email protected]', '', '', '', '2', '0', '', '', 'Kath138', '', '2', 'Member of the UK Psoriasis Help Forum', 'blank.gif', '1116102207', '', '1952-03-11', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('Dez', 'e2f7476324822a0c10c35619feb2cbfb', 'Dez', '
[email protected]', '', '', '', '22', '0', '', '', '', '', '', 'Member of the UK Psoriasis Help Forum', 'blank.gif', '1131377172', '', '', '1', '1147686905', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('Megan', '92a6760cf4e8fca716a874b5c3e2c63f', 'Megan', '
[email protected]', '', '', '', '0', '0', '', '', '', '', '', 'Member of the UK Psoriasis Help Forum', 'blank.gif', '1068213574', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
etc etc etc...
Caused the error:
Column count doesn't match value count at row 1What I don't understand is that you used the same member files and it worked?
Any ideas?
Thanks
M
Quote from: JayBachatero on November 26, 2006, 10:44:27 PM
Can you tell me the directory where polls are stored in? Is it the same as the posts?
yea it should be in the same as posts, i was looking for it, cant really find anything that says polls tho
Ummmmm weird. Did any of the members convert?
njoker555 I found the dir. I'll look into it later. Didn't have time last night.
Quote from: JayBachatero on November 27, 2006, 03:05:54 PM
Ummmmm weird. Did any of the members convert?
njoker555 I found the dir. I'll look into it later. Didn't have time last night.
uh...im gonna upload the smf1.1 install and its folders again, i didnt try the new file yet, the one in fantastico is smf1.08 so, give me like 40 mins and i'll tell u, (slow internet), and polls arent really that important, i just need the members, posts, boards, and msgs to convert and im happy :D
Quote from: JayBachatero on November 27, 2006, 03:05:54 PM
Ummmmm weird. Did any of the members convert?
Looks like some did, 1291 Users on the new SMF forum but doesn't look they converted completely
What does this imply?
Caused the error:
Column count doesn't match value count at row 1
does the convert.php from the download section remain that? or is there another i have to download to use with this, im pretty sure that its the same but i wanna be 100% sure
ok just tried it and got this error
QuoteConverting...
Warning: file(/home/njoker55/public_html/yabb/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 77
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 80
Notice: Undefined index: boardsdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: datadir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: memberdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: sourcedir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: vardir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: facesdir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: uploaddir in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 92
Warning: file() [function.file]: open_basedir restriction in effect. File(/Settings.pl) is not within the allowed path(s): (/home/njoker55/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 99
Warning: file(/Settings.pl) [function.file]: failed to open stream: Operation not permitted in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 99
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 100
Converting membergroups...
Warning: file() [function.file]: open_basedir restriction in effect. File(/membergroups.txt) is not within the allowed path(s): (/home/njoker55/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 121
Warning: file(/membergroups.txt) [function.file]: failed to open stream: Operation not permitted in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 121
Warning: Invalid argument supplied for foreach() in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 122
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/njoker55/public_html/smf/yabb21_to_smf.php on line 246
and no try again button like before, i have like 3 different convert.php file for this converter, can u upload the one u used plz
What are the file permission that you have set Try this converter.
i think they are all 777, well SMF files, it auto ftp connected to my server and changed the permissions, the server im on is kinda messed up, if i change permissions to like 766, it changes back to 777, or 755, back to 777
Check the permissions for the yabb files not SMF.
in the main yabb folder, all folders in there are 755, and most of the other files are either 777 or 666, 666 files are like yabbc.js and ubbc.js u can see the pic of all the permissions in the middle of the page here http://i54.photobucket.com/albums/g118/njoker555/permissions.gif (http://i54.photobucket.com/albums/g118/njoker555/permissions.gif)
Damn. That should be able to work. Post your phpinfo.php.
wat, where is that
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0)
Im using the convert.php file from the download and the newest yabb21_to_smf.php from this thread.
using SMF 1.1 RC3 and Yabb 2.1
And I get this error:
Converting personal messages... Successful.
Converting boards and categories... Unsuccessful!
This query:
ALTER TABLE `smfni`.smf_categories
ADD tempID tinytext;
Caused the error:
Duplicate column name 'tempID'
Any help would be appreciated..
Thanks for working on this conversion for us.
Did you try to convert before or this is the first time that you try it? Also if you want to wait I can post the new version of the converter that I'm working on. It converts polls. I'm not home right now so I can't finish working on it.
I tried it before with a previous one, with the same result.
You need to convert to a clean fresh board. I'm looking into utting checks to prevent this from happening.
i just tried again, with a brand new install, new database and everything.
And I got the same error.
ok jay, i tried it again on my computer like u told me too, and it says the posts were converted but at the end, i get this message
QuoteUnsuccessful!
This query:
ALTER IGNORE TABLE `smf`.smf_log_topics
ADD tempID int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists
and because of that, none of the posts were converted
finally did it, everything is good, thanks guys for this converter, here is the link if anybody wants to view www.gamers-forum.com (http://www.gamers-forum.com)
Ok I really need to write some checks to prevent these INDEX errors. Also I was working on the poll. If I don't get called in to work I'll work on it tom.
thanks Jay
Any word on a upate?
Nothing yet. Been pretty busy. I should hopefully have something out by the end of the week.
thanks
just really ready to move from yabb ;) .
I know your still working on this , but i got a quick question.
the current yabb forum I am working with is setup on a Win Server, It shouldn't matter if I copy the files over to a Apache server and convert it there should it?
No it shouldn't matter. Also I just finished writing the poll stuff to convert them. Now I am working on the keys so that you wont have to convert on a fresh forum. I should have it up by tonight.
Awesome!!
thanks again for your work on this. 8)
Whos has a YaBB board that they want to convert? I need a board to test the new features that I added to the converter. If you want to offer your board please send me a PM with the FTP info and the database password.
Information sent via PM
Hey all,
I have been working on converting from Yabb 2.1 to SMF on and off for a week now and it's not working for me. I have a few questions after reading through this thread.
Are there any other instructions then what shows up when you start the converter?
Do I need to delete all of the Polls?
I saw a post about deleting all of the tables, what tables are they talking about?
I'm using IE 7 could that be a problem?
Here is the first error that I get....
YaBB 2 to SMF Converter
Converting...
Converting membergroups... Successful.
Converting members...
Notice: Undefined index: icq in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 301
Notice: Undefined index: aim in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 302
Notice: Undefined index: yim in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 303
Notice: Undefined index: msn in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 304
*Snip*
This goes on for about 3500 lines...
*Snip*
Notice: Undefined index: staff in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 656
Unsuccessful!
This query:
INSERT INTO `db189962049`.smf_boards
(name, description, countPosts, boardOrder, memberGroups, tempID, tempCatID, membergroups)
VALUES ('', 'For news and information regarding the Fox Valley chapter of Trout Unlimited.', '1', '1', '', 'FoxValleyTU', 'general', '-1,0'),
('', 'Share information on what's hatching and how the tributary runs are doing.', '1', '2', '', 'Hatch', 'general', '-1,0'),
('', 'Discuss Wisconsin fly patterns and how best to tie them.', '1', '3', '', 'Tying', 'general', '-1,0'),
('', 'This is the board for General Discussions on Fly Fishing.<br />', '1', '4', '', 'general', 'general', '-1,0'),
('', 'Test the forum out here. Posts made in this board will not add to your post count. Post will be deleted from this section after testing is done.', '', '5', '', 'test', 'general', '-1,0'),
('', '', '', '6', '', '2', 'staff', '-1,0'),
('', 'If You Can\'t Stand The Heat, Stay Out Of The Fire!<br /><br />Complaints To Staff Will Be Ignored You Have Been Warned', '1', '7', '', 'Flame', 'staff', '-1,0'),
('', 'Share info and notes on moderating task.', '1', '8', '', 'Moderator', 'staff', '-1,0'),
('', 'Topics you place in this board will display as a \"Global Announcement\" on the top of all other boards. Use this for things such as forum rules, top news articles, or important statements.', '1', '9', '', 'announcements', 'staff', '-1,0');
Caused the error:
Column 'memberGroups' specified twice
So I hit try again and I get this....
Converting...
Converting boards and categories... Unsuccessful!
This query:
ALTER TABLE `db189962049`.smf_categories
ADD tempID tinytext;
Caused the error:
Duplicate column name 'tempID'
Is this just the Index error that other are seeing?
I'm in no big rush to get it convered over but sooner the better.
Thanks for reading the post.
-ST
I've been real busy the past few days and I've worked on this slowly. I'll try to see if I get a working converter by monday. Can't promise anything since i work today and I'm going to a party from work tom.
Thanks for the reply, I'll glady wait untill you have time.
Enjoy the party!
-ST
Any Update on the Converter?
No update sorry. I've been too busy with work. Barely had time to work on it. After new years I should be able to finish it. Sorry for the log wait. I did manage to fix the bug that you were having when the convertor was just hanging. Just need to finish the poll conversion.
Thanks Jay,
Thats understandable , I know what its like to be busy at work, especially this time of year.
and No worries, Im just happy someone is even making this converter.
thanks again. Enjoy the rest of the holiday season. ;)
I have a problem. I converted from YaBB 2.1 and I thought everything was fine until I noticed that when people posted, their post count wasn't increasing. How do I fix this?
Thanks for a great converter. I just converted a board with the following stats
22444 Posts in 2528 Topics by 49 Members
Only problem I had was the polls. I just deleted the *.poll and *.polled files from the Yabb Messages directory and then did a fresh install of SMF and then did the conversion and it went fine.
The problem I have now is that I want to convert a board with the following stats
Our users have made 461213 Posts within 50111 Topics.
We have 16603 registered members.
There is a lot of polls in this one that I do not want to delete. Will be great if you do get some time to do the poll bit. But as they say, All good things take time :)
Thanks for all the hard work you have done
Yea I worked on it a bit the other day but haven't had time to work on it again. I do have 3 days off from work this week so I can work on it and fix it finally.
The converter has been updated. The two biggest changes are: Polls are now converted and you don't need a fresh install of SMF to convert to. Before if you got a duplicate column/key error you had to reinstall SMF. Now you don't have to do that.
Changelog
! In some cases YaBB users ' or " in membergrouos.txt causing the regular expression to fail and membergroups not to be converted. (yabb21_to_smf.php)
+ Added check to prevent duplicate columns/keys errors. (convert.php, yabb21_to_smf.php)
! It's location not locaiton (yabb21_smf.php)
+ Added allow_guestAccess to the list of settings to convert. (yabb21_to_smf.php)
! Sometimes YaBB leaves members files behind causing deleted members to be converted. (yabb21_to_smf.php)
! Mark PM's as read. (yabb21_to_smf.php)
! When converting posts in part 3 "while (true)" was giving internal server errors in some hosts and looping for ever. (yabb21_to_smf.php)
+ Polls are now converted. (yabb21_to_smf.php)
Thanks for your hard work. Much appreciated.
Just tried to convert my main board and got the following
It listed about 100 Members, I cut the list down and also blanked out their E-mail address
Any clues as to what I should do. I tried a second time and it appeared to list different users.
**** = information I have blanked out
Converting...
Converting members...
Notice: Undefined offset: 0 in /home/****/public_html/forums/yabb21_to_smf.php on line 2005
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/****/public_html/forums/yabb21_to_smf.php on line 2005
Warning: implode() [function.implode]: Bad arguments. in /home/****/public_html/forums/yabb21_to_smf.php on line 2005
Unsuccessful!
This query:
INSERT INTO `****_forums`.smf_members
()
('RichardS', '1589061267c6524965bdc0895ae9f2d2', 'RichardS', '****@ssc.net.au', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1165176649', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('ifan', '7ad8c6ae6fad49f2ab9f3a5be0e7c432', 'ifan', '****@yahoo.com.au', '', '', '', '0', '0', '', '', '', '', '1', '****.com.au', 'homer.gif', '1152023499', '', '', '1', '1152019743', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('nitro_man', '5b38b6a590f60c2984b979e27bc95c6e', 'nitro_man', '****@hotmail.com', '', '', '', '0', '0', '', '', '', '', '1', 'Born to Fish - Forced to Work', 'blank.gif', '1102519288', '', '1989-03-04', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('thespark', '1b7cfe4906531892381d8ae090eaad8d', 'thespark', '****@bigpond.net.au', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1163169833', '', '', '1', '1164090541', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('duebs', 'd86c195a46545a0881b9cce677b3ffbe', 'duebs', '****@sunmetals.com.au', '', '', '', '0', '0', '', '', '', '', '', 'Ausfish.com.au', 'blank.gif', '1138076641', '', '', '1', '1138642040', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('bartman', '6768cd7620fcc4167671496f743097cd', 'bartman', '****@hotmail.cm', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1154457618', '', '', '0', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('catchum', '1e80686bf909b80af2b9d0194a9be327', 'catchum', '****@hotmail.com', '', '', '', '15', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1161730076', 'caboolture', '', '0', '1168330582', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('salty', 'f1165d717f35820468caf0dc2bc00aea', 'salty', '****@interworx.com.au', '', '', '', '0', '0', '', '', '', '', '', 'Born to fish - Forced to work', 'blank.gif', '1010876228', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('plano', '67db70a1524fad9ed75af956d0e3a201', 'plano', '****@hotmail.com', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1131881778', 'redland bay', '1970-12-03', '1', '1131862057', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('Hamowa', 'ec8f8f6b2ba2a444472d4b6d07a87d09', 'Hamowa', '****@iinet.net.au', '', '', '', '0', '0', '', '', '', '', '1', '****.com.au', 'ze0_avatar.gif', '1138275008', '', '', '0', '1141254986', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
Caused the error:
Column count doesn't match value count at row 1
What version of YaBB are you using?
Running 2.1
Stats
Our users have made 463089 Posts within 50320 Topics.
We have 16672 registered members.
Mods installed
Members Only Search
Ban / Mod Functions YaBB2
Quick Reply Box
YaMMS 4
Gender Lock
Event Calendar
Search for IP Address
Online Games
SpelChek
Users Today
NewsIndex
Sub-Board for YaBB 2.1
Print Who Is Online
Dice 4
YaBB Media Center
Admin HTML in Posts
RateIT Mod
Alert Moderator
Users Avatars Upload
Well I don't know much about the mods for YaBB. What does the members only search do? Can you create a backup board and try to convert w/o the mods installed?
Members only search just means you have to be logged in to be able to us ethe search function.
The only ones that would effect the profile would be the - Users Avatars Upload and YaMMS 4 (Yet Another Member Map)
Users Avatars Upload - http://www.boardmod.org/yabb/YaBB.pl?board=newsy2;action=display;num=1145536083
YAMMS - http://www.boardmod.org/yabb/YaBB.pl?board=newsy2;action=display;num=1104252089
Bit hard to do the board without the mods as they are very important mods to the members
I was thinking it maybe more the data that is in the profile file rather than the mods. Maybe ?
Also the shear size of the forum makes it a bit of a hard task. But if you think it is the only way I will give it a go.
Let me try and get a custom converter for you. Can you send me a few of the .vars and .dat files from the members dir. That way I can see the structure of it.
Thanks
PM sent with info
I looked at it and it look ok to me. Can you give me FTP info so that I can give it a shot and debug it?
E-mail sent with FTP and SMF details
You sent it to lilj625@gmail right? This is a test account that I have while my other account is restored.
Hi
I sent it to the simply machines E-mail where I sent the other one.
Have just forwarded it to the gmail address
I'll look into it now.
I converted from yabb 2.1 and had around 15 mods installed. I obviously did not keep those mods and did not expect to but the conversion was seamless.
Thank you
Quote from: madkeen on January 10, 2007, 08:17:02 AM
Hi
I sent it to the simply machines E-mail where I sent the other one.
Have just forwarded it to the gmail address
Ok I have the conversion running. The weird thing is that the first time that I ran it I got the error then I added some debug stuff and it's been running fine so far. Converting topics now. Might take a while. Might want to put the live forum down for a bit.
Thanks, have put the live one off line
BTW - Took over an hour for the error to come up some times.
Well the error was on the members table so that table is done for.
Excellent, here's hoping the rest will go smoothly :-)
Had to restart the conversion since the converter died on the topics part 2. I changed that a bit to prevent it from dying.
Hi. I'm trying to convert my Yabb2.1 board, but I keep getting an Internal Server Error when running the convert tool. I've tried multiple times, and the error seems to occur pretty randomly. Sometimes it would happen when converting Topics, or sometimes when converting Posts, or even right off the bat. The furthest I've got has been converting Posts (part 2).
I'm not running any mods, and my forum has a modest post count (~38,000) posts). Any help would be appreciated.
-patchy
Are you with 1and1 hosting? I've had this happen to be before also.
no, I'm with Site5.
anyhoo. I was able to get it to work, by clicking Back in my browser to go back to the previous step, and hitting the Continue button after each Internal Server Error. Now everything seems to be running ok. Thanks!
-patchy
Quote from: ApacheXMD on January 11, 2007, 10:43:38 PM
no, I'm with Site5.
anyhoo. I was able to get it to work, by clicking Back in my browser to go back to the previous step, and hitting the Continue button after each Internal Server Error. Now everything seems to be running ok. Thanks!
-patchy
Hard way of doing it but at least you got it to work.
Ok,.. I'm completly clueless at this,.. no point pretending otherwise!
Trying to convert my YaBB2.1 forum at www.fermoycleaning.com/forum to my new instalation of SMF at www.fermoycleaning.com/smf and I get the following errors:
Warning: file(/home/fermoycl/public_html/forum/Paths.pl): failed to open stream: Permission denied in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 77
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 80
Notice: Undefined index: boardsdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: datadir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: memberdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: sourcedir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: vardir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: facesdir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Notice: Undefined index: uploaddir in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 92
Warning: file(/Settings.pl): failed to open stream: No such file or directory in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 99
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 100
Converting membergroups...
Warning: file(/membergroups.txt): failed to open stream: No such file or directory in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 121
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 122
Successful.
Converting members...
Fatal error: Call to undefined function: altertable() in /home/fermoycl/public_html/smf/yabb21_to_smf.php on line 197
I haven't a clue what it all means!
How do I fix it????
I need a real "For dummies" guide on this one!!!
Are you using the most recent convert.php?
think so,... tried 2 of em!!
Could you e-mail me the latest one pls?
[email protected]
It's attached in the first post. Also can you link me to the phpinfo.php file.
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0)
Yep, used the one attached to the first post.
Here;s the link:
http://www.fermoycleaning.com/phpinfo.php
Appreciate the help Jay!
Ok phpinfo looks good. Make sure that you overwrite the convert.php. From the looks of it you have an old convert.php since it doesn't have the alterTable() function.
I managed to get the conversion past the Memebers section that it was stopping on with errors. Now the problem is that it keeps stalling when converting the post about every 10000. I have to hit teh stop button on teh browser and then click on continue and it seems to be working again. Well, at least the count in the URL increases every 90 seconds or so. I am hoping it is doing its thing.
With 460000 posts though it will take days to do this and there will be another 1000 posts per day added to teh boards so the new one will be a few days out.
Is it possible to run teh script on the server in a shell rather than in teh browser?
Would be a lot quicker and less painful
I am desperate to convert my board but just not having much luck in doing it
Converting...
Warning: file(/home/fermoycl/public_html/forum/Paths.pl): failed to open stream: Permission denied in /home/fermoycl/public_html/yabb21_to_smf.php on line 77
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 80
Notice: Undefined index: boardsdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: datadir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: memberdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: sourcedir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: vardir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: facesdir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Notice: Undefined index: uploaddir in /home/fermoycl/public_html/yabb21_to_smf.php on line 92
Warning: file(/Settings.pl): failed to open stream: No such file or directory in /home/fermoycl/public_html/yabb21_to_smf.php on line 99
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 100
Converting membergroups...
Warning: file(/membergroups.txt): failed to open stream: No such file or directory in /home/fermoycl/public_html/yabb21_to_smf.php on line 121
Used the files on th e first post of this thread, and got this message:
Warning: Invalid argument supplied for foreach() in /home/fermoycl/public_html/yabb21_to_smf.php on line 122
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/fermoycl/public_html/yabb21_to_smf.php on line 247
I managed to get past a few errors by clicking the back button and then cicking on continue.
But it has stopped again and gives me the following error
Converting...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `ausfish_forums`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '20052-3438' for key 1
I have clicked on he Try Again button but just gives teh same error. I have also tried ccking on the back buton then the continue button but get the same error.
Can anyone help out how to get past this?
The URL is the same everytme it gets to this error - convert.php?step=1&substep=50800&cstep=8&start=0
madkeen there is no way to run this via shell. I was thinking of looking into adding support for it but I don't know much about CLI. I'll see what I can come up with.
Njones seems like your host has open_basedir enabled. I suggest that you convert your board locally.
Thanks Jay
Very much appreciate your time and effort
Cheers Jay,
How do I convert it locally?
Sorry to be so clueless!!!
I assume that you would go to your web site and run the convert.php so,
http://www.yourwebsite.com/smf/convert.php
and follow the simple instructions.
If you have smf installed at that location.
-ST
Yes, that is correct. You will also need to have the yabb21_to_smf.php file in that location.
Hi.. I am trying to use your latest conversion scripts and get this error displayed. Admittedly I haven't read through the whole thread on this yet.. but didn't find anything quickly using the search option on the board.
any ideas on what to do? Thanks!!
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: Tests in /home/savageg/public_html/judb/forum/yabb21_to_smf.php on line 706
Unsuccessful!
This query:
ALTER TABLE `savageg_smf1`.smf_moderators
ADD PRIMARY KEY (ID_BOARD, ID_MEMBER);
Caused the error:
Duplicate entry '5-886' for key 1
Well I did some poking around and decided it was related to conversion of the moderator settings and so I removed all the mod assignments (some forums had more than one mod in the list that was comma seperated and I think that was killing it.) and now the script ran till it hit this error:
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `savageg_smf1`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '327-1331' for key 1
Looks like there is something in there that is duplicated or that it doesn't like.. any ideas? could it be moved topics? I don't know!
Okay well with some painful poking around I determined that YaBB had created some duplicate .log .vars .rlog files for users in the Members directory with different case for the username in the files..
example
bob.vars
Bob.vars
These were for the same user, just had different time stamps.. this caused the database to be populated twice with thread / post links that caused the error I was getting. I went in and deleted the older of the files for each of the 9 users that had this issue and the conversion completed.
Maybe there is a way in the script to detect this in the future and generate a meaningful error that the user is duplicated and to remove the files?
Well it's hard to detect that really. Cause what it does it uses all lowercase username on conversion.
Well, could it detect which file is newer and ignore the duplicates? im not an SQL guru and it took me quite a while to figure out which users were duplicated and fix the files.
Thanks!
i just ran the latest convertor today, and ran into a couple of problems
Converting...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '164-479' for key 1
and the import polls piece acted strange,
before i "tweaked" the import script it had populated over 1.2 million rows into smf_log_polls
on line 1749 if ($_GET['substep'] < 0) the substep was always 0 everytime the page refreshed
also imported attachments dont seem to display in the post, only give a download link. may not be a convertor issue
thanks for any help you can offer
just noticed that alot of posts dont have proper linking to IDs
Ok try using this one.
! When converting attachments set the width and height for images. (yabb21_to_smf.php)
! Make sure to increase pastTime when converting poll log. (yabb21_to_smf.php)
thanks, running it now
after i realized i forgot to overwrite it, i did another clean install, but the convertor wont run
from my web server log
[client 192.168.100.10] PHP Parse error: parse error, unexpected T_LIST in /home/.sites/28/site1/web/smf/yabb21_to_smf.php on line 1396
ok, i got past that
line above was
if (!empty($attachmentExtension)
changed it to
if (!empty($attachmentExtension))
Oops. Me and my typos :P.
! Typo
hit some more issues.
got stuck on this function convert.php?step=1&substep=0&cstep=11&start=0
i changed line 1248
from:
if ($_GET['substep'] == 0 || (isset($_SESSION['cstep']) && $_SESSION['cstep'] < 11))
to:
if ($_GET['substep'] == 0 || (isset($_SESSION['cstep']) && $_SESSION['cstep'] == 11))
also had an error inserting attachments
change line 1399
to:
$ID_ATTACH, $size, 0, '" . addslashes($row['temp_filename']) . "', $row[ID_MSG], $width, $height)'";
was that supposed be able to determine the width and height of the existing attachments?
all threads import but nothing is linked to user profiles, everything is "guest" i can PM you the site URL if you want to take a look
I'm looking into that guests posts issue. I can't seem to figure out what is going on. I'm working on it now and see if I can find the problem.
thanks, let me know if i can help at all
Ok here we go. Took me a while to get a working version but here it is. Let me know if anything. I attached it to the first post.
still getting stuck at
convert.php?step=1&substep=0&cstep=11&start=0
dont think this is related but i also get
Converting...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '164-478' for key 1
i can always trick it past this point, from the reading i've done i think its because YaBB was case sensitive and SMF isnt so i have some duplicate user entries
ran it again on a clean install and got past step 11
now stuck on step 12
convert.php?step=1&substep=12&cstep=12&start=0
seems odd that substep and cstep are both 12 here
looking at the code for function convertStep12() i dont see substem being incremented
went back to the version from last night, trying to make sense of the topics that are not linked to the profiles, and found that afew were linked properly
mysql> select count(*) from smf_topics;
+----------+
| count(*) |
+----------+
| 10441 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from smf_topics where ID_MEMBER_STARTED != 0;
+----------+
| count(*) |
+----------+
| 19 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from smf_topics where ID_MEMBER_updated != 0;
+----------+
| count(*) |
+----------+
| 18 |
+----------+
1 row in set (0.01 sec)
sorry if i'm rambling on here, but i keep diggin further into this,
the majority of posts show
<membername>
Guest
(the mail icon with the members email in the mailto: link)
i have been able to pull member ID's and names then use that to update smf_messages one user at a time
update smf_messages set ID_MEMBER = 3 where posterName ='naitram';
this appears to have fixed most of the cosmetic issues
The issue on step 12 is a known issue. This was the only way that I was able to get step 12 to work. Step 12 handles assigning posts to the correct user. That's why some of them show as guests since you didn't let step 12 finish. I'll see what I can do.
thanks again, for all the help. i kown maintaining a convertor can be a real pain in the ass.
i found some other minor issues along the way none of them will stop me from converting my production site
non-post member groups dont convert
post member groups dont have the right values for min posts
polls all have maxvotes set to 0
all boards set for posts not to count towrads post totals
board names truncated ( might be a special character issue )
i hope you dont take the above as complaining, the convertor in its current state will allow me to migrate from YaBB to SMF with a minimum of hassle. and anyone who isnt willing to correct the above issues by hand doesnt realy want to convert their software ;D
I don't mind you giving me all this feedback :). It helps get the converter working properly.
Can you please send me your membergroups.txt file. Need to test it out locally and see what's up. Also do you know how many characters were cut off from the board name? There is a max of 255 chars since that's the biggest value a tinytext field can hold.
Also I added some type of step notice for step 12. It should say something like "x out of y have been assigned to the correct member."
! When converting make sure to check if a is set to count posts (yabb21_to_smf.php)
! Check to see what the maxVotes for polls is set to, if 0 set it to 1. (yabb21_to_smf.php)
$Group{'Global Moderator'} = 'Global Moderator|5|mod.gif|#ffa500|0|0|0|0|0|0';
$Group{'Moderator'} = 'YaBB Moderator|4|mod.gif|purple|0|0|0|0|0|0';
$Group{'Administrator'} = 'YaBB Administrator|6|mod.gif|green|0|0|0|0|0|0';
$NoPost{'1'} = 'CVO Moderator|4|mod.gif|maroon|1|0|0|0|0|0';
$NoPost{'4'} = '07GTG|1|mod.gif|fuchsia|1|0|0|0|0|0';
$NoPost{'3'} = 'Vendor|2|vend.gif|maroon|0|0|0|0|0|0';
$NoPost{'2'} = 'MVOC|1|mod.gif|fuchsia|1|0|0|0|0|0';
$Post{'50'} = 'Junior CVO Member|2|off.gif||0|0|0|0|0|0|Green';
$Post{'5000'} = '5k CVO Member|3|on.gif|#a0522d|0|0|0|0|0|0|Gradient_Yellow';
$Post{'250'} = 'Senior CVO Member|4|off.gif||0|0|0|0|0|0|Orange';
$Post{'10000'} = '10K CVO Member|4|on.gif|red|0|0|0|0|0|0|Gradient_Red';
$Post{'2500'} = '2.5K CVO Member|2|on.gif|teal|0|0|0|0|0|0|Gradient_Green';
$Post{'1000'} = '1K CVO Member|1|on.gif|blue|0|0|0|0|0|0|Gradient_Blue';
$Post{'500'} = 'Elite CVO Member|5|off.gif||0|0|0|0|0|0|Red';
$Post{'100'} = 'Full CVO Member|3|off.gif||0|0|0|0|0|0|Yellow';
$Post{'-1'} = 'CVO Newbie|1|off.gif||0|0|0|0|0|0|Blue';
1;
board names seems to be getting truncated where i have a (R) symbol
! When converting non posts based groups the preg_match was incorrect. (yabb21_to_smf.php)
! Make sure to use the correct offset to get the correct minPosts for post count based groups. (yabb21_to_smf.php)
Do you have ab example for the board names issue? Like before and after example.
Let me know how this goes. Any outstanding issues?
just started another conversion with a clean install, i'll post the board names later
Quote from: naitram on January 28, 2007, 04:13:28 PM
just started another conversion with a clean install, i'll post the board names later
example
was
VRXSE Screamin' Eagle® Destroyer™
after conversion
VRXSE Screamin' Eagle
Post the forum.master file so that I can test it locally.
here ya go
Ok can you please also post the forum.control file?
here ya go
stuck in a loop at
convert.php?step=1&substep=0&cstep=11&start=0
forced it forward by manually going to
convert.php?step=1&substep=1&cstep=11&start=0
ok now stuck at
convert.php?step=1&substep=12&cstep=12&start=0
Converting...
Converting posts (part 3)... 250 out of 164448 have been assigned to the correct member. 500 out of 164448 have been assigned to the correct member. Incomplete.
Ok give this a try.
! When converting board names make sure to sanitize it. (yabb21_to_smf.php)
! Show the convert posts status just once. (yabb21_to_smf.php)
not at home right now, but i'll get this tested tomorrow
starting another conversion, board names look good
Ok good. Let me know how everything else goes.
still stuck on step 12
convert.php?step=1&substep=12&cstep=12&start=0
Converting...
Converting posts (part 3)... out of 164448 have been assigned to the correct member. Incomplete.
Seems like I have a typo somewhere. Just let the converter run. It will finish.
it's always substep 12 in the URL
i checked in mysql
mysql> show processlist;
+-----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+------+---------+------+-------+------------------+
| 506 | smf | localhost | smf | Sleep | 151 | | NULL |
| 514 | smf | localhost | smf | Sleep | 57 | | NULL |
| 515 | smf | localhost | smf | Sleep | 43 | | NULL |
| 516 | smf | localhost | NULL | Sleep | 97 | | NULL |
| 517 | smf | localhost | smf | Sleep | 17 | | NULL |
| 518 | smf | localhost | smf | Sleep | 191 | | NULL |
| 519 | smf | localhost | NULL | Sleep | 30 | | NULL |
| 520 | smf | localhost | smf | Sleep | 84 | | NULL |
| 521 | smf | localhost | smf | Sleep | 735 | | NULL |
| 522 | smf | localhost | smf | Sleep | 111 | | NULL |
| 523 | smf | localhost | smf | Sleep | 138 | | NULL |
| 524 | smf | localhost | smf | Sleep | 70 | | NULL |
| 525 | smf | localhost | NULL | Sleep | 3 | | NULL |
| 546 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+-----+------+-----------+------+---------+------+-------+------------------+
14 rows in set (0.00 sec)
running this over and over, i don't see any activity in the DB
Well there is a 5 seconds sleep period between each page load.
i sat in mysql using issuing that command over and over as fast as possible for a good 10 seconds just to be sure
ok, started from a clean install again,
found the error in the echo statemens in Step12
', $actualPosts, ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';
changed to
', $_SESSION['actualPosts'], ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';
may last run worked ;D
followup issues found
ID_MEMBER not linked in smf_polls table
all boards default to posts not counting towards post total
Quote from: naitram on January 29, 2007, 02:07:52 PM
ok, started from a clean install again,
found the error in the echo statemens in Step12
', $actualPosts, ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';
changed to
', $_SESSION['actualPosts'], ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';
Yup the exact typo that I was thinking about :P.
Quote from: naitram on January 29, 2007, 03:27:02 PM
followup issues found
ID_MEMBER not linked in smf_polls table
all boards default to posts not counting towards post total
Got an example? I don't really get what you mean in the second part.
if i go into admin and modify a board this following option
Count Posts
Makes new replies and topics raise members' post counts.
this is not checked by default
Quote from: fro on November 23, 2006, 10:26:32 PM
I enabled attachments in YaBB a few days ago without installing any mods.
There's only a few attachments, so I can add them by editing a few posts. So I just added return; at the beginning of convertStep13(). Is that ok, or will that break something else?
At least the script completed and the messages are converted. Polls were not included, but that's not a big problem.
I am having the very same issue. can you tell me where I should put the return;?
Quote from: naitram on January 30, 2007, 09:40:40 AM
if i go into admin and modify a board this following option
Count Posts
Makes new replies and topics raise members' post counts.
this is not checked by default
I'll look into that again. I thought I had fixed this. In regards to the polls. What do you mean?
Quote from: heckuvanoob on January 30, 2007, 12:30:19 PM
Quote from: fro on November 23, 2006, 10:26:32 PM
I enabled attachments in YaBB a few days ago without installing any mods.
There's only a few attachments, so I can add them by editing a few posts. So I just added return; at the beginning of convertStep13(). Is that ok, or will that break something else?
At least the script completed and the messages are converted. Polls were not included, but that's not a big problem.
I am having the very same issue. can you tell me where I should put the return;?
That post is kinda old. Try the new converter that I uploaded.
Quote from: JayBachatero on January 30, 2007, 07:18:11 PM
I'll look into that again. I thought I had fixed this. In regards to the polls. What do you mean?
if you look in the database when you create a new poll you will see the ID and the username of the person who created. on the converted poll the ID is alwasy 0 i cant find any negative imapct to this in my testing.
i'd grab some more specific info for you but as of last night i no longer have access to my test system.
I'll look into fixing this later on when I get home from school. I wonder where I messed up >_<.
i think the same logic for "linking" posts to members could be used for the polls as wel
It's a tricky one actually. Took me a while to get it "working" when I first added the poll conversion to the converter.
if all goes well i'll have my new system up this weekend and may have some time to run some more tests for you before i cut over my production site
Ok sounds good. I'll try to have something for you to test on soon.
Hey JayBachatero, just wanted to say thanks! If it wasnt for guys like you taking the time out of your personal life to work on stuff like this, it just wouldnt be possible. My conversion from Yabb 2.1 was perfect, went without a hitch. 8) Cheers!
Yes What Tom said! Thanks a whole bunch Jay!! I have been having so much fun with SMF I forgot to say thanks! It's so much better then Yabb I can't believe it.
And for any of you want to convert from Yabb and it doesn't work, have patience Jay is a busy guy and does have a life outside of SMF. You wait will be worth it.
just to echo what has already been said, thanks for the time and effort you put into this converter.
i upgraded my production site this past weekend 3000+ users 160000+ posts and the response from my members has been extremely positive.
i did have some problems with the attachments piece of the conversion and had to do alot of the SQL updates by hand. non-image attachments were to entering "0" for height and width the null values were causing errors.
but when all was said and done we are up and running on SMF and everyone is happy
Hi
I seem to be having a problem in getting the converter to find the Settings.pl
The YaBB forum is on one website and I am trying to convert the files to a SMF which is on a second website at a different address with a different ISP - is this possible?
If it is, can someone suggest what the path is likely to be - I seem to have tried all permutations - Thanks John
needs to be on the same filesystem
Thanks for the above - got that sorted now.
Started to convert the records and this error message appeared - has anyone got any ideas?
QuoteConverting members... Unsuccessful!
This query:
ALTER TABLE `temp`.smf_members
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY;
Caused the error:
Multiple primary key defined
oh!! - not sure how the smiley appeared - that should read [8]
That error shouldn't happen since the converter will check to see if the key/column exists before adding/removing it. Are you using the more recent convert.php right?
Quote from: JayBachatero on November 17, 2006, 11:21:57 PM
Is anyone here having problems with post count not increasing when posting?
Yes we are having that issue with our board.. I read most of this thread.. is there a solution for this that I missed?
check you converted boards and see it they are configured for post to count towards post totals.
I missed this for about a week before I found it.
Under Admin, Forums, boards, Modify Boards, then each board has a "Count Posts".
Hope that helps.
-ST
Thanks! That helps!
Seems like I have some values mixed up. I'll look into it and see where I messed up. Did you have non post count based boards that posts are being counted on?
Im getting the following error...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `ftaindex_smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '409-4702' for key 1
Any ideas please??
Many thanks
Are you using the convert files in this topic?
Quote from: sleeper99 on March 04, 2007, 04:31:41 AM
Im getting the following error...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `ftaindex_smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '409-4702' for key 1
Any ideas please??
Many thanks
i ran into this as well, i simply commented out that step inb the convertor. and after cleared the table and put the index on it
That table should insert ignore into. Gotta look into this error.
Everytime I try to convert my yabb 2.1 to SMF I just get this error:
Converting...
Warning: file(/home/max/public_html/yabb/Variables/Settings.pl) [function.file]: failed to open stream: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 98
Warning: Invalid argument supplied for foreach() in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/home/max/public_html/yabb/Variables/membergroups.txt) [function.file]: failed to open stream: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 120
Warning: Invalid argument supplied for foreach() in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 121
Successful.
Converting members...
Warning: dir(/home/max/public_html/yabb/Members) [function.dir]: failed to open dir: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 214
Fatal error: Call to a member function read() on a non-object in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 246
Ideas anybody?
Thanks
Fix the paths in the Paths.pl file.
Ok I see the reason for the duplicate key error. Insert ignore doesn't work since it doesn't have an index at the time. Need to come up with something to prevent this.
Quote from: JayBachatero on March 06, 2007, 07:08:26 PM
Fix the paths in the Paths.pl file.
Thanks so much!!!
It works... ahh... great! :D
Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `american_smf1`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
Quote from: kelltech on March 07, 2007, 09:55:22 AM
Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `american_smf1`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
Umm now that error shouldn't be happening. What happens if you run it again?
Quote from: JayBachatero on March 07, 2007, 01:04:22 PM
Quote from: kelltech on March 07, 2007, 09:55:22 AM
Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `american_smf1`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
Umm now that error shouldn't be happening. What happens if you run it again?
Thanks Jay...if I click the try again option or if I run the entire installation again it repeats the error. When re-running the installation it sometimes changes the numbers in the duplicate entry causing the error.
How big is your board?
Quote from: JayBachatero on March 07, 2007, 04:37:47 PM
How big is your board?
Our users have made 7727 Posts within 1642 Topics, we have 202 registered members
Umm so it shouldn't be giving those errors. I'll have to look more into these errors.
Hi Jay, thanks for working on that-I appreciate your time. I tried a clean install and a clean convert and got the 'poll votes' error again:
QuoteConverting poll votes... Unsuccessful!
This query:
ALTER TABLE `american_smf1`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
So I thought I'd pass on what mods are installed, I don't know if it makes a difference:
* Quick Reply Box
* Link IP Mod
* YaBB 2 Backup
* Distilled Email Domains
Thanks again, whenever you get a chance to take a look, no rush. Have a good weekend :-)
Those mods shouldn't cause an error. I have to work this weekend but I'll see what I can do.
Im probably being stupid here, but i cant find any instructions for using the converter.
Plz post the blindingly obvious link i am missing. :-[
http://docs.simplemachines.org/index.php?board=4.0;sort=subject
Hi Jay-I've been working like crazy lately. Any chance to look into those errors? I've not had any luck with a conversion, still getting the same error.
I've been real busy with school and work lately. I'll try to take a look at this for you when I get a chance.
Hello. I have used the converter of yabb21 to SMF. Perfect one became all, the users, post, etc, but they do not appear to me topics in the forum.
What can be? Please, helpme. Thanks.
In the beginning it gives an error me:
Converting membergroups... Successful.
Converting members...
Notice: Undefined index: password in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 308
Notice: Undefined index: password in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 308
Notice: Undefined index: email in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 310
Notice: Undefined index: postcount in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 314
Notice: Undefined index: userpic in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 322
Incomplete.
When finalizing the conversion gives the following error me:
Converting...
Notice: Undefined index: convert_script in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 580
Warning: Invalid argument supplied for foreach() in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 583
Notice: Undefined index: convert_script in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 935
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 945
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 953
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 963
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 976
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 989
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1035
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1037
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1043
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1049
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1060
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1061
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1069
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1071
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1077
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1078
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1084
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1085
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1109
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1111
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1117
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1129
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1154
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1156
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1192
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1193
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1231
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1236
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1297
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1299
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1335
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1354
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1377
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1378
Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1454
installation.
We hope you had a smooth transition!
After the conversion the forum is just as when installing it. I must make a reconteo of the forum so that they appear the users, but post does not appear. Excuse my English.
what can be?
About half the posts imported from Yabb 2.1 are not linked to users, so they appear as guests. But the other half works nicely. It's not really a problem to me, but can it be fixed manually ?
Did you try reconverting again?
Quote from: kelltech on March 09, 2007, 10:24:03 PM
Hi Jay, thanks for working on that-I appreciate your time. I tried a clean install and a clean convert and got the 'poll votes' error again:QuoteConverting poll votes... Unsuccessful!
This query:
ALTER TABLE `american_smf1`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
So I thought I'd pass on what mods are installed, I don't know if it makes a difference:
* Quick Reply Box
* Link IP Mod
* YaBB 2 Backup
* Distilled Email Domains
Thanks again, whenever you get a chance to take a look, no rush. Have a good weekend :-)
Just thought I'd check for any progress on this error-still getting the same error on a fresh install & convert attempt. Thanks for any help!
Could someone help me with the issue at: http://www.simplemachines.org/community/index.php?topic=165586.0
Thanks in advanced.
Will this converter keep the looks of the yabb forum like the colors I put for a theme or will I have to do the theme all over again?
Quote from: msbean on April 21, 2007, 04:21:14 AM
Will this converter keep the looks of the yabb forum like the colors I put for a theme or will I have to do the theme all over again?
AFAIK the converter wont convert your theme over since they are not compatible. You will have to convert it manually.
hi, Anyone know why the yabb > smf1.1.2 converters in the donwloads section are just empty zip files - am I missing something ?
Thanks
Those files are out of date AFAIK. You should use the one's in this topic.
I'm trying to convert a forum and I get this error.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `smf`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('3', '2203', '5'),
('3', '0', '6'),
('3', '0', '6'),
('3', '0', '4'),
('3', '0', '5'),
('3', '0', '3'),
('3', '0', '1'),
('3', '0', '2'),
('3', '0', '6'),
('3', '0', '0'),
('3', '0', '0'),
('3', '0', '6'),
('3', '0', '5'),
('3', '0', '0'),
('3', '0', '5'),
('3', '0', '1'),
('3', '0', '5'),
('3', '2647', '3'),
('3', '0', '1'),
('3', '0', '3'),
('3', '0', '1'),
('3', '0', '3'),
('3', '0', '3'),
('3', '2538', '1'),
('3', '0', '3'),
('3', '0', '1'),
('3', '0', '1'),
('3', '0', '1'),
('3', '0', '2'),
('3', '0', '5'),
('3', '0', '3'),
('3', '0', '1'),
('3', '0', '1'),
('3', '0', '3'),
('3', '0', '3'),
('3', '0', '3'),
('3', '0', '3'),
('3', '0', '0'),
('3', '531', '1'),
('3', '0', '1'),
('3', '0', '1'),
('3', '0', '3'),
('3', '0', '3'),
('3', '0', '6'),
('3', '1839', '3'),
('3', '0', '1'),
('3', '0', '4'),
('3', '0', '0'),
('3', '2517', '6'),
('3', '1539', '3'),
('3', '0', '1'),
('3', '0', '4'),
('3', '0', '1'),
('3', '0', '1'),
('3', '0', '3'),
('3', '0', '1'),
('3', '2172', '3'),
('3', '0', '3'),
('3', '0', '1'),
('3', '0', '3'),
('3', '2495', '1'),
('3', '0', '6'),
('3', '0', '6'),
('3', '0', '3'),
('3', '1318', '3'),
('3', '0', '6'),
('3', '2328', '1'),
('3', '0', '4'),
('3', '0', '6'),
('3', '2485', '5'),
('3', '1', '1'),
('3', '1520', '1'),
('3', '2', '1');
Caused the error:
Duplicate entry '3-2203-5' for key 1
Anyone know how to fix this?
Okay, I figured out how to get past this issue. I just deleted the postnumber.poll and .polled files. The problem I'm having now is that the username registration date didn't carry over on the conversion and it's making most of my members as deleted guests thus no profile. Anyone know how to fix this?
Hello All, Im considering converting my Yabb , And would like to know if there is any help available should I need It, Being a complete muppet at this sort of thing...Thought I had best ask first...
Thankyou in advance..
Shawn
Allrighty
Anyone provide any clues on this error?
QuoteConverting attachments (if the mod is installed)...
Warning: getimagesize() [function.getimagesize]: Read error! in /home/u4/personal/html/yabb_convert4/yabb21_to_smf.php on line 1378
Unsuccessful!
This query:
INSERT INTO `smf_db`.convert4attachments
(ID_ATTACH, size, downloads, filename, ID_MSG, width, height)
VALUES
(1, 16894, 0, 'hummer.jpg', 43, 400, 290),
(2, 68865, 0, 'JAM_022604_A.JPG', 266, 380, 472),
(3, 37564, 0, 'diego3.jpg', 456, 320, 237),
(4, 52672, 0, 'BoulderSunset.JPG', 460, 736, 552),
(5, 66746, 0, 'DSCF0002.JPG', 1481, 800, 600),
(6, 57915, 0, 'dogs.jpg', 1797, 448, 293),
(7, 47256, 0, 'SLAssn6-30-04.jpg', 2215, 500, 646),
(8, 53363, 0, 'tequila1.1.JPG', 2291, 626, 943),
(9, 45553, 0, 'backyard_rink1.jpg', 2389, 640, 427),
(10, 23341, 0, 'bluebig.jpg', 2720, 400, 300),
(11, 45146, 0, 'bluejack.jpg', 2721, 480, 640),
(12, 40505, 0, 'Free_Dog.jpg', 2756, 555, 600),
(13, 72410, 0, 'MENBLUE.GIF', 2809, 353, 336),
(14, 106911, 0, 'Jaxy.JPG', 2894, 872, 1158),
(15, 50905, 0, 'cop.jpg', 3231, 432, 316),
(16, 35349, 0, 'chris_and_tequila_2.JPG', 3324, 533, 360),
(17, 196548, 0, 'silverstone_lake_morning_fall_04.JPG', 4030, 720, 540),
(18, 158555, 0, 'September_2004_022.jpg', 4072, 640, 480),
(19, 135902, 0, 'September_2004_023.jpg', 4073, 640, 480),
(20, 156030, 0, 'September_2004_024.jpg', 4074, 640, 480),
(21, 17454, 0, 'dishDiagram.gif', 4104, 814, 562),
(22, 43809, 0, 'dish4.jpg', 4107, 633, 466),
(23, 21179, 0, 'dish2.jpg', 4108, 504, 347),
(24, 153511, 0, 'October_04_005.jpg', 4262, 640, 480),
(25, 36674, 0, 'owl3.JPG', 4325, 640, 425),
(26, 51543, 0, 'future.jpg', 4358, 575, 349),
(27, 89967, 0, 'golf.jpg', 4975, 1024, 768),
(28, 128781, 0, 'Score.jpg', 4991, 500, 352),
(29, 150896, 0, 'Halloween_04_009.jpg', 5079, 640, 480),
(30, 3236, 0, 'high5.gif', 5124, 65, 35),
(31, 21137, 0, 'DOG05RK002206.jpg', 5464, 280, 210),
(32, 16594, 0, 'DOG05RK003919.jpg', 5465, 280, 210),
(33, 23551, 0, 'logo_316693.jpg', 5775, 342, 484),
(34, 77527, 0, 'turkeymap.jpg', 5847, 697, 439),
(35, 7802, 0, 'tiara.jpg', 5942, 132, 176),
(36, 103681, 0, 'PICT0296.JPG', 6063, 640, 480),
(37, 64247, 0, 'tony.jpg', 6064, 480, 640),
(38, 93470, 0, 'PICT0290.JPG', 6065, 640, 480),
(39, 67886, 0, '13949.gif', 6215, 423, 381),
(40, 4806, 0, '39221_wallpaper110.jpg', 6230, 110, 82),
(41, 5793, 0, '42714_wallpaper110.jpg', 6231, 110, 82),
(42, 10925, 0, 'december.jpg', 6461, 260, 260),
(43, 19490, 0, 'november.jpg', 6468, 260, 260),
(44, 43789, 0, 'santa-timmy1.jpg', 6501, 300, 450),
(45, 36005, 0, 'santa-sarah1.jpg', 6502, 300, 450),
(46, 405054, 0, 'untitled.bmp', 6529, 300, 450),
(47, 405054, 0, 'untitled_2.bmp', 6530, 300, 450),
(48, 405054, 0, 'untitled_3.bmp', 6531, 300, 450),
(49, 28087, 0, 'DSCF0002b.jpg', 6536, 400, 300),
(50, 48030, 0, 'santa-francis1.jpg', 6544, 300, 450),
(51, 31543, 0, 'crapart2_4.jpg', 6546, 419, 329),
(52, 900, 0, 'stargold.gif', 6785, 12, 12),
(53, 171113, 0, 'temp.JPG', 6962, 1016, 762),
(54, 63583, 0, 'geese.jpg', 7206, 981, 368),
(55, 182863, 0, 'MerryChristmas.jpg', 7515, 722, 771),
(56, 5794, 0, 'bluepuff1.jpg', 7924, 132, 176),
(57, 5058, 0, 'bluepuff2.jpg', 7925, 132, 176),
(58, 71148, 0, 'PICT0337.JPG', 8492, 640, 480),
(59, 123678, 0, 'PICT0336.JPG', 8494, 640, 480),
(60, 27644, 0, 'kitty.jpg', 8674, 301, 428),
(61, 308578, 0, 'Santa.bmp', 8758, 495, 311),
(62, 37310, 0, 'freepuppy.jpg', 8905, 617, 434),
(63, 4285, 0, 'Rascal1.jpg', 9237, 147, 145),
(64, 94529, 0, '8380.jpg', 9266, 640, 480),
(65, 23996, 0, 'pup.jpg', 9319, 300, 282),
(66, 24956, 0, 'pup2.jpg', 9321, 300, 474),
(67, 16094, 0, 'pup3.jpg', 9322, 300, 353),
(68, 14252, 0, '16452004311105750.jpg', 9323, 300, 234),
(69, 52563, 0, 'street-with-no-beer.jpg', 9369, 800, 600),
(70, 15501, 0, 'helmet.gif', 9379, 612, 439),
(71, 70123, 0, 'PICT0344.JPG', 9397, 640, 480),
(72, 77680, 0, 'PICT0347.JPG', 9398, 640, 480),
(73, 70309, 0, 'PICT0348.JPG', 9399, 640, 480),
(74, 45699, 0, 'PICT0403.JPG', 9400, 448, 336),
(75, 213138, 0, 'PICT0399.JPG', 9401, 1024, 768),
(76, 31194, 0, 'sunspotmod.jpg', 9476, 297, 219),
(77, 9768, 0, 'Tv_abc_dick_clark_newyears.jpg', 9485, 217, 174),
(78, 288008, 0, 'PICT0408.JPG', 9584, 1024, 768),
(79, 234042, 0, 'PICT0411.JPG', 9585, 1024, 768),
(80, 104708, 0, 'lily5.jpg', 9672, 379, 450),
(81, 153767, 0, 'lily2.jpg', 9673, 918, 619),
(82, 0, 0, 'santa_hat.jpg', 9674, , ),
(83, 210314, 0, 'xmas_lily.jpg', 9675, 925, 622),
(84, 12626, 0, '1732.jpg', 9682, 288, 192),
(85, 14565, 0, '1.jpg', 9685, 288, 192),
(86, 11357, 0, '2.jpg', 9686, 202, 288),
(87, 16724, 0, '3.jpg', 9687, 288, 200),
(88, 20036, 0, '4.jpg', 9688, 288, 201),
(89, 16150, 0, 'group20001.jpg', 9689, 202, 288),
(90, 14121, 0, 'group20002.jpg', 9690, 202, 288),
(91, 15915, 0, 'group20003.jpg', 9691, 288, 202),
(92, 18634, 0, 'group20004.jpg', 9692, 288, 200),
(93, 18629, 0, 'group20005.jpg', 9693, 288, 201),
(94, 17731, 0, 'My_Pictures0001.jpg', 9703, 288, 192),
(95, 18446, 0, 'My_Pictures0002.jpg', 9704, 205, 288),
(96, 17405, 0, 'My_Pictures0003.jpg', 9705, 288, 202),
(97, 15129, 0, 'My_Pictures0004.jpg', 9706, 288, 192),
(98, 18543, 0, 'My_Pictures0005.jpg', 9707, 288, 203),
(99, 2762, 0, 'champagne_glasses_confetti_sm_wht.gif', 9744, 50, 50),
(100, 6025, 0, 'man_head_spinning_sm_blk.gif', 9761, 84, 84);
Caused the error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ),
(83, 210314, 0, 'xmas_lily.jpg', 9675, 925, 622),
Thanks!
Argh
Not sure if this has anything to do with it, but the file in question xmas_lily.jpg appears to be from an ex member so I am having a hard time tracking down this post in my forum.
The weird thing is that this image is located in my attachments folder. But not listed in a post that I can find.
In fact when I look at the attachments log, this file is no where to be found. So...why does this error show up?
Seems like I have a LOT of attached files that are in posts but NOT in my attachments log.
Does this make any sense?
Wow, OK took some tracking but I found something.
I use to run a YaBB 1.3 Gold something or other. Back in Sept of 2005 I moved to Yabb2. What I didnt do was move the old attachments log to the new Yabb2.
So now my new attachments log only lists attachments after Sept 16th 2005. But I still have posts from before Sept 16th 2005 that have attachments that are not accounted for in the new log.
If this converter was still being worked on, I would suggest only looking at the currently active attachments log and ignore any attachments not in the log. Which I guess means those attachments do not get moved. Not sure that would fix my situation.
Any thoughts? I guess I could dump any attachments made before Sept 16. Though that is not the best solution...
Confirmed.
I was able to use the old attachments log to find what post had the xmas_lily.jpg file attached. I edited the post to remove the file and re-ran the converter.
As predicted, the converter failed out while converting attachments, but this time on a different attachment.
Anyone have any suggestions? Manually editing 270 posts to remove old attachments is not fun that I would like to have.
I think I have a problem with my paths or permission... Can anybody piont me in the right direction...
Kindest Regards
Warning: file(/home/ravensho/public_html/bbs/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 76
Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 79
Notice: Undefined index: boardsdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: datadir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: memberdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: sourcedir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: vardir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: facesdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Notice: Undefined index: uploaddir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91
Warning: file(/Settings.pl) [function.file]: failed to open stream: No such file or directory in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 98
Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/membergroups.txt) [function.file]: failed to open stream: No such file or directory in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 120
Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 121
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 246
Ive learnt a little from reading posts here and have managed to get all the posts, and boards across, But I stumped, I have NO members, and no attachments.. If anybody can help I would really appreciate it
Does this mean anything to someone that knows, what they are doing, ?
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics...
Notice: Undefined index: latestMember in /home/ravensho/public_html/forum/convert.php on line 1088
Notice: Undefined index: latestRealName in /home/ravensho/public_html/forum/convert.php on line 1089
Successful.
Conversion Complete
Cheers Shawn
...
The attached file fixes the poll duplicate errors.
Well Im not having a lot of Luck converting mine over, Ive spent many hours trying, If anybody can help me at all it would be most appreciated, Im not too savvy at this sort of thing..
Thankyou all
S
Hi Everyone,
Firstly, a very big thanks for the help that you guys are clearly giving everyone.
I've tried the standard files, with a database error, and now found these threads with new files... With excitement I downloaded them, reinstalled a fresh version of the forums (as I saw this was a good idea in the various posts) and downloaded the new files... However, the only converter that works is the original one I downloaded from the web site (the one with the error).. All the other convert.php and yabb_to_smf.php files give an error. I tried different combination and nothing works...
Here is the error I'm getting:
Parse error: syntax error, unexpected T_VARIABLE in /home/3199/domains/domain.com/html/smf/yabb_to_smf.php on line 1
Would love some assistance.. It's really important for me to be able to convert this very large yabb forum into something a little bit better, and I think this forum would be perfect.
Thanks!
Al
Which version of Yabb are you using? Do you still need help?
Craig
Yes Im having all sorts of grief, and am using 2.1
That is if you are talking to me....
Thankyou Shawn
...
Are you still getting these errors?
Notice: Undefined index: latestMember in /home/ravensho/public_html/forum/convert.php on line 1088
Notice: Undefined index: latestRealName in /home/ravensho/public_html/forum/convert.php on line 1089
or are you getting a different one now?
Hi Im not getting any errors, now the conversion seems to go well , with the little message at the end, but when you look at the forum the posts and catagories are there, Images and attacthments are not and there are no members, Including myself , So I cant Log in...
Any help would be really appreciated...
Kind Regards
Shawn
...
And I just had a look again, the board runs very slowly, all the 9000 odd posts are by the same person, half the threads are locked...Something screwy went on me thinks,,, :-\
Thankyou
Shawn
..
hi all , recently i just convert from yabb2.1 to SMF .. everything was ok , the problem is :
1) Existing members appear as guest
2) no increase of posting
3) all members registration date shown from 1970,
Appreciate if someone could advise how to deal with this problem ...
Thank you
Did you recount your forum totals and stats and check for errors? Do you see anything in the forum error log?
bro i still facing the same issue after board has been recount ....
Version of phpbb you converted from and did you see any errors during conversion?
Send me a dump of your phpBB database so I can take a look.
Quote from: yeop on July 30, 2007, 12:21:44 AM
hi all , recently i just convert from yabb2.1 to SMF .. everything was ok , the problem is :
1) Existing members appear as guest
2) no increase of posting
3) all members registration date shown from 1970,
Appreciate if someone could advise how to deal with this problem ...
Thank you
post count -fixed :)
members registration wrongly date - fixed :)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg146.imageshack.us%2Fimg146%2F7029%2Fguesttfw8.png&hash=cc29c5b38f84e445db833e846e31e0e87df8de57)
existing member still appear as guest , pls advise ...thanksQuote from: redone on August 01, 2007, 12:02:28 PM
Version of phpbb you converted from and did you see any errors during conversion?
Send me a dump of your phpBB database so I can take a look.
thanks for your reply planning to migrate from YaBB2.1 to SMF1.13
Can you post how you fixed the issues. They may help somebody in the future or it may be a bug in the script that we may have to fix.
My only guess about members being guests is that it wasn't able to match up their IDs to anything in the members table.
For date registered is not converted , i just follow posting given by the members
http://www.simplemachines.org/community/index.php?topic=174754.0
Thanks to Jorish :)
Ok who still needs help with the converter?
hi Jay I am now full running on SMF1.1.3 , convert from yabb2.1 to SMF , anyhow can fix members appear as guest ???
thanks in advanced
Quote from: yeop on August 12, 2007, 03:51:54 AM
hi Jay I am now full running on SMF1.1.3 , convert from yabb2.1 to SMF , anyhow can fix members appear as guest ???
thanks in advanced
If I remember correctly I fixed this a while ago and posted the converter in of the pages of this topic and not in the main page. I'll look into it.
Hello,
I have installed a fresh copy of SMF 1.1.3. It works fine!
But I would like to import my YABB-21 forum.
I use convertor from 1st posting in this thread. Nothing works. I get the following error-output. I am sure that path to YABB-21 is correct!
Quote
Warning: file(/home/ser12476/public_html/vlad4m/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 76
Warning: Invalid argument supplied for foreach() in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 79
Notice: Undefined index: boardsdir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: datadir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: memberdir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: sourcedir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: vardir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: facesdir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: uploaddir in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 91
Warning: file(/Settings.pl) [function.file]: failed to open stream: No such file or directory in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 98
Warning: Invalid argument supplied for foreach() in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/membergroups.txt) [function.file]: failed to open stream: No such file or directory in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 120
Warning: Invalid argument supplied for foreach() in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 121
Successful.
Converting members...
Fatal error: Call to a member function read() on a non-object in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 246
Please tell me, what is wrong? I am out of advice :( Thanks!
Read your first error, it explains it:
QuoteWarning: file(/home/ser12476/public_html/vlad4m/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/ser12476/public_html/smf/yabb21_to_smf.php on line 76
OK I am ready to try this again.
One thing I was wondering if people in here could help me with.
First, which version of SMF should I try converting to? 1.1.3?
Second, where are the latest conversion files I need to use? The are scattered through out this thread. Its a little hard to track down which one to use.
Thanks everyone
You need SMF 1.1.3 and the converter from the first page.
Thanks Jay
I will get that going today.
When you say that the converter from the first page you mean the first posted one? There have been others posted on different pages.
Sorry for my confusion.
Cheers for all the work you did on this converter. It is really appreciated!
Yea the first posted one. If not the last one.
Great thanks Jay
I am grabbing the converters from here:
http://www.simplemachines.org/community/index.php?topic=122338.msg781367#msg781367
And I am uploading a fresh install of 1.1.3
Doing it now.
I got an
QuoteInternal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.
Just hit refresh and it started up again.
Currently converting topics.
Now doing the posts
Another Internal error - Hit Refresh
Converting Posts (part 3)
Error while converting attachments.
So this is where I was the last time I tried this. I think I narrowed it down to the fact that I had migrated my YaBB a long time ago and the attachments list got messed up. The attachments prior to the upgrade are not listed in the new attachments log because they were handled differently on the older board around YaBB 1.3.1. I had started the pain process of removing the old attachments (the pre 2.1 board) hoping that it would help the SMF convert get past this error. (All 200+ of them)
Any thoughts?
QuoteConverting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Unsuccessful!
This query:
INSERT INTO `mysql-2`.yabb_convert6_attachments
(ID_ATTACH, size, downloads, filename, ID_MSG, width, height)
VALUES
(1, 17454, 0, 'dishDiagram.gif', 4104, 814, 562),
(2, 43809, 0, 'dish4.jpg', 4107, 633, 466),
(3, 21179, 0, 'dish2.jpg', 4108, 504, 347),
(4, 51543, 0, 'future.jpg', 4358, 575, 349),
(5, 77527, 0, 'turkeymap.jpg', 5847, 697, 439),
(6, 7802, 0, 'tiara.jpg', 5942, 132, 176),
(7, 10925, 0, 'december.jpg', 6461, 260, 260),
(8, 19490, 0, 'november.jpg', 6468, 260, 260),
(9, 28087, 0, 'DSCF0002b.jpg', 6536, 400, 300),
(10, 900, 0, 'stargold.gif', 6785, 12, 12),
(11, 63583, 0, 'geese.jpg', 7206, 981, 368),
(12, 71148, 0, 'PICT0337.JPG', 8492, 640, 480),
(13, 37310, 0, 'freepuppy.jpg', 8905, 617, 434),
(14, 4285, 0, 'Rascal1.jpg', 9237, 147, 145),
(15, 23996, 0, 'pup.jpg', 9319, 300, 282),
(16, 24956, 0, 'pup2.jpg', 9321, 300, 474),
(17, 16094, 0, 'pup3.jpg', 9322, 300, 353),
(18, 14252, 0, '16452004311105750.jpg', 9323, 300, 234),
(19, 52563, 0, 'street-with-no-beer.jpg', 9369, 800, 600),
(20, 15501, 0, 'helmet.gif', 9379, 612, 439),
(21, 70123, 0, 'PICT0344.JPG', 9397, 640, 480),
(22, 77680, 0, 'PICT0347.JPG', 9398, 640, 480),
(23, 70309, 0, 'PICT0348.JPG', 9399, 640, 480),
(24, 31194, 0, 'sunspotmod.jpg', 9476, 297, 219),
(25, 9768, 0, 'Tv_abc_dick_clark_newyears.jpg', 9485, 217, 174),
(26, 288008, 0, 'PICT0408.JPG', 9584, 1024, 768),
(27, 234042, 0, 'PICT0411.JPG', 9585, 1024, 768),
(28, 12626, 0, '1732.jpg', 9682, 288, 192),
(29, 2762, 0, 'champagne_glasses_confetti_sm_wht.gif', 9744, 50, 50),
(30, 20874, 0, 'ty_photo_of_the_month.jpg', 10148, 327, 167),
(31, 5930, 0, 'ty.jpg', 10150, 110, 124),
(32, 13940, 0, 'Carter.jpg', 10153, 133, 200),
(33, 27618, 0, 'TimnZoe.JPG', 10455, 407, 305),
(34, 217598, 0, 'NY05_9.jpg', 10480, 500, 337),
(35, 168749, 0, 'rainmaker.jpg', 10786, 320, 356),
(36, 78453, 0, 'cute_doodle.jpg', 10788, 320, 240),
(37, 60734, 0, 'fozzie.gif', 10792, 320, 224),
(38, 16331, 0, 'Jezebel20A.jpg', 10797, 320, 236),
(39, 35165, 0, 'myprotector2.jpg', 10816, 300, 288),
(40, 5878, 0, 'untitled.gif', 10826, 64, 75),
(41, 5268, 0, 'puggle.jpg', 10827, 120, 160),
(42, 47180, 0, 'Bentley2.jpg', 10839, 509, 351),
(43, 35199, 0, 'Bentley.jpg', 10841, 391, 305),
(44, 74961, 0, 'Zoe.JPG', 10862, 610, 458),
(45, 2345, 0, 'white.jpg', 11008, 121, 100),
(46, 23130, 0, 'paige.jpg', 11029, 300, 300),
(47, 20936, 0, 'paige_2.jpg', 11030, 300, 300),
(48, 5081, 0, 'bio_Hutson.jpg', 11032, 110, 124),
(49, 13326, 0, 'pam.jpg', 11033, 76, 105),
(50, 7292, 0, 'andrew2_109.jpg', 11061, 109, 122),
(51, 45731, 0, 'Icy.jpg', 11392, 800, 531),
(52, 18014, 0, 'Bittersweet_Map.gif', 11460, 400, 400),
(53, 63801, 0, 'Frozen_Tundra.JPG', 11809, 1024, 768),
(54, 9118, 0, 'jose.jpg', 11826, 160, 180),
(55, 176110, 0, 'SSLnet.jpg', 12347, 935, 757),
(56, 70632, 0, '00870018b.jpg', 12842, 500, 359),
(57, 78824, 0, '00870013b.jpg', 12844, 500, 376),
(58, 433514, 0, 'DSC00594a.JPG', 13216, 1290, 1105),
(59, 21548, 0, 'harley.jpg', 13630, 300, 225),
(60, 90429, 0, '083104042043b.jpg', 13638, 358, 224),
(61, 90825, 0, 'rdcs034b.jpg', 13647, 500, 374),
(62, 82518, 0, 'rdcs088b.jpg', 13648, 500, 374),
(63, 88787, 0, '114-1.JPG', 13650, 583, 438),
(64, 314614, 0, '2000_Ford_Explorer_003.jpg', 14014, 2448, 1632),
(65, 35712, 0, 'PICT0478.JPG', 14025, 448, 336),
(66, 36634, 0, 'PICT0480.JPG', 14026, 448, 336),
(67, 1629, 0, '58449.gif', 14620, 29, 29),
(68, 1629, 0, '58449.gif', 14621, 29, 29),
(69, 1629, 0, '58449.gif', 14622, 29, 29),
(70, 31987, 0, '03-13-2005_100245PM.JPG', 15539, 452, 283),
(71, 64868, 0, 'silverstone.jpg', 15690, 570, 368),
(72, 59909, 0, '2002acura.JPG', 15735, 640, 480),
(73, 137730, 0, 'neros2.JPG', 15794, 599, 895),
(74, 176578, 0, 'neros1.JPG', 15795, 598, 893),
(75, 32588, 0, 'maltipoo.jpg', 15993, 450, 338),
(76, 22139, 0, 'happy_keester.jpg', 16152, 420, 336),
(77, 18602, 0, 'SAILOR20JERRY20TATTOO20FLASH.jpg', 16227, 450, 331),
(78, 20691, 0, 'tattoo_web.JPG', 16547, 336, 448),
(79, 27809, 0, 'bunny_web.JPG', 16548, 336, 355),
(80, 55440, 0, 'SSLSatDishGuidelines.pdf', 17056, , ),
(81, 148330, 0, 'lowresjblj2060a.JPG', 17960, 640, 425),
(82, 75157, 0, 'lowrestlx151.JPG', 17961, 319, 480),
(83, 15092, 0, 'MoreLike.JPG', 18182, 316, 312),
(84, 33435, 0, '6.jpg', 18207, 315, 466),
(85, 20343, 0, 'baby_n_beer.jpg', 18360, 480, 320),
(86, 35880, 0, 'girl_bike.jpg', 18361, 500, 337),
(87, 34508, 0, 'neros.jpg', 18365, 464, 380),
(88, 62609, 0, 'wackyplanetshop_1840_80664117.jpg', 18598, 247, 260),
(89, 121, 0, 'starblue.gif', 18732, 9, 10),
(90, 22468, 0, '4313b7c5964d6be.jpg', 18882, 420, 279),
(91, 8303, 0, 'aj_tee-shirt_web.jpg', 19472, 120, 160),
(92, 17855, 0, 'kidclaw.jpg', 19667, 320, 240),
(93, 16513, 0, 'kidswing.jpg', 19669, 320, 240),
(94, 20639, 0, 'fountain2.JPG', 20201, 448, 336),
(95, 207887, 0, 'White_Kitty1.JPG', 21292, 1024, 768),
(96, 106974, 0, 'Path_to_bike_trail.jpg', 21531, 868, 682),
(97, 253558, 0, 'Gracie.jpg', 22540, 1548, 1393),
(98, 81684, 0, 'Hood_Watch.GIF', 23531, 622, 593),
(99, 46476, 0, 'PICT0674.JPG', 24205, 448, 336),
(100, 37490, 0, 'PICT0675.JPG', 24206, 448, 336);
Caused the error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ),
(81, 148330, 0, 'lowresjblj2060a.JPG', 17960, 640, 4
Alrighty,
Removed all of the older attached files and tried the converter again.
No go. Still getting the same error.
I am really suck at this point. Would really appreciate any help.
Quote
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Unsuccessful!
This query:
INSERT INTO `smf_db`.yabb_convert6_attachments
(ID_ATTACH, size, downloads, filename, ID_MSG, width, height)
VALUES
(1, 80278, 0, 'Chihuhua_In_Costume.JPG', 30175, 336, 404),
(2, 21780, 0, 'ATT030042.jpg', 30200, 600, 450),
(3, 21870, 0, 'ATT03005.jpg', 30201, 600, 450),
(4, 23475, 0, 'ATT030072.jpg', 30202, 600, 450),
(5, 21216, 0, 'ATT03006.jpg', 30203, 600, 450),
(6, 21399, 0, 'ATT03010.jpg', 30204, 600, 450),
(7, 20445, 0, 'ATT03011.jpg', 30205, 600, 450),
(8, 20408, 0, 'ATT03012.jpg', 30206, 600, 450),
(9, 30637, 0, 'coffeecupchi.jpg', 30210, 343, 236),
(10, 18475, 0, 'redneck_hottub.jpg', 30277, 400, 296),
(11, 82264, 0, 'navy1.jpg', 30336, 800, 600),
(12, 126530, 0, 'timbeer.jpg', 30364, 782, 519),
(13, 39085, 0, 'boobs.jpg', 30365, 350, 336),
(14, 77198, 0, 'wedding.jpg', 30371, 796, 540),
(15, 8928, 0, 'sslnet_policy.rtf', 30415, , ),
(16, 29228, 0, 'pumpkin.jpg', 30508, 278, 469),
(17, 355861, 0, 'cell2.jpg', 30916, 736, 599),
(18, 90767, 0, 'car1.jpg', 30958, 892, 602),
(19, 81039, 0, 'car2.jpg', 30959, 894, 602),
(20, 32884, 0, 'moose1.jpg', 30960, 547, 378),
(21, 37010, 0, 'moose2.jpg', 30961, 550, 370),
(22, 20046, 0, 'anna_kournikova_37.jpg', 30990, 385, 575),
(23, 19981, 0, 'perfectwoman.jpg', 31051, 245, 330),
(24, 126023, 0, 'LUCKYSTRIKESOX.jpg', 31231, 400, 500),
(25, 48341, 0, 'BestHalloweenCostumeEver.jpg', 31241, 450, 335),
(26, 4268, 0, 'thigh.gif', 31246, 90, 90),
(27, 18697, 0, 'calf.gif', 31248, 190, 166),
(28, 16617, 0, 'Spiderman.jpg', 31433, 400, 300),
(29, 48152, 0, 'baseballpunch.jpg', 31478, 400, 450),
(30, 39806, 0, 'kids.jpg', 31535, 450, 600),
(31, 39365, 0, 'Wrigley.JPG', 31794, 640, 480),
(32, 123067, 0, 'jphoneymoon.JPG', 31803, 640, 479),
(33, 36691, 0, 'PICT0761.JPG', 32058, 336, 448),
(34, 113426, 0, 'DSCN0262.jpg', 32064, 640, 478),
(35, 100830, 0, 'DSCN0261.jpg', 32065, 528, 480),
(36, 66922, 0, 'DSCN0263.jpg', 32066, 640, 241),
(37, 132685, 0, 'DSCN0264.jpg', 32067, 386, 640),
(38, 120729, 0, 'DSCN0265.jpg', 32068, 397, 640),
(39, 101236, 0, 'DSCN0267.jpg', 32069, 640, 478),
(40, 124921, 0, 'DSCN0270.jpg', 32070, 480, 618),
(41, 1375, 0, 'patrocks.gif', 32102, 70, 46),
(42, 363316, 0, 'dogs_001.jpg', 32407, 804, 475),
(43, 49173, 0, 'BaseballsRevenge.jpg', 32419, 340, 455),
(44, 59491, 0, 'untitled.JPG', 32537, 550, 520),
(45, 1834, 0, 'cherrygraphic.gif', 32899, 105, 85),
(46, 4387, 0, 'Hopefully_My_guys_-_Nemo_and_Spike.JPG', 32905, 160, 114),
(47, 4392, 0, 'Penny_and_Nemo_from_above_001.JPG', 32906, 160, 90),
(48, 29534, 0, 'gold_gym.jpg', 32928, 360, 481),
(49, 118548, 0, 'Kittens.JPG', 32969, 640, 480),
(50, 63488, 0, 'mushroom.jpg', 33237, 480, 711),
(51, 720698, 0, 'IMG_1725.jpg', 33433, 1600, 1200),
(52, 26439, 0, 'baby_guiness.JPG', 33442, 219, 469),
(53, 61642, 0, 'JL.jpg', 33705, 227, 344),
(54, 46394, 0, 'fav-rey3.jpg', 33862, 454, 512),
(55, 38469, 0, 'fav-rey2.jpg', 33863, 500, 425),
(56, 101031, 0, 'Pandora_and_Salem.jpg', 33951, 1410, 984),
(57, 5131, 0, 'Lizzy.jpg', 33955, 100, 100),
(58, 11329, 0, 'car1_001.jpg', 33967, 800, 600),
(59, 22705, 0, 'car2_001.jpg', 33969, 800, 600),
(60, 24626, 0, 'car3.jpg', 33970, 800, 600),
(61, 20533, 0, 'car4.jpg', 33971, 800, 600),
(62, 6081, 0, 'Lizzy2.jpg', 34283, 160, 120),
(63, 635139, 0, 'Doggies1.jpg', 34503, 800, 531),
(64, 676916, 0, 'doggies2.jpg', 34504, 800, 531),
(65, 17742, 0, 'no_poop_zone.jpg', 34590, 165, 174),
(66, 19958, 0, 'pick_up_city.jpg', 34591, 165, 175),
(67, 16972, 0, '23_11_56.gif', 34740, 83, 83),
(68, 7634, 0, 'begging.gif', 34795, 227, 315),
(69, 17128, 0, 'Tide.jpg', 34848, 748, 451),
(70, 95898, 0, 'whitesoxfans05.jpg', 35036, 760, 451),
(71, 88022, 0, 'doorball.jpg', 35058, 480, 480),
(72, 38825, 0, 'Luke_and_Gypsi.jpg', 35303, 448, 336),
(73, 47475, 0, 'Luke.jpg', 35305, 448, 336),
(74, 30155, 0, 'Gypsi.jpg', 35306, 448, 336),
(75, 561595, 0, 'lawn.jpg', 35328, 800, 531),
(76, 97199, 0, 'Misc_August_05_009.jpg', 35516, 640, 480),
(77, 13027, 0, 'morningside.jpg', 36242, 300, 200),
(78, 37729, 0, 'Copy_of_Found_Cat_002.jpg', 36880, 448, 336),
(79, 41258, 0, 'Found_Cat_001.jpg', 36881, 448, 336),
(80, 37729, 0, 'Copy_of_Found_Cat_002_001.jpg', 36882, 448, 336),
(81, 37729, 0, 'Copy_of_Found_Cat_002_002.jpg', 36883, 448, 336),
(82, 144421, 0, 'Sargent.jpg', 37050, 1024, 682),
(83, 30239, 0, 'TheUg.JPG', 37660, 350, 458),
(84, 13730, 0, 'BigUgly2.JPG', 37661, 459, 195),
(85, 23150, 0, 'BigUgly.JPG', 37662, 351, 460),
(86, 26480, 0, 'Lucy.jpg', 37847, 600, 438),
(87, 81343, 0, 'yuckboob.JPG', 38033, 512, 384),
(88, 81974, 0, 'Nala_056.jpg', 38501, 720, 576),
(89, 62909, 0, 'Nala_047.jpg', 38509, 512, 384),
(90, 327109, 0, 'Mia-bella_018_2.jpg', 38918, 1736, 1096),
(91, 321567, 0, 'Galaxy_2006.JPG', 38971, 700, 525),
(92, 16354, 0, 'PICT0406_001.JPG', 38991, 448, 336),
(93, 38701, 0, 'PICT0306.JPG', 38992, 448, 336),
(94, 45694, 0, 'frustation.jpg', 39271, 236, 359),
(95, 74386, 0, '23524987.jpg', 39274, 467, 425),
(96, 261532, 0, 'ajmb.gif', 39278, 600, 675),
(97, 14826, 0, 'Image2.jpg', 39295, 211, 301),
(98, 334152, 0, 'Cubs_Sox_Fans_posters_outside.pdf', 39389, , ),
(99, 112878, 0, 'Cubs_Sox_Reasons1.pdf', 39390, , ),
(100, 162749, 0, 'Baby_pics_011-_revised.JPG', 39409, 1536, 1152);
Caused the error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ),
(16, 29228, 0, 'pumpkin.jpg', 30508, 278, 469),
Post the yabb21_to_smf.php file that you are using.
I keep getting this error (as well as many others that fixed on retry):
Quote
Notice: Undefined offset: 0 in /home/username/public_html/forum/yabb21_to_smf.php on line 2004
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/username/public_html/forum/yabb21_to_smf.php on line 2004
Warning: implode() [function.implode]: Bad arguments. in /home/username/public_html/forum/yabb21_to_smf.php on line 2004
Unsuccessful!
This query:
INSERT INTO `username_forum`.smf_members
()
VALUES ('ocsiocsi', '1f3a8471c55ef8be99c8791760e0dab3', 'ocsiocsi', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1155765367', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('octo', '45e0403fb8d2f101becbf74ed2e0b1bc', 'octo', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1183372873', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('Octonion2006', 'c98b95b25dccb3fef744c09e0823103a', 'Octonion2006', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1158877791', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('octopus', 'b75dee1da738312269123f1bd4f25e7d', 'octopus', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1184962343', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('octopus8888', 'b75dee1da738312269123f1bd4f25e7d', 'octopus8888', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '0', '1154255856', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('octopus99', 'ec9d404b58f168eea20a797b288b9f61', 'octopus99', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1160303106', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('(removed email)', 'adf4661fe6715ed47954193e68b63036', '(removed email)', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '0', '1175834593', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('oddblob', 'f35a6a19be69e913c41f584fbac16e30', 'oddblob', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '0', '1176019310', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('odddna', '0eda241fc65ccf35d9743309ac395215', 'odddna', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '0', '1151587876', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('oddi', 'd68e84140e6956552ce2dd8edc2dd627', 'oddi', '(removed email)', '', '', '', '0', '0', '', '', '', '', '1', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1182116829', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('oddjohn', '2469c12ad712ef35e0792dd239e318f4', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1182895075', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('oden666', 'd9420f48073079d2c8b693cdc8d35260', 'oden666', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1179218933', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('odenson', 'e0557497c0f1427589d9a08fe5f22be6', 'odenson', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1154999274', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('odgirl', 'd25922edb7ab92c0ca31328cbdcbd42f', 'odgirl', '(removed email)', '', '', '', '0', '0', '', '', '', '', '', 'I Love YaBB!', 'blank.gif', '', '', '', '1', '1163650098', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
Caused the error:
Column count doesn't match value count at row 1
Well, I cant seem to attach a file...do I have to have a certain number of posts?
Not sure if this is a good idea but...here is a copy paste of the file contents. :-[
<?php
/**********************************************************************************
* yabb21_to_smf.php *
***********************************************************************************
* SMF: Simple Machines Forum *
* Open-Source Project Inspired by Zef Hemel ([email protected]) *
* =============================================================================== *
* Software Version: SMF 1.1 *
* Software by: Simple Machines (http://www.simplemachines.org) *
* Copyright 2006 by: Simple Machines LLC (http://www.simplemachines.org) *
* 2001-2006 by: Lewis Media (http://www.lewismedia.com) *
* Support, News, Updates at: http://www.simplemachines.org *
***********************************************************************************
* This program is free software; you may redistribute it and/or modify it under *
* the terms of the provided license as published by Simple Machines LLC. *
* *
* This program is distributed in the hope that it is and will be useful, but *
* WITHOUT ANY WARRANTIES; without even any implied warranty of MERCHANTABILITY *
* or FITNESS FOR A PARTICULAR PURPOSE. *
* *
* See the "license.txt" file for details of the Simple Machines license. *
* The latest version can always be found at http://www.simplemachines.org. *
**********************************************************************************/
$convert_data = array(
'name' => 'YaBB 2.1',
'version' => 'SMF 1.1',
'flatfile' => true,
'settings' => array('/Paths.pl', '/Variables/Paths.pl'),
'parameters' => array(
array(
'id' => 'db_purge',
'type' => 'checked',
'label' => 'Clear current SMF posts and members during conversion.',
),
),
);
if (!function_exists('convert_query'))
{
if (file_exists(dirname(__FILE__) . '/convert.php'))
header('Location: http://' . (empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST']) . (strtr(dirname($_SERVER['PHP_SELF']), '\\', '/') == '/' ? '' : strtr(dirname($_SERVER['PHP_SELF']), '\\', '/')) . '/convert.php?convert_script=' . basename(__FILE__));
else
{
echo '<html>
<head>
<title>Unable to continue!</title>
</head>
<body>
<h1>Sorry, this file can\'t work alone</h1>
<p>Please download convert.php from <a href="http://www.simplemachines.org/">www.simplemachines.org</a> and use it. This file should be in the same directory as it.</p>
</body>
</html>';
}
exit;
}
if (empty($preparsing))
{
// Memory, please!!
@ini_set('memory_limit', '128M');
function load_converter_settings()
{
global $yabb;
if (isset($_SESSION['convert_parameters']['db_purge']))
$_SESSION['purge'] = !empty($_SESSION['convert_parameters']['db_purge']);
if (!isset($_POST['path_from']) || (!file_exists($_POST['path_from'] . '/Paths.pl') && !file_exists($_POST['path_from'] . '/Variables/Paths.pl')))
return;
if (file_exists($_POST['path_from'] . '/Paths.pl'))
$data = file($_POST['path_from'] . '/Paths.pl');
else
$data = file($_POST['path_from'] . '/Variables/Paths.pl');
foreach ($data as $line)
{
$line = trim($line);
if (empty($line) || substr($line, 0, 1) == '#')
continue;
if (preg_match('~\$([^ =]+?)\s*=\s*[q]?([\^"\']?)(.+?)\\2;~', $line, $match) != 0)
$yabb[$match[1]] = $match[2] == '^' ? addslashes($match[3]) : $match[3];
}
$paths = array('boarddir', 'boardsdir', 'datadir', 'memberdir', 'sourcedir', 'vardir', 'facesdir', 'uploaddir');
foreach ($paths as $path)
$yabb[$path] = fixRelativePath($yabb[$path], $_POST['path_from']);
// In some cases $boarddir is not parsed causing the paths to be incorrect.
foreach ($paths as $path)
if (substr($yabb[$path], 0, 9) == '$boarddir')
$yabb[$path] = str_replace('$boarddir', $yabb['boarddir'], $yabb[$path]);
$data = file($yabb['vardir'] . '/Settings.pl');
foreach ($data as $line)
{
$line = trim($line);
if (empty($line) || substr($line, 0, 1) == '#')
continue;
if (preg_match('~\$([^ =]+?)\s*=\s*[q]?([\^"\']?)(.+?)\\2;~', $line, $match) != 0)
$yabb[$match[1]] = $match[2] == '^' ? addslashes($match[3]) : $match[3];
}
}
function convertStep1()
{
global $to_prefix, $yabb;
echo 'Converting membergroups...';
$knownGroups = array();
$extraGroups = array();
$newbie = false;
$groups = file($yabb['vardir'] . '/membergroups.txt');
foreach ($groups as $i => $group)
{
if (preg_match('~^\$Group\{\'(Administrator|Global Moderator|Moderator)\'\} = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)
{
$match = addslashes_recursive($match);
$ID_GROUP = $match[1] == 'Administrator' ? 1 : ($match[1] == 'Global Moderator' ? 2 : 3);
$knownGroups[] = "$ID_GROUP, SUBSTRING('$match[2]', 1, 80), SUBSTRING('$match[5]', 1, 20), '-1', SUBSTRING('$match[3]#$match[4]', 1, 255)";
}
elseif (preg_match('~\$Post\{\'(\d+)\'\} = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)
{
$match = addslashes_recursive($match);
$extraGroups[] = "SUBSTRING('$match[2]', 1, 80), SUBSTRING('$match[5]', 1, 20), " . max(0, $match[3]) . ", SUBSTRING('$match[3]#$match[4]', 1, 255)";
if ($match[3] < 1)
$newbie = true;
}
elseif (preg_match('~\$NoPost\[(\d+)\] = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)
{
$match = addslashes_recursive($match);
$extraGroups[] = "SUBSTRING('$match[2]', 1, 80), SUBSTRING('$match[5]', 1, 20), 0, SUBSTRING('$match[3]#$match[4]', 1, 255)";
}
}
if (!empty($_SESSION['purge']))
{
convert_query("
DELETE FROM {$to_prefix}permissions
WHERE ID_GROUP > " . ($newbie ? 3 : 4));
convert_query("
DELETE FROM {$to_prefix}membergroups
WHERE ID_GROUP > " . ($newbie ? 3 : 4));
}
if (!empty($knownGroups))
{
convert_query("
REPLACE INTO {$to_prefix}membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (" . implode("),
(", $knownGroups) . ")");
}
if (!empty($extraGroups))
{
convert_query("
REPLACE INTO {$to_prefix}membergroups
(groupName, onlineColor, minPosts, stars)
VALUES (" . implode("),
(", $extraGroups) . ")");
}
}
function convertStep2()
{
global $to_prefix, $yabb;
echo 'Converting members...';
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}members");
}
if ($_GET['substep'] == 0)
{
// Get rid of the primary key... we have to resort anyway.
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
);
$alterColumns = array(
'ID_MEMBER' => 'CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0',
);
alterTable('members', $knownKeys, '', $alterColumns);
}
pastTime(0);
$request = convert_query("
SELECT ID_GROUP, groupName
FROM {$to_prefix}membergroups
WHERE ID_GROUP != 3");
$groups = array('Administrator' => 1, 'Global Moderator' => 2, 'Moderator' => 0);
while ($row = mysql_fetch_assoc($request))
$groups[$row['groupName']] = $row['ID_GROUP'];
mysql_free_result($request);
$file_n = 0;
$dir = dir($yabb['memberdir']);
$block = array();
$text_columns = array(
'memberName' => 80,
'lngfile' => 255,
'realName' => 255,
'buddy_list' => 255,
'pm_ignore_list' => 255,
'messageLabels' => 65534,
'passwd' => 64,
'emailAddress' => 255,
'personalText' => 255,
'websiteTitle' => 255,
'websiteUrl' => 255,
'location' => 255,
'ICQ' => 255,
'AIM' => 16,
'YIM' => 32,
'MSN' => 255,
'timeFormat' => 80,
'signature' => 255,
'avatar' => 255,
'usertitle' => 255,
'memberIP' => 255,
'memberIP2' => 255,
'secretQuestion' => 255,
'secretAnswer' => 64,
'validation_code' => 10,
'additionalGroups' => 255,
'smileySet' => 48,
'passwordSalt' => 5,
);
while ($entry = $dir->read())
{
if ($_GET['substep'] < 0)
break;
if ($file_n++ < $_GET['substep'])
continue;
if (strrchr($entry, '.') != '.vars' && strrchr($entry, '.') != '.dat')
continue;
$name = substr($entry, 0, strrpos($entry, '.'));
$userData = file($yabb['memberdir'] . '/' . $entry);
if (count($userData) < 3)
continue;
$data = array();
foreach ($userData as $i => $v)
{
$userData[$i] = trim($userData[$i]);
if (strrchr($entry, '.') == '.vars' && preg_match('~^\'([^\']+)\',"([^"]+)"~', $userData[$i], $match) != 0)
$data[$match[1]] = $match[2];
}
// Is it an invalid user?
if (empty($data))
continue;
if (strrchr($entry, '.') != '.vars')
{
$userData = array_pad($userData, 31, '');
$data = array(
'password' => $userData[0],
'realname' => $userData[1],
'email' => $userData[2],
'webtitle' => $userData[3],
'weburl' => $userData[4],
'signature' => $userData[5],
'postcount' => $userData[6],
'position' => $userData[7],
'icq' => $userData[8],
'aim' => $userData[9],
'yim' => $userData[10],
'gender' => $userData[11],
'usertext' => $userData[12],
'userpic' => $userData[13],
'regdate' => $userData[14],
'location' => $userData[15],
'bday' => $userData[16],
'hidemail' => $userData[19],
'msn' => $userData[20],
'lastonline' => $userData[23],
'im_ignorelist' => $userData[26],
'im_notify' => $userData[27],
// !!! 'cathide' => $userData[30],
// !!! 'postlayout' => $userData[31],
);
}
$row = array(
'memberName' => substr(htmlspecialchars(trim($name)), 0, 80),
'passwd' => strlen($data['password']) == 22 ? bin2hex(base64_decode($data['password'])) : md5($data['password']),
'realName' => htmlspecialchars($data['realname']),
'emailAddress' => htmlspecialchars($data['email']),
'websiteTitle' => isset($data['website']) ? htmlspecialchars($data['webtitle']) : '',
'websiteUrl' => isset($data['weburl']) ? htmlspecialchars($data['weburl']) : '',
'signature' => isset($data['signature']) ? str_replace(array('&&', '&lt;', '&gt;'), array('<br />', '<'. '>'), strtr($data['signature'], array('\'' => '&#039;'))) : '',
'posts' => (int) $data['postcount'],
'ID_GROUP' => isset($data['position']) && isset($groups[$data['position']]) ? $groups[$data['position']] : 0,
'ICQ' => isset($data['icq']) ? htmlspecialchars($data['icq']) : '',
'AIM' => isset($data['aim']) ? substr(htmlspecialchars($data['aim']), 0, 16) : '',
'YIM' => isset($data['yim']) ? substr(htmlspecialchars($data['yim']), 0, 32) : '',
'MSN' => isset($data['msn']) ? htmlspecialchars($data['msn']) : '',
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
'personalText' => isset($data['usertext']) ? htmlspecialchars($data['usertext']) : '',
'avatar' => $data['userpic'],
'dateRegistered' => parse_time($data['regdate']),
'location' => isset($data['location']) ? htmlspecialchars($data['location']) : '',
'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '',
'hideEmail' => isset($data['hidemail']) && $data['hidemail'] == 'checked' ? '1' : '0',
'lastLogin' => isset($data['lastonline']) ? $data['lastonline'] : '',
'pm_email_notify' => empty($data['im_notify']) || trim($data['im_notify']) == '' ? '0' : '1',
'karmaGood' => 0,
'karmaBad' => 0,
);
// Make sure these columns have a value and don't exceed max width.
foreach ($text_columns as $text_column => $max_size)
$row[$text_column] = isset($row[$text_column]) ? substr($row[$text_column], 0, $max_size) : '';
if ($row['birthdate'] == '0001-01-01' && parse_time($data['bday'], false) != 0)
$row['birthdate'] = strftime('%Y-%m-%d', parse_time($data['bday'], false));
if (file_exists($yabb['memberdir'] . '/' . substr($entry, 0, -4) . '.karma'))
{
$karma = (int) implode('', file($yabb['memberdir'] . '/' . substr($entry, 0, -4) . '.karma'));
$row['karmaGood'] = $karma > 0 ? $karma : 0;
$row['karmaBad'] = $karma < 0 ? -$karma : 0;
}
$block[] = addslashes_recursive($row);
if (count($block) > 100)
{
doBlock('members', $block);
pastTime($file_n);
}
}
$dir->close();
doBlock('members', $block);
pastTime(-1);
// Part 2: Now we get to resort the members table!
if ($_GET['substep'] >= -1)
{
convert_query("
ALTER TABLE {$to_prefix}members
ORDER BY ID_MEMBER = 0, dateRegistered");
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_MEMBER)',
);
$alterColumns = array(
'ID_MEMBER' => 'CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL auto_increment',
);
alterTable('members', $knownKeys, '', $alterColumns, true);
pastTime(-3);
}
if ($_GET['substep'] >= -3)
{
convert_query("
ALTER TABLE {$to_prefix}members
ORDER BY ID_MEMBER");
}
}
function convertStep3()
{
global $to_prefix, $yabb;
echo 'Converting settings...';
$temp = file($yabb['vardir'] . '/reservecfg.txt');
$settings = array(
'allow_guestAccess' => isset($yabb['guestaccess']) ? (int) $yabb['guestaccess'] : 0,
'news' => addslashes(strtr(implode('', file($yabb['vardir'] . '/news.txt')), array("\r" => ''))),
'cookieTime' => !empty($yabb['Cookie_Length']) && $yabb['Cookie_Length'] > 1 ? (int) $yabb['Cookie_Length'] : 60,
'requireAgreement' => !empty($yabb['RegAgree']) ? 1 : 0,
'registration_method' => !empty($yabb['emailpassword']) ? 1 : 0,
'send_validation_onChange' => !empty($yabb['emailnewpass']) ? 1 : 0,
'send_welcomeEmail' => !empty($yabb['emailwelcome']) ? 1 : 0,
'mail_type' => empty($yabb['mailtype']) ? 0 : 1,
'smtp_host' => isset($yabb['smtp_server']) ? $yabb['smtp_server'] : '',
'smtp_username' => !empty($yabb['smtp_auth_required']) && isset($yabb['authuser']) ? $yabb['authuser'] : '',
'smtp_password' => !empty($yabb['smtp_auth_required']) && isset($yabb['authpass']) ? $yabb['authpass'] : '',
'defaultMaxTopics' => !empty($yabb['maxdisplay']) ? (int) $yabb['maxdisplay'] : 20,
'defaultMaxMessages' => !empty($yabb['maxmessagedisplay']) ? (int) $yabb['maxmessagedisplay'] : 15,
'max_messageLength' => !empty($yabb['MaxMessLen']) ? (int) $yabb['MaxMessLen'] : 10000,
'max_signatureLength' => (int) $yabb['MaxSigLen'],
'spamWaitTime' => (int) $yabb['timeout'],
'hotTopicPosts' => isset($yabb['HotTopic']) ? (int) $yabb['HotTopic'] : 15,
'hotTopicVeryPosts' => isset($yabb['VeryHotTopic']) ? (int) $yabb['VeryHotTopic'] : 25,
'avatar_max_width_external' => (int) $yabb['userpic_width'],
'avatar_max_height_external' => (int) $yabb['userpic_height'],
'avatar_max_width_upload' => (int) $yabb['userpic_width'],
'avatar_max_height_upload' => (int) $yabb['userpic_height'],
'reserveWord' => trim($temp[0]) == 'checked' ? '1' : '0',
'reserveCase' => trim($temp[1]) == 'checked' ? '1' : '0',
'reserveUser' => trim($temp[2]) == 'checked' ? '1' : '0',
'reserveName' => trim($temp[3]) == 'checked' ? '1' : '0',
'reserveNames' => addslashes(strtr(implode('', file($yabb['vardir'] . '/reserve.txt')), array("\r" => ''))),
);
$setString = '';
foreach ($settings as $var => $val)
$setString .= "
('$var', SUBSTRING('$val', 1, 65534)),";
convert_query("
REPLACE INTO {$to_prefix}settings
(variable, value)
VALUES" . substr($setString, 0, -1));
}
function convertStep4()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}personal_messages");
convert_query("
TRUNCATE {$to_prefix}pm_recipients");
}
if ($_GET['substep'] == 0)
{
// Set the keys and columns to alter.
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
);
$knownColumns = array(
'temp_toName' => 'ADD COLUMN temp_toName tinytext',
);
$alterColumns = array(
'ID_PM' => 'CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0',
);
alterTable('personal_messages', $knownKeys, $knownColumns, $alterColumns);
}
echo 'Converting personal messages...';
$names = array();
$file_n = 0;
$dir = dir($yabb['memberdir']);
$block = array();
while ($entry = $dir->read())
{
if ($_GET['substep'] < 0)
break;
if ($file_n++ < $_GET['substep'])
continue;
if (strrchr($entry, '.') != '.msg')
continue;
$userData = file($yabb['memberdir'] . '/' . $entry);
foreach ($userData as $i => $v)
{
$userData[$i] = explode('|', rtrim($userData[$i]));
if (count($userData[$i]) <= 2 || empty($userData[$i]))
continue;
if (substr($userData[$i][3], -10) == '#nosmileys')
$userData[$i][3] = substr($userData[$i][3], 0, -10);
$row = array(
'fromName' => substr(htmlspecialchars($userData[$i][0]), 0, 255),
'subject' => substr($userData[$i][1], 0, 255),
'msgtime' => $userData[$i][2],
'body' => substr($userData[$i][3], 0, 65534),
'ID_MEMBER_FROM' => 0,
'deletedBySender' => 1,
'temp_toName' => htmlspecialchars(substr($entry, 0, -4)),
);
$names[strtolower(addslashes($row['fromName']))][] = &$row['ID_MEMBER_FROM'];
$block[] = addslashes_recursive($row);
}
if (count($block) > 100)
{
$result = convert_query("
SELECT ID_MEMBER, memberName
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("', '", array_keys($names)) . "')
LIMIT " . count($names));
while ($row = mysql_fetch_assoc($result))
foreach ($names[strtolower(addslashes($row['memberName']))] as $k => $v)
$names[strtolower(addslashes($row['memberName']))][$k] = $row['ID_MEMBER'];
mysql_free_result($result);
$names = array();
doBlock('personal_messages', $block);
pastTime($file_n);
}
}
$dir->close();
if (!empty($block))
{
$result = convert_query("
SELECT ID_MEMBER, memberName
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("', '", array_keys($names)) . "')
LIMIT " . count($names));
while ($row = mysql_fetch_assoc($result))
{
foreach ($names[strtolower(addslashes($row['memberName']))] as $k => $v)
$names[strtolower(addslashes($row['memberName']))][$k] = $row['ID_MEMBER'];
}
mysql_free_result($result);
$names = array();
doBlock('personal_messages', $block);
}
pastTime(-1);
// Part 2: Now we get to resort the personal messages table!
if ($_GET['substep'] >= -1)
{
convert_query("
ALTER TABLE {$to_prefix}personal_messages
ORDER BY ID_PM = 0, msgtime");
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_PM)',
);
$alterColumns = array(
'ID_PM' => 'CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment',
);
alterTable('personal_messages', $knownKeys, '', $alterColumns, true);
pastTime(-3);
}
if ($_GET['substep'] >= -3)
{
convert_query("
INSERT IGNORE INTO {$to_prefix}pm_recipients
(ID_PM, ID_MEMBER, labels, is_read)
SELECT pm.ID_PM, mem.ID_MEMBER, -1 AS labels, 1 AS is_read
FROM ({$to_prefix}personal_messages AS pm, {$to_prefix}members AS mem)
WHERE mem.memberName = pm.temp_toName
AND pm.temp_toName != ''");
pastTime(-4);
}
if ($_GET['substep'] >= -4)
{
$knownColumns = array(
'temp_toName' => 'DROP temp_toName',
);
alterTable('personal_messages', '', $knownColumns, false, true);
pastTime(-5);
}
if ($_GET['substep'] >= -5)
{
convert_query("
ALTER TABLE {$to_prefix}personal_messages
ORDER BY ID_PM");
}
}
function convertStep5()
{
global $to_prefix, $yabb;
echo 'Converting boards and categories...';
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}categories");
convert_query("
TRUNCATE {$to_prefix}boards");
convert_query("
TRUNCATE {$to_prefix}moderators");
}
if ($_GET['substep'] == 0)
{
// Handle the categories table and columns
$knownColumns = array(
'tempID' => 'ADD COLUMN tempID tinytext',
);
alterTable('categories', '', $knownColumns);
// Use the $knownColumns frm before and add tempCatID then alter boards table.
$knownColumns += array(
'tempCatID' => 'ADD COLUMN tempCatID tinytext',
);
alterTable('boards', '', $knownColumns);
// Drop the primary key for moderators
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
);
alterTable('moderators', $knownKeys);
}
$request = convert_query("
SELECT ID_GROUP, groupName
FROM {$to_prefix}membergroups
WHERE ID_GROUP != 3");
$groups = array('Administrator' => 1, 'Global Moderator' => 2, 'Moderator' => 0);
while ($row = mysql_fetch_assoc($request))
$groups[$row['groupName']] = $row['ID_GROUP'];
mysql_free_result($request);
$cat_data = file($yabb['boardsdir'] . '/forum.master');
$cat_order = array();
$cats = array();
$boards = array();
foreach ($cat_data as $line)
{
if (preg_match('~^\$board\{\'(.+?)\'\} = ([^|]+)~', $line, $match) != 0)
$boards[$match[1]] = trim($match[2], '"');
elseif (preg_match('~^\$catinfo\{\'(.+?)\'\} = ([^|]+?)\|([^|]*?)\|([^|]+?);~', $line, $match) != 0)
{
$match[3] = explode(',', $match[3]);
if (trim($match[3][0]) == '')
$cat_groups = array_merge($groups, array(2, 0, -1));
else
{
$cat_groups = array(2);
foreach ($match[3] as $group)
{
if (isset($groups[trim($group)]))
$cat_groups[] = $groups[trim($group)];
}
}
// Make the tempCatID lowercase
$match[1] = strtolower(trim($match[1]));
$cats[$match[1]]['name'] = trim($match[2], '"');
$cats[$match[1]]['groups'] = implode(',', $cat_groups);
$cats[$match[1]]['canCollapse'] = !empty($match[4]);
}
elseif (preg_match('~^@categoryorder = qw\((.+?)\);~', $line, $match) != 0)
$cat_order = array_flip(explode(' ', ' ', strtolower(trim($match[1]))));
}
$cat_rows = array();
foreach ($cats as $tempID => $cat)
{
$tempID = strtolower(trim($tempID));
$row = array(
'name' => str_replace(array('qq~', 'qw~'), '', substr($cat['name'], 0, 255)),
'catOrder' => @$cat_order[$tempID],
'tempID' => $tempID,
);
$cat_rows[] = addslashes_recursive($row);
}
doBlock('categories', $cat_rows);
$board_data = file($yabb['boardsdir'] . '/forum.control');
$boardOrder = 1;
$moderators = array();
$board_rows = array();
foreach ($board_data as $line)
{
list ($tempCatID, $tempID, , $description, $mods, , , , , $doCountPosts, , , $is_recycle) = explode('|', rtrim($line));
// !!! is_recycle -> set recycle board?
// Set lower case since case matters in PHP
$tempCatID = strtolower(trim($tempCatID));
$row = array(
'name' => str_replace(array('qq~', 'qw~'), '', substr($boards[$tempID], 0, 255)),
'description' => substr($description, 0, 255),
'countPosts' => empty($doCountPosts),
'boardOrder' => $boardOrder++,
'memberGroups' => $cats[$tempCatID]['groups'],
'tempID' => $tempID,
'tempCatID' => $tempCatID,
);
$board_rows[] = addslashes_recursive($row);
$moderators[$tempID] = preg_split('~(, | |,)~', $mods);
}
doBlock('boards', $board_rows);
$result = convert_query("
SELECT ID_CAT, tempID
FROM {$to_prefix}categories
WHERE tempID != ''");
while ($row = mysql_fetch_assoc($result))
{
convert_query("
UPDATE {$to_prefix}boards
SET ID_CAT = $row[ID_CAT]
WHERE tempCatID = '$row[tempID]'");
}
mysql_free_result($result);
foreach ($moderators as $boardid => $names)
{
$result = convert_query("
SELECT ID_BOARD
FROM {$to_prefix}boards
WHERE tempID = '$boardid'
LIMIT 1");
list ($ID_BOARD) = mysql_fetch_row($result);
mysql_free_result($result);
convert_query("
INSERT INTO {$to_prefix}moderators
(ID_BOARD, ID_MEMBER)
SELECT $ID_BOARD, ID_MEMBER
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("', '", addslashes_recursive($names)) . "')
LIMIT " . count($names));
}
pastTime(-1);
if ($_GET['substep'] >= -1)
{
$knownColumns = array(
'tempID' => 'DROP COLUMN tempID',
);
alterTable('categories', '', $knownColumns, '', false, true);
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
$knownColumns = array(
'tempCatID' => 'DROP COLUMN tempCatID',
);
alterTable('boards', '', $knownColumns, '', false, true);
pastTime(-3);
}
if ($_GET['substep'] >= -3)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_BOARD, ID_MEMBER)',
);
alterTable('moderators', $knownKeys, '', '', true);
}
}
function convertStep6()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}log_boards");
convert_query("
TRUNCATE {$to_prefix}log_mark_read");
convert_query("
TRUNCATE {$to_prefix}log_topics");
}
if ($_GET['substep'] == 0)
{
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
);
$knownColumns = array(
'tempID' => 'ADD COLUMN tempID int(10) unsigned NOT NULL default 0',
);
alterTable('log_topics', $knownKeys, $knownColumns);
}
echo 'Converting mark read data...';
$result = convert_query("
SELECT ID_BOARD, tempID
FROM {$to_prefix}boards");
$boards = array();
while ($row = mysql_fetch_assoc($result))
$boards[$row['tempID']] = $row['ID_BOARD'];
mysql_free_result($result);
$file_n = 0;
$dir = dir($yabb['memberdir']);
$mark_read_block = array();
$boards_block = array();
$topics_block = array();
while ($entry = $dir->read())
{
if ($_GET['substep'] < 0)
break;
if ($file_n++ < $_GET['substep'])
continue;
if (strrchr($entry, '.') != '.log')
continue;
$result = convert_query("
SELECT ID_MEMBER
FROM {$to_prefix}members
WHERE memberName = '" . substr($entry, 0, -4) . "'
LIMIT 1");
list ($ID_MEMBER) = mysql_fetch_row($result);
mysql_free_result($result);
$logData = file($yabb['memberdir'] . '/' . $entry);
foreach ($logData as $log)
{
$parts = array_pad(explode('|', $log), 3, '');
if (trim($parts[0]) == '')
continue;
$row = array();
$row['ID_MEMBER'] = $ID_MEMBER;
if (is_numeric(trim($parts[0])) && trim($parts[0]) > 10000)
{
$row['tempID'] = trim($parts[0]);
$topics_block[] = $row;
}
else
{
if (substr(trim($parts[0]), -6) == '--mark' && isset($boards[substr(trim($parts[0]), 0, -6)]))
{
$row['ID_BOARD'] = $boards[substr(trim($parts[0]), 0, -6)];
$mark_read_block[] = $row;
}
elseif (isset($boards[trim($parts[0])]))
{
$row['ID_BOARD'] = $boards[trim($parts[0])];
$boards_block[] = $row;
}
}
}
// Because of the way steps are done, we have to flush all of these at once, or none.
if (count($mark_read_block) > 250 || count($boards_block) > 250 || count($topics_block) > 250)
{
doBlock('log_mark_read', $mark_read_block);
doBlock('log_boards', $boards_block);
doBlock('log_topics', $topics_block);
pastTime($file_n);
}
}
$dir->close();
doBlock('log_mark_read', $mark_read_block);
doBlock('log_boards', $boards_block);
doBlock('log_topics', $topics_block);
}
function convertStep7()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}topics");
}
if ($_GET['substep'] == 0)
{
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
'poll' => 'DROP INDEX poll',
'firstMessage' => 'DROP INDEX firstMessage',
'lastMessage' => 'DROP INDEX lastMessage',
);
$knownColumns = array(
'tempID' => 'ADD COLUMN tempID int(10) unsigned NOT NULL default 0'
);
$alterColumns = array(
'ID_TOPIC' => 'CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL default 0',
);
alterTable('topics', $knownKeys, $knownColumns, $alterColumns);
}
echo 'Converting topics (part 1)...';
$result = convert_query("
SELECT ID_BOARD, tempID
FROM {$to_prefix}boards
WHERE tempID != ''");
$boards = array();
while ($row = mysql_fetch_assoc($result))
$boards[$row['tempID']] = $row['ID_BOARD'];
mysql_free_result($result);
$data_n = 0;
$block = array();
foreach ($boards as $boardname => $ID_BOARD)
{
if ($_GET['substep'] < 0)
break;
if (!file_exists($yabb['boardsdir'] . '/' . $boardname . '.txt'))
continue;
$topicListing = file($yabb['boardsdir'] . '/' . $boardname . '.txt');
foreach ($topicListing as $topicData)
{
if ($data_n++ < $_GET['substep'])
continue;
$topicInfo = explode('|', rtrim($topicData));
$tempID = (int) $topicInfo[0];
if (!file_exists($yabb['datadir'] . '/' . $tempID . '.txt'))
continue;
$views = @file($yabb['datadir'] . '/' . $tempID . '.ctb');
$views = $views[2] - 1;
$block[] = array(
'tempID' => $tempID,
'ID_BOARD' => (int) $ID_BOARD,
'isSticky' => isset($topicInfo[8]) && strpos($topicInfo[8], 's') !== false ? 1 : 0,
'locked' => isset($topicInfo[8]) && strpos($topicInfo[8], 'l') !== false ? 1 : 0,
'numViews' => $views,
);
if (count($block) > 100)
{
doBlock('topics', $block);
pastTime($data_n);
}
}
}
doBlock('topics', $block);
pastTime(-1);
if ($_GET['substep'] >= -1)
{
convert_query("
UPDATE {$to_prefix}topics
SET tempID = ID_TOPIC
WHERE tempID = 0");
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
convert_query("
ALTER TABLE {$to_prefix}topics
ORDER BY ID_TOPIC = 0, tempID");
pastTime(-3);
}
if ($_GET['substep'] >= -3)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_TOPIC)',
);
$alterColumns = array(
'ID_TOPIC' => 'CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL auto_increment',
);
alterTable('topics', $knownKeys, '', $alterColumns, true);
pastTime(-4);
}
if ($_GET['substep'] >= -4)
{
convert_query("
ALTER TABLE {$to_prefix}topics
ORDER BY ID_TOPIC");
}
}
function convertStep8()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0)
{
$knownColumns = array(
'tempID' => 'DROP COLUMN tempID',
);
alterTable('boards', '', $knownColumns, '', false, true);
}
echo 'Converting topics (part 2)...';
$request = convert_query("
SELECT COUNT(*)
FROM {$to_prefix}topics
WHERE tempID != ID_TOPIC");
list ($topicCount) = mysql_fetch_row($request);
mysql_free_result($request);
while ($_GET['substep'] <= $topicCount)
{
pastTime($_GET['substep']);
$result = convert_query("
SELECT ID_TOPIC, tempID
FROM {$to_prefix}topics
WHERE tempID != ID_TOPIC
LIMIT $_GET[substep], 150");
while ($row = mysql_fetch_assoc($result))
{
convert_query("
UPDATE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]
WHERE tempID = $row[tempID]");
}
$_GET['substep'] += 150;
mysql_free_result($result);
}
pastTime(-1);
if ($_GET['substep'] >= -1)
{
convert_query("
DELETE FROM {$to_prefix}log_topics
WHERE ID_TOPIC = 0 OR ID_MEMBER = 0");
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER)',
);
$knownColumns = array(
'tempID' => 'DROP COLUMN tempID',
);
alterTable('log_topics', $knownKeys, $knownColumns, '', true, true);
}
}
function convertStep9()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}log_notify");
}
echo 'Converting notifications...';
$request = convert_query("
SELECT COUNT(*)
FROM {$to_prefix}topics
WHERE tempID != ID_TOPIC");
list ($count) = mysql_fetch_row($request);
mysql_free_result($request);
while ($_GET['substep'] < $count)
{
pastTime($_GET['substep']);
$result = convert_query("
SELECT ID_TOPIC, tempID
FROM {$to_prefix}topics
WHERE tempID != ID_TOPIC
LIMIT $_GET[substep], 150");
while ($row = mysql_fetch_assoc($result))
{
if (!file_exists($yabb['datadir'] . '/' . $row['tempID'] . '.mail'))
continue;
$list = file($yabb['datadir'] . '/' . $row['tempID'] . '.mail');
foreach ($list as $k => $v)
list ($list[$k]) = explode('|', htmlspecialchars(addslashes(rtrim($v))));
convert_query("
INSERT IGNORE INTO {$to_prefix}log_notify
(ID_TOPIC, ID_MEMBER)
SELECT $row[ID_TOPIC], ID_MEMBER
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("', '", $list) . "')
LIMIT " . count($list));
}
$_GET['substep'] += 50;
if (mysql_num_rows($result) < 50)
break;
mysql_free_result($result);
}
}
function convertStep10()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}messages");
convert_query("
TRUNCATE {$to_prefix}attachments");
}
if ($_GET['substep'] == 0)
{
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
'topic' => 'DROP INDEX topic',
'ID_BOARD' => 'DROP INDEX ID_BOARD',
'ID_TOPIC' => 'DROP INDEX ID_TOPIC',
'ID_MEMBER' => 'DROP INDEX ID_MEMBER',
);
$alterColumns = array(
'ID_MSG' => 'CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0',
);
// Do we have attachments?
if (isset($yabb['uploaddir']))
$knownColumns = array(
'temp_filename' => "ADD COLUMN temp_filename tinytext NOT NULL default ''",
);
else
$knownColumns = array();
alterTable('messages', $knownKeys, $knownColumns, $alterColumns);
}
echo 'Converting posts (part 1 - this may take some time)...';
$block = array();
while (true)
{
$result = convert_query("
SELECT ID_TOPIC, tempID, ID_BOARD
FROM {$to_prefix}topics
WHERE tempID != ID_TOPIC
LIMIT $_GET[substep], 100");
while ($topic = mysql_fetch_assoc($result))
{
$messages = file($yabb['datadir'] . '/' . $topic['tempID'] . '.txt');
if (empty($messages))
{
convert_query("
DELETE FROM {$to_prefix}topics
WHERE ID_TOPIC = $topic[ID_TOPIC]
LIMIT 1");
pastTime($_GET['substep']);
continue;
}
foreach ($messages as $message)
{
if (trim($message) == '')
continue;
$message = array_pad(explode('|', $message), 12, '');
foreach ($message as $k => $v)
$message[$k] = rtrim($v);
if (substr($message[8], -10) == '#nosmileys')
$message[8] = substr($message[8], 0, -10);
$row = array(
'ID_TOPIC' => $topic['ID_TOPIC'],
'ID_BOARD' => $topic['ID_BOARD'],
'subject' => substr($message[0], 0, 255),
'posterName' => substr(htmlspecialchars($message[4] == 'Guest' ? trim($message[1]) : trim($message[4])), 0, 255),
'posterEmail' => substr(htmlspecialchars($message[2]), 0, 255),
'posterTime' => $message[3],
'icon' => substr($message[5], 0, 16),
'posterIP' => substr($message[7], 0, 255),
'body' => substr(preg_replace('~\[quote author=.+? link=.+?\]~i', '[quote]', $message[8]), 0, 65534),
'smileysEnabled' => empty($message[9]),
'modifiedTime' => $message[10],
'modifiedName' => substr($message[11], 0, 255),
);
if (isset($yabb['uploaddir']))
{
if (isset($message[12]) && file_exists($yabb['uploaddir'] . '/' . $message[12]))
$row['temp_filename'] = $message[12];
else
$row['temp_filename'] = '';
}
$block[] = addslashes_recursive($row);
if (count($block) > 100)
doBlock('messages', $block);
}
doBlock('messages', $block);
pastTime(++$_GET['substep']);
}
if (mysql_num_rows($result) < 100)
break;
mysql_free_result($result);
}
doBlock('messages', $block);
}
function convertStep11()
{
global $to_prefix, $yabb;
if ($_GET['substep'] == 0)
{
mysql_query("
ALTER TABLE {$to_prefix}messages
ORDER BY posterTime");
}
echo 'Converting posts (part 2)...';
$request = convert_query("
SELECT @msg := IFNULL(MAX(ID_MSG), 0)
FROM {$to_prefix}messages");
mysql_free_result($request);
while (true)
{
pastTime($_GET['substep']);
mysql_query("
UPDATE {$to_prefix}messages
SET ID_MSG = (@msg := @msg + 1)
WHERE ID_MSG = 0
LIMIT 150");
$_GET['substep'] += 150;
if (mysql_affected_rows() < 150)
break;
}
pastTime(-1);
if ($_GET['substep'] >= -1)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_MSG)',
);
$alterColumns = array(
'ID_MSG' => 'CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment',
);
alterTable('messages', $knownKeys, '', $alterColumns, true);
}
}
function convertStep12()
{
global $to_prefix, $yabb;
echo 'Converting posts (part 3)...';
while (true)
{
$result = convert_query("
SELECT m.ID_MSG, mem.ID_MEMBER
FROM ({$to_prefix}messages AS m, {$to_prefix}members AS mem)
WHERE m.posterName = mem.memberName
AND m.ID_MEMBER = 0
LIMIT 250");
$numRows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result))
convert_query("
UPDATE {$to_prefix}messages
SET ID_MEMBER = $row[ID_MEMBER]
WHERE ID_MSG = $row[ID_MSG]");
mysql_free_result($result);
// We need a time out.
sleep(5);
if ($numRows < 1)
break;
else
pastTime(12);
}
}
function convertStep13()
{
global $to_prefix, $yabb;
echo 'Converting attachments (if the mod is installed)...';
if (!isset($yabb['uploaddir']))
return;
$result = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1");
list ($attachmentUploadDir) = mysql_fetch_row($result);
mysql_free_result($result);
// Danger, Will Robinson!
if ($yabb['uploaddir'] == $attachmentUploadDir)
return;
$result = convert_query("
SELECT MAX(ID_ATTACH)
FROM {$to_prefix}attachments");
list ($ID_ATTACH) = mysql_fetch_row($result);
mysql_free_result($result);
$ID_ATTACH++;
while (true)
{
pastTime($_GET['substep']);
$setString = '';
$result = convert_query("
SELECT ID_MSG, temp_filename
FROM {$to_prefix}messages
WHERE temp_filename != ''
LIMIT $_GET[substep], 100");
while ($row = mysql_fetch_assoc($result))
{
$size = filesize($yabb['uploaddir'] . '/' . $row['temp_filename']);
$filename = getAttachmentFilename($row['temp_filename'], $ID_ATTACH);
// Is this an image???
$attachmentExtension = strtolower(substr(strrchr($row['temp_filename'], '.'), 1));
if (!in_array($attachmentExtension, array('jpg', 'jpeg', 'gif', 'png')))
$attachmentExtention = '';
if (strlen($filename) <= 255 && copy($yabb['uploaddir'] . '/' . $row['temp_filename'], $attachmentUploadDir . '/' . $filename))
{
// Set the default empty values.
$width = 0;
$height = 0;
// Is an an image?
if (!empty($attachmentExtension))
list ($width, $height) = getimagesize($yabb['uploaddir'] . '/' . $row['temp_filename']);
$setString .= "
($ID_ATTACH, $size, 0, '" . addslashes($row['temp_filename']) . "', $row[ID_MSG], $width, $height),";
$ID_ATTACH++;
}
}
if ($setString != '')
convert_query("
INSERT INTO {$to_prefix}attachments
(ID_ATTACH, size, downloads, filename, ID_MSG, width, height)
VALUES" . substr($setString, 0, -1));
$_GET['substep'] += 100;
if (mysql_num_rows($result) < 100)
break;
mysql_free_result($result);
}
pastTime(-1);
if ($_GET['substep'] >= -1)
{
$knownColumns = array(
'temp_filename' => 'DROP COLUMN temp_filename'
);
alterTable('messages', '', $knownColumns, '', false, true);
}
}
function convertStep14()
{
global $to_prefix, $yabb;
echo 'Cleaning up (part 1)...';
if ($_GET['substep'] <= 0)
{
$knownKeys = array(
'topic' => 'ADD UNIQUE INDEX topic (ID_TOPIC, ID_MSG)'
);
alterTable('messages', $knownKeys, '', true);
pastTime(1);
}
if ($_GET['substep'] <= 1)
{
$knownKeys = array(
'ID_BOARD' => 'ADD UNIQUE INDEX ID_BOARD (ID_BOARD, ID_MSG)',
);
alterTable('messages', $knownKeys, '', true);
pastTime(2);
}
if ($_GET['substep'] <= 2)
{
$knownKeys = array(
'ID_TOPIC' => 'ADD KEY ID_TOPIC (ID_TOPIC)',
);
alterTable('messages', $knownKeys, '', true);
pastTime(3);
}
if ($_GET['substep'] <= 3)
{
$knownKeys = array(
'ID_MEMBER' => 'ADD UNIQUE INDEX ID_MEMBER (ID_MEMBER, ID_MSG)',
);
alterTable('messages', $knownKeys, '', true);
}
}
function convertStep15()
{
global $to_prefix, $yabb;
echo 'Cleaning up (part 2)...';
while ($_GET['substep'] >= 0)
{
pastTime($_GET['substep']);
$result = convert_query("
SELECT t.ID_TOPIC, MIN(m.ID_MSG) AS ID_FIRST_MSG, MAX(m.ID_MSG) AS ID_LAST_MSG
FROM ({$to_prefix}topics AS t, {$to_prefix}messages AS m)
WHERE m.ID_TOPIC = t.ID_TOPIC
GROUP BY t.ID_TOPIC
LIMIT $_GET[substep], 150");
while ($row = mysql_fetch_assoc($result))
{
$result2 = convert_query("
SELECT ID_MEMBER
FROM {$to_prefix}messages
WHERE ID_MSG = $row[ID_LAST_MSG]
LIMIT 1");
list ($row['ID_MEMBER_UPDATED']) = mysql_fetch_row($result2);
mysql_free_result($result2);
$result2 = convert_query("
SELECT ID_MEMBER
FROM {$to_prefix}messages
WHERE ID_MSG = $row[ID_FIRST_MSG]
LIMIT 1");
list ($row['ID_MEMBER_STARTED']) = mysql_fetch_row($result2);
mysql_free_result($result2);
convert_query("
UPDATE {$to_prefix}topics
SET ID_FIRST_MSG = '$row[ID_FIRST_MSG]', ID_LAST_MSG = '$row[ID_LAST_MSG]',
ID_MEMBER_STARTED = '$row[ID_MEMBER_STARTED]', ID_MEMBER_UPDATED = '$row[ID_MEMBER_UPDATED]'
WHERE ID_TOPIC = $row[ID_TOPIC]
LIMIT 1");
}
$_GET['substep'] += 150;
if (mysql_num_rows($result) < 150)
break;
mysql_free_result($result);
}
if ($_GET['substep'] > -1)
{
$knownKeys = array(
'lastMessage' => 'ADD UNIQUE INDEX lastMessage (ID_LAST_MSG, ID_BOARD)',
);
alterTable('topics', $knownKeys, '', true);
pastTime(-2);
}
if ($_GET['substep'] > -2)
{
$knownKeys = array(
'firstMessage' => 'ADD UNIQUE INDEX firstMessage (ID_FIRST_MSG, ID_BOARD)',
);
alterTable('topics', $knownKeys, '', true);
}
}
function convertStep16()
{
global $to_prefix, $yabb;
// If set remove the old data
if ($_GET['substep'] == 0 && !empty($_SESSION['purge']))
{
convert_query("
TRUNCATE {$to_prefix}polls");
convert_query("
TRUNCATE {$to_prefix}poll_choices");
convert_query("
TRUNCATE {$to_prefix}log_polls");
}
// Drop the indexes to prevent Dup keys errors
if ($_GET['substep'] == 0)
{
$knownKeys = array(
'PRIMARY' => 'DROP PRIMARY KEY',
);
$knownColumns = array(
'tempID' => 'ADD tempID int(10) unsigned NOT NULL default 0',
);
$alterColumns = array(
'ID_POLL' => 'CHANGE COLUMN ID_POLL ID_POLL MEDIUMINT(8) unsigned NOT NULL default 0',
);
alterTable('polls', $knownKeys, $knownColumns, $alterColumns);
alterTable('poll_choices', $knownKeys);
}
echo 'Converting polls and poll choices...';
$file_n = 0;
$dir = dir($yabb['datadir']);
$pollQuestionsBlock = array();
$pollChoicesBlock = array();
while ($entry = $dir->read())
{
if ($_GET['substep'] < 0)
break;
if ($file_n++ < $_GET['substep'])
continue;
if (strrchr($entry, '.') != '.poll')
continue;
$pollData = file($yabb['datadir'] . '/' . $entry);
$ID_POLL = substr($entry, 0, strrpos($entry, '.'));
foreach ($pollData as $i => $v)
{
$pollData[$i] = explode('|', rtrim($pollData[$i]));
// Is this the poll option/question? If so set the data.
if (count($pollData[$i]) > 3)
{
$pollQuestions = array(
'question' => substr(htmlspecialchars($pollData[$i][0]), 0, 255),
'votingLocked' => (int) $pollData[$i][1],
Here is the rest of the file:
'maxVotes' => (int) $pollData[$i][8],
'expireTime' => 0,
'hideResults' => (int) $pollData[$i][7],
'changeVote' => 0,
'ID_MEMBER' => 0,
'posterName' => empty($pollData[$i][3]) ? 'Guest' : substr(htmlspecialchars($pollData[$i][3]), 0, 255),
'tempID' => (int) $ID_POLL,
);
$pollQuestionsBlock[] = addslashes_recursive($pollQuestions);
}
// Are these the choices?
if (count($pollData[$i]) == 2)
{
$pollChoices = array(
'ID_POLL' => $ID_POLL,
'ID_CHOICE' => $i - 1, // Make sure to subtract the first row since that's the question
'label' => $pollData[$i][1],
'votes' => (int) $pollData[$i][0],
);
$pollChoicesBlock[] = addslashes_recursive($pollChoices);
}
}
// Since we are basing this off questions lets put the number of rows to a lower ammount since it will be more with the choices
if (count($file_n) > 50)
{
// Set the ID_TOPIC
$topics = array();
foreach ($pollQuestionsBlock as $question)
$topics[] = $question['tempID'];
// Select the members
$request = convert_query("
SELECT ID_MEMBER_STARTED AS ID_MEMBER, tempID, ID_TOPIC
FROM {$to_prefix}topics
WHERE tempID IN (" . implode(',', $topics) . ")");
while ($row = mysql_fetch_assoc($request))
{
// Assign ID_POLL ID_MEMBER to the pollQuestion
foreach ($pollQuestionsBlock as $keyID => $questions)
{
if (isset($pollQuestionsBlock[$keyID]['ID_MEMBER']) && $pollQuestionsBlock[$keyID]['ID_MEMBER'] == $row['ID_MEMBER'])
$pollQuestionsBlock[$keyID]['ID_MEMBER'] = $row['ID_MEMBER'];
}
// Assign ID_POLL to the choices
foreach ($pollChoicesBlock as $keyID => $choices)
{
foreach ($choices as $key => $choice)
if ($key == 'ID_POLL' && $choice == $row['tempID'])
$pollChoicesBlock[$keyID]['ID_POLL'] = $row['ID_TOPIC'];
}
}
mysql_free_result($request);
doBlock('polls', $pollQuestionsBlock);
doBlock('poll_choices', $pollChoicesBlock);
// Increase the time
pastTime($file_n);
}
}
$dir->close();
if (!empty($pollQuestionsBlock) && !empty($pollChoicesBlock))
{
$topics = array();
foreach ($pollQuestionsBlock as $question)
$topics[] = $question['tempID'];
// Select the members
$request = convert_query("
SELECT ID_MEMBER_STARTED AS ID_MEMBER, tempID, ID_TOPIC
FROM {$to_prefix}topics
WHERE tempID IN (" . implode(',', $topics) . ")");
while ($row = mysql_fetch_assoc($request))
{
// Assign ID_POLL ID_MEMBER to the pollQuestion
foreach ($pollQuestionsBlock as $keyID => $questions)
{
if (isset($pollQuestionsBlock[$keyID]['ID_MEMBER']) && $pollQuestionsBlock[$keyID]['ID_MEMBER'] == $row['tempID'])
$pollQuestionsBlock[$keyID]['ID_MEMBER'] = $row['ID_MEMBER'];
}
// Assign ID_POLL to the choices
foreach ($pollChoicesBlock as $keyID => $choices)
{
foreach ($choices as $key => $choice)
if ($key == 'ID_POLL' && $choice == $row['tempID'])
$pollChoicesBlock[$keyID]['ID_POLL'] = $row['ID_TOPIC'];
}
}
mysql_free_result($request);
doBlock('polls', $pollQuestionsBlock);
doBlock('poll_choices', $pollChoicesBlock);
}
pastTime(-1);
if ($_GET['substep'] >= -1)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_POLL)',
);
$alterColumns = array(
'ID_POLL' => 'CHANGE COLUMN ID_POLL ID_POLL MEDIUMINT(8) unsigned NOT NULL auto_increment',
);
alterTable('polls', $knownKeys, '', $alterColumns, true, true);
}
}
function convertStep17()
{
global $to_prefix;
echo 'Converting polls and poll choices (part 2)...';
while (true)
{
pastTime($_GET['substep']);
$request = convert_query("
SELECT p.ID_POLL, t.ID_TOPIC
FROM ({$to_prefix}polls AS p, {$to_prefix}topics AS t)
WHERE p.tempID = t.tempID
LIMIT $_GET[substep], 200");
while ($row = mysql_fetch_assoc($request))
{
convert_query("
UPDATE {$to_prefix}topics
SET ID_POLL = $row[ID_POLL]
WHERE ID_TOPIC = $row[ID_TOPIC]");
convert_query("
UPDATE {$to_prefix}poll_choices
SET ID_POLL = $row[ID_POLL]
WHERE ID_POLL = $row[ID_TOPIC]");
}
$_GET['substep'] += 200;
if (mysql_num_rows($request) < 200)
break;
mysql_free_result($request);
}
}
function convertStep18()
{
global $to_prefix, $yabb;
echo 'Converting poll votes...';
$file_n = 0;
$dir = dir($yabb['datadir']);
$pollVotesBlock = array();
$members = array();
$pollIdsBlock = array();
while ($entry = $dir->read())
{
if ($_GET['substep'] < 0)
break;
if ($file_n++ < $_GET['substep'])
continue;
if (strrchr($entry, '.') != '.polled')
continue;
$pollVotesData = file($yabb['datadir'] . '/' . $entry);
$ID_POLL = substr($entry, 0, strrpos($entry, '.'));
$pollIdsBlock[] = $ID_POLL;
// Get the data from each line/
foreach ($pollVotesData as $i => $votes)
{
$pollVotesData[$i] = explode('|', rtrim($pollVotesData[$i]));
// We just need the memberName and ID_CHOICE here.
if (count($pollVotesData) > 2)
{
// Set the members.
$members[] = $pollVotesData[$i][1];
// Set the other poll data
$pollVotes = array(
'ID_POLL' => 0,
'ID_MEMBER' => 0,
'ID_CHOICE' => $pollVotesData[$i][2],
'tempID' => $ID_POLL,
'memberName' => trim($pollVotesData[$i][1])
);
$pollVotesBlock[] = addslashes_recursive($pollVotes);
}
}
// Now time to insert the votes.
if (count($pollVotesBlock) > 50)
{
$request = convert_query("
SELECT ID_MEMBER, memberName
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("','", $members) . "')");
// Asssign the ID_MEMBER to the poll.
while ($row = mysql_fetch_assoc($request))
{
foreach ($pollVotesBlock as $key => $avlue)
{
if (isset($pollVotesBlock[$key]['memberName']) && $pollVotesBlock[$key]['memberName'] == $row['memberName'])
{
// Assign ID_MEMBER
$pollVotesBlock[$key]['ID_MEMBER'] = $row['ID_MEMBER'];
// Now lets unset memberName since we don't need it any more
unset($pollVotesBlock[$key]['memberName'], $pollVotesBlock[$key]['memberName']);
}
}
}
// Get the ID_POLL form the temp ID
$request = convert_query("
SELECT ID_POLL, tempID
FROM {$to_prefix}polls
WHERE tempID IN (" . implode(',', $pollIdsBlock) . ")");
// Assign the ID_POLL
while ($row = mysql_fetch_assoc($request))
{
foreach ($pollVotesBlock as $key => $value)
{
if (isset($pollVotesBlock[$key]['tempID']) && $pollVotesBlock[$key]['tempID'] == $row['tempID'])
{
$pollVotesBlock[$key]['ID_POLL'] = $row['ID_POLL'];
unset($pollVotesBlock[$key]['tempID'], $pollVotesBlock[$key]['tempID']);
}
}
}
// Lets unset the remaining memberNames
foreach ($pollVotesBlock as $key => $value)
{
if (isset($pollVotesBlock[$key]['memberName']))
unset($pollVotesBlock[$key]['memberName'], $pollVotesBlock[$key]['memberName']);
}
doBlock('log_polls', $pollVotesBlock);
// Some time has passed so do something
pastTime($file_n);
}
}
$dir->close();
if (!empty($members))
{
$request = convert_query("
SELECT ID_MEMBER, memberName
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("','", $members) . "')");
// Asssign the ID_MEMBER to the poll.
while ($row = mysql_fetch_assoc($request))
{
foreach ($pollVotesBlock as $key => $avlue)
{
if (isset($pollVotesBlock[$key]['memberName']) && $pollVotesBlock[$key]['memberName'] == $row['memberName'])
{
// Assign ID_MEMBER
$pollVotesBlock[$key]['ID_MEMBER'] = $row['ID_MEMBER'];
// Now lets unset memberName since we don't need it any more
unset($pollVotesBlock[$key]['memberName'], $pollVotesBlock[$key]['memberName']);
}
}
}
}
if (!empty($pollIdsBlock))
{
// Get the ID_POLL form the temp ID
$request = convert_query("
SELECT ID_POLL, tempID
FROM {$to_prefix}polls
WHERE tempID IN (" . implode(',', $pollIdsBlock) . ")");
// Assign the ID_POLL
while ($row = mysql_fetch_assoc($request))
{
foreach ($pollVotesBlock as $key => $value)
{
if (isset($pollVotesBlock[$key]['tempID']) && $pollVotesBlock[$key]['tempID'] == $row['tempID'])
{
// Assign the ID_POLL
$pollVotesBlock[$key]['ID_POLL'] = $row['ID_POLL'];
// We don't need you any more so...BYE!!!
unset($pollVotesBlock[$key]['tempID'], $pollVotesBlock[$key]['tempID']);
}
}
}
}
// Lets unset the remaining memberNames
foreach ($pollVotesBlock as $key => $value)
{
if (isset($pollVotesBlock[$key]['memberName']))
unset($pollVotesBlock[$key]['memberName'], $pollVotesBlock[$key]['memberName']);
}
// Do the remaining block
if (!empty($pollVotesBlock))
doBlock('log_polls', $pollVotesBlock);
pastTime(-1);
// Remove the temp column from the table and put the primary key back.
if ($_GET['substep'] >= -1)
{
$knownKeys = array(
'PRIMARY' => 'ADD PRIMARY KEY (ID_POLL, ID_CHOICE)',
);
alterTable('poll_choices', $knownKeys, '', '', true);
pastTime(-2);
}
if ($_GET['substep'] >= -2)
{
$knownKeys = array(
'poll' => 'ADD UNIQUE INDEX poll (ID_POLL, ID_TOPIC)',
);
alterTable('messages', $knownKeys, '', true);
pastTime(-3);
}
if ($_GET['substep'] >= -3)
{
$knownColumns = array(
'tempID' => 'DROP COLUMN tempID'
);
alterTable('topics', '', $knownColumns, '', false, true);
pastTime(-4);
}
if ($_GET['substep'] >= -4)
{
$knownColumns = array(
'tempID' => 'DROP COLUMN tempID',
);
alterTable('polls', '', $knownColumns, '', true, true);
}
}
function fixRelativePath($path, $cwd_path)
{
// Fix the . at the start, clear any duplicate slashes, and fix any trailing slash...
return addslashes(preg_replace(array('~^\.([/\\\]|$)~', '~[/]+~', '~[\\\]+~', '~[/\\\]$~'), array($cwd_path . '$1', '/', '\\', ''), $path));
}
function parse_time($field, $use_now = true)
{
$field = trim(str_replace(array(' um ', ' de ', ' en ', ' la ', ' om '), ' at ', $field));
if ($field == '')
$field = $use_now ? time() : 0;
elseif (strtotime($field) != -1)
$field = strtotime($field);
elseif (preg_match('~(\d\d)/(\d\d)/(\d\d)(.*?)(\d\d)\:(\d\d)\:(\d\d)~i', $field, $matches) != 0)
$field = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
else
$field = $use_now ? time() : 0;
return $field;
}
function doBlock($table, &$block)
{
global $to_prefix;
if (empty($block))
return;
// If converting mark as read data make the insert be ignore into
if ($table == 'log_mark_read' || $table == 'log_boards' || $table == 'log_topics' || $table == 'log_polls')
$ignore = ' IGNORE ';
else
$ignore = '';
if ($table == 'members')
{
$block_names = array();
foreach ($block as $i => $row)
$block_names[$row['memberName']] = $i;
$request = convert_query("
SELECT memberName
FROM {$to_prefix}members
WHERE memberName IN ('" . implode("', '", array_keys($block_names)) . "')
LIMIT " . count($block_names));
while ($row = mysql_fetch_assoc($request))
{
if (isset($block_names[$row['memberName']]))
unset($block[$block_names[$row['memberName']]]);
}
mysql_free_result($request);
if (empty($block))
return;
unset($block_names);
}
$insert_block = array();
foreach ($block as $row)
$insert_block[] = '\'' . implode('\', \'', $row) . '\'';
convert_query("
INSERT $ignore INTO {$to_prefix}$table
(" . implode(', ', array_keys($block[0])) . ")
VALUES (" . implode("),
(", $insert_block) . ")");
$block = array();
}
}
?>
BTW, the yabb21_to_smf.php file that I am using is right from here:
http://www.simplemachines.org/community/index.php?topic=122338.msg781367#msg781367
Thanks for looking into this and your help. I really appreciate it very much!
OK I fixed the above error by reinstalling SMF without UTF8 Unicode support, but now I get the following error:
Converting...
Converting members... Unsuccessful!
This query:
ALTER TABLE `username_forum`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0, dateRegistered' at line 2
I have PHP 5.2.3 MySQL 5.0.45 and Apache 2.2.4
I am converting a large YaBB 2.1 forum to SMF 1.1.3 using the converter downloaded freshly from the simplemachines.org website.
I see you submitted a support ticket. We will try to resolve this for you via the ticket system.
Thanks! I resolved this one by changing this code (thanks SleePy!):
convert_query("
ALTER TABLE {$to_prefix}members
ORDER BY ID_MEMBER =0, dateRegistered");
to this:
convert_query("
ALTER TABLE {$to_prefix}members
ORDER BY ID_MEMBER, dateRegistered");
and also changed it for {$to_prefix}personal_messages and {$to_prefix}topics as well.
This error is in regards to MySQL 5.0.45 and how it handles queries.
Alas, I now have another error about duplicate entries while converting topics. :( I also will try solve this through the ticket system.
Nevermind ... Decided to give SMF the flick and stick with YaBB 2.1. Support here is too slow, even for Charter Member's support ticket system.
Any ideas on how to get past this error?
Thanks!
vmpre2 try this one.
Awesome, thanks Jay.
I will give it a try today!
Cheers!
ALL HAIL JAY
ALL HAIL JAY
Thank you very much Jay, transition completed on my test board. Everything seemed to work.
I really appreciate all the help. I cant wait to dig in and get things going to the new SMF!!
Quote from: Stallyon on August 28, 2007, 08:27:32 AM
Nevermind ... Decided to give SMF the flick and stick with YaBB 2.1. Support here is too slow, even for Charter Member's support ticket system.
Is the ticket still open?
Please remember we are all volunteers, we have lives we must deal with and only get to SMF in our free time we wish to give up.
Most of us try to make an effort to get to charter tickets asap (I usually do right after I read the team boards).
The duplicate entry most likely means there are two topics with the same ID_TOPIC in your database.
You can search your old yab files for this and see if you can find it and remove one of them or change the ID to a higher number.
Quote from: SleePy on August 30, 2007, 10:15:56 PM
Is the ticket still open?
Please remember we are all volunteers, we have lives we must deal with and only get to SMF in our free time we wish to give up.
Most of us try to make an effort to get to charter tickets asap (I usually do right after I read the team boards).
The duplicate entry most likely means there are two topics with the same ID_TOPIC in your database.
You can search your old yab files for this and see if you can find it and remove one of them or change the ID to a higher number.
In the end, it ultimately wasn't my choice. I would have loved to persevere and stick with SMF, because I think YaBB 2.1 and FFDB is a system hog. But, alas, the owners of the forum I was converting got impatient (I do understand that you guys do have lives outside of this forum, as does everyone). It was not my impatience that lead to this decision. Forgive me if I sounded abrupt, but I was getting my butt chewed by a murder of admins, and I too was developing a foul mood as a result. These guys just can't get a grip on SQL, and don't like to do anything that's "too hard" i.e. don't want to learn a new forum system, templating, coding, etc. *sighs*
Hello guys, first post here. I'm thrilled to convert my YaBB2.1 into SMF but I keep running into this problem when converting:
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `ptfig3_ptfforum`.ptfsmf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('1', '0', '1'),
('1', '70', '4'),
('1', '8', '5'),
('1', '16', '2'),
('1', '143', '4'),
('1', '14', '4'),
('1', '65', '1'),
('1', '130', '4'),
('1', '29', '4'),
('1', '36', '5'),
('1', '52', '2'),
('1', '172', '5'),
('1', '13', '2'),
('1', '69', '0'),
('1', '11', '0'),
('1', '15', '2'),
('1', '75', '4'),
('2', '97', '9'),
('2', '93', '2'),
('2', '11', '1'),
('2', '5', '2'),
('2', '4', '9'),
('2', '16', '2'),
('2', '70', '1'),
('2', '116', '9'),
('2', '65', '6'),
('2', '34', '4'),
('2', '143', '1'),
('2', '69', '9'),
('2', '52', '2'),
('2', '9', '7'),
('2', '1', '2'),
('2', '14', '2'),
('2', '53', '6'),
('2', '15', '9'),
('2', '36', '2'),
('2', '0', '7'),
('2', '130', '0'),
('2', '119', '0'),
('2', '17', '6'),
('2', '13', '9'),
('2', '0', '0'),
('3', '147', '2'),
('3', '16', '2'),
('3', '29', '1'),
('3', '5', '0'),
('3', '123', '0'),
('3', '131', '2'),
('3', '75', '0'),
('3', '163', '2'),
('3', '9', '1'),
('3', '1', '2'),
('3', '36', '2'),
('3', '17', '2'),
('3', '53', '1'),
('3', '34', '2'),
('3', '70', '2'),
('3', '119', '1'),
('3', '15', '0'),
('3', '11', '1'),
('3', '169', '1'),
('3', '0', '1'),
('3', '143', '2'),
('3', '0', '1'),
('3', '98', '1'),
('3', '6', '1');
Caused the error:
Duplicate entry '3-0-1' for key 1
Any ideias how to fix it? I've already tried to delete all .poll and .polled files, but the same error happens.
Thank you
--- edit ---
got it fixed guys. Thanks to craigbass with his "fixed" file :)
Cheers!
I need help too, i started the conversion from Yabb2.1 to smf 1.1.3 today, the part 1 was converted successfully then everytime it stops from converting part 2 here's the error
Converting...
Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `user_smf`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '0-0' for key 1
I used the convert.php and the yabb21_to_smf.php from this thread?
Hope somebody can help.
BTW, the Yabb I'm converting from is a transfer of a Yabb from another server. I made a clean install of the Yabb 2.1 and then put in my members and messages folder plus boards and variables into the new install. It seems to be working fine though.
Thanks
Use the convert files in this topic.
Thanks Jay for responding, but it's still the same error I also got this error prior to that
Converting...
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: shows in /home/idto00/public_html/fora/yabb21_to_smf.php on line 692
Successful.
Then it continued until it hit part 2 again.
with the same error Converting topics (part 2)... Unsuccessful!
This query:
ALTER TABLE `user_smf1`.smf_log_topics
ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
DROP COLUMN tempID;
Caused the error:
Duplicate entry '0-0' for key 1
I used the most latest yabb21_to_smf.php I can find in this thread and the converter also came from this thread. Still the same
I'm trying to convert from Yabb2.1 to SMF 1.1.4, however, I'm getting the following errors when running the convert.php file:
_____________________
Warning: file(/home/dspforum/public_html/forum/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 76
Warning: Invalid argument supplied for foreach() in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 79
Notice: Undefined index: boardsdir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: datadir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: memberdir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: sourcedir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: vardir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: facesdir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Notice: Undefined index: uploaddir in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 91
Warning: file(/Settings.pl) [function.file]: failed to open stream: No such file or directory in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 98
Warning: Invalid argument supplied for foreach() in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/membergroups.txt) [function.file]: failed to open stream: No such file or directory in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 120
Warning: Invalid argument supplied for foreach() in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 121
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/dspforum/public_html/smf/yabb21_to_smf.php on line 246
I got it figured out. In Yabb 2.1 the file paths.pl had permission settings of 700. I changed the permissions on that file to 777 and everything converted.
kongming are you using a modified version of YaBB 2.1?
Hm, quite the nasty bunch of issues.
I tried the original version of the converter & was greeted with the 'poll' key errors -- so I tried the Craigbass version attached earlier and I arrive at even better errors:
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `dbname_forums`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '53-0' for key 1
Any thoughts?
That tells us that on a poll with the id of 53.. there is more than 1 choice that is 0..
Are you able to track back in your yabb forum to figure out which poll this was? You might have to manually either edit it or remove it.
SleePy,
Thank you, that certainly gives me a bit more to go on.
I'll contact the forum owner I'm attempting to convert it for & have him toss it :)
I appreciate it. I should be able to take it from here!
i have searched over the forum (maybe i am missing something) but mine just hangs on the converting members...
i have changed the $_GET to $_REQUEST - is there something else that i am missing?
Oh boy, disappointing. It converts & I'm left with a blank SMF forum.
I despise YaBB with a passion!
Quote from: tracom on December 10, 2007, 11:35:29 AM
i have searched over the forum (maybe i am missing something) but mine just hangs on the converting members...
i have changed the $_GET to $_REQUEST - is there something else that i am missing?
What convert files are you using?
Quote from: DavidJ on December 10, 2007, 11:37:56 AM
Oh boy, disappointing. It converts & I'm left with a blank SMF forum.
I despise YaBB with a passion!
When you start the conversion does it go straight to the "Recount board stats" section? If so take a look at Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
for mine - i am using the one that you have linked at the beginning of this thread. I tried it and just seems to hang. So thinking it might be a similar content problem i changed the $_GETs out.
i am going from 2.1 to 1.1.4 - i just upgraded YABB to 2.1 from 2.0 in hopes it would upgrade easier. oh how i hate yabb.
Jay,
Well, this time around I used the original again. After clearing all of the polls off the forum (A multi-year old board with millions of unique visitors a year - doh!, wish he'd just switch to a paid product like vB) it still errors out at a poll. I suspect maybe another user added one in since clearing them.
Back to the drawing board!
Quote from: tracom on December 10, 2007, 01:19:31 PM
for mine - i am using the one that you have linked at the beginning of this thread. I tried it and just seems to hang. So thinking it might be a similar content problem i changed the $_GETs out.
i am going from 2.1 to 1.1.4 - i just upgraded YABB to 2.1 from 2.0 in hopes it would upgrade easier. oh how i hate yabb.
Check the permissions for the data folders in YaBB. The members folders and so on. How big is your board?
Quote from: DavidJ on December 10, 2007, 01:52:20 PM
Jay,
Well, this time around I used the original again. After clearing all of the polls off the forum (A multi-year old board with millions of unique visitors a year - doh!, wish he'd just switch to a paid product like vB) it still errors out at a poll. I suspect maybe another user added one in since clearing them.
Back to the drawing board!
Give this one try. http://www.simplemachines.org/community/index.php?topic=122338.msg1220273#msg1220273
Hm, well the result actually goes through but I end up with a blank forum, e.g. no categories.
The members are there though, it's a start :)
Quote from: DavidJ on December 10, 2007, 02:16:12 PM
Hm, well the result actually goes through but I end up with a blank forum, e.g. no categories.
The members are there though, it's a start :)
If you'd like I can take a look into this for you.
Jay,
I'd hate to take up any of your time, you've already been an exceptional help!
Well I have a few mins free to look into this. If you want me to just let me know.
Jay,
I'm available at david [at] FusedNetwork.com, if you could send me an initial message I'll get back to you immediately.
Thank you!
Is that for messenger or just email?
Jay -
checked the permissions on everything from my yabb folder - 777. if this matters, the yabb was running on a win/IIS so i copied that folder over to my linux box and reset the permissions.
Any other ideas? Thanks for all the help.
Jay,
Both, technically however I prefer e-mail based communication for simplicity.
tried doint a fresh install of smf again - and recopying the files back over. doesnt seem to make a difference. any help would be great - i would like to get them off perl and flat files to php/mysql.
DavidJ - I'll send you an email.
tracom can you contact me on one of the messengers?
Thanks Jay, looking forward to hearing from you.
I just recently converted my YaBB 2.1 board to SMF 1.1.4. The conversion went okay in that I did not receive any error messages when converting. It appears that all went well with the conversion. I will however need to reorder the boards since the conversion placed them in alphabetical order.
The only problem I am having now is that I am unable to access the admin screen. I get the following message when I try to do so "Unterminated comment starting line 27 in /xxxxxxxxx/smf/Sources/Admin.php on line 27". Checking the file size after conversion (3072) with the original file size (59015), it apears that somewhere along the line part of the file got left off.
How can I address this problem? Thanks in advance for your assistance.
Just reupload the Source dir incase other files are corrupt. For the board order. You might have to order them on your own. Do they appear in the right order in the admin panel?
Thanks for your help. I reuploaded the Admin.php file and everything worked fine. I manually reorderd the categories.
Converting...
Notice: Undefined index: convert_script in /home/www/kywilderness/forum/convert.php on line 578
Warning: Invalid argument supplied for foreach() in /home/www/kywilderness/forum/convert.php on line 581
Notice: Undefined index: convert_script in /home/www/kywilderness/forum/convert.php on line 586
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 933
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 943
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 951
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 961
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 974
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 987
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1033
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1035
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1041
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1047
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1058
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1059
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1067
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1069
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1075
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1076
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1082
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1083
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1107
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1109
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1115
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1127
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1152
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1154
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1190
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1191
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1229
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1234
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1295
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1297
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1333
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1352
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1825
Notice: Undefined variable: result in /home/www/kywilderness/forum/convert.php on line 1826
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1375
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/www/kywilderness/forum/convert.php on line 1376
Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /home/www/kywilderness/forum/convert.php on line 1452
installation.
We hope you had a smooth transition!
Warning: Unknown(): write failed: Disk quota exceeded (122) in Unknown on line 0
Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
i know im missing something.. but this is what i am getting everytime... any help?
Who is your host?
netnation. I figured it out.. was the php. ini thing..
note to self: read the FAQ.. hehe.
one problem i am having now though is the captcha is broken.. its not showing any images..
Check the mods that you have installed. Make sure that there is no new lines before the <DOCTYPE declaration in the page source. I suggest that you make a new topic. Also does quoting work?
php needs to be compiled with GD support for that to work, at least that I know of.
Quote from: efroma on February 14, 2008, 12:58:23 PM
one problem i am having now though is the captcha is broken.. its not showing any images..
I'm getting this error going from yabb 2.1 -> SMF 1.1.4
Apache 2.2 / PHP 5 / Mysql 4
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Successful.
Converting topics (part 1)... Successful.
Converting topics (part 2)... Successful.
Converting notifications... Successful.
Converting posts (part 1 - this may take some time)... Successful.
Converting posts (part 2)... Successful.
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `hibuzz_smf1`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('5', '70', '0'),
('5', '84', '1'),
('5', '215', '0'),
('5', '211', '0'),
('5', '45', '2'),
('5', '197', '1'),
('5', '64', '0'),
('5', '95', '0'),
('5', '162', '0'),
('5', '13', '0'),
('5', '229', '0'),
('5', '22', '0'),
('5', '97', '0'),
('4', '0', '0'),
('4', '89', '0'),
('4', '0', '0'),
('4', '0', '0'),
('4', '0', '0'),
('4', '0', '0'),
('4', '0', '0'),
('4', '49', '0'),
('4', '0', '1'),
('4', '0', '0'),
('4', '45', '0'),
('4', '70', '1'),
('4', '101', '1'),
('4', '0', '0'),
('4', '0', '0'),
('4', '4', '0'),
('4', '0', '0'),
('4', '23', '0'),
('4', '0', '0'),
('4', '215', '1'),
('4', '0', '1'),
('4', '54', '1'),
('4', '0', '1'),
('4', '124', '0'),
('4', '241', '0'),
('4', '0', '1'),
('4', '0', '1'),
('4', '102', '0'),
('4', '134', '0'),
('4', '22', '0'),
('4', '0', '0'),
('4', '0', '1'),
('4', '0', '0'),
('4', '0', '0'),
('4', '19', '0'),
('4', '162', '0'),
('4', '0', '1'),
('4', '16', '0'),
('4', '64', '0'),
('4', '0', '1'),
('4', '229', '0'),
('4', '84', '0'),
('4', '0', '0'),
('4', '200', '0'),
('4', '0', '0'),
('4', '199', '0'),
('4', '13', '0'),
('4', '76', '1'),
('4', '0', '0'),
('4', '121', '1'),
('4', '174', '0'),
('4', '97', '0');
Caused the error:
Duplicate entry '4-0-0' for key 1
I read earlier in this post about this, and about having to go back and delete polls or some such?
I'm not sure what to do here, maybe I just need some clarification.
Also, that is the converter file from page 17 that worked for one person earlier.
I have also tried the version on the downloads page, and it gives the same error.
Thanks!
Try the one in the first page.
Hello Jay,
Currently, on my forum Yabb 2.1 I have
1 216 568 messages,
28 659 subj,
12 226 users.
I'm trying to convert all staff to SMF 1.1.4 (fresh install of course).
After 2 times(it took a few hours to fulfill), I have the same result - blank board. All user data converted well(it seems well).
Now I install 2 additional SMF :-) and trying to convert all data.
During converting there are numerous errors, like
Notice: Undefined index: convert_script in /home/forumgr/public_html/smf01/convert.php on line 580
Warning: Invalid argument supplied for foreach() in /home/forumgr/public_html/smf01/convert.php on line 583
Notice: Undefined index: convert_script in /home/forumgr/public_html/smf01/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 935
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 945
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 953
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 963
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 976
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 989
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1035
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1037
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1043
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1049
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1060
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1061
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1069
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1071
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1077
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1078
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1084
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1085
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1109
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1111
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1117
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1129
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1154
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1156
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1192
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1193
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1231
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1236
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1297
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1299
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1335
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1354
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1827
Notice: Undefined variable: result in /home/forumgr/public_html/smf01/convert.php on line 1828
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1377
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/forumgr/public_html/smf01/convert.php on line 1378
In today converting one another type of error appeared(it caused stop converting process):
INSERT INTO `forumgr_smf01db`.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 (`forumgr_smf01db`.smf_personal_messages AS pm, `forumgr_smf01db`.smf_members AS mem)
WHERE mem.memberName = pm.temp_toName
AND pm.temp_toName != '';
Caused the error:
Duplicate entry '1-462' for key 1
Is your convertor is for 1.1.3 only?
May be I have to insatll not 1.1.4, but 1.1.3?
Can you give me any suggestion - how to finish process?
PS:
I tried 6 times, unfortunately, results are vary but not too much...
1) script works very slow, it takes 3-4 hours and after that time script end it's work with numerous of mistakes. After that SMF board became empty, only Category and subforms is viewable. No messages, no topics...
Is it possible to divide convert script into several scripts?
pPS: it's became strange more and more ...
I ran convert yesterday at evening/night, now is midday and convert is still
"Converting personal messages... Incomplete"
it works is about 12-14 hours.
I have MySQL 4.1.22 on FreeBSD 5.3 x86.
I found that converting process begin working slowly when converting each of part is close to the end. E.g.
Converting personal messages... Incomplete.
Script converted ~150 000 messages quickly(totally is about 152 000), and last 2 000 processing by 10-20 pieces per request...
Umm how many personal messages do you have in total? Also it might be better running the conversion locally since you seem to have a pretty big forum. Would run faster if you run it locally.
I don't know how many personal messages on my forum.
For now:
1 390 120 messages
30 144 subjects
12 290 users
I have tried locally, but locally I have Apache 2.2.8+PHP 5.2.5+MySQL 5.0.51a installed in Win32.
I tried on win32... but your script doesn't work after first step. Only
Converting membergroups... Successful.
Converting members...
and nothing.
Also, on win32 there is problem with names(uppercase and lowcase :))...
So... I prefer converting is better on production server.
I tried to run Lynx locally... but not too much faster.
Is it possible to divide converting script somehow? Divide converting members, converting personal messages, converting boards?
How do you think - is it possible that problems idue to old version of MySQL 4.1.22?
I have other small forum, it is the same Yabb2.1, there test conversion passed well.
But with this one... :-(
I really like SMF... and mods for it, but... I already 3-4 days can't convert my yabb2.1 to smf :-(
I'm already began looking to vBulletin :-(
I not lost my hope for good migration to SMF yet... ;)
I run locally converting and I got the same problem as on production server.
When count of personal messages, inserted in MySQL reached ~145 000, then converting process became very slow. Only 10-100 rows inserted per one transaction.
I guessed the problem is with accessing to 55 000 files(~220 MB), which located on one directory.
Jay, is it possible to add to script possibility to load files to the memory by portions... e.g per 100MB, and then access to them directly from RAM? It will speed up process, i'm sure.
Ummmm. If you can give me the FTP info I can try running the conversion and see what exactly is going on. There must be something going on with a wiery or something. So if I can get access to phpMyAdmin and FTP I can debug this for you and convert the forum. :).
Converting from flatfile will always be an issue since you have to look at EVERY single file that ends with .abc and the parse the data and so on. Maybe making PHP use more memory when converting PM's. But it shouldn't be so much of a problem if posts were converted successfully. That means that it should handle PMs as well w/o too much trouble.
Thanks for your proposal!
Today is too late for me, I'll wait results of local converting tomorrow then write PM to you.
Alright. I should have some time to do it tomorrow while at work. So just shoot me a PM if anything.
"News" :-)
I waited 2 days of converting...
In table personal_messages was 705 000 rows.
After ~140 000 rows convert sript began work very slow and insert ~100rows each 25 seconds
With help of grep I aprroximately calculate how much of personal messages should contian my forum ~ 350 000.
So, more than 700 000 rows looks strange. I have stopped converting.
I'll prepare FTP and rest data for you... right now then will PM you.
I actually think it may be a bug in the conversion process why it does that.
It shouldn't slow down. Though it is possible jay coded in the timeout script to detect when sections take longer to convert due to slower queries and changed the size of data it is converting at once.
You could change the default size it is trying to use when converting PMs at a time as well.
As said I think a local convert would be better in the long run. You wouldn't affect server resources and when you are done you can just import the sql file to your mysql database and then setup your SMF forum to point to that database.
I prepeared all things, I wait for NS update...
May be following data will be useful for someone who want to use convertor, especially in case of converting big boards. I collected this during exploring this forum and looking my log-files:
1) MySQL should not be runned under Strict mode
Simple way to decide problem it is to run query in MySQL:
SET @@global.sql_mode=''
2) If you see error message saying "MySQL server has gone away" probably this is:
#08S01Got a packet bigger than 'max_allowed_packet' bytes
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Simple way to decide problem it is to run query in MySQL:
SET GLOBAL max_allowed_packet=10000000;
3) if your convert just finished and no new step appear this may happened due to
PHP Fatal error: Maximum execution time of 30 seconds exceeded
How to fix: Edit the maximum_execution_time in your php.ini
Default is 30 seconds, I increased it to 300 seconds and works still fine.
Also I add to Apache settings: php_value max_execution_time 300
And don't forget to restart apache and php.
Jay, I sent all info in PM
Thanks for the info :) Useful for others to know :)
Hi everyone, I'm new to SMF and have been trying to convert from YaBB2.1
The farthest I've gotten is to the poll votes conversion where it gave me the error below:
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `ibaraki_smf`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
I found the file on page 15 of this topic that was supposed to fix the poll vote problem, but I never got that far with that file. It always stopped at topics i think.
I've gone back to the file attached to the first post. Any help would be greatly appreciated, thank you.
Please do not post your question in multiple places.
As well if you do a search you will see that similar errors have been posted before and have been answered.
First off make sure you got the latest file which is attached to the first post in this topic.
Make sure for one you are not clicking continue and trying to speed up the process of conversion. If javascript is enabled on the browser it will automatically count down and continue the conversion at a nice rate to not put a big load on the server.
It shouldn't still be happening as a key like tha shouldn't be added :|
Try this file and see if that fixes the poll issues. http://www.simplemachines.org/community/index.php?topic=122338.msg1220273#msg1220273
--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!
Ok you got me lost. Did it work at the end or still no go?
Hallo,
i got the following error message when converting from YaBB 2.1 at http://forum.ersterkontakt.com/cgi-bin/yabb2/YaBB.pl:
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
Where you using the .php file attached to the first post in this topic?
Please, help me with converting my big forum! ^-)
I almost lost my hope to move from Yabb 2.1 to SMF :-(
What errors are you getting?
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).
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
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.
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.
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 ...
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?
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 :(
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.
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
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 :)
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
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.
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
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',
thanks for the help! i'm using the lastest stable community version (5.0.51b)
i have actually fixed it though after a bit of googling.
changing the sql mode from to sql-mode=""
in my.ini got everything working for me. something about the default setting not allowing auto-increment in version 5.
i hope this helps others down the road!
hey again. i have another problem for my local conversion. it gives me errors at polls, i've never had a conversion that didn't do that, but i always just skip it by increasing the cstep manually. however this time, it just hangs on "recalculating forum statistics"
i'm wondering what could be causing this?
Can you post the errors its giving?
this is the only error i've gotten locally:
Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `ibaraki_smf`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:
Duplicate entry '16777215-0' for key 1
and if i increase cstep manually (at 19) it hangs, and eventually i get:
Converting...
Recalculating forum statistics...
and it just sits there. refresh doesn't help. increasing cstep again doesn't help.
any ideas?
Well the first one is saying that there is dupliate poll votes.
For the poll id of 16777215 you need to go into the database and look at the smf_poll_choices table.
Performing a search may help but there appears to be a poll with 2 or more choices of 0 on the same poll.
They either need removed (easier way) or edited (a little hard as you need to know the ids of the other choices for this poll)
Thanks for explaining the poll vote error. Though I'm not sure how to go about removing/editing. At the moment I thought to myself, maybe I'm supposed to use MySQL Query Browser. So I've loaded it up and I've found poll id 16777215, what I see is:
ID_Poll: 16777215 ID_Choice: 0 Votes: 22
ID_Poll: 16777215 ID_Choice: 1 Votes: 1
ID_Poll: 16777215 ID_Choice: 2 Votes: 0
Should I delete ID_Choice 0? Delete them all? The poll data really isn't necessary, but I've no idea which thread the poll belongs to in the original forum, otherwise I'd delete it there.
On another note, I haven't been able to complete the conversion yet. Something makes me think that this error will come up again if I don't find where the poll is in the original forum and delete it.
Is there more than one poll with that same id?
With what data has been imported, it doesn't seem so. Those choices above where the only ones with this ID.
Hmm, well that is odd.
Are you able to click on by clicking try again?
That error is saying its finding two in the database so that seems weird.
Are there ids higher than that for polls?
Edit,
I did a test and 16777215 is the highest ID that is supported by the polls table. I think for some reason the ids are not being set right :|
clicking try again gives me the same error.
actually that particular poll id is the only one that is 8 digits long.
oooh, actually playing with the query browser right now i did find more entries for that poll id.
i'm guessing if i delete all of them, i can click try again, and the conversion will continue??
well, i haven't figured out how to edit/delete these the entry for this poll.
not really sure what to do actually. i think i'll see if deleting all the polls will help.
Well what happening is the polls are all hitting the maximun that field can hold.
Does the smf_polls table look the same with these really high numbers?
nope. and i've figured out that in smf_poll_choices, three of the 16777215 entries should be poll_ID 2
and the other two 16777215 entries i found should be poll_id 60
i think this is where my problem is because the smf_polls table goes straight from 1-84 (i checked and i only have 84 polls)
well in the end i went through the yabb poll files and found the file matching poll_ID 16777215 and deleted it. after that the conversion went smoothly except that it says "Recalculating forum statistics" at the end and never changes. Doesn't even seem like the page is reloading.
other than that issue though, it seems like everything is there.
thanks for the clueing me in on the DB stuff. it was a good learning experience.
For the most part if you run
"Find and Repair Errors" and then "Recount Totals and Statistics" from Admin -> Forum Maintenance
It will basically (minor a few things) do the cleanup that was attempting to be done at the end.
hi,
trying to convert a fairly large yabb 2.2.1 ("Our users have made 231720 Posts within 8279 Topics") using the convert.php and yabb21_to_smf.php from the op and i'm getting hung up at step 11 (converting posts part 2). it seems like i have close to the right number of rows in sda_messages:
mysql> select count(*) from sda_messages;
+----------+
| count(*) |
+----------+
| 231889 |
+----------+
1 row in set (0.00 sec)
mysql>
... which i'm assuming is what step 11 does, but then the converter just reloads endlessly at cstep=11 and doesn't complete the step. i'm curious what could cause this as i'm willing to do anything at this point to dump yabb and convert to smf. i very much appreciate any assistance you could offer me in this matter.
Are you sure its looping or is it just working on updating all the ID_MSG in that table to have the correct values?
There is a big while loop in step 11 that might take a while as its doing the updates to the ids of the messages (and a large forum might have a lot of messages to update).
i'm going to download the forum and attempt the conversion my local machine which has a much faster cpu/disk. i can't seem to find what the parameter list to convert.php should look like though - could i get some help with that? thanks.
parameter list? Are you doing it via command line?
You won't need the list of parameter if you are doing the conversion via url as it has a gui interface.
yes, commandline. it should be quicker, right?
Command line would be quicker as you do not have to worry about the apache timeout.
If you just do the file name, it should detect no parameters set and will output a nice list of options you can specify.
MINI:forum njahnke$ php -f convert.php
Array
(
[0] => convert.php
)
ERROR: You must enter the path_to in order to convert.MINI:forum njahnke$
hmmm ...
My bad, it didn't do it for the 1.1 converter (it was fixed in the 2.0 converter).
Try the attached one. I simply just had it force the --help command if there is no parameters set.
thanks for that - still having trouble with the cli convert ...
MINI:forum njahnke$ php -f convert.php -- --path_to="/Volumes/t/forum" --path_from="/Volumes/t/yabb2bak" --db_pass=abc123
Starting Conversion
Successful.
* Recalculating forum statistics... Successful.
Conversion Complete!
Please delete this file as soon as possible for security reasons.
Notice: Undefined index: convert_script in /Volumes/t/forum/convert.php on line 727
Warning: Invalid argument supplied for foreach() in /Volumes/t/forum/convert.php on line 730
Notice: Undefined index: convert_script in /Volumes/t/forum/convert.php on line 740
Notice: Undefined index: convert_script in /Volumes/t/forum/convert.php on line 658
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1111
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1121
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1129
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1139
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1152
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1165
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1208
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1210
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1216
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1222
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1232
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1233
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1240
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1242
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1247
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1248
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1253
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1254
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1278
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1280
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1286
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1298
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1321
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1323
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1363
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1378
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1406
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1408
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1421
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1441
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1446
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1501
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1503
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1539
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1558
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1581
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 1582
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 2250
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Volumes/t/forum/convert.php on line 2250
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2091
Notice: Undefined variable: result in /Volumes/t/forum/convert.php on line 2092
MINI:forum njahnke$
i changed the db password to something simple (also changed it in smf) to make sure it wasn't choking on weird characters in the password, still a no go. works in the browser but i'd like to do this quickly if possible as i'll need to do it "for real" eventually and the old forum can't be live during that time obviously.
Is there the .sql script there?
You didn't specify it:
Quote--convert_script The name of the script. (old_forum_to_smf.sql)
If you need the name you could either browse there or just do the command "ls -a" (add g if your used to that type of output) and have it list out all the files in the current directory and copy and paste it :P
tried again in the browser before i got your last message, this time with everything locally though. left it until just now, was hung for ~12 hours, just like before, at:
/forum/convert.php?step=1&substep=0&cstep=11&start=0
now, every time it reloads, i got 100% cpu use from mysql, but i have to wonder whether it was actually accomplishing anything. going to try again from the commandline and see if there's any difference.
Do you know what query it is running that is doing that?
If that url is true then it is doing a step that does very minimal mysql usage (its converting the membergroups).
no i don't know the query - maybe if it hangs this time i can enable a debug mode for convert.php to print that information for you? and yes that would be strange especially given we only have like two usergroups on this forum.
Well debug from convert.php only outputs a little bit more informatin, it doesn't do to much more at the moment :P
Try enable logging for mysql (and slow query logging as well). See what query is possibly taking a long time or what the last query ran was (as the query with the problem should be shortly after that).
trying again now that my server is back up (was affected by the explosion at the planet).
can get through to "recalculating forum statistics" fairly quickly, but then things get really slow. got some slow queries for you:
# Time: 080606 17:28:02
# User@Host: sda[sda] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 0 Rows_examined: 231890
SELECT ID_MSG, temp_filename LIMIT 0, 100;lename != ''ges
# Time: 080606 22:33:49
# User@Host: sda[sda] @ localhost []
# Query_time: 18250 Lock_time: 0 Rows_sent: 0 Rows_examined: 1925863060
SELECT t.ID_TOPIC, COUNT(m.ID_MSLIMIT 0, 200; = 0ICsdaforum`.sda_messages AS m ON (m.ID_TOPIC = t.ID_TOPIC)
# Time: 080607 3:39:30
# User@Host: sda[sda] @ localhost []
# Query_time: 18341 Lock_time: 0 Rows_sent: 200 Rows_examined: 1925863260
SELECT LIMIT 0, 200;ST_MSG != myID_FIRST_MSG OR ID_LAST_MSG != myID_LAST_MSG OR numReplies != myNumReplies
# Time: 080607 8:35:27
# User@Host: sda[sda] @ localhost []
# Query_time: 17757 Lock_time: 0 Rows_sent: 200 Rows_examined: 1925863360
SELECT LIMIT 100, 200;_MSG != myID_FIRST_MSG OR ID_LAST_MSG != myID_LAST_MSG OR numReplies != myNumReplies
output looks like this:
MINI:forum njahnke$ php -f convert.php -- --path_to="/Volumes/t/forum" --path_from="/Volumes/t/yabb2bak" --db_pass=abc123 --convert_script=yabb21_to_smf.php
Successful.<br />
........................... Successful.<br />
Successful.<br />
..... Successful.<br />
. Successful.<br />
...................... Successful.<br />
......................................... Successful.<br />
................................ Successful.<br />
...... Successful.<br />
... Successful.<br />
... Successful.<br />
... Successful.<br />
.. Successful.<br />
Successful.<br />
............................... Successful.<br />
Successful.<br />
Successful.<br />
. Successful.<br />
* Recalculating forum statistics... ....
i guess those long queries are the last four dots. taking several hours each - i've never seen this complete before (always had to terminate it), so don't know how much longer it's going to take or even if the conversion is running properly. if we could optimize these it would be great because i will have to have my yabb forum down the entire time when i do the real conversion. thanks.
Ok, just kill that
Go into the SMF Admin panel
Then Forum Maintenance.
Do the Find and Repair Errors as well as Recount Totals and Stats options and let those run.
They are basically the same thing (minus a few things).
ok, running find & repair errors through the forum interface now - thing is it's still really slow - at only 15% after several hours - i can deal with it, just curious whether it's normal or if anything can easily be done.
For converting form a flat file system, yes it would be normal ;)
There are a lot of errors and issues that come from converting from a flat file system.
was able to speed up the error checking and total recounting phases dramatically by adding an index to ID_TOPIC in messages:
create index sda_messages_ID_TOPIC on sda_messages (ID_TOPIC);
they went from taking hours to minutes. either that or it was because i changed the first user on the new smf forum to have a unique username against the yabb forum - it matched a username on yabb before - i added the index and changed the username at the same time and then the speedup happened so i don't know which change did it. suspect it was the index though. now i can do the whole conversion in about 7 hours.
looking at the converted forum i noticed the converter aborted on contact with extended latin characters. so if a post contained "das wäre gut" then it only wrote "das w" in smf. this is not a big deal as i only had very few non-english posts in the old forum but i was wondering if there was a quick fix for the converter before i do this for real (probably tomorrow). thanks again.
is the SMF installed in UTF-8 or latin1 Database? (I Think it's a typical behaviour when SMF Installation is UTF-8).
maybe, you get better results with latin and after successfull conversion change it via ACP to UTF-8.
that was it - thanks!
successfully launched the new forum tonight. unfortunately i didn't notice until too late that all the pms were destroyed - the converter apparently was off by one field, so author was in date, etc, and the message text was totally lost. i don't care that much, but i'll have to retrieve people's pms from the old forum in plain text on request. just a heads up in case that's an easy fix.
I have just downloaded the latest yabb-smf convertor.
I have done a new smf install. I have checked that I can login to the new board. I have uploaded the yabb-to-smf and the convert php files. I have accessed the convert programme in my browser (FF3) and I get a blank screen with done on the footer bar of the browser. I did not get the options everyone else is mentioning in this thread.
I have obviously missed something. Anybody got any bright ideas?
TIA
Colin
A blank screen usually indicates that a fatal error has occurred and the php is not allowed to echo it out.
You will need to ask your host where php error logs are kept, so you can access them and look at what error is being generated here.
That error is going to help out, otherwise we could try hundreds of things and it would be like finding a needle in a haystack :(
For some reason I'm having trouble getting the convert.php to recognize my SMF database password. I've tried several clean installs and nothing will seem to make the converter recognize my database password.
So, I'm thinking that I'm going to completely start over from scratch, and list the steps that I've been doing and maybe someone can point out what I'm doing wrong.
1. Install SMF via cPanel. When I do this step, I'm asked for an admin username and admin password. This is the SMF database password right? This is what I've been trying to use, although I've also tried looking for a password to my YaBB database, but I'm not even sure where the database is for YaBB, it's not listed with all the other ones on my server.
2. After I've installed SMF, I upload the zipped converter files (convert.php and yabb21_to_smf.php) to the SMF directory and unzip them.
3. After I've done this, I open the URL for the convert file to begin conversion. I set the directories to the corresponding forum directories and then when I go to put in the database password, this is where I get stuck.
Where should I be finding the password I'm supposed to use and is it the password for the SMF database or the YaBB database that I should use?
It is the smf password it uses to connect to the database. This is for security reasons only.
Quote from: SleePy on August 02, 2008, 01:08:44 PM
It is the smf password it uses to connect to the database. This is for security reasons only.
Okay, so if I'm installing SMF via cPanel that would be the admin password I put in right? If so, that hasn't been working...
I've also tried creating a mySQL user with a password and adding it to the SMF database, but that isn't working either. Is there any kind of coding file that I could look through to find the password?
If you installed SMF via cpanel, you most likely where not told the mysql database password.
Open the Settings.php file, in there is a $db_passwd field. It contains your database password inside the quotes.
Quote from: SleePy on August 02, 2008, 01:15:10 PM
If you installed SMF via cpanel, you most likely where not told the mysql database password.
Open the Settings.php file, in there is a $db_passwd field. It contains your database password inside the quotes.
Awesome, I'll try that and that should most likely work.
Successfully converted everything except for poll votes, no big deal. Except that when I go to the SMF board, there are no posts there, just looks like the members, boards and categories transferred over. Guess I'll re-read through this thread to see what went wrong.
Okay, it doesn't look like the conversion is completing because of the poll votes error. Here's some screenshots of the error, any suggestions?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi247.photobucket.com%2Falbums%2Fgg134%2Fshanksta13%2Fpage1.jpg&hash=d01361fe065b08fed558a9c8f2b0d70008b21a2e)(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi247.photobucket.com%2Falbums%2Fgg134%2Fshanksta13%2Fpage2.jpg&hash=2607659007866d994a52a6718e9246406d24835a)
Give the one attached to the first post in this topic a try :)
Quote from: SleePy on August 02, 2008, 01:47:15 PM
Give the one attached to the first post in this topic a try :)
Just ran that on a clean install no change. Based on the other guy that had poll problems seems like I might have to try and delete the multiple poll IDs... no idea how to do that, though. I'd rather not have to delete all my polls.
I can easily see the duplicate on the error message, but I'm not sure how I'd go about finding that in the YaBB files.
Any suggestions, nothing obvious sticks out to me after looking at the yabb poll file.
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.
Quote from: SleePy on August 02, 2008, 02:45:15 PM
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.
Worked like a charm, thanks a ton!
What does mean the "Warning: set_time_limit() has been disabled for security reasons in /home/****/public_html/smf/convert.php on line 29" ?
the convert.php uses set_time_limit() to increase the maximum execution time for itself... On bigger board the conversion took a while and most hosts have limitations for executing scripts.
the error above means that your host doesn't allow to increase the script execution time.
If you have a smaller board the conversion is possible, if you have a big board the conversion possibly fails. Then you can only make a backup of your old board, install a local webserver enrironment (XAMPP for example) and convert on your local computer.
Quote from: SleePy on August 02, 2008, 02:45:15 PM
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.
Hi Sleepy,
Conversion worked really well for my site, everything I needed seems to have been converted. Have just noticed the user "post count" is not incrementing, same for all users and admin. Any thoughts?
Thanks
Have you tried to go to Admin -> Boards.
Then check each board to make sure Count posts option is checked? This may not be checked.
Aghhhhhhhhhh you are right, looking for the difficult option I totally missed the obvious! Its odd that another fresh install I made of SMF was fine, but the yabb conversation wasnt.
Thanks, help is very much appreciated
does it really take more than 12 hours to complete the "clean up"??
it has been converting for more than 12 hours now.... im getting worried about this.
Quote from: enna on January 25, 2009, 12:21:54 AM
does it really take more than 12 hours to complete the "clean up"??
it has been converting for more than 12 hours now.... im getting worried about this.
Uhh, sounds like you are using our
old Yabb Converter. You'll find a new version attached. The old converter removes some indexes from the SMF database tables during the conversion. Therefore it's better to start with new SMF installation, then use the attached converter..
thanks i got it running again but then another error occured.. i got an unsuccessful convert with registering statistics
it says:
Converting...
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `NAME_forum`.NAME_topics
ADD PRIMARY KEY (ID_TOPIC),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD),
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE poll (ID_POLL, ID_TOPIC);
Caused the error:
Duplicate entry '0' for key 1
well i know i already posted this... so sorry for the double post... just gets confusing sometimes.
ok, maybe we can solve this without re-conversion. can you try this please:
go to phpMyAdmin ( What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0) ) and execute the following database queries:
UPDATE smf_topics SET ID_LAST_MSG = ID_LAST_MSG + 1000000;
UPDATE smf_topics SET ID_LAST_MSG = ID_FIRST_MSG + 1000000;
then go to SMF - Admin - Forum Maintenance and click "Find and repair any errors" and "Recount all forum totals and statistics".
thank you very much.
I did it and this error came:
Error
SQL query:
UPDATE smf_topics SET ID_LAST_MSG = ID_LAST_MSG +1000000;
MySQL said: Documentation
#1146 - Table 'NAME_imga1.smf_topics' doesn't exist
(i just replaced my account with "name")
sorry, my mistake.. you used a different table prefix and the table is named camileve_topics instead of smf_topics.
try it with:
UPDATE camileve_topics SET ID_LAST_MSG = ID_LAST_MSG + 1000000;
UPDATE camileve_topics SET ID_LAST_MSG = ID_FIRST_MSG + 1000000;
thank you very much. I am workin on it. Will let you know. Greatly appreciate the help!
Hi,
I'm thinking of changing from YaBB to SMF. I tested to convert from the YaBB 2.1 -> SMF. All works fine but atleast things listed below are one problem. Anyone have suggestions how to fix em' ?
- Attachments do not convert. SMF attachments directory is empty, mysql attachments don't have any data. No errors in the conversion program.
- In private messages, I see 300 posts even though there should be only 58. Those posts seem to be related to topics I have posted something and not my actual pm's.
Thanks.
Give this file a try.
Quote from: SleePy on May 28, 2009, 06:11:49 PM
Give this file a try.
No change.
Also one problem is that Scandinavian characters like Ä and Ö are not showing at all. They have been replaced by "?" character.
I will try to convert my yabb to clean 2.2 version without any modifications. And then convert to SMF. Hopefully it will solve these problems.
Quote from: temestos on May 30, 2009, 01:59:59 PM
Also one problem is that Scandinavian characters like Ä and Ö are not showing at all. They have been replaced by "?" character.
This is UTF-8 related..
see UTF-8 Readme (http://docs.simplemachines.org/index.php?topic=865)
Hi,
I found problems to import the attachments of yabb, we solve changing this SQL in line 1220 of yabb21_to_smf.php, it has an error with real_id and temp fields, now it works:
$result = convert_query("
SELECT m.ID_MSG, con.real_id as temp_filename
FROM {$to_prefix}messages AS m
INNER JOIN {$to_prefix}convert AS con ON (con.temp = CONCAT(m.posterTime, ':', m.posterName))
WHERE con.type = 'msg_attach'
LIMIT $_GET[substep], $block_size");
Thanks
Regards
Lucas
Hi,
Another problem with yabb and iso8859-1 to utf8.
When we need to import the yabb to smf our forum files are in iso8859-1, the solution is convert all the files of yabb to utf8, we use this .sh:
--------------
#!/bin/bash
ICONVBIN='/usr/bin/iconv' # path to iconv binary
if [ $# -lt 3 ]
then
echo "$0 dir from_charset to_charset"
exit
fi
for f in $1/*
do
if test -f $f
then
echo -e "\nConverting $f"
/bin/mv $f $f.old
$ICONVBIN -f $2 -t $3 $f.old > $f
else
echo -e "\nSkipping $f - not a regular file";
fi
done
--------------
Later we execute this .sh in the directories Messages, Boards and Members of our yabb forum to convert all the files to utf8.
The sintaxis to run the .sh are:
file.sh directory_to_convert from_characterset to_characterset
example for directory messages:
/path_of_sh/name_of_sh.sh /path_of_your_yabb_directory/Messages iso-8859-1 utf8
With this files in utf8 and the solved attachments import the conversion works fine.
Thanks for the conversion script ;)
Regards
Lucas
Just converted from YaBB 2.1 over to SMF today. I can tell that all of the posts were converted (topic and post totals match), but some of them are not showing up. In many threads, only the first page of 25 posts are viewable. There are quite a few 20+ page threads on this forum so it's a major problem.
What could be the cause of this problem and is there any way to fix it?
Thanks.
When i convert my board than i missing the Attachment on the Posts ... !?
Have you a Solutions vor this problem !?
I am coverting Yabb 2.1 to SMF. First I tried it with the newest version 2.0.8 and later with 2.0. Still I get this error:
QuoteConverting membergroups...
Unsuccessful!
This query:
REPLACE INTO `XXXXX_smf`.smf_XXXXXmembergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars)
VALUES (2, SUBSTRING('Global Moderator', 1, 80), SUBSTRING('blue', 1, 20), '-1', SUBSTRING('5#stargmod.gif', 1, 255)),
(3, SUBSTRING('YaBB Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('5#starmod.gif', 1, 255)),
(1, SUBSTRING('Admini', 1, 80), SUBSTRING('red', 1, 20), '-1', SUBSTRING('0#staradmin.gif', 1, 255));
Caused the error:
Unknown column 'groupName' in 'field list'
Any thoughts how to fix this?
Quote from: Bazie on August 16, 2014, 09:32:41 AMAny thoughts how to fix this?
Help, please :)
SMF 1.1 RC3 is mentioned on starting post but I can't install 1.1 because of newer version MySQL :-\
For SMF2 you should use the converters from the download page:
http://download.simplemachines.org/?converters;software=yabb
Use 2.0.8 as the database schema is the same in all 2.0.x range ;)
Quote from: margarett on August 27, 2014, 01:31:27 PMFor SMF2 you should use the converters from the download page:
http://download.simplemachines.org/?converters;software=yabb
Use 2.0.8 as the database schema is the same in all 2.0.x range ;)
Now I did a fresh install of 2.0.8. Then I used converter from link above. Now I get this error message:
QuoteConverting...
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) { - => array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) {
- => &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
- => &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
- => &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/XXXXXX/public_html/forum/convert.php on line 2864 and defined in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 530
Notice: Undefined variable: table_name in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''
Quote from: Bazie on August 27, 2014, 01:46:01 PMNow I did a fresh install of 2.0.8. Then I used converter from link above. Now I get this error message:
QuoteConverting...
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) { - => array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) {
- => &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
- => &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) {
- => &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/XXXXXX/public_html/forum/convert.php on line 2864 and defined in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 530
Notice: Undefined variable: table_name in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''
Any help on this?
Case closed: http://www.simplemachines.org/community/index.php?topic=445475.msg3768509#msg3768509 :D