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.
I'm having a few problems migrating my forum, almost all of the phpBB tags are appearing with some strange numbers/letters, like so:- [b:a5ab13a41c]Adventures[/b:a5ab13a41c] -- A couple of pages back this was discussed, but I couldn't make out any conclusion? -- I'm not very code-leiterate.
phpBB uses two types of quote, I've noticed that type where you specify the user your quoting from doesn't migrate successfully:- [quote="Ao"]This is the quote from Ao[/quote] -- where, [quote]This is the quote[/quote] does.
Lists also don't migrate; in the phpBB they are generally formatted like this:
[list][*]Point One
[*]Point Two
[*]Point Three[/list]
If its too complex to migrate this feature, would it be possible that the tags be completely removed from the message body?
Thats all the problems i've come across so far, apart from that guy this is great!
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...
Well, haven't actually tried anything, but what I'd do is put it in line 54 of comments.php, replacing $body = $body['post_text']; with $body = preg_replace("/\[(\/?)(.+?):[\dabcdef]+?\]/", '[\\1\\2]', $body['post_text']); Although I'm still not 100% that preg_replace()'ll work...
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.
minisweeper the
Sql pulling the rows from phpbb is fine, yet the migrator is still not working
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
you can see more detailed info in the post above
Um. Hold on. Can i just check now that you actually have the full vanilla tableset installed? You need that before you use the migrator and it needs to be in the same database as your phpBB tableset.
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.
Thanks for the heads up. Changed that on the download.
And yeah, i know, regex and such arent my strong point. If you could implement the code to translate the stuff correctly i'd be more than happy to put it in the download copy :)
I'm migrating from another server. I have all of these options to check for my exported database--which ones should I select?
Structure only
Structure and data
Data only
Export to XML format
Add 'drop table'
Complete inserts
Extended inserts
Enclose table and field names with backquotes
Comments
$str = preg_replace("/\[(\/?)(.+?):[\dabcdef]+?\]/", '[\\1\\2]', $str);should work.
$body = $body['post_text'];with$body = preg_replace("/\[(\/?)(.+?):[\dabcdef]+?\]/", '[\\1\\2]', $body['post_text']);Although I'm still not 100% that preg_replace()'ll work...
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.