Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

[v0.2] phpBB Migrator

1111214161720

Comments

  • 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,
  • Ok. Can you run the following queries on your phpBB database for me and report the errors.
    SELECT user_id,username,user_password,user_email,user_viewemail,user_avatar,user_posts,user_regdate,user_lastvisit FROM phpbb_users ORDER BY user_id ASC

    SELECT forum_id,forum_name,forum_desc,forum_order FROM phpbb_forums ORDER BY forum_id ASC

    SELECT topic_id,forum_id,topic_title,topic_poster,topic_time,topic_replies,topic_first_post_id,topic_last_post_id FROM phpbb_topics ORDER BY topic_id ASC

    SELECT post_id,topic_id,poster_id,post_time,poster_ip,post_edit_time FROM phpbb_posts ORDER BY post_id ASC
  • edited February 2006
    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.....
  • never mind. unhacked the forum (had to delete the forum comments for a topic) and the migrator is still a no go
  • You get no errors? Wtf? Remind me to look at this in the morning, sorry.
  • I can not download the file from minisweeper's site to convert phpBB to Vanilla. Where else can I get it?
  • grab it from me here - http://www.backendscience.com/migrator.zip
  • minisweeper: i could not download the file to reimport (as described above) too, so i thought i'd have the latest version... since i did this thingy just few weeks before. but good to know you already fixed that :-) and glad to see you still maintain it :-) good work hunny
  • 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.
  • having server issues wil post update shortly
  • 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
  • btw SELECT post_id,topic_id,poster_id,post_time,poster_ip,post_edit_time FROM phpbb_posts ORDER BY post_id ASC does work within 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?
  • sorry. i didnt mean to come across as a dick i'm just generally confused at me being the only one to have a problem. you were right thought. it displayed resouce #n. so its running. thats also proven that the mysql_total_rows prodcues a valid number you can check out the results at http://www.melounge.net/forum/migrator/ i put the echo in h1 tags so that it would be obvious. as always let me know what i can do to be of assitance to get this thing working
  • 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.
  • sorry for the late reply but 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 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);
  • Whats the biggest phpBB forum someone has moved with this? Its not huge but I've got over 500 users and 40,000 posts (pruning is done regularly). I'd love to switch and help with this conversion app however I can.
  • 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? :)
  • i have 250 users and 13,500 posts and i am having heck of a problem
Sign In or Register to comment.