I finally caught up with everyone, upgrading both my VB to 3.6.2 and my LDM to 2.2.6. I ended up having the problem with the constant MYSQL error e-mails like this:
PHP Code:
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('', 1, '', '', 1161414394, '', 0, 0, 1, 0, 0, 0, 0, '', 0, 0);
MySQL Error :
Error Number :
Date : Saturday, October 21st 2006 @ 12:06:38 AM
Script : http://www.MyWebSite.com/local_links.php?action=jump&id=1131&catid=18
Referrer :
- Hide quoted text -
IP Address : [removed for privacy]
Username : Name
Classname : vB_Database
Anyway, I just uploaded your fixed local_links.php. The e-mails were coming in at a very consistent rate before. I'll wait through the evening before my final verdict.
One question: I ended up adjusting wait_timeout to 90 seconds when I was troubleshooting this problem. LDM told me that was a low wait_timeout setting, so I changed the setting back to default. What is an optimal wait_timeout setting?
Thanks again Andrew.