MySQL Error

pirouet posted 1st of May 2008 in Community Voice. 7 comments.
I was installing Dolphin 6.1 when i got this error. Can anyone help me and tell me whatis going wrong ??? plzzzzzLaughing

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
 
Comments
·Oldest
·Top
Please login to post a comment.
AndreyP
Try clean database and perform install again (clean)
pirouet
tried clean database and clean install...still getting the same problem :(
cyberajith
Pirouet, I ran into the same error when I tried to install D 6.1 as well.

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 '' as a option to the list of options in the enumeration for the 'Control' field.

I haven't looked in detail to see if this can have an adverse effect in the application elsewhere, but for now, the installation should proceed smoothly if you make that change.

I hope this helps..
pirouet
thanks a lot, seemed to have worked and let me finish installation.

Thanks once again
zankoku666
Hi, I had the same problem...

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!
auntie_uli
I'm getting the same error. When I add " to the 'Control' line making it:

`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.
auntie_uli
I got it to work. Just had to realize that you were adding two single quotes instead of a double quote.
:S
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.092927932739258