MySQL Error
I was installing Dolphin 6.1 when i got this error. Can anyone help me and tell me whatis going wrong ??? plzzzzz
Error while executing: INSERT INTO `ProfileFields` VALUES(1, 'ID', 'system', '', '', NULL, NULL, '', 'LKey', '', 1, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 1, 17, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(2, 'NickName', 'text', '', '', 4, 16, '', 'LKey', 'return ( preg_match( ''/^[a-zA-Z0-9_-]+$/'', $arg0 ) and !file_exists( $dir[''root''] . $arg0 ) );', 1, '', 1, 0, 0, 17, 1, 17, 1, 17, 1, 17, 1, 17, 1, 17, 2, 17, 2, 17, 1, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(3, 'Password', 'pass', '', '', 5, 16, '', 'LKey', '', 0, '', 1, 0, 0, 17, 3, 17, 4, 17, 4, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(4, 'Email', 'text', '', '', 6, NULL, '', 'LKey', 'return (bool)preg_match( ''/^[a-z0-9_\\-]+(\\.[_a-z0-9\\-]+)*@([_a-z0-9\\-]+\\.)+([a-z]{2}|aero|arpa|biz|com|coop|edu|gov|info|int|jobs|mil|museum|name|nato|net|org|pro|travel)$/i'', $arg0 );', 1, '', 1, 0, 0, 17, 2, 17, 2, 17, 2, 17, 2, 0, NULL, 21, 1, 21, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(5, 'DateReg', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(6, 'DateLastEdit', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 4, 21, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(8, 'DateLastLogin', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(9, 'Featured', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(12, 'DescriptionMe', 'area', '', '', 20, NULL, '', 'LKey', '', 0, '', 1, 1, 0, 20, 5, 20, 4, 20, 4, 20, 4, 22, 2, 22, 2, 22, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(13, 'DateOfBirth', 'date', '', '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 3, 20, 2, 20, 2, 20, 2, 20, 1, 20, 1, 20, 1, 0, NULL, '', 17, 3, 0, NULL, 17, 3, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(14, 'Headline', 'text', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 20, 4, 20, 3, 20, 3, 20, 3, 22, 1, 22, 1, 22, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(16, 'City', 'text', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 20, 7, 20, 6, 20, 6, 20, 6, 20, 3, 20, 3, 20, 3, 20, 2, '', 0, NULL, 0, NULL, 20, 2, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(17, 'General Info', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 2, 0, 1, 0, 2, 0, 2, 0, 1, 0, 2, 0, 1, 0, 1, '', 0, 1, 0, NULL, 0, 1, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(18, 'Location', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 5, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(19, 'Keyword', 'system', '', 'DescriptionMe\nHeadline', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 2, 0, NULL, 20, 3, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(20, 'Misc Info', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 3, 0, 2, 0, 3, 0, 3, 0, 2, 0, 3, 0, 2, 0, 2, '', 0, 2, 0, NULL, 0, 2, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(21, 'Admin Controls', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, 1, 0, 1, 0, NULL, 0, 5, 0, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(22, 'Description', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 3, 0, 4, 0, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(24, 'Captcha', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(25, 'Security Image', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(30, 'Profile Type', 'block', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(41, 'EmailNotify', 'system', '', '', NULL, NULL, 'NotifyMe\nNotNotifyMe', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(39, 'zip', 'text', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 8, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(34, 'DateLastNav', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(35, 'PrimPhoto', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(36, 'Picture', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(37, 'aff_num', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(38, 'Tags', 'text', '', '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 9, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 4, 0, 0);
Data truncated for column 'Control' at row 1
Error while executing: INSERT INTO `ProfileFields` VALUES(42, 'TermsOfUse', 'system', '', '', NULL, NULL, '', 'LKey', '', 0, '', 1, 1, 0, 25, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
Data truncated for column 'Control' at row 1
As a quick-fix, I opened v61.sql (under the <dolphin root folder>/install/sql)and changed line 8881 from:
`Control` enum('select','checkbox','radio') collate utf8_unicode_ci NOT NULL default 'select' COMMENT 'input element for selectors',
to
`Control` enum('select','checkbox','radio','') collate utf8_unicode_ci NOT NULL default 'select' COMMENT 'input element for selectors',
Essentially, I just added see more
Thanks once again
Just try to modify the archive v61.sql (bug on inserts definition) you can add the '' on the enumeration like cyberajith says or replace '' for 'select' in each insert. and voila!
`Control` enum('select','checkbox','radio',") NOT NULL default 'select' COMMENT 'input element for selectors',
I get the following new error:
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 '") NOT NULL default 'select' COMMENT 'input element for selectors',`Extra` text ' at line 1
Thanks for your help.
:S