Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » Upgraded from 3.3 to 4.0 - sql issues
 
Thread actions
PDF Print this page
  • Print all pages

    • Upgraded from 3.3 to 4.0 - sql issues

    Posted by dkjkj posts: 2

    Just upgraded from 3.3 to 4.0 and I came across the following issues:
    INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (107,42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_list_newsletters','',0)
    Duplicate entry '107' for key 1
    INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Search','tiki-searchindex.php',13,'feature_search','tiki_p_search','',0)
    Duplicate entry '42-Search-tiki-searchindex.php-13-feature_search-tiki_p_search-' for key 2
    -- 2009-09-18 lphuberdeau
    ALTER TABLE `tiki_transitions` ADD COLUMN guards TEXT NOT NULL
    BLOB/TEXT column 'guards' can't have a default value

    Platform Linux OpenSuse 11.0 mysql.

    There was no visual effect on those warnings/errors.

    Reads: 1948
    Link
    Posted by Marc Laporte posts: 1633 Canada

    Don't worry. They are harmless. Should be fixed for 4.1 But this doesn't indicate there is something wrong with your installation.

    2 are "duplicate entry": saying that that part of the upgrade was already done.
    column 'guards' can't have a default value: this is solved by a later operation in the upgrade script.

    Link