Announcement

Collapse
No announcement yet.

Error message

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

  • Error message

    Getting this error when trying to run impex. I have done the impex before and never had an issue. I am trying to import IPB 3.4.6

    ImpEx Database error

    mysql error: Link-ID == false, connect failed

    mysql error:

    Date: Friday 23rd 2014f May 2014 03:39:10 PM
    Database: myprefix_ipbforum
    MySQL error:

  • #2
    That looks like it couldn't connect to mysql. Is the information in your impex config.php file correct? That database must be on the same server as vbulletin.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      Yes, the database is on the same server and the info is correct.

      Comment


      • #4
        I'm having the same problem.

        Originally, i got this message:
        --------------------------------------------------------------------------------------------------------------------------------------------------------

        There seems to have been a problem with the database.

        ImpEx Database error

        mysql error: Invalid SQL: CREATE TABLE impexerror (
        errorid bigint(20) unsigned NOT NULL auto_increment,
        errortype varchar(10) NOT NULL default '',
        classnumber varchar(3) NOT NULL default '',
        importid bigint(20) NOT NULL default 0,
        error varchar(250) default 'NULL',
        remedy varchar(250) default 'NULL',
        PRIMARY KEY (errorid)
        ) TYPE=MyISAM

        mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

        mysql error number: 1064

        Date: Sunday 11th 2014f May 2014 05:54:28 AM
        Database: bargainf_vb4
        MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

        ​--------------------------------------------------------------------------------------------------------------------------------------------------------

        Someone told me to
        In the /upload/impex/ folder from the impex zip open the index.php file in notepad++ or similar and look at line 271:
        PHP Code:
        ) TYPE=MyISAM";


        Change to:
        PHP Code:
        ) ENGINE=MyISAM";





        After i did that, i got this message:

        There seems to have been a problem with the database.

        ImpEx Database error

        mysql error: Link-ID == false, connect failed

        mysql error:

        Date: Sunday 18th 2014f May 2014 07:49:28 AM
        Database: source
        MySQL error:


        I'm noticing now that the database is showing up differently now. I didn't set up the software, my host did.

        Any suggestions?

        Thanks

        Oh, and if you tell me to look at XYZ, please keep in mind i'm a total newbie so i may not be able to navigate myself around and find files as easily as an experienced user. Sometimes i see posts saying to change X but i wouldn't know where to find X.

        Comment


        • #5
          In the /impex/index.php file, change this line:
          PHP Code:
                              TYPE=MyISAM"; 
          to this line
          PHP Code:
                              ENGINE=MyISAM"; 

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools <- awesome site for html/css help

          Comment


          • #6
            Originally posted by Lynne View Post
            In the /impex/index.php file, change this line:
            PHP Code:
             TYPE=MyISAM"; 
            to this line
            PHP Code:
             ENGINE=MyISAM"; 
            Already did that and I am getting the same error as the poster before me. Obviously it is an issue with impex. Like I said, I have used impex several times in the past so I know what I am doing and it is not working.

            Comment


            • #7
              If you are now getting the message regarding "Link-ID" being false, then something is wrong with the credentials you have supplied in the impex config.php file - it can't connect to the impex database.

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools <- awesome site for html/css help

              Comment


              • #8
                Originally posted by Lynne View Post
                If you are now getting the message regarding "Link-ID" being false, then something is wrong with the credentials you have supplied in the impex config.php file - it can't connect to the impex database.
                I checked a config file from when I was using 4.1. Nothing has changed in how you fill out the config file and what I have is correct. It either does not work with one of the following vB 4.2, mysql 5.4 or IPB 3.4.6

                Comment


                • #9
                  It does work with 4.2, but I don't know about with PHP5.4 or IPB3.4.6 (it was last tested with IPB3.0.3 according to the manual).

                  Please don't PM or VM me for support - I only help out in the threads.
                  vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                  Want help modifying your vbulletin forum? Head on over to vbulletin.org
                  If I post CSS and you don't know where it goes, throw it into the additional.css template.

                  W3Schools <- awesome site for html/css help

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X