HomeUnityBlogs
 
 
pirouet

MySQL Error

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
bad
0
good
 
 

Comments

AndreyP
AndreyP 65 days agocomment permalink
  
Try clean database and perform install again (clean)
 
bad
0
good
 
 
pirouet
pirouet 65 days agocomment permalink
  
tried clean database and clean install...still getting the same problem :(
 
bad
0
good
 
 
cyberajith
cyberajith 64 days agocomment permalink
  
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 '' 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..
 
bad
1
good
 
View 1 replies to this comment
 
zankoku666
zankoku666 46 days agocomment permalink
  
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!
 
bad
0
good
 
 
auntie_uli
auntie_uli 27 days agocomment permalink
  
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.
 
bad
0
good
 
 
auntie_uli
auntie_uli 27 days agocomment permalink
  
I got it to work. Just had to realize that you were adding two single quotes instead of a double quote.
:S
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
pirouet Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
 
Home  Products  Unity  Trac  About  Help  Contact  Privacy Policy  Terms of Use  Rules  RSS Feed  Blog
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.582188844681