Simple fix for SQL Error : 1016
This was a simple problem that came up with one of my databases, and I wasted a lot of time going the long way around the mountain. I’m posting the database problem here along with a quick fix for those with a similar error.
THE ERROR:
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1016 Can’t open file: ‘phpbb_sessions.MYD’. (errno: 145)
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES (‘1c2d81c6031571e71b2909fa76261504′, 2, 1161053838, 1161053838, ’47e750bd’, 0, 1, 0)
Line : 245
File : sessions.php
***********
THE FIX:
Perform the following SQL query:
REPAIR TABLE phpbb_sessions
***********************
DETAILS:
This problem can happen to many different mysql database tables and seems to happen specifically on sessions.php – My SQL had been restarted, so that might have been a cause. If you are using PHPMYADMIN to run your databases, you will not be allow to fix the database from within the tables view for that database (like you normally would). Because phpmyadmin cannot complete the listing of tables, you cannot select the table to fix, and also do not have the normal listing of functions to select from (including the “optimize” table and “repair” table functions).
But just because you can’t see the sessions or users table, doesn’t mean they don’t exist. On my databases I entered “REPAIR TABLE phpbb_sessions” as an sql query and it fixed the table, which fixed the database problem.
In looking for a fix for the problem, I saw this same error across many different software platforms including phpbb, vbulletin and several ecommerce software platforms.
My initial fix was to backup databases from the command line on the server, since I had root access. I then deleted the existing database and reloaded the backups. A very long process when the mysql query fixed it. To perform the simple query you do not need root server access, only access to phpmyadmin.
Another reason I’m posting this, is I saw several dozen instances where other people had this error for over a month, effectively closing their websites. Hopefully this will help those who, like myself, are technically challenged with mysql.
Hope that helps!
************
Another version of a related error:
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1146 Table ‘databasename.phpbb_users’ doesn’t exist
SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = ‘d0d838d45d9db9fea44a2500bb8199ab’
Line : 89
File : sessions.php
thanks for this post – used it to fix my phpbb too!
Thx for the post. My phpBB is fixed !! 🙂
Hi, thanks for the post!
It works for my phpbb forum
help me with this error please
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/pershqip/public_html/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/pershqip/public_html/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
Hi,
I’m not advanced enough to look at that and know the exact problem – perhaps someone else will have something to add.
This post worked for my phpbb forum as well. One of my other admins found this post, sent it to me, I logged into the phpmyadmin tool and in less than .0000001 seconds it was fixed. Thanks!
Thank you a lot. it resolved my problem.
You Sir, are a scholar and gentleman. Thank You.