Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2001
Posts: 169
Member
Member
Offline
Joined: Feb 2001
Posts: 169
In last days I continuosly have problems with my DB, in the beginning I got a W3t_posts table marked as "In use", I asked my Server provider to fix it and after a few minutes after the fix the same error occurred again. After the new fix I have a brand new problem:

[]
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/Forum/mysql.inc.php on line 35
SQL ERROR: Mon, Sep 13 2004 19:30:12 +0200 Database error only visible to forum administrators

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/html/Forum/mysql.inc.php on line 45

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/Forum/mysql.inc.php on line 107
SQL ERROR: Mon, Sep 13 2004 19:30:12 +0200 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/Forum/mysql.inc.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/Forum/mysql.inc.php:35) in /var/www/html/Forum/ubbt.inc.php on line 270
[/]

My server admin suggested me to replace mysql_pconnect() with mysql_connect() and as you can see I did it with no result.

Any idea on how to solve ? If you want to have a look here is the site: www.inpiega.com

Sponsored Links
Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
"SQL ERROR: Mon, Sep 13 2004 19:30:12 +0200 Database error only visible to forum administrators"

What is the real error that is showing up in the logs?

Joined: Feb 2001
Posts: 169
Member
Member
Offline
Joined: Feb 2001
Posts: 169
The log is HUGE, those are only the latests:

[]
[ERROR][Mon, Sep 13 2004 21:03:41 +0200] [/Forum/ubbthreads.php] [212.171.215.105] Unable to do_query:
SELECT O_Board,COUNT(*),O_Type
FROM w3t_Online
WHERE O_Last > '1095101621'
GROUP BY O_Board,O_Type
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[ERROR][Mon, Sep 13 2004 21:03:41 +0200] [/Forum/ubbthreads.php] [212.171.215.105] Unable to do_query:
SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description
FROM w3t_Category
WHERE Cat_Type = 'forum'

ORDER BY Cat_Number
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[ERROR][Mon, Sep 13 2004 21:03:41 +0200] [/Forum/ubbthreads.php] [212.171.215.105] Unable to do_query:
UPDATE w3t_Cache
SET
C_Users = '',
C_NewUsername = '',
C_NewUid = '',
C_Users_timestamp = '1095102221',
C_Birthdays = '',
C_Birthdays_timestamp = '1095102221'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[ERROR][Mon, Sep 13 2004 21:03:41 +0200] [/Forum/ubbthreads.php] [212.171.215.105] Unable to do_query:
SELECT COUNT(*)
FROM w3t_Online
WHERE O_Last > '1095101621'
AND O_Type = 'a'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[ERROR][Mon, Sep 13 2004 21:03:41 +0200] [/Forum/ubbthreads.php] [212.171.215.105] Unable to do_query:
SELECT COUNT(*)
FROM w3t_Online,w3t_Users
WHERE w3t_Online.O_Username = w3t_Users.U_Username
AND w3t_Online.O_Last > '1095101621'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[/]


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)