I’m getting a database error on an EE v2.4.0 site when creating a new site and copying data across from an existing one.
Steps I’m taking:
1. Site Management > Create new site
2. Using ‘duplicate channel, duplicate entries’ on the items I wish to copy across. Some others are set to ‘do nothing’ if the site I’m creating doesn’t need that data.
3. The following errors occur:
A PHP Error was encountered
Severity: Notice
Message: Undefined index: 571
Filename: cp/sites.php
Line Number: 744
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_2`, `field_ft_2`, `field_id_3`, `field_ft_3`, `field_id_4`, `field_ft_4`, `field_id_5`, `field_ft_5`, `field_id_6`, `field_ft_6`, `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_dt_13`, `field_ft_13`, `field_id_14`, `field_ft_14`, `field_id_19`, `field_ft_19`, `field_id_20`, `field_ft_20`, `field_id_21`, `field_ft_21`, `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_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_60`, `field_ft_60`, `field_id_61`, `field_ft_61`, `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_74`, `field_ft_74`, `field_id_75`, `field_ft_75`, `field_id_78`, `field_ft_78`, `field_id_80`, `field_ft_80`, `field_id_81`, `field_ft_81`, `field_id_83`, `field_ft_83`, `field_id_84`, `field_ft_84`, `field_id_86`, `field_ft_86`, `field_id_87`, `field_ft_87`, `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`, `field_id_99`, `field_ft_99`, `field_id_100`, `field_ft_100`, `field_id_101`, `field_ft_101`, `field_id_102`, `field_ft_102`, `field_id_104`, `field_ft_104`, `field_id_105`, `field_ft_105`, `field_id_106`, `field_ft_106`, `field_id_107`, `field_ft_107`, `field_id_108`, `field_ft_108`, `field_id_109`, `field_ft_109`, `field_id_110`, `field_ft_110`, `field_id_111`, `field_ft_111`, `field_id_112`, `field_ft_112`, `field_id_113`, `field_ft_113`, `field_id_114`, `field_ft_114`, `field_id_115`, `field_ft_115`, `field_id_116`, `field_ft_116`, `field_id_117`, `field_ft_117`, `field_id_118`, `field_ft_118`, `field_id_119`, `field_ft_119`, `field_id_121`, `field_ft_121`, `field_id_122`, `field_ft_122`, `field_id_123`, `field_ft_123`, `field_id_124`, `field_ft_124`, `field_id_125`, `field_ft_125`, `field_id_126`, `field_ft_126`, `field_id_127`, `field_ft_127`, `field_id_128`, `field_ft_128`, `field_id_129`, `field_ft_129`, `field_id_130`, `field_ft_130`, `field_id_134`, `field_ft_134`, `field_id_135`, `field_ft_135`, `field_id_136`, `field_ft_136`, `field_id_137`, `field_ft_137`, `field_id_138`, `field_ft_138`, `field_id_139`, `field_ft_139`, `field_id_140`, `field_ft_140`) VALUES (NULL, 16, 105, '', NULL, '', NULL, '', NULL, '0', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '0', NULL, NULL, '', NULL, '', NULL, '', NULL, '', NULL, 'xxx', 'br', 'VPA No: 10999/129/003', 'none', 'Each light brown tablet contains:\nCarprofen 100mg', 'br', '', 'br', '', 'br', '', NULL, '', NULL, '', NULL, '', NULL, '', 'xhtml', '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '0', NULL, '', NULL, '0', NULL, '', NULL, '0', NULL, '', NULL, '0', NULL, '', NULL, '', 'xhtml', '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', NULL, '', 'xhtml', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '0', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'br', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'none', '', 'xhtml')
Filename: controllers/cp/sites.php
Line Number: 747Please can anyone advise why this error may be occuring? I examined the database and noticed ‘entry_id’ is not an auto_increment field, but I believe this is correct anyway since the same is true on both the live and development versions of the site we’re working on.
Any help would be appreciated.
I should also mention that the new site is actually created even though this error occurs, in other words the new site appears on the top right-hand menu in the EE Admin. But not all of the data selected gets copied across.
Thanks,
Andy