Title: MySQL VBB Question: Record Has Changed Since Last Read in Table 'Session'
I installed VBB3.01 under Linux Rhel Update3. There is no error in the installation process, but in the process of operation, VBB often pilots the same one, which is described below:
------------------------------------------------
Status: RO
Database errors appear in Vbulletin 3.0.1:
INVALID SQL:
SELECT *
From session
Where userid = 0
And host = '219.128.14.27'
AND IDHASH = '7a6aa3842444f07f5ebf5470da946f7b'
Limit 1
Mysql error: Record Has Changed Since Last Read in Table 'Session'
MySQL error number: 1020
Date: Friday 31st of December 2004 08:38:41 PM
------------------------------------------------
This MYSQL program is:
MySQL-Server-4.1.7-0
MySQL-DEVEL-4.1.7-0
MySQL-Client-4.1.7-0
MySQL-Shared-4.1.7-0
Mysql-shared-compat-4.1.7-0
At the beginning, it was a bug of the VBB program, and later found some information after searching, only the misfire of MySQL was known.
Solution: Upgrade MySQL 4.1.7 to 4.1.8.