AndyF Posted August 18, 2010 Share Posted August 18, 2010 InvisionFree Importer View File This small script facilitates the conversion to IP.Board 3.x from InvisionFree by providing the correct empty database tables required. This is usually required when converting from InvisionFree as the database backup as supplied expects an already existent 1.3 database to be present for the data to be inserted into. The script will create this for you and includes detailed step-by-step instructions to assist you. Now updated to include the newer stopped_ columns as found in later IF databases. Note this can be used to go from InvisionFree to IPS4 but you will require IPB3x to do this as you *must* convert to that first, then upgrade IPB3 to IPS4 as normal. Submitter AndyF Submitted 08/18/2010 Category Maintenance Supported Versions Link to comment Share on other sites More sharing options...
Maine Posted March 20, 2011 Share Posted March 20, 2011 Hi, thanks for the script. I tried using it, but I get this error when I import the sql on phpmyadmin: Is this a problem with my invisionfree database (.sql) file? Link to comment Share on other sites More sharing options...
AndyF Posted March 20, 2011 Author Share Posted March 20, 2011 I think so yes, as there's no stopped_posts or stopped_members in the db dump, at least the ones I have :). A typical line would look like this:INSERT IGNORE INTO ibf_stats (TOTAL_REPLIES, TOTAL_TOPICS, LAST_MEM_NAME, LAST_MEM_ID, MOST_DATE, MOST_COUNT, MEM_COUNT) VALUES ('17364','936','tester','138','1140742706','77','123'); I'll look into this later though, although I've never seen that error before. Link to comment Share on other sites More sharing options...
Maine Posted March 20, 2011 Share Posted March 20, 2011 ^ Ohhhh, thanks. I tried removing stopped_posts & stopped_members & '0' '0' and it uploaded successfully. I'll try to continue installing and share if I have installed it properly. Link to comment Share on other sites More sharing options...
AndyF Posted March 20, 2011 Author Share Posted March 20, 2011 Good to hear its OK. :) , I did test it on a couple of databases but that was all I could do to 'test' it really. If you want to (completely optional naturally) export the ibf_stats table for me and PM it to me I'll see what's going on. When I get a bit of time later today, I'll examine a few versions but I do not recall seeing that in any of them. I'd have to assume its a recent change from IF. Link to comment Share on other sites More sharing options...
Maine Posted March 20, 2011 Share Posted March 20, 2011 Hi Andy, the upgrade went well on my test forum, I shall do it on the actual site. Thanks for the script & help! Link to comment Share on other sites More sharing options...
AndyF Posted March 20, 2011 Author Share Posted March 20, 2011 You're welcome. Pleased it worked well. I will look into this stopped_x part as I did not have that in my test IF databases, although they are very old. Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 26, 2012 Share Posted February 26, 2012 Hi Andy, Thanks so much for your wonderful script! I actually used this on my board www.thebeyhive.com/board although it seems to have saved everything, I am getting 0 posts nor are none of the topics / threads showing up. Is there a way you could help fix this? Link to comment Share on other sites More sharing options...
AndyF Posted February 26, 2012 Author Share Posted February 26, 2012 Thank you for your feedback. :) Are the members present ? (ignore stats, look at memberlist for now) Edit a forums settings (pick one that you know has some topics present in it, the pencil icon) , on the "Postable Forum Settings" tab, scroll down to "Sorting / Ordering" , ensure that the sort filter is on "all topics" As its a very large upgrade, you'd need to run the Clean Up tools in System, then the Recount / Rebuild tools too. Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 26, 2012 Share Posted February 26, 2012 HI Andy! Thanks so much! I had started the recount / rebuild process earlier today, but when I had done so, I wound up seeing 0 posts, 0 topics,and 0 members, etc. so I figured I had done something wrong. Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 26, 2012 Share Posted February 26, 2012 Is there something that I should do after clicking rebuild / recount to make the posts turn up again? Link to comment Share on other sites More sharing options...
AndyF Posted February 26, 2012 Author Share Posted February 26, 2012 No, that should be it. I have tested it with a couple of db's and it worked fine. :) Can you use phpmyadmin ? , examine the ibf_members table. Ensure it is actually populated. Then do the same with the ibf_posts and ibf_topics tables too. It almost sounds as though your database from IF was not imported fully. What method did you use to import it ? Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 26, 2012 Share Posted February 26, 2012 Hi! I checked the tables and you are absolutely right. The ibf_topics tables is showing this message "Showing rows 0 - 0 (1 total, Query took 0.0009 sec)"I used the "import" tab to import my old .sql database. Link to comment Share on other sites More sharing options...
AndyF Posted February 27, 2012 Author Share Posted February 27, 2012 OK, so it was skipped. Start again with a new empty database, run the importer tool which will create the tables then upload the database via FTP to above public_html somewhere (so its not web visible) At this stage, contact your host and tell them to import the database you just uploaded to the new empty database for you. They will do it via shell which won't break, assuming the backup was OK (it would be very rare for that to be a problem) :smile: Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 27, 2012 Share Posted February 27, 2012 Hi Andy, our host (godaddy) actually told us that they would not help us with this issue. this is the message I got after trying to import the databases myself Link to comment Share on other sites More sharing options...
AndyF Posted February 28, 2012 Author Share Posted February 28, 2012 Ah. I have seen that before although the previous client who had that issue did not export the stats table for me to examine. This is something that was added to IF since my test db's were exported. How big is the database file ? (the actual 1234567890.sql) file ? One way assuming the file is not too big would be to manually chop that data out or I can do this for you if needed, if you are willing to .zip and send me your database. There are other ways too if not. :smile:EDIT... If you are comfortable one other alternative is to open a copy of the database .sql in notepad++ (don't do this if its massive > about 15 or 20 mb though) and find...INSERT IGNORE INTO ibf_stats (TOTAL_REPLIES, TOTAL_TOPICS, LAST_MEM_NAME, LAST_MEM_ID, MOST_DATE, MOST_COUNT, MEM_COUNT, stopped_posts, stopped_members) VALUES ('105838','1519','brebreyonce','1492','1326146646','433','1688','0','0'); Change to... INSERT IGNORE INTO ibf_stats (TOTAL_REPLIES, TOTAL_TOPICS, LAST_MEM_NAME, LAST_MEM_ID, MOST_DATE, MOST_COUNT, MEM_COUNT) VALUES ('105838','1519','brebreyonce','1492','1326146646','433','1688');Modify a copy, don't modify the original. That should work. The issue is those two fields were added after my last export so I don't have a structure for them, they are not afaik 1.3. Link to comment Share on other sites More sharing options...
TheBeyHive Posted February 28, 2012 Share Posted February 28, 2012 hey Andy, I've send you a personal message Link to comment Share on other sites More sharing options...
AndyF Posted February 29, 2012 Author Share Posted February 29, 2012 Rectified via PM. The small issue encountered was caused by the size of the source db, being so large it was not possible to import it easily via phpmyadmins importer. Link to comment Share on other sites More sharing options...
AndyF Posted March 6, 2012 Author Share Posted March 6, 2012 Some minor additions have been added to prevent the stopped_ issue from occuring again, although its only later exported databases that this might of occured with, not a problem in reality really but avoiding it erroring out at all is better. :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.