Database Error 2006 Phplist
version roll out and QA » phpList, maintainer needed » UI lite phpList plugins » phpList API » rssmanager phpList.org My View | View Issues | Change Log | RoadmapView Issue Details[Jump to Notes] [Print] IDProjectCategoryView StatusDate SubmittedLast Update0008905phplistMessage Send Processpublic11-01-07 14:2806-06-13 03:51ReportersatyrvsPrioritynormalSeverityblockReproducibilityalwaysStatusresolvedResolutionunable to reproducePlatformOSOS VersionProduct Version2.10.3Target Version2.10.7Fixed in VersionSummary0008905: Database error 2006 while doing query MySQL server has goneDescriptionIssue on Forum: http://forums.phplist.com/viewtopic.php?p=26650#26650 [^] error output: --------------------------------------------------- PHPlist version 2.10.3 --------------------------------------------------- Started Processing has started, 1 message(s) to process. It is safe to click your "stop" button now, report will be sent by email to (email) Processing message 30 Looking for users Found them: 3859 to process Process Killed by other process Script stage: 5 1 messages sent in 38.03 seconds (94 msgs/hr) Finished this run Waiting for 3600 seconds before reloading --------------------------------------------------- Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Database error 2006 while doing query MySQL server has gone away Aparently when i hit "process queue" the script cannot process the message
reproducePlatformOSOS VersionProduct Version3.0.5Target VersionFixed in VersionSummary0016956: MySQL Error while processing queueDescriptionRunning following command : /usr/local/bin/php /home/blabla/public_html/boletin/admin/index.php -p processqueue -c /home/blabla/public_html/boletin/config/config.php? I am getting : phpList version 3.0.5 (c) 2000-2013 phpList Ltd, http://www.phplist.com [^] phpList - Recently sent : 0 phpList - Comenzado... [0,0503470000] (190) phpList - Sending in batches of 50 emails [0,0204810000] (194) phpList - Ha comenzado el procesamiento, 1 message(s) to process. [0,0134990000] (200) phpList - Procesando mensaje 2 [0,3681000000] (237) phpList - Buscando usuarios [0,0011660000] (242) phpList https://mantis.phplist.org/view.php?id=8905 - Encontrados: 365 para procesar [0,0317300000] (248) phpList - Processing batch of : 50 [0,0025100000] (254) phpList - Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax https://mantis.phplist.org/print_bug_page.php?bug_id=16956 to use near '9411764706' at line 1 phpList - Sql error replace into phplist_messagedata set id= 2, name="msg/hr", data= 52,9411764706 phpList - sent 1 ETA Tue 26 Nov 01:53 sending 52 msg/hr phpList - Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9411764706' at line 1 phpList - Sql error replace into phplist_messagedata set id= 2, name="msg/hr", data= 52,9411764706 phpList - sent 2 ETA Tue 26 Nov 01:53 sending 52 msg/hr phpList - Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9411764706' at line 1 phpList - Sql error replace into phpl
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product http://www.inmotionhosting.com/support/community-support/databases/error-number-2006-mysql-server-has-gone-away Guides Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community http://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away Support Browse Questions Ask a Question User Submitted Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable Type OpenCart OpenCart 2.0 osCommerce PHP-Fusion PHP-Nuke phpBB phpList Premium Website Builder PrestaShop 1.5 PrestaShop 1.6 SMF Tiki Wiki VirtueMart database error 3 Web Hosting Manager Website Design WordPress Tools & Resources Email Configuration Blacklist Check Visual DNS Lookup Quick Tagger Icon Sets Favicon Generator Bounce Back Parser What is my IP address? >>Community Support Community Support Browse Questions Ask a Question User Submitted Articles Community Support Questions Categories Users Ask a question Error Number: 2006 MySQL server has gone away Category: Databases Lwonder 11 database error 2006 Points Asked: 2013-09-13 2:55 pm EST Hits: 2,010 Recently on our wedding photography blog we've been getting the following message when trying to upload images (after hitting submit). No changes have been made from our side and the only thing I was able to do based on Google searches was try a Database Repair which didnt help. Hoping someone can provide some insight on what needs to be done to avoid this issue so we can return to business as usual. Not sure why but each subsequent attempt produces a different Line Number. A Database Error Occurred Error Number: 2006 MySQL server has gone away SELECT * FROM (`exp_channel_images`) WHERE `entry_id` = '91' AND `site_id` = '1' Filename: third_party/channel_images/ft.channel_images.php Line Number: 495 You must login before you can ask a follow up question. You must login before you can submit an answer. Jacob - my files range from 173KB to 1044KB. I'll be able to look more into it this evening. Thanks Lwonder 11 Points 2013-09-16 02:46 pm EST OTHER ANSWERS 0 Arn Staff 34,964 Points 2013-09-13 7:27 pm EST Hello Lwonder, Sorry to hear about your database issue. In order for us
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL error 2006: mysql server has gone away up vote 93 down vote favorite 14 I'm running a server at my office to process some files and report the results to a remote MySQL server. The files processing takes sometime and the process dies halfway through with the following error: 2006, mysql server has gone away Ive heard about the MySQL setting, wait_timeout, but do I need to change that on the server at my office or the remote MySQL server? mysql mysql-error-2006 share|improve this question edited Jan 25 at 7:44 bpoiss 7,55611435 asked Oct 29 '11 at 22:44 floatleft 96752540 2 it depends of that witch server gives the error –bksi Oct 29 '11 at 23:01 1 possible duplicate of ERROR 2006 (HY000): MySQL server has gone away –Simon East Oct 6 '14 at 0:40 For people getting here from Google: If changing the max_allowed_packet size or wait_timeout amount doesn't fix it, check your memory usage. I was getting the same error and it was being caused by my server running out of memory. I added a 1GB swap file and that fixed it. –Pikamander2 Sep 19 at 23:52 1 @Pikamander2 thanks for the hint! –ihsan Sep 26 at 9:10 add a comment| 13 Answers 13 active oldest votes up vote 4 down vote accepted It may be easier to check if the connection and re-establish it if needed. See PHP:mysqli_ping for info on that. share|improve this answer edited May 14 '15 at 14:46 cgaldiolo 525610 answered Oct 29 '11 at 23:15 Niet the Dark Absol 207k35240370 Good point, if you have a process that is intermittent then it