vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   How to clear VB Mail Que System.. (https://vborg.vbsupport.ru/showthread.php?t=233637)

vortech1 01-20-2010 08:16 PM

yea I just ran what you posted table is there.. that full error is to long to post it had all the html + emails from the news letter as well in it.. Was there something at the bottom that might be useful?


--------------- Added [DATE]1264026595[/DATE] at [TIME]1264026595[/TIME] ---------------

here is the full error I took out most of the body as it had all that in there.. It also did it at the same point the 65 user in the news letter.

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO mailqueue
(dateline, toemail, fromemail, subject, message, header)
VALUES

(1264026469,
'removed',
'removed',
'StuntUSA',
'<!-- If you can\'t see this message properly, then you are unable to see HTML formatted emails. Please change your setting in the control panel to receive the community bulletin in Text format. \nhttp://www.stuntusa.com/forums/profile.php?do=editoptions -->\n\n</html>',
'From: \"nightshades@stuntusa.com\" <removed>\nSender: nightshades@stuntusa.com\nReturn-Path: removed\nMessage-ID: <20100120222758.9a724d34b6bc@www.stuntusa.com>\nMI ME-Version: 1.0\nContent-Type: text/html; charset=\"UTF-8\"\nContent-Transfer-Encoding: 8bit\nX-Priority: 3\nX-Mailer: Stunt USA\n');

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Wednesday, January 20th 2010 @ 05:27:49 PM
Error Date : Wednesday, January 20th 2010 @ 05:27:58 PM
Script : http://www.stuntusa.com/forums/admin...ll.php?do=send
Referrer : http://www.stuntusa.com/forums/admincp/commbull.php
IP Address : 70.121.133.157
Username : NightShades
Classname : vB_Database
MySQL Version : 5.0.87-community
--------------- Added [DATE]1264030850[/DATE] at [TIME]1264030850[/TIME] ---------------

ok now I am getting this error and has takenmy site down some how, mysql is up and running.

Database error in vBulletin 3.8.4:

Invalid SQL:
LOCK TABLES mailqueue WRITE;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, January 20th 2010 @ 06:28:13 PM
Error Date : Wednesday, January 20th 2010 @ 06:28:40 PM
Script : http://www.stuntusa.com/forums/rss-f...g-bicycle.html
Referrer : http://www.stuntusa.com/forums/searc...archid=1142775
IP Address : 69.125.137.99
Username : scott_f4i
Classname : vB_Database
MySQL Version :

Adrian Schneider 01-20-2010 09:50 PM

Sounds like the email you are sending contains too much information for MySQL to handle at once.

If you edit your MySQL config you can bump up the setting for 'max_allowed_packet'.

vortech1 01-21-2010 01:59 AM

ok I fixed that problem, but now if I turn on send email with locking it just kills the forum. Is there a way to remove the mailqueue table and re-add it fresh? I have tried running repair and it just dies at mailqueue.

I have cleaed it out but with the setting not set to locking the forum NEVER sends any email it just sits in the mailqueue in vb no idea why..

Adrian Schneider 01-21-2010 02:48 AM

Why not ask over at vb.com for support?


All times are GMT. The time now is 10:00 AM.

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.01160 seconds
  • Memory Usage 1,727KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete