Hi there,

I used your migrator and it worked like a charme. The only problem is that I (me, myself, blah ;) ) made a mistake. Since I had to change something in the script, I had to execute it twice. The first time was not completed successfully, but the second did. The result is that I have a great number of "double postings" in my forum. There are many postings added twice by the migrator where the commentid is not the same, but the content/body is.

Anyone got an idea how to fix this? I'd like to use phpmyadmin to simply delete the double entries, but I dont know why. Especially since there are no double commentids, but double contents...

This is really wierd. Can anyone with more of a clue than me look at the code (which hasnt changed for quite some time) and explain why it works 'fine' for some people and breaks for others?

bezoard - just to double check it wasnt a transfer error somewhere, try re-downloading and uploading the migrator. If that doesnt help i'll try thinking deeper.

akb - if you ran the script twice it's natural it would have doubled some stuff up. All i can suggest is to flush and start over. Sorry it took a while to reply - i'm sure i responded once but it turns out i must have been dreaming.

Right. I think i might know why. Can you guys grab the latest copy (0.4S) from my server and run through it and see what you get. I'm pretty sure you'll get data transfer errors but you shouldnt get code execution errors.

Hmm. Well you could make a script which ran through the entire database and checked if there was a post with the same phpBBid value and deleted one if so (which would take a fair bit of time)
What might be easier is to wipe everything which *has* a phpBBid value (your new comments shouldnt do) and then run the migrator again on the old set of data. I think that should be easier and less resource intensive. Though whether you can wipe all the phpBB stuff with a single command i'm not sure.

Before you do anything, though, backup your current stuff :)

i got something for these parse errors. theres one line few lines above with an syntax error. in case of comments.php this error is at line 74. the line says:

echo "<br> ERROR ROW ".$count.";

but has to be

echo "<br> ERROR ROW ".$count;

since the last added quote "comments" all the following out.

edit: btw... minisweeper, it worked :-) i killed all phpbbpostid != 0, exported the entries that were not killed (the new ones after migration), emptied the table and imported again. now i got no double postings any more :-)

here are the problems basicly nothing is working. my version of
phpbb is 2.0.11

when i click on users i do get errors, and when i click on "Click here
to go back" it says "Users (264 rows migrated in 0.823520seconds)"
but when i check the database (via phpmyadmin) no users have been
migrateed
-----------

when i click on discussions i get the following error for every row of
discussions

run: 0

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/meloun00/domains/melounge.net/public_html/forum/migrator/discussions.php
on line 37

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/meloun00/domains/melounge.net/public_html/forum/migrator/discussions.php
on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/meloun00/domains/melounge.net/public_html/forum/migrator/discussions.php
on line 49

ERROR ROW 0

-----------

and when i click on comments i get the following for every row in the
comments table

run: 0
0,
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/meloun00/domains/melounge.net/public_html/forum/migrator/comments.php
on line 36

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/meloun00/domains/melounge.net/public_html/forum/migrator/comments.php
on line 56

ERROR ROW 01,

sorry but i'm an idiot i just remembered that my forum was hacked by yusuf kara. apparently he ownz my shit. rather than unhacking it i just i decided to migrate to vanilla. not sure if that is going to cause a problem with the migration script. you can see the results of maladjusted 13 yr olds with too much time on their hands at http://www.melounge.net/forum_old

that aside
no errors on SELECT user_id,username.........
no errors on SELECT forum_id,forum_name.....
no errors on SELECT topic_id,forum_id,topic_title....
no errros on SELECT post_id,topic_id,poster_id.....

You get no errors? Wtf? Remind me to look at this in the morning, sorry.

grab it from me here - http://www.backendscience.com/migrator.zip

No probs. Bobert - can you add in an
echo $phpBBcommentquery;
into comments.php just after $phpBBcommentquery is defined (and do similar to the rest of the files) then run through it again and check that the queries it's running arent messed up in some way. If you then put *those* queries through your phpMyAdmin and see what results it gets i'd appreciated it.

so phpcommentary was defined only in comments.php
as $phpBBcommentquery = mysql_query("SELECT post_id,topic_id,poster_id,post_time,poster_ip,post_edit_time FROM $phpbb_posts ORDER BY post_id ASC LIMIT $count,$limit");

i then inserted afterwards
echo $phpBBcommentquery;

and i did not see anything. honestly i am confused as to what i could have a seen as i thought that $var = mysqlselect("sql statement") would only store a resource. and i could not use that resource in phpmyadmin

