Piwigo.org

ketchemr · 2023-03-03 16:04:43

I updated to PHP 8.1 FastCGI. I now periodically get this error:

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_agent' in 'field list' in /home/ketchemr/rrkphoto.com/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /home/ketchemr/rrkphoto.com/include/dblayer/functions_mysqli.inc.php(132): mysqli->query('\nINSERT INTO `...') #1 /home/ketchemr/rrkphoto.com/include/dblayer/functions_mysqli.inc.php(550): pwg_query('\nINSERT INTO `...') #2 /home/ketchemr/rrkphoto.com/include/functions.inc.php(625): mass_inserts('piwigo_activity', Array, Array) #3 /home/ketchemr/rrkphoto.com/include/functions_user.inc.php(1009): pwg_activity('user', 1, 'login') #4 /home/ketchemr/rrkphoto.com/include/functions_user.inc.php(1033): log_user('1', true) #5 /home/ketchemr/rrkphoto.com/include/user.inc.php(28): auto_login() #6 /home/ketchemr/rrkphoto.com/include/common.inc.php(178): include('/home/ketchemr/...') #7 /home/ketchemr/rrkphoto.com/index.php(11): include_once('/home/ketchemr/...') #8 {main} thrown in /home/ketchemr/rrkphoto.com/include/dblayer/functions_mysqli.inc.php on line 132

A page reload works and the page loads fine.

Piwigo URL: http://www.rrkphoto.com

Any ideas?

Thanks,
Randy

ketchemr · 2023-03-04 01:15:04

The same error shows up in the admin panel, so I suspect it is not related to any extensions, plugins, or theme.

erAck · 2023-03-04 12:31:44

Make sure you actually have a field user_agent in table piwigo_activity, see install/db/164-database.php for its parameters.

ketchemr · 2023-03-04 16:47:57

Thank you, @erAck. That helped. It gave an error when trying to open a newly uploaded image (I did not capture the text, but it was pertaining to user permissions), so I had to then run "Repair and optimize database", but it seems to have worked. I will watch it for a few days and report back here.

ketchemr · 2023-03-07 15:43:49

Error has been resolved. Thank you again.

Piwigo.org

Announcement

#1 2023-03-03 16:04:43

PHP 8.1 FastCGI Error

#2 2023-03-04 01:15:04

Re: PHP 8.1 FastCGI Error

#3 2023-03-04 12:31:44

Re: PHP 8.1 FastCGI Error

#4 2023-03-04 16:47:57

Re: PHP 8.1 FastCGI Error

#5 2023-03-07 15:43:49

Re: PHP 8.1 FastCGI Error

Board footer