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

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2008, 01:27 PM
SpeakeasyMedia SpeakeasyMedia is offline
 
Join Date: Dec 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default wmv upload, database error

I just added wmv to the file extensions users can upload, and set the max size to 4 MB. When I tested it with a 2 MB file, I got a database error message.

Quote:
<!-- Database error in vBulletin 3.6.8: Invalid SQL: INSERT INTO attachment (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata) VALUES (1206887024, 1206887024, 1, 3, 'wmv', [attachment name]
I've tried it several times with the same result, and attaching other file types works fine. What did I do wrong?
Reply With Quote
  #2  
Old 03-30-2008, 02:06 PM
MiahBeSmokin420 MiahBeSmokin420 is offline
 
Join Date: May 2007
Location: Ohio
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

go to the main page of your acp

there should be like 4 columns

the one on the left should say something like php upload size

make sure that is larger then the size of the fie you are uploading

if it is not the you need to change that and to do that you need to edit your httaccess file

i got to go hope that helps
Reply With Quote
  #3  
Old 03-30-2008, 02:21 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please post the complete error message. Edit it out any long pieces of text. Also ensure that you post the bit which says "MySQL error:"
Reply With Quote
  #4  
Old 03-30-2008, 05:12 PM
SpeakeasyMedia SpeakeasyMedia is offline
 
Join Date: Dec 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here is the message:

Quote:
<!-- Database error in vBulletin 3.6.8: Invalid SQL: INSERT INTO attachment (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata) VALUES (1206900331, 1206900331, 1, 3, 'wmv', 'Greatest_Movie_Line_Ever.wmv', 'e48208662d9c449c6051ad396e52fe1a', '81d4b948778eb0f4d5336d5cd87fbf69', 1113146,

[thousands of characters of gobbledygook]

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes Error Number : 1153 Date : Sunday, March 30th 2008 @ 02:05:31 PM Script : http://www.therealnicaragua.com/vb/f...anageattach&p= Referrer : http://www.therealnicaragua.com/vb/f...51ad396e52fe1a IP Address : 75.92.125.228 Username : John Classname : vB_Database -->
Reply With Quote
  #5  
Old 03-31-2008, 05:22 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That means that the attachment you have uploaded is bigger than the size MySQL can accept. You can either store attachments in the file system, or increase the packet size in the MySQL configuration file.
Reply With Quote
  #6  
Old 03-31-2008, 01:35 PM
Medtech's Avatar
Medtech Medtech is offline
 
Join Date: Oct 2007
Posts: 310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I store attachments in my file system, have my php set for 1 gig. all my other file size settings are at 1 gig. i can upload a 16 meg file just fine, 17 meg errors out. you should be able to do the same.
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 11:53 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.03640 seconds
  • Memory Usage 2,207KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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