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
AndreyP•1st of May 2008
 
Try clean database and perform install again (clean)
Permalink•Reply•Plus•0 pluses
pirouet
pirouet•2nd of May 2008
 
tried clean database and clean install...still getting the same problem :(
Permalink•Reply•Plus•0 pluses
cyberajith
cyberajith•3rd of May 2008
 
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..
Permalink•Reply•Plus•0 pluses
pirouet
pirouet•3rd of May 2008•to cyberajith
 
thanks a lot, seemed to have worked and let me finish installation.

Thanks once again
Permalink•Reply•Plus•0 pluses
zankoku666
zankoku666•20th of May 2008
 
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!
Permalink•Reply•Plus•0 pluses
auntie_uli
auntie_uli•8th of June 2008
 
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.
Permalink•Reply•Plus•0 pluses
auntie_uli
auntie_uli•8th of June 2008
 
I got it to work. Just had to realize that you were adding two single quotes instead of a double quote.
:S
Permalink•Reply•Plus•0 pluses
 
 
Home
Features
Pricing
Hosting
Support
About
StartDemo
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.

Blogs

Dolphin.Pro News
BoonEx News
Our Journey
Social Software World
Community Voice

Help

Support Forums
Documentation
BoonEx at GitHub
Custom Jobs
Contact Support Team

Product

Dolphin.Pro Features
Live Demo & Sandbox
Download Packages
Pricing & Order
Contact Sales Team

Company

Contact Us
About BoonEx
Privacy Policy
Terms & Conditions
© BoonEx Pty Ltd
SSL
© BoonEx
Home
Features
Pricing
Support
Hosting
About
Demo
PET:0.054569959640503