Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
After I deployed my project to shared hosting, I ran migration and everything worked perfectly - all my table were migrated to the database using my dB credentials in my .env file. I set ph version to 8.2. after that I loaded my website: landing page works as expected but when I try to access other pages I'm getting 500 internal server error: Base table mydbname.sessions not found. I checked my database through phpMyAdmin and sessions table exist. What could be causing this behaviour?
In config/session.php, you have 2 settings: driver and connection. By default, driver is set to SESSION_DRIVER (in .env) and connection to SESSION_CONNECTION.
driver seems to be set to database in your case (either because SESSION_DRIVER doesn't exist in your .env or because it's set to database), check that SESSION_CONNECTION is set to the same connection as your DB_CONNECTION (or config/database.php)
@Max13 I did your solutions and still not working fine. I've checked the sessions table in my database. it has session data for my visit to the landing page but once I try to visit other pages, it returns 500. Currently, it returns 500 but no longer logs errors to the laravel error log file. I am really confused to the extent I'm beginning to ask myself could be possible that GitHub workflow deployment somehow messed up my application
@Max13 Thank you so much for been the first person to reply to me and gave me solutions, i implanted your solutions again but this time it worked, thank you. About laravel not logging errors, i now know why, i messed up .htaccess file. Thanks once again. Please can we become friend beyond here
@sergitet94 check SESSION_CONNECTION IN env file, there is some problem with your session connection.
@amitsolanki24_ i did that already. still not working as supposed, the landing pages works fine but other pages doesn't respond. Now, my doesn't even logg errors anymore
@amitsolanki24_ Thank this solution worked. I didn't do it well initially.
Please or to participate in this conversation.