PDA

View Full Version : a veeery looong Database Error when creating new question for guests


boogie box high
Mon 17th Dec '07, 5:01pm
The text that you have entered is too long (475546 characters). Please shorten it to 65536 characters long.
very long db error after adding question for guests registration and clicking on "save"

Database error in vBulletin 3.7.0 Beta 2:

Invalid SQL:
Privacy\";s:28:\"make_changes_parent_notified\";s:287:\"When you make changes to this profile, your Parent / Guardian will be notified by email.<br />\r\n <br />\r\n If you are over the age of 13, you should not be seeing this message. Please contact the <a href=\"%1$s\">administrator</a> with your username, and your account will be changed.\";s:27:\"manage_your_friend_requests\";s:27:\"Manage your Friend Requests\";s:31:\"may_allow_users_tdownload_vcard\";s:204:\"You may choose to allow other users to download a vCard containing your email address and username.<br />\r\n <br />\r\n If you want to keep your email address private, do not allow vCard downloads.\";s:31:\"may_be_identified_member_groups\";s:67:\"You may choose to be identified as a member of the following groups\";s:25:\"may_enter_identity_for_im\";s:151:\"You may enter your registered identity for the instant messaging networks if you would like other visitors to be able to contact you using that medium.\";s:31:\"may_select_predefined_as_avatar\";s:77:\"You may select one of the following pre-defined images to use as your avatar:\";s:23:\"may_upload_custom_image\";s:80:\"Możesz dodac własny avatar wybierając go z dysku lub podając jego adres poniżej.\";s:32:\"may_upload_custom_image_controls\";s:60:\"You may upload a new custom image using the controls below. \";s:26:\"member_of_following_groups\";s:40:\"You are a member of the following groups\";s:20:\"members_of_usergroup\";s:20:\"Members of Usergroup\";s:24:\"message_editor_interface\";s:24:\"Message Editor Interface\";s:22:\"messaging_notification\";s:28:\"Messaging &amp; Notification\";s:15:\"mini_statistics\";s:15:\"Mini Statistics\";s:21:\"miscellaneous_options\";s:21:\"Miscellaneous Options\";s:18:\"moderated_messages\";s:18:\"Moderated Messages\";s:15:\"moderated_posts\";s:15:\"Moderated Posts\";s:17:\"moderated_threads\";s:17:\"Moderated Threads\";s:25:\"moderated_visitor_message\";s:25:\"Moderated Visitor Message\";s:16:\"moderated_within\";s:16:\"Moderated within\";s:10:\"moderation\";s:10:\"Moderation\";s:14:\"more_text_here\";s:14:\"More Text Here\";s:19:\"most_recent_message\";s:19:\"Most Recent Message\";s:21:\"most_recent_user_note\";s:21:\"Most Recent User Note\";s:20:\"msn_messenger_handle\";s:20:\"MSN Messenger Handle\";s:10:\"networking\";s:10:\"Networking\";s:5:\"never\";s:5:\"Never\";s:22:\"new_challenge_received\";s:26:\"Someone has challenged you\";s:17:\"new_email_address\";s:17:\"New Email Address\";s:12:\"new_password\";s:12:\"New Password\";s:20:\"new_private_messages\";s:20:\"New Private Messages\";s:22:\"new_subscribed_threads\";s:22:\"New Subscribed Threads\";s:20:\"new_visitor_messages\";s:20:\"New Visitor Messages\";s:12:\"newest_first\";s:12:\"Newest First\";s:16:\"newsletterformat\";s:44:\"Format of the Community Bulletin Newsletters\";s:19:\"no_avatar_specified\";s:19:\"No Avatar Specified\";s:14:\"no_posts_found\";s:15:\"No posts found.\";s:18:\"no_profile_picture\";s:28:\"No Profile Picture Specified\";s:32:\"no_subscribed_threads_to_display\";s:79:\"There are no subscribed threads to display in this folder for this time period.\";s:30:\"note_have_custom_avatar_delete\";s:71:\"Note: if you have a custom avatar selecting this option will delete it.\";s:19:\"note_maximum_size_x\";s:52:\"Note: The maximum size of your custom image is %1$s.\";s:26:\"note_maximum_size_x_y_or_z\";s:98:\"Note: The maximum size of your custom image is %1$s by %2$s pixels or %3$s (whichever is smaller).\";s:28:\"note_maximum_size_x_y_pixels\";s:67:\"Note: The maximum size of your custom image is %1$s by %2$s pixels.\";s:19:\"notification_events\";s:19:\"Notification Events\";s:20:\"notification_methods\";s:20:\"Notification Methods\";s:20:\"notification_options\";s:20:\"Notification Options\";s:12:\"oldest_first\";s:12:\"Oldest First\";s:6:\"option\";s:6:\"Option\";s:23:\"option_to_hide_elements\";s:177:\"You have the option to show or hide various elements of messages, which may be of use to users on slow internet con UPDATE language SET title = title, phrasegroup_accessmask = 'a:11:{s:13:\"access_denied\";s:13:\"Access Denied\";s:21:\"access_denied_x_users\";s:27:\"Access Denied: %1$s User(s)\";s:14:\"access_granted\";s:14:\"Access Granted\";s:22:\"access_granted_x_users\";s:28:\"Access Granted: %1$s User(s)\";s:19:\"access_mask_manager\";s:19:\"Access Mask Manager\";s:25:\"access_masks_quick_editor\";s:25:\"Access Masks Quick Editor\";s:23:\"delete_all_access_masks\";s:23:\"Delete All Access Masks\";s:17:\"display_all_users\";s:17:\"Display All Users\";s:13:\"display_users\";s:13:\"Display Users\";s:4:\"sort\";s:4:\"Sort\";s:23:\"user_forum_access_for_x\";s:26:\"User Forum Access for %1$s\";}', phrasegroup_album = 'a:51:{s:9:\"add_album\";s:9:\"Add Album\";s:21:\"add_groups_to_picture\";s:21:\"Add Groups to Picture\";s:12:\"add_pictures\";s:12:\"Add

