Announcement

Collapse
No announcement yet.

Error restoring DB to another host

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

  • Error restoring DB to another host

    Dear Gurus

    Im in the process of seting up a VB test site. I have dumped my DB and Im trying to import it on another host using phpMYadmin.

    Im going from mysql 4.0.22 To 4.1.22

    However part way through the import I get the error below

    Code:
    Error
    SQL query: 
    --
    -- Dumping data for table `holiday`
    --
    --
    -- Table structure for table `icash_donations`
    --
    CREATE TABLE icash_donations(
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    FROM text NOT NULL ,
    TO text NOT NULL ,          [COLOR=red][B]I get an error icon on this line[/B][/COLOR]
    amount int( 11 ) NOT NULL default '0',
    time text NOT NULL ,
    PRIMARY KEY ( id ) 
    ) TYPE = MYISAM ;
     
    MySQL said:  
    #1064 - 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 'from text NOT NULL,
      to text NOT NULL,
      amount int(11) NOT NULL default '0',
    ' at line 3
    Can anybody help?

    Many Thanks

    VJ
    Last edited by Vinyljunky; Mon 25 Jun '07, 5:47am.

  • #2
    icash_donations is not a default vBulletin table. This error is likely being caused by a plugin or modification you have installed.

    Disable the plugin system and see if you have the same problem. Edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    Comment


    • #3
      Yes you are quite right its not a default plugin

      My forum works ok I just cant restore it. Its as if there is an error in the SQL itself

      I just dont understand how its functioning if there is an error in the code

      I'll ask over at vbulletin.org (again)

      Regards

      VJ

      Comment

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