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.