WordPress database error Unknown column ‘secure_session_id’

  • I am seeing this error in my logs from the plugin hosted on Pantheon:

    WordPress database error Unknown column 'secure_session_id' in 'where clause' for query SELECT * FROM wp_pantheon_sessions WHERE secure_session_id=

    We are running plugin version 1.3.4 and WP 6.5.5 and PHP 8.2

    Anyone seen this error? Could this be a compatibility issue as it only started happening recently after a PHP 8.2 update a month ago on Pantheon.

Viewing 1 replies (of 1 total)
  • Plugin Contributor jazzs3quence

    (@jazzs3quence)

    Hey @marcpersad

    Thanks for the report. I’ve copied it over to our GitHub repo so there’s visibility there. I don’t have an immediate answer for you but we will look into it. My first guess is that something that was maybe not yelling before PHP updated to 8.2 started yelling after the update, but I would need to do some testing to confirm. If it’s in the logs but not white-screening the site, I assume it’s not breaking anything, but are you using the plugin to store sessions and are those sessions being stored still?

    It also looks like you’re on the older version of the plugin — you might benefit from updating and running the wp session add index WP-CLI command (so terminus wp <site>.<env> -- session add index on Pantheon) to add indexes to the database tables used by the plugin. Docs here: https://github.com/pantheon-systems/wp-native-php-sessions?tab=readme-ov-file#wp-pantheon-session-add-index

    • This reply was modified 7 months, 2 weeks ago by jazzs3quence.
    • This reply was modified 7 months, 2 weeks ago by jazzs3quence.
Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error Unknown column ‘secure_session_id’’ is closed to new replies.