Staging site shows SQLSTATE[42S22] error
Development and Programming
Hi!
I’ve made various changes to a client site locally which are working well (and included adding a couple of add-ons). I’ve deployed the changes to the staging site and as long as I have debugging turned on I get the error shown in the attached screenshot. Here’s what I’ve tried:
- Completely re-deploying everything from scratch to staging
- Deleting staging DB tables and importing from a local DB export
- Completely deleting the staging DB and re-creating with new credentials and importing from a local DB export
None of those things have worked.
Not sure how to troubleshoot further.
This site is running EE Pro 7.3.3 on PHP 8.1
Thanks!
Hi Angie! o/
Reading the SQL error, it appears to be including a column that isn’t there. Technically, the highlight column; it’s not in your database. That said, it’s not in any of my local builds of any EE site either, which makes me wonder how/why it’s being requested.
You say this is working locally though? And you’ve imported the database from your local to stage and it’s still not working? Very curious behavior.
Further, reading through the stack trace, it appears to be an issue within an Extension (it’s happening within the Session initialization, so am guessing, but is likely an Extension. Are there any legacy Add-ons at play that would have modified the Roles table and added the highlight column?
Eric
Thanks Eric! I’m sending this up the flagpole to official support—can’t figure out the cause of the ghost highlight column.