[CUT!)

%1$s\";s:6:\"voting\";s:6:\"Voting\";s:22:\"x_spider_htmlvalidator\";s:19:\"%1$s HTML Validator\";s:20:\"x_spider_linkchecker\";s:17:\"%1$s Link Checker\";s:21:\"x_spider_searchspider\";s:11:\"%1$s Spider\";}', phrasegroup_cprofilefield = 'a:12:{s:11:\"field1_desc\";s:28:\"A few details about yourself\";s:12:\"field1_title\";s:9:\"Biography\";s:11:\"field2_desc\";s:14:\"Where you live\";s:12:\"field2_title\";s:8:\"Location\";s:11:\"field3_desc\";s:32:\"What is about your hour hobbies?\";s:12:\"field3_title\";s:9:\"Interests\";s:11:\"field4_desc\";s:57:\"You can tell us a bit more about your job, if you like :)\";s:12:\"field4_title\";s:10:\"Occupation\";s:11:\"field5_desc\";s:0:\"\";s:12:\"field5_title\";s:17:\"Foreign Languages\";s:11:\"field6_desc\";s:11:\"Your gender\";s:12:\"field6_title\";s:6:\"Gender\";}', phrasegroup_hvquestion = 'a:1:{s:9:\"question1\";s:5:\"1+1=?\";}', phrasegroup_infractionlevel = 'a:9:{s:22:\"infractionlevel1_title\";s:22:\"Spammed Advertisements\";s:22:\"infractionlevel2_title\";s:26:\"Posting Of Entire Articles\";s:22:\"infractionlevel3_title\";s:24:\"Signature Rule Violation\";s:22:\"infractionlevel4_title\";s:32:\"Offensive Posts, Links or Images\";s:22:\"infractionlevel5_title\";s:18:\"Copyrighted Images\";s:22:\"infractionlevel6_title\";s:40:\"Copyrighted Material - Videos/MP3/Copies\";s:22:\"infractionlevel7_title\";s:8:\"Trolling\";s:22:\"infractionlevel8_title\";s:7:\"Flaming\";s:22:\"infractionlevel9_title\";s:16:\"Personal Details\";}', phrasegroup_reputationlevel = 'a:15:{s:11:\"reputation1\";s:30:\"is infamous around these parts\";s:12:\"reputation10\";s:29:\"is a glorious beacon of light\";s:12:\"reputation11\";s:22:\"is a name known to all\";s:12:\"reputation12\";s:27:\"is a splendid one to behold\";s:12:\"reputation13\";s:30:\"has a reputation beyond repute\";s:12:\"reputation14\";s:22:\"has a brilliant future\";s:12:\"reputation15\";s:23:\"has much to be proud of\";s:11:\"reputation2\";s:24:\"can only hope to improve\";s:11:\"reputation3\";s:44:\"has a little shameless behaviour in the past\";s:11:\"reputation4\";s:36:\"is an unknown quantity at this point\";s:11:\"reputation5\";s:26:\"is on a distinguished road\";s:11:\"reputation6\";s:30:\"will become famous soon enough\";s:11:\"reputation7\";s:28:\"has a spectacular aura about\";s:11:\"reputation8\";s:23:\"is a jewel in the rough\";s:11:\"reputation9\";s:19:\"is just really nice\";}' WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_hvquestion' in 'field list'
Error Number : 1054
Date : Monday, December 17th 2007 @ 10:55:15 PM
Script : /admincp/verify.php?do=updatequestion
Referrer : /verify.php?do=modifyquestion
IP Address : xxx
Username : webmaster
Classname : vb_database

not sure of it has something to do running beta version on my of course .htaccess protected test domain (different url).

Wayne Luke
Mon 17th Dec '07, 6:03pm
This is a known issue and the developers are working to fix it. Please be patient and a fix will be made available as soon as possible.

Run this query:
UPDATE phrasetype SET special = 1 WHERE fieldname = 'hvquestion'

Or wait until the next beta release to have the system fix this for you.