Please Post SQL Errors Here

Report problems with the forum.
Post ideas for additions or changes to the forum.
Request help with forum functionality.

Please Post SQL Errors Here

Postby allingeneral » Wed, 02 Feb 2011 20:39:42

If you have received an SQL error from the forum, please post it in reply to this thread so that I can attempt to debug the issue(s).

Copy and paste the error directly to a post here
Post the Date and Time of the error.

Thank you!
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby Palladin » Wed, 02 Feb 2011 20:59:00

:clap: I caught a squirrel! Now how'd I do it? And what did I do wrong?


General Error
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: rick@vagunforum.net
Now is the time for all good men to get off their rusty dustys...


User avatar
Palladin
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 4154
Joined: Mon, 05 Oct 2009 22:06:43
Location: Louisa
First Name: Glen

My Arsenal:
Wrist Rocket and a pocket full of 00buck...

Re: Please Post SQL Errors Here

Postby Palladin » Wed, 02 Feb 2011 21:01:23

That was on Religious Daggers, got another on on Read it and learn, same thing.

A few more and I'll have enough for biscuits and gravy!
Now is the time for all good men to get off their rusty dustys...


User avatar
Palladin
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 4154
Joined: Mon, 05 Oct 2009 22:06:43
Location: Louisa
First Name: Glen

My Arsenal:
Wrist Rocket and a pocket full of 00buck...

Re: Please Post SQL Errors Here

Postby Palladin » Wed, 02 Feb 2011 21:08:58

Now is the time for all good men to get off their rusty dustys...


User avatar
Palladin
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 4154
Joined: Mon, 05 Oct 2009 22:06:43
Location: Louisa
First Name: Glen

My Arsenal:
Wrist Rocket and a pocket full of 00buck...

Re: Please Post SQL Errors Here

Postby OakRidgeStars » Wed, 02 Feb 2011 21:14:30

Keep those SQuirreLs away from your nuts :hysterical:


OakRidgeStars
VGOF Gold Supporter
VGOF Gold Supporter
 
Posts: 14109
Joined: Sun, 22 Mar 2009 10:13:20
First Name: ORS

Re: Please Post SQL Errors Here

Postby allingeneral » Wed, 02 Feb 2011 21:21:00

Palladin wrote::clap: I caught a squirrel! Now how'd I do it? And what did I do wrong?


General Error
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: rick@vagunforum.net


Alright - I was messing around with some things for a minute...let's start... NOW! :)
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby Diomed » Thu, 03 Feb 2011 01:57:34

Great! I get these every day, from 25 to 75% of the time. Been happening for months. It even happened on this thread (and on the reply preview page).

They pretty much all look like this:
General Error
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: rick@vagunforum.net

In this instance, starting at 12:05am EST 2/3/11 and going forward.


User avatar
Diomed
Sharp Shooter
Sharp Shooter
 
Posts: 1891
Joined: Tue, 09 Mar 2010 02:28:14
Location: Central VA
First Name: Nah

Re: Please Post SQL Errors Here

Postby OakRidgeStars » Thu, 03 Feb 2011 17:58:54

General Error
SQL ERROR [ mysql4 ]

