Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2008, 02:24 AM
mferris mferris is offline
 
Join Date: Mar 2008
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error in vBulletin 3.7.0 Help?

Invalid SQL: Error # 2006 MySQL Server has gone away. I'm on a yahoo server.

Can I email someone a copy of the errors I'm getting?

I get an error every time I try to save changes from the admincp. The only thing I can pinpoint is one of the files in my server isn't set to chmod 777, but I'm not sure. I'm running a VBGallery, and a custom skin too. The bulk of the errors seem to be photo related, and I'm guessing related to vb gallery. Here's a few lines of the error:

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:8:{s:11:\"field1_desc\";s:50:\"Tell us about yourself in 1000 characters or less.\";s:12:\"field1_title\";s:9:\"Biography\";s: 11:\"field2_desc\";s:14:\"Wher e you live\";s:12:\"field2_title\";s:8:\"Location\";s:11 :\"field3_desc\";s:17:\"Your hobbies, etc\";s:12:\"field3_title\";s:9:\"Interests\";s:11 :\"field4_desc\";s:8:\"Your job\";s:12:\"field4_title\";s:10:\"Occupation\";}' , 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:23:\"has much to be proud of\";s:12:\"reputation14\";s:22:\"has a brilliant future\";s:12:\"reputation15\";s:30:\"has a reputation beyond repute\";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\";}', phrasegroup_infractionlevel = 'a:4:{s:22:\"infractionlevel1_title\";s:22:\"Spamm ed Advertisements\";s:22:\"infractionlevel2_title\";s :24:\"Insulted Other Member(s)\";s:22:\"infractionlevel3_title\";s:24:\ "Signature Rule Violation\";s:22:\"infractionlevel4_title\";s:22:\ "Inappropriate Language\";}', phrasegroup_accessmask = 'a:11:{s:13:\"access_denied\";s:13:\"Access Denied\";s:21:\"access_denied_x_users\";s:27:\"Acc ess Denied: %1$s User(s)\";s:14:\"access_granted\";s:14:\"Access Granted\";s:22:\"access_granted_x_users\";s:28:\"A ccess Granted: %1$s User(s)\";s:19:\"access_mask_manager\";s:19:\"Acce ss Mask Manager\";s:25:\"access_masks_quick_editor\";s:25: \"Access Masks Quick Editor\";s:23:\"delete_all_access_masks\";s:23:\"D elete 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_foru m_access_for_x\";s:26:\"User Forum Access for %1$s\";}', phrasegroup_album = 'a:68:{s:9:\"add_album\";s:9:\"Add Album\";s:21:\"add_picture_to_groups\";s:21:\"Add Picture to Groups\";s:12:\"add_pictures\";s:12:\"Add Pictures\";s:23:\"add_pictures_to_a_group\";s:23:\ "Add Pictures to a Group\";s:24:\"add_selected_pictures_to\";s:24:\"A dd selected pictures to\";s:12:\"add_to_group\";s:12:\"Add to Group\";s:5:\"album\";s:5:\"Album\";s:35:\"album_p ictures_used_profile_styling\" ;s:118:\"This album has pictures used for profile styling. Removing the album or making it non-public will remove this styling!\";s:11:\"album_title\";s:11:\"Album Title\";s:10:\"album_type\";s:10:\"Album Type\";s:20:\"approve_this_picture\";s:20:\"Approv e this picture\";s:7:\"bb_code\";s:7:\"BB Code\";s:7:\"caption\";s:7:\"Caption\";s:36:\"clic k_here_add_album_upload_pictur es\";s:56:\"Click here to add an album and start uploading pictures!\";s:29:\"click_here_to_upload_pictures\" ;s:30:\"Click here to upload pictures!\";s:12:\"delete_album\";s:12:\"Delete Album\";s:19:\"delete_this_picture\";s:19:\"Delete this picture\";s:11:\"description\";s:11:\"Description\ ";s:10:\"edit_album\";s:10:\"E dit Album\";s:12:\"edit_picture\";s:12:\"Edit Picture\";s:20:\"edit_picture_comment\";s:20:\"Edi t Picture Comment\";s:13:\"edit_pictures\";s:13:\"Edit Pictures\";s:13:\"first_picture\";s:13:\"First Picture\";s:6:\"groups\";s:6:\"Groups\";s:12:\"las t_picture\";s:12:\"Last Picture\";s:21:\"leave_cover_unchanged\";s:21:\"Le ave cover unchanged\";s:25:\"max_file_size_per_picture\";s:2 9:\"Maximum File Size per Picture\";s:22:\"max_picture_dimensions\";s:26:\"M aximum Picture Dimensions\";s:12:\"next_picture\";s:20:\"Next Picture &raquo;\";s:34:\"only_report_inappropriate_picture s\";s:80:\"<strong>Note</strong>: This is ONLY to be used to report inappropriate pictures.\";s:7:\"picture\";s:7:\"Picture\";s:13:\ "picture_added\";s:13:\"Pictur e Added\";s:10:\"picture_by\";s:10:\"Picture By\";s:14:\"picture_limits\";s:14:\"Picture Limits\";s:17:\"picture_moderated\";s:9:\"Moderate d\";s:26:\"picture_moderation_ enabled\";s:115:\"Moderation Enabled<br /><span class=\"shade\">Your pictures will not be visible until approved by a moderator.</span>\";s:11:\"picture_url\";s:11:\"Picture URL\";s:34:\"picture_waiting_moderator_approval\"; s:34:\"Picture Waiting Moderator Approval\";s:27:\"picture_x_of_y_from_album_z\";s: 64:\"Picture %1$s of %2$s from Album <span class=\"normal\">%3$s</span>\";s:29:\"pictured_used_profile_styling\";s:4 0:\"This picture is used for profile styling\";s:8:\"pictures\";s:8:\"Pictures\";s:46:\ "pictures_automatically_resize d_better_manually\";s:145:\"Pictures will be automatically resized to fit within these constraints if possible. However, you may receive better results by doing it manually.\";s:32:\"pictures_from_this_private_albu m\";s:72:

Any help would be greatly appreciated.

Mike
Reply With Quote
  #2  
Old 05-23-2008, 02:32 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MySQL Server has gone away is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway
Reply With Quote
  #3  
Old 05-23-2008, 09:57 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also the last few lines of the error message are important.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:45 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04898 seconds
  • Memory Usage 2,195KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete