Previous Thread
Next Thread
Print Thread
Hop To
#169205 11/27/2006 3:12 PM
Joined: Nov 2006
Posts: 190
Likes: 5
J
Member
Member
J Offline
Joined: Nov 2006
Posts: 190
Likes: 5
We were getting occasional SQL errors. Sometimes it happens once and then a reload will clear it. Other times you can get the same error for 10 minutes.

Most common with 7.0.2:

Script: ../forums/libs/ubbthreads.inc.php
Line#: 2086
SQL Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
SQL Error #: 2002
Query: select t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = '' and t1.USER_ID = t2.USER_ID

--

Also get:

Script:

../forums/libs/ubbthreads.inc.php

Line#: 2074

SQL Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) SQL Error #: 2002

Query: select t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID,

t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE,

t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = '' and t1.USER_ID = t2.USER_ID

---

Can someone comment about these?

Thanks!

Last edited by Rick; 12/03/2006 2:04 PM.
Jake #169206 11/27/2006 3:19 PM
Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
seems that your connection to the database server breaks down:

SQL Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Maybe connection problems or something other is wrong with the database server


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Zarzal #169214 11/27/2006 7:31 PM
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
I agree with Zarzal...

Quote
SQL Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


The error message is indicitive of your connection to the MySQL server going flop; either by it being overloaded and unable to accept connections, or being down completely.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
0 members (), 686 guests, and 131 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)