mysql error number: 1146 - Help please.

[jd-inflames]

Ok, I MIGHT be doing this wrong alltogether, but some of the instructions were confusing me. Just so everyone knows, I'm updating a IPB 1.3 database into vB 3.0.3...if that helps any.

I'm testing this out on my computer (I use appserv) to make sure that I'm doing it right, just because it's much faster than doing it online. Ok, now that you have all that information, here is my config:

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.

targetdatabasetype  = mysql
targetserver        = localhost
targetuser          = "root"
targetpassword      = ""
targetdatabase      = forums
targettableprefix   =

[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists        = TRUE

sourcedatabasetype  = mysql
sourceserver        = localhost
sourceuser          = "root"
sourcepassword      = ""
sourcedatabase      = cptest
sourcetableprefix   = ibf_

Ok, just to be sure, the Target database is the vB database, right? And the source would be my IPB? Just about everything in editing the config confused me sadly...All of the information in there is correct (there are no passwords on my test server), are we supposed to have the quotes?

Here is the error messege when I open up AdminCP and hit Import/Export:

Database error in vBulletin:ImpEx Target 3.0.3:

Invalid SQL: SELECT title, data FROM datastore WHERE title = 'ImpExSession'
mysql error: Table 'forums.datastore' doesn't exist

mysql error number: 1146

Date: Thursday 21st of October 2004 12:19:54 PM
Script: http://localhost/test2/impex/index.php
Referer: http://localhost/test2/admincp/index.php?do=nav
Username: jd-inflames
IP Address: 127.0.0.1

Help please?

[Steve Machol]

Yes, the target database is vB. Try running this script to fix the datastore problem:

http://www.vbulletin.com/forum/showp...68&postcount=7

[jd-inflames]

Rebuilding options
Fatal error: Call to undefined function: build_datastore() in d:\web\www\test2\includes\adminfunctions.php on line 1836

=/

[Steve Machol]

Reupload your original vB files.

[jd-inflames]

I am. I'm going to go ahead and put it on my server and try it there, that way you can see the problems if I continue to run into them.

[jd-inflames]

Ok, I got it all working now. It must have been something wrong with my computer, because once I put it on my server it worked fine.

Only one problem however, it reads every forum as though it was a parent forum =/ In otherwords, I'm going to have to redo all of my forums so that the structure is correct again.

Other than that, this is a very brilliant script.

[s7az2mm]

Hi all.

I have this Problem to import IPB 2.0.0 ... ( jd-inflames's Problem )
i downloaded "
http://www.vbulletin.com/forum/show...568&postcount=7 " and run it. but this error Show " Rebuilding options
Fatal error: Call to undefined function: build_datastore() in F:\Sub domains\sites\forums\includes\adminfunctions.php on line 1836 ".
My Web server is Windows 2000. what me work to import IPB 2.0.0 Too Vbulletin
TNX. This is Very Necessary.
Please Guide me..
very TNX.

[Steve Machol]

Reupload the original .php files in the includes directory. Make sure you upload in ASCII and overwrite the ones on the server.

[s7az2mm]

I Upload original files in Include directory...
But that error show me again.
what me work ?

[Steve Machol]

Honestly I don't see how it's possible to get that error if you are using the original vB files. If you have not installed any hacks (which includes portals), fill out a support ticket at:

http://www.vbulletin.com/members/mem...ontactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.