JReviews 3.7.5 is not working with my NGINX server

September 4, 2020 at 06:08 PM

I recently updated my dev JReviews site from 3.6.8.0 to 3.7.5 and it broke the site. Everything was working fine with 3.6.8.0. My live site and local dev site are using Apache and everything works fine after upgrading both to 3.7.5.

The dev site is a DigitalOcean droplet: Ubuntu 18.04, NGINX 1.14, MySQL 5.7.31, PHP 7.3.21.

Depending on the page I see an SQL error that always starts with this.

Unknown column 'Directory.slug' in 'field list' => SELECT...

I tried using the Protostar template on the home page and see this notice multiple times (with different line numbers for each) on the page as well.

Notice: Array to string conversion in .../templates/protostar/error.php on line 123
Array

The server was originally using PHP 7.2 when I did the initial 3.6.8.0 to 3.7.5 upgrade so I used the opportunity to upgrade it to PHP 7.3 and started over with a snapshot of my live site that was at 3.6.3.1. This worked fine as well. After upgrading to 3.7.5 everything broke again with the same SQL errors.

Maybe I'm missing a PHP module with the NGINX server?

September 4, 2020 at 06:29 PM