Announcement

Collapse
No announcement yet.

Error restoring DB to another host

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

  • Vinyljunky
    replied
    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

    Leave a comment:


  • Boxy
    replied
    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);

    Leave a comment:


  • Vinyljunky
    started a topic Error restoring DB to another host

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X