Well naturally in the rest of the files the variables were named phpBBtopicquery, phpBBforumsquery and phpBBuserquery. It is however my mistake that echoing it wouldnt have shown the query it was running, though it should atleast have said Resource ID #N. Did it do that or not?

I didnt realise you had come across as a dick so no worries :)

Grab the latest version from my site (0.5) HERE and run that through. It'l chuck out all the queries it's using so hopefully we can see if it's going wrong atall anywhere just to satisfy me.
If it's not the queries *then* i'm getting confused.

so i edited the users file to view the error produced by each insertion of a user into the vanilla db

(because there HAS to be one) by outputting mysql_error. however when i store the resource id of the

query and do mysql_error($result) i get
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource

also i'm not sure if
mysql_query("ALTER TABLE `$LUM_User` ADD `phpBBuserid` INT( 10 ) NOT NULL AFTER `UserID`");
works

when i do
$result = mysql_query("ALTER TABLE `$LUM_User` ADD `phpBBuserid` INT( 10 ) NOT NULL AFTER `UserID`");
and then do echo $result, i do not get a valid resource


//--------------------------------------
$result = mysql_query("
INSERT INTO `$LUM_User` (`phpBBuserid` , `RoleID` , `FirstName` , `LastName` , `Name` , `Password` ,

`Email` , `UtilizeEmail` , `ShowName` , `Icon` , `CountVisit` , `CountDiscussions` , `CountComments` ,

`DateFirstVisit` , `DateLastActive` , `LastDiscussionPost` , `LastCommentPost` )
VALUES (
'$phpBBuserid' , '$RoleID' , 'phpbb' , 'user' , '$Name' , '$Password' , '$Email' , '$UtilizeEmail' ,

'0' , '$Icon' , '$CountVisit' , '$CountDiscussions' , '$CountComments' , '$DateFirstVisit' ,

'$DateLastVisit' , '$LastDiscussionPost' , '$LastCommentPost'
)
");
echo "result: $result";
echo mysql_error($result);

i have a bloated vb db that will be getting ported soon too, i was planning on hacking this script apart to do it. any advice? :)

yes, i have 12k members, roughly 120k posts, and am expecting it to be properly un-plain sailing. of course, i'd be happy to whittle these numbers down slightly before porting, but not that much, heh.

Does anybody know how I can remove the strange numbers/letters (the post uid), would it be possible for someone who programs PHP to make a script like those included in the migrator, something like phpedi_remove.php, which i could upload and execute?

This would be so much help, and I'd be able to get Vanilla running for my project...

Sorry if i missed it, where does this line of code go?

Cheers for looking after the dudes (better than i could have done, infact) in my absense, sirnot.
chris: i *believe* the latest version should actually handle that size of database. I'm pretty sure the changes i made to the comments migrator in particular encouraged it to handle any number you could throw at it - users might cause more of a probem because i assumed there would be very few cases where an enormous number of users would need to be moved so i didnt bother making similar changes to the script. I do believe, however, it should handle about 30k no probs (i've had it do that many comments on the old method, and theres a lot less work involved migrating users); though that depends on the server.

bobert - sorry if i've missed it; i've tried reading the forum but catching up with a weeks hyperactive posting while uber tired (i've been up since half 3am (it's half 5pm now)) and travelling a few k miles has left me a little weary so it's quite likely i've missed stuff. - anyway, did you grab the latest version and run the queries the script echo'd with all the variables evaluated and such to see what happened in phpmyadmin?

everyone else complaing about the bbcode bit - through my own admission i suck at regex (and infact coding in general, i really built this thing as a bit of fun practice to try and help out those who needed it) - try implementing sirnot's changes and see what happens. Come back with results and hopefully between us we can work something out for you.

Hmmmm ... might have to try this out. Got just over 800 users and 4000 posts. At least I have the luxury of time to see if it'll work for me! :)

All seems to work for me but the categories.php. Get a mysql error every time. Everything else seems to work just fine.

if that question was for me, the vanilla installtion went just fine. is there a query i should run for you to verify

that link doesnt work. went to http://www.int0rw3b.com/migrator.php and just got a 404 error

Hi there!

I followed your link to the migrator... you a little error on your
categories.php file...

at around line 36:

$insert = mysql_query($inserquery);

the argument the mysql_query should be $insertquery.. just a missing "t".

By the way, nice work on the migrator. But phpBB posts using BBcode will not be translated into its equivalent form.

I think the half-dozen or so regexes in the BBCode plugin should be able to handle that; just run them after import.