Thread: Database Error

Hi

I'm using GPLDate & my site works fine, but then all of a sudden I get a blank screen with a "Database Activation Failed" error message. Each time this occurs I get an email from postmaster@mysite.com (subject: Error)

Error in substr(/profile_edit.php, 0, (strlen(/profile_edit.php) - @strlen())):
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2)

Error in substr(/admin/index.php, 0, (strlen(/admin/index.php) - @strlen())):
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2)

Error in substr(/im.php, 0, (strlen(/im.php) - @strlen())): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

& many more...

Are these errors caused due to a bug in the code or hosting server .

Please Help!!!!!

Hi,

Yes - it appears your host is having mSQL errors.

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

is a host issue.

Couple of things can cause this... one is the use of pconnect by Dolphin and other scripts - using up all the database connections. Your host can disable pconnect in my.cnf system wide - or you can change the code in db.inc.php - search modmysite for "pconnect" to find help with that.

Also - this error can happen when your host is doing backups... does it happen during the day or just in the early AM (server time)?

Smoge

Thanks Smoge, I think the problem was caused because my host was doing backups because all the errors were generated within a few minutes & hasn't happened again.