Announcement

Collapse
No announcement yet.

Error trying to import a database

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

  • Error trying to import a database

    I'm getting an error when using in Impex to import a database, I've read through the other posts and the problem has cropped up before, but the solution given is not appropriate to the problem I', having.
    I've submitted a support ticket but haven't had a reply in about 12 hours.

    When I try to import via the ACP or directly I get the following error :

    Code:
    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: Wednesday 13th 2013f November 2013 11:03:22 AM
    Database: footbal9_football
    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
    I also get an error in the Primary tables ( accessmasks) if I try to import via phpmyadmin

  • #2
    Edit your /impex/index.php file and about halfway down is this line:
    HTML Code:
                          ) TYPE=MyISAM
    change it to:
    HTML 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


    • #3
      That has cured the one problem, but I now get this error when I try to connect :

      Code:
      ImpEx Database error
      
      mysql error: Link-ID == false, connect failed
      
      mysql error:
      
      Date: Thursday 14th 2013f November 2013 04:16:04 PM
      Database: talkofth_vb
      MySQL error:

      Comment


      • #4
        I changed it to and it fixed the first problem now I am getting the same error as Graham

        ImpEx Database error mysql error: Link-ID == false, connect failed mysql error: Date: Thursday 14th 2013f November 2013 04:16:04 PM Database: talkofth_vb MySQL error:

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X