View Single Post
  #1353  
Old 03-07-2006, 04:17 PM
AndrewD AndrewD is offline
 
Join Date: Jul 2002
Location: Scotland
Posts: 3,486
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ophelia
Andrew,
We are having a huge issue right now.. hoping you can give some insight.

Whenever anyone tries to do something in the download manager, they are getting the following error:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

		INSERT INTO local_linksdebug (userid, settingtime, message, settings)
		VALUES (
		'2564',
		'1141749185',
		'local_filename:/forum/correctlink/980611410121089844.jpg:returns:/home/webattit/public_html/forum/teamuploads/imageuploads/980611410121089844.jpg:',
		'a:78:{s:17:"title_data_access";s:26:"ll_settings_title_features";s:16:"title_data_entry";s:23:"ll_settings_title_entry";s:14:"title_controls";s:26:"ll_settings_title_controls";s:10:"allow_html";s:1:"0";s:12:"allow_images";s:1:"1";s:13:"allow_smilies";s:1:"0";s:12:"allow_bbcode";s:1:"1";s:16:"allow_null_links";s:1:"0";s:14:"title_moderate";s:26:"ll_settings_title_moderate";s:14:"moderate_links";s:1:"0";s:21:"moderate_email_accept";s:1:"0";s:21:"moderate_email_submit";s:1:"0";s:16:"title_displayopt";s:28:"ll_settings_title_displayopt";s:17:"cat_depth_display";s:1:"1";s:15:"cat_sub_display";s:1:"0";s:16:"cat_cols_display";s:1:"1";s:11:"count_depth";s:1:"1";s:8:"cat_icon";s:0:"";s:12:"cat_icon_new";s:0:"";s:16:"template_linkbit";s:13:"links_linkbit";s:17:"link_cols_display";s:0:"";s:14:"links_per_page";s:1:"0";s:20:"links_show_othercats";s:1:"1";s:18:"default_sort_order";s:1:"d";s:13:"default_style";s:2:"-1";s:13:"title_general";s:25:"ll_settings_title_general";s:25:"categories_seen_on_portal";s:0:"";s:18:"category_jump_menu";s:1:"1";s:13:"database_name";s:0:"";s:19:"days_seen_on_portal";s:2:"30";s:18:"featured_user_favs";s:0:"";s:14:"featured_sites";s:1:"0";s:20:"links_seen_on_portal";s:2:"10";s:11:"mod_rewrite";s:0:"";s:16:"monitor_template";s:14:"links_scantext";s:12:"seo_friendly";s:1:"0";s:15:"show_hit_parade";s:1:"1";s:27:"template_category_selection";s:26:"links_addnewlink_catselect";s:12:"title_images";s:24:"ll_settings_title_images";s:14:"file_icons_dir";s:17:"images/ldm_icons/";s:14:"link_imagesize";s:3:"100";s:10:"thumbs_dir";s:14:"/forum/thumbs/";s:12:"title_search";s:24:"ll_settings_title_search";s:18:"default_search_all";s:1:"1";s:19:"default_search_desc";s:1:"1";s:19:"default_search_keys";s:1:"1";s:16:"match_using_like";s:1:"0";s:19:"profile_searchfield";s:2:"-1";s:14:"title_security";s:26:"ll_settings_title_security";s:22:"allow_remote_downloads";s:1:"1";s:15:"default_forumid";s:4:"-999";s:16:"default_cat_dseq";s:1:"1";s:17:"default_link_dseq";s:1:"1";s:12:"force_accept";s:1:"0";s:14:"force_redirect";s:1:"0";s:15:"local_file_root";s:1:"0";s:22:"local_file_root_prefix";s:0:"";s:19:"profile_ldmactivity";s:1:"1";s:14:"protected_link";s:1:"0";s:15:"robots_meta_tag";s:15:"index, nofollow";s:17:"timeout_hit_allow";s:2:"30";s:21:"timeout_hit_recording";s:2:"60";s:17:"validate_on_entry";s:1:"1";s:11:"title_media";s:23:"ll_settings_title_media";s:18:"musicbox_filetypes";s:44:"mpg, mpeg, wmv, mp3, swf, asf, wma, avi, wav";s:28:"musicbox_filetypes_quicktime";s:3:"mov";s:29:"musicbox_filetypes_realplayer";s:34:"rm, ra, ram, rt, rp, rv, rmvb, rpm";s:12:"title_upload";s:24:"ll_settings_title_upload";s:10:"upload_dir";s:18:"/forum/teamuploads";s:14:"upload_enabled";s:1:"1";s:16:"upload_filetypes";s:0:"";s:15:"upload_maxspace";s:1:"0";s:11:"title_debug";s:14:"ll_perms_DEBUG";s:5:"DEBUG";s:1:"1";s:11:"LDMHomePage";s:41:"http://www.eirma.org/devel/LDM/index.html";s:12:"this_version";s:5:"2.1.3";s:17:"version_installed";s:1:"1";s:15:"bandwidth_limit";s:0:"";}'
		);

MySQL Error  : Duplicate entry '32767' for key 1
Error Number : 1062
Date         : Tuesday, March 7th 2006 @ 11:33:05 AM
Script       : http://www.oursite.com/forum/local_r...4.jpg&size=600
Referrer     : http://www.oursite.com/forum/local_links.php?catid=17
IP Address   : 67.48.75.160
Username     : Ophelia
Classname    : vb_database
We get this when we are trying to view the image, trying to download... anything/everything. Any ideas?

**Updating

Andrew there were over 32,000 entries into the debug table in the database. I emptied this and the download manager works again. However, this might be something that needs looked into.

Has someone turned on the debug switch on the admin page?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01219 seconds
  • Memory Usage 1,800KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete