mysql error number: 1146

[certify]

Where can I find the error code for mysql error number: 1146

[Chris Schreiber]

Looking at the source code, looks like "ER_NO_SUCH_TABLE" is the error text that goes with that number.

[certify]

Below is the actual error. Anyway to fix it?


Database error in vBulletin 2.2.2:

Invalid SQL: DELETE FROM session WHERE sessionhash=''
mysql error: Table 'phpresume.session' doesn't exist

mysql error number: 1146

[Chris Schreiber]

Yes, it looks like the 'session' table doesn't exist in the 'phpresume' database. You need to either create the table, or switch to the correct database.

[certify]

I having the same problem with phpmychat. I suspect this start happening since I upgrade my server php from 4.0.6 to 4.1.0

What do you think?


Database error in vBulletin 2.2.2:

Invalid SQL: UPDATE session SET lastactivity=1013608377,location='/chat/index.php3'
WHERE sessionhash='0adebf1c52018b5fff14aaa3c0e71b25'
mysql error:

mysql error number:

[certify]

Thanks, I managed to fix this problem.

[stilger]

Can anyone help it telling me how to fix this error. I have searched the Forums and I can not find a complete answer. I think I am in the same boat as Certify where we upgrade from PHP 4.0.6 to 4.1.2 and are now gettin the mysql error 1146..

Thanks