We use cookies to help make our site work properly and to analyze how our site is used. Some are optional, but none contain your personal information, and we don't use any for ads. You can view our cookies policy, manage your cookie preferences, or consent and dismiss this banner by clicking agree:

Agree
ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

MSM duplicating channel entry data error

April 09, 2012 9:34am

Subscribe [2]

  • #1 / Apr 09, 2012 9:34am

    readio

    12 posts

    Hi

    I have just installed MSM. When I try and create a new site if I duplicate all channels and channel data I get the below error message

    A Database Error Occurred
Error Number: 1048
Column 'entry_id' cannot be null
INSERT INTO `exp_channel_data` (`entry_id`, `site_id`, `channel_id`, `field_id_1`, `field_ft_1`, `field_id_2`, `field_ft_2`, `field_id_3`, `field_ft_3`, `field_id_4`, `field_ft_4`, `field_id_7`, `field_ft_7`, `field_id_8`, `field_ft_8`, `field_id_9`, `field_ft_9`, `field_id_10`, `field_ft_10`, `field_id_11`, `field_ft_11`, `field_id_12`, `field_ft_12`, `field_id_13`, `field_ft_13`, `field_id_14`, `field_ft_14`, `field_id_15`, `field_ft_15`, `field_id_16`, `field_ft_16`, `field_id_17`, `field_ft_17`, `field_id_18`, `field_ft_18`, `field_id_19`, `field_ft_19`, `field_id_20`, `field_ft_20`, `field_id_21`, `field_ft_21`, `field_id_22`, `field_ft_22`, `field_id_23`, `field_ft_23`, `field_id_24`, `field_ft_24`, `field_id_25`, `field_ft_25`, `field_id_26`, `field_ft_26`, `field_id_27`, `field_ft_27`, `field_id_28`, `field_ft_28`, `field_id_29`, `field_ft_29`, `field_id_30`, `field_ft_30`, `field_id_31`, `field_ft_31`, `field_id_32`, `field_ft_32`, `field_id_33`, `field_ft_33`, `field_id_34`, `field_ft_34`, `field_id_35`, `field_ft_35`, `field_id_36`, `field_ft_36`, `field_id_37`, `field_ft_37`, `field_id_38`, `field_ft_38`, `field_id_39`, `field_ft_39`, `field_id_40`, `field_ft_40`, `field_id_41`, `field_ft_41`, `field_id_42`, `field_ft_42`, `field_id_43`, `field_ft_43`, `field_id_44`, `field_ft_44`, `field_id_45`, `field_ft_45`, `field_id_46`, `field_ft_46`, `field_id_47`, `field_ft_47`, `field_id_48`, `field_ft_48`, `field_id_49`, `field_ft_49`, `field_id_50`, `field_ft_50`, `field_id_51`, `field_ft_51`, `field_id_52`, `field_ft_52`, `field_id_53`, `field_ft_53`, `field_id_54`, `field_ft_54`, `field_id_55`, `field_ft_55`, `field_id_56`, `field_ft_56`, `field_id_57`, `field_ft_57`, `field_id_58`, `field_ft_58`, `field_id_59`, `field_ft_59`, `field_id_62`, `field_ft_62`, `field_id_63`, `field_ft_63`, `field_id_64`, `field_ft_64`, `field_id_65`, `field_ft_65`, `field_id_66`, `field_ft_66`, `field_id_67`, `field_ft_67`, `field_id_68`, `field_ft_68`, `field_id_69`, `field_ft_69`, `field_id_70`, `field_ft_70`, `field_id_71`, `field_ft_71`, `field_id_72`, `field_ft_72`, `field_id_73`, `field_ft_73`, `field_id_74`, `field_ft_74`, `field_id_75`, `field_ft_75`, `field_id_76`, `field_ft_76`, `field_id_77`, `field_ft_77`, `field_id_78`, `field_ft_78`, `field_id_79`, `field_ft_79`, `field_id_80`, `field_ft_80`, `field_id_81`, `field_ft_81`, `field_id_82`, `field_ft_82`, `field_id_85`, `field_ft_85`, `field_id_86`, `field_ft_86`, `field_id_87`, `field_ft_87`, `field_id_88`, `field_ft_88`, `field_id_89`, `field_ft_89`, `field_id_90`, `field_ft_90`, `field_id_91`, `field_ft_91`, `field_id_92`, `field_ft_92`, `field_id_93`, `field_ft_93`, `field_id_94`, `field_ft_94`, `field_id_95`, `field_ft_95`, `field_id_96`, `field_ft_96`, `field_id_97`, `field_ft_97`, `field_id_98`, `field_ft_98`) VALUES (NULL, 2, 18, '', NULL, '', NULL, '', NULL, '', NULL, '1', 'none', 'https://ellislab.com/asset/images/team-photo/img-comp-home.png', 'none', '1', 'none', '1', 'none', '', 'none', '', 'xhtml', '', 'xhtml', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'xhtml', '', 'xhtml', '', 'xhtml', '', 'none', '', 'xhtml', '', 'none', '', 'xhtml', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'xhtml', '', 'xhtml', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none')
Filename: controllers/cp/sites.php
Line Number: 747

    The site does get created but nothing gets duplicated (Templates/channels/channel data).

    If I set up the site and select to duplicate everything expect the channel data it works perfectly. I really need all the channel data though so I don’t have to re-insert it on the new site.

    I am using the latest version of EE (2.4.0) and MSM (2.1.2).

    Any ideas?

    Thanks
    Darren

  • #2 / Apr 09, 2012 12:59pm

    readio

    12 posts

    UPDATE

    I have done some trails by creating a new site and selecting one Channel at a time to duplicate. This narrowed the issue down to just the one channel which when trying to duplicate the data, threw the error.

    Having looked in the DB I found that an entry existed in the database for this channel that did not appear in the EE content section. I deleted the row from the DB and can now set up new sites without error.

  • #3 / Apr 09, 2012 5:41pm

    Shane Eckert

    7174 posts

    Hey readio,

    Glad to hear it.

    Is there anything I can do to help or any questions I can answer?

    Cheers,

  • #4 / Apr 10, 2012 9:39am

    readio

    12 posts

    Hi Shane

    I think I have everything under control…just about.

    Now seeing If I can solve the issues with extensions not duplicating content. Mainly Matrix and Channel Videos. This is looking like a case of manually re-adding though.

    Cheers
    Darren

  • #5 / Apr 11, 2012 10:28am

    Shane Eckert

    7174 posts

    Hi readio,

    Sounds good. I am glad things are on their way!

    If you need anything else, please just let us know by opening a new thread.

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases

© Packet Tide, All Rights Reserved. Legal Notices

Username

Password

Forgot password?
or Register