Jump to:

23459 Posts in 18906 Topics by 2877 members

General Questions

SilverStripe Forums » General Questions » Import SQL data problems

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 861 Views
  • steve_nyhof
    Avatar
    Community Member
    224 Posts

    Import SQL data problems Link to this post

    Hi All,

    I have been successful on this several times, but I have also not been successful at importing the sql file into another site to duplicate sites - then just make a few changes.

    Does anyone have a "best" way to export (phpmyadmin options???)
    Then import without issues. I have the same server, nothing different going on. I tried Insert/Update/Replace options, but even when I did not get an error, nothing was added to the new site.
    Also, I thought an INSERT would add what ever columns missing??
    This is the error I get...
    .
    .
    .
    Error
    SQL query:

    --
    -- Dumping data for table `Group`
    --
    INSERT IGNORE INTO `Group` ( `ID` , `ClassName` , `Created` , `LastEdited` , `Title` , `Description` , `Code` , `CanCMS` , `CanCMSAdmin` , `Locked` , `Sort` , `ParentID` , `IPRestrictions` )
    VALUES ( 1, 'Group', '2008-08-29 16:20:09', '2008-08-29 16:20:09', 'Administrators', NULL , 'administrators', 0, 0, 0, 0, 0, NULL ) , ( 2, 'Group', '2008-12-14 17:10:03', '2008-12-14 17:10:31', 'Mailing List: Websites', NULL , 'websites', 0, 0, 0, 0, 0, NULL ) ;

    MySQL said:

    #1054 - Unknown column 'IPRestrictions' in 'field list'

    ----

    I also get this...
    .
    .
    .
    Error
    SQL query:

    --
    -- Dumping data for table `ArchiveWidget`
    --
    INSERT INTO `ArchiveWidget` ( `ID` , `DisplayMode` )
    VALUES ( 3, 'month' ) , ( 6, 'month' ) ;

    MySQL said:

    #1062 - Duplicate entry '3' for key 1

    ----------------
    No mater what I try I get errors, over and over. I have in the past imported, and all worked perfect - ?!?!

    861 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.