PHP Fatal error: Table 'zm.Sessions' doesn't exist in engine

[burger]

I just received the following error in 1.36.33 after rebuilding the database per https://wiki.zoneminder.com/MySQL#[ERRO ... nd_the_end

Code: Select all

[Wed Jan 08 08:31:25.176630 2025] [php7:error] [pid 1743] [client #########:43002] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'zm.Sessions' doesn't exist in engine in /usr/share/zoneminder/www/includes/session.php:138\nStack trace:\n#0 /usr/share/zoneminder/www/includes/session.php(138): PDO->prepare()\n#1 [internal function]: ZMSessionHandler->read()\n#2 /usr/share/zoneminder/www/includes/session.php(46): session_start()\n#3 /usr/share/zoneminder/www/index.php(139): zm_session_start()\n#4 {main}\n  thrown in /usr/share/zoneminder/www/includes/session.php on line 138

The homepage was not working. I looked at the sessions table, and it had some old information. The solution was to restart apache2.

[iconnor]

Your db doesn't have all the tables. You can try running sudo zmupdate.pl

Or you may have to do
mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.35.9.sql

[burger]

My mistake, I think you are correct. In this case, I restored the DB without rebuilding it, and as a result, I had to start over (getting the sessions table missing error). Though there was some other error that was causing the web site to be blank after database restore. I suppose this second error didn't show up in the apache logs, so I confused it for the other one. When I restarted apache after a restore of the database, the website came back.

I'll have to check what exactly the other error was then, if it wasn't the PHP error I thought I was looking at.