Invisionfree conversion quick question

[danny7633]

Ok, I have my dump. I have my database setup. I installed the tables from the TXT file Jerry provided. I am using bigdump to restore from the sql file. I am getting an error



Error at the line 82919: INSERT IGNORE INTO ibf_calendar_events (eventid, userid, year, month, mday, title, event_text, read_perms, unix_stamp, priv_event, show_emoticons, event_ranged, event_repeat, repeat_unit, end_day, end_month, end_year, end_unix_stamp, event_bgcolor, event_color) VALUES ('34006','1','2006','1','6','mydata ','*','1136613599','0','1','1','0','w','8','1','20 06','1136786399','red','white');

should I manually remove these instances from my dump? I understand that there is no table for calendar.

Also, my Impex- i followed the instructions but it does not show up in the Admin CP. It does appear to work when I navigate to /forum/impex should I use it this way? Not sure why it isnt in my Admin CP - Are there any additional steps to take to get it there?

[Steve Machol]

For this to show up in ther Admin CP you need to upload the file cpnav_impex.xml (which can be found in upload/includes/xml) to the includes/xml directory.

I'm not sure about that error. How was the IBF backup made?

[danny7633]

thank you for your reply. I had to manually remove those tables and I was able to use bigdump to get the sql into the database. I was able to get the import into the admincp, thanks -

however when using the import I am getting an error when I run the importer when it analyzes the database:




I verified connection settings and verified the prefix in the impexconfig

Any ideas?

[Steve Machol]

Honestly if the info in ImpExConfig.php was correect then I do not see any way to get that error.

Why did you manually remove tables and which ones did you remove?

[danny7633]

I removed the ones which were giving error messages when trying to load the dump. The messages referred to the fact that there were no tables to place the data into.

[Steve Machol]

I don't think you can simply remove tables from the backup and have it work. Which tables did you remove?

[danny7633]

I don't think you can simply remove tables from the backup and have it work. Which tables did you remove?edit. Should I just try to load the database from the command line?

[Steve Machol]

It would appear you removed tables that vB needs in order to import the data.

[danny7633]

I think I made a mistake when I originally posted that.

I also dont understand what this instruction means


If you create the tables in a database with the attached SQL, you can then restore the invision free SQL into it with ignoring the INSERT's for the tables that ImpEx doesn't use in a IPB1.3 import thus

[danny7633]

im not sure how to "ignore" the inserts.

[Steve Machol]

I don't know what that means either. Where are those instructions?

[danny7633]

http://www.vbulletin.com/forum/showthread.php?t=116398 bottom of the page.

[Steve Machol]

I'm afraid I'm going to have to defer to Jerry on that one. Sorry.

[danny7633]

if it helps, this is what invisionfree told me

You can download the data (71.3MB) at ***

Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
ibf_badwords
ibf_posts
ibf_calendar_events
ibf_categories
ibf_contacts
ibf_emoticons
ibf_forums
ibf_groups
ibf_members
ibf_messages
ibf_moderators
ibf_polls
ibf_stats
ibf_titles
ibf_topics
ibf_tracker
ibf_voters
ibf_cache_store
ibf_forum_perms
ibf_topic_mmod
ibf_validating;

or you can use these queries:




CODE DELETE FROM ibf_badwords;
DELETE FROM ibf_posts;
DELETE FROM ibf_calendar_events;
DELETE FROM ibf_categories;
DELETE FROM ibf_contacts;
DELETE FROM ibf_emoticons;
DELETE FROM ibf_forums;
DELETE FROM ibf_groups;
DELETE FROM ibf_members;
DELETE FROM ibf_messages;
DELETE FROM ibf_moderators;
DELETE FROM ibf_polls;
DELETE FROM ibf_stats;
DELETE FROM ibf_titles;
DELETE FROM ibf_topics;
DELETE FROM ibf_tracker;
DELETE FROM ibf_voters;
DELETE FROM ibf_cache_store;
DELETE FROM ibf_forum_perms;
DELETE FROM ibf_topic_mmod;
DELETE FROM ibf_validating;

[danny7633]

I'm afraid I'm going to have to defer to Jerry on that one. Sorry.


Ok well I started over from scratch. I uploaded the original dump unedited, made a database, and when I try to import to that database using SSH command line I get the following error


"ERROR 1146 (42S02) at line 82919: Table 'turboop_freeforum.ibf_calendar_events' doesn't exist"

Yes, I have created the tables from the list Jerry provided in the TXT file.

ANY IDEAS?

[danny7633]

Ok ladies and gents. This was 100% my fault. I was trying to use BIGDUMP a PHP based utility that takes a dump and restores it to SQL. WEll, problem is that there are a switches (-h -f) that I am assuming mean FORCE that are required and this HAS to be run at the SSH command line. I read the directions over again, used everything word for word and its working great. All my members were banned at first but as explained in the directions permissions need to be reset.

THANK YOU VBULLETIN!! SORRY I DIDNT FOLLOW DIRECTIONS.

[Steve Machol]

Glad to see you got it working. :)