Announcement

Collapse
No announcement yet.

mysql error number: 1146 - Help please.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error number: 1146 - Help please.

    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:

    Code:
    [ 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:

    Code:
    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?

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

    http://www.vbulletin.com/forum/showp...68&postcount=7
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


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

      Comment


      • #4
        Reupload your original vB files.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          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.

          Comment


          • #6
            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.

            Comment


            • #7
              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.

              Comment


              • #8
                Reupload the original .php files in the includes directory. Make sure you upload in ASCII and overwrite the ones on the server.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


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

                  Comment


                  • #10
                    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.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment

                    Loading...
                    Working...
                    X