Piwigo.org

tanyp · 2024-01-22 12:49:30

Hi there,

I keep getting this error when I use the back end of pwigio

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_agent' in 'field list' in /home/excelsta/images.checkinapartments.com/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /home/excelsta/images.checkinapartments.com/include/dblayer/functions_mysqli.inc.php(132): mysqli->query('\nINSERT INTO `...') #1 /home/excelsta/images.checkinapartments.com/include/dblayer/functions_mysqli.inc.php(550): pwg_query('\nINSERT INTO `...') #2 /home/excelsta/images.checkinapartments.com/include/functions.inc.php(625): mass_inserts('piwi1n_activity', Array, Array) #3 /home/excelsta/images.checkinapartments.com/admin/maintenance_actions.php(256): pwg_activity('system', 1, 'maintenance', Array) #4 /home/excelsta/images.checkinapartments.com/admin/maintenance.php(51): include('/home/excelsta/...') #5 /home/excelsta/images.checkinapartments.com/admin.php(345): include('/home/excelsta/...') #6 {main} thrown in /home/excelsta/images.checkinapartments.com/include/dblayer/functions_mysqli.inc.php on line 132

---------------------

I am also not able to properly upload and save images, they upload but then always go into orphan folder and never into the folder I assign them on the "Add photos" page.

-------------------

The website is:
https://images.checkinapartments.com/admin.php

-------------------

Environment
Piwigo 13.8.0 Check for upgrade
Installed on 23 November 2020, 3 years 1 month 4 weeks ago
Operating system: Linux
PHP: 8.1.26 (Show info) [2024-01-22 11:48:08]
MySQL: 10.5.23-MariaDB [2024-01-22 11:48:08]
Graphics Library: ImageMagick 6.8.0-1
Cache size 3871.47 Mo   calculated 2 minutes ago Refresh

-------------------

Any help would be much appreciated and thank you in advance.

Tanielle
Check-in-London

plg · 2024-01-22 14:04:09

column activity.user_agent has been added in Piwigo 13, more precisely in upgrade script 164. Can you tell us what you have in your database, for the latest lines?

tanyp · 2024-01-22 15:26:26

Hi Plg, thank you for responding.

Sorry I don't follow your question, Where can I find the latest lines in the database?

We have images in our database.

Thank you in advance,
Tanielle

plg · 2024-01-22 15:32:38

In the table "activity" of your database. You may read your database content with PhpMyAdmin (or ask your system administrator)

tanyp · 2024-01-22 16:14:56

Thanks for explaining.

Is it this information you need?
https://drive.google.com/file/d/1efg-vu … sp=sharing

plg · 2024-01-22 16:19:35

Sorry, I meant the "piwigo_upgrade" table. But yes, that's the data we need. But not as a CSV file in a Google Drive ;-)

tanyp · 2024-01-22 16:46:53

Ah ok, thanks so much.

Is this information useful?

<?php
/**
* Export to PHP Array plugin for PHPMyAdmin
* @version 5.2.1
*/

/**
* Database `excelsta_imgchec`
*/

/* `excelsta_imgchec`.`piwi1n_upgrade` */
$piwi1n_upgrade = array(
array('id' => '100','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '101','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '102','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '103','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '104','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '105','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '106','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '107','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '108','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '109','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '110','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '111','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '112','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '113','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '114','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '115','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '116','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '117','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '118','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '119','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '120','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '121','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '122','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '123','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '124','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '125','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '126','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '127','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '128','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '129','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '130','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '131','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '132','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '133','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '134','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '135','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '136','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '137','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '138','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '139','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '140','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '141','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '142','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '143','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '144','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '145','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '146','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '147','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '148','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '149','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '150','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '151','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '152','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '153','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '154','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '155','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '156','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '157','applied' => '2021-01-24 12:20:10','description' => '[migration from 2.10.0 to 11.1.0, 0.001 s] add config parameters to display smart app banner'),
array('id' => '158','applied' => '2021-01-24 12:20:10','description' => '[migration from 2.10.0 to 11.1.0, 0.113 s] set default date to 1970-01-01'),
array('id' => '159','applied' => '2021-01-24 12:20:10','description' => '[migration from 2.10.0 to 11.1.0, 0.223 s] add index on images.path'),
array('id' => '160','applied' => '2021-11-05 09:15:45','description' => '[migration from 11.0.0 to 12.0.0, 0.409 s] add lounge table'),
array('id' => '161','applied' => '2021-11-05 09:15:45','description' => '[migration from 11.0.0 to 12.0.0, 0.486 s] remove doubled activities on tag addition'),
array('id' => '162','applied' => '2021-11-05 09:15:45','description' => '[migration from 11.0.0 to 12.0.0, 0.038 s] change activity.performed_by for logout'),
array('id' => '61','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '62','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '63','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '64','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '65','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '66','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '67','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '68','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '69','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '70','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '71','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '72','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '73','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '74','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '75','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '76','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '77','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '78','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '79','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '80','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '81','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '82','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '83','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '84','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '85','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '86','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '87','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '88','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '89','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '90','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '91','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '92','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '93','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '94','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '95','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '96','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '97','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '98','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation'),
array('id' => '99','applied' => '2020-11-23 22:59:48','description' => 'upgrade included in installation')
);

plg · 2024-01-24 13:43:12

I see your last updates where for version 12.0.0. You're in version 13.x. It seems you haven't run the upgrade from 12 to 13. Go to https://images.checkinapartments.com/upgrade.php and follow the instructions.

tanyp · 2024-01-24 17:58:50

Thanks,

When I click the link I see.

No upgrade required, the database structure is up to date
← back to gallery

I will try from the admin panel but any other suggestion would be much appreciated.

Piwigo.org

Announcement

#1 2024-01-22 12:49:30

I keep getting Fatal error

#2 2024-01-22 14:04:09

Re: I keep getting Fatal error

#3 2024-01-22 15:26:26

Re: I keep getting Fatal error

#4 2024-01-22 15:32:38

Re: I keep getting Fatal error

#5 2024-01-22 16:14:56

Re: I keep getting Fatal error

#6 2024-01-22 16:19:35

Re: I keep getting Fatal error

#7 2024-01-22 16:46:53

Re: I keep getting Fatal error

#8 2024-01-24 13:43:12

Re: I keep getting Fatal error

#9 2024-01-24 17:58:50

Re: I keep getting Fatal error

Board footer