Duplicate entry '152-14' for key 1 [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Trying to open question-and-answer/ccw-holder-driving-through-t7690.html


OakRidgeStars
VGOF Gold Supporter
VGOF Gold Supporter
 
Posts: 14109
Joined: Sun, 22 Mar 2009 10:13:20
First Name: ORS

Re: Please Post SQL Errors Here

Postby allingeneral » Thu, 03 Feb 2011 19:35:17

I have made some adjustments to the SQL server and will continue to do so until this gets worked out.

Diomed, are you still getting these errors? I made a change last night and hope that it will help the specific issue that you're seeing.

Jay - I'm digging for your error right now...
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby gunderwood » Thu, 03 Feb 2011 20:39:27

Refreshing the new posts page.

SQL ERROR [ mysql4 ]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
sudo modprobe commonsense
FATAL: Module commonsense not found.


User avatar
gunderwood
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 7189
Joined: Sat, 19 Dec 2009 00:28:34

Re: Please Post SQL Errors Here

Postby Chasbo00 » Thu, 03 Feb 2011 20:41:27

About a minute ago...

General Error
SQL ERROR [ mysql4 ]

Lost connection to MySQL server during query [2013]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Competition is one of the "great levelers" of ego.


Active, Reserve or Veteran of the United States Army   National Rifle Association (NRA) Member   United States Practical Shooting Association (USPSA) Member   International Defensive Pistol Association (IDPA) Member   Second Amendment Foundation (SAF) Member  
User avatar
Chasbo00
Sharp Shooter
Sharp Shooter
 
Posts: 1819
Joined: Mon, 08 Mar 2010 19:34:29
Location: Northern VA
First Name: Charlie

Re: Please Post SQL Errors Here

Postby gunderwood » Thu, 03 Feb 2011 20:45:13

The squirrels are angry tonight.
sudo modprobe commonsense
FATAL: Module commonsense not found.


User avatar
gunderwood
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 7189
Joined: Sat, 19 Dec 2009 00:28:34

Re: Please Post SQL Errors Here

Postby allingeneral » Thu, 03 Feb 2011 20:52:14

The error that gunderwood received (mysql.sock) is because I was restarting the server and it wasn;t running when the page was loaded, therefore couldn't connect.

Hang with me for a bit while I adjust some things.
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby OakRidgeStars » Thu, 03 Feb 2011 21:00:48

Oh noes... we has angered the SQuirreLs :hysterical:

Image


OakRidgeStars
VGOF Gold Supporter
VGOF Gold Supporter
 
Posts: 14109
Joined: Sun, 22 Mar 2009 10:13:20
First Name: ORS

Re: Please Post SQL Errors Here

Postby smltooner » Sat, 05 Feb 2011 18:30:35

General Error
SQL ERROR [ mysql4 ]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
THE HIGH PRICE OF FREEDOM IS A COST PAID BY A BRAVE FEW. In memory of our fallen heroes.

THOSE WHO SERVE DESERVE HONOR, RESPECT, THANKS.


National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
smltooner
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 1245
Joined: Thu, 15 Apr 2010 00:53:38
Location: Smith Mtn Lake, VA
First Name: Ted

Re: Please Post SQL Errors Here

Postby allingeneral » Sat, 05 Feb 2011 18:35:53

w00ps! Sorry - just restarted the server because of a setup change.
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby Palladin » Sat, 05 Feb 2011 19:35:15

allingeneral wrote:w00ps! Sorry - just restarted the server because of a setup change.


soooo... is the site really up on blocks in your backyard?! :hysterical:
Now is the time for all good men to get off their rusty dustys...


User avatar
Palladin
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 4154
Joined: Mon, 05 Oct 2009 22:06:43
Location: Louisa
First Name: Glen

My Arsenal:
Wrist Rocket and a pocket full of 00buck...

Re: Please Post SQL Errors Here

Postby allingeneral » Sat, 05 Feb 2011 19:59:07

Palladin wrote:
allingeneral wrote:w00ps! Sorry - just restarted the server because of a setup change.


soooo... is the site really up on blocks in your backyard?! :hysterical:


It always is...I'm always trying to add something that will make bigger and better...
Please consider a DONATION to VGOF to help cover our operating costs

Image


Active, Reserve or Veteran of the United States Navy   National Rifle Association (NRA) Member   Virginia Citizens Defense League (VCDL) Member  
User avatar
allingeneral
Site Admin
Site Admin
 
Posts: 9548
Joined: Sun, 01 Mar 2009 17:38:25
Location: King George, Virginia
First Name: Rick

My Arsenal:
Ruger 10/22
S&W 4043 .40
Daly 1911 .45
Mossberg 500 12Ga
Rem 870 Super Mag
Ranger Youth 20Ga
Browning Buck Mark .22

Next Firearm:
Lever Action .357Mag

Re: Please Post SQL Errors Here

Postby Diomed » Sun, 06 Feb 2011 03:37:09

allingeneral wrote:Diomed, are you still getting these errors? I made a change last night and hope that it will help the specific issue that you're seeing.

Yes, I just got one for the General Discussion section, looks like the same error message as before:
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: rick@vagunforum.net


User avatar
Diomed
Sharp Shooter
Sharp Shooter
 
Posts: 1891
Joined: Tue, 09 Mar 2010 02:28:14
Location: Central VA
First Name: Nah

Re: Please Post SQL Errors Here

Postby gunderwood » Sun, 06 Feb 2011 11:20:23

Palladin wrote:
allingeneral wrote:w00ps! Sorry - just restarted the server because of a setup change.


soooo... is the site really up on blocks in your backyard?! :hysterical:

:hysterical: :hysterical: :hysterical: :hysterical: :hysterical: (5 of 5)
sudo modprobe commonsense
FATAL: Module commonsense not found.


User avatar
gunderwood
VGOF Platinum Supporter
VGOF Platinum Supporter
 
Posts: 7189
Joined: Sat, 19 Dec 2009 00:28:34

Next


Return to Forum Suggestions and Help

Who is online

Registered users: dusterdude, Exabot [Bot], Google [Bot], Google Feedfetcher, jdonovan

Please Support
Our Sponsors