🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2020-06-01 22:53:11
- Ed69
- Member
- 2020-06-01
- 6
Fatal error after updating Manage Properties Photos plug-in
Hello
Today I updated my piwigo installation with the latest version of the Manage Properties Photos plug-in and now I am getting the following warning and fatal error:
Warning: [mysql error 1054] Unknown column 'dataprop' in 'where clause'
SELECT id_prop_pho FROM piwigo_add_properties_photos WHERE dataprop = 'DeletetePhoto' AND Typ = 2 LIMIT 1; in /var/www/<my domain goes here>/include/dblayer/functions_mysqli.inc.php on line 856
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/<my domain goes here>/include/dblayer/functions_mysqli.inc.php:220 Stack trace: #0 /var/www/<my domain goes here>/plugins/manage_properties_photos/main.inc.php(61): pwg_db_fetch_assoc(false) #1 /var/www/<my domain goes here>/include/functions_plugins.inc.php(350): include_once('/var/www/<my domain goes here>...') #2 /var/www/<my domain goes here>/include/functions_plugins.inc.php(430): load_plugin(Array) #3 /var/www/<my domain goes here>/include/common.inc.php(142): load_plugins() #4 /var/www/<my domain goes here>/index.php(11): include_once('/var/www/<my domain goes here>...') #5 {main} thrown in /var/www/<my domain goes here>/include/dblayer/functions_mysqli.inc.php on line 220
I don't know if it is relevant but I deleted some unneeded photos before running the update rutine.
I have search the forum but couldn't find a similar issue, so I will be very grateful for your help.
Piwigo version: 2.10.2
PHP version: 7.2.24-0ubuntu0.18.04.4
MySQL version: 5.7.30-0ubuntu0.18.04.1 - (Ubuntu)
Offline
#2 2020-06-01 23:02:16
- ddtddt
- Piwigo Team
- Quetigny - France
- 2007-07-27
- 7207
Re: Fatal error after updating Manage Properties Photos plug-in
Hi :-)
Database isn't update
go to database
table plugin
edit line en change version plugin to 2.9.a for remake update database
You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.
Offline
#3 2020-06-01 23:05:15
- ddtddt
- Piwigo Team
- Quetigny - France
- 2007-07-27
- 7207
Re: Fatal error after updating Manage Properties Photos plug-in
Hi :-)
update to 2.10.c
desactivate and activate plugin
You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.
Offline
#4 2020-06-01 23:10:19
- Ed69
- Member
- 2020-06-01
- 6
Re: Fatal error after updating Manage Properties Photos plug-in
Thank you for your quick response.
I am very sorry but could you please be a bit more specific? I only know enough to be dangerous and some steps to follw would be very much appreciated.
Offline
#5 2020-06-01 23:18:45
- Ed69
- Member
- 2020-06-01
- 6
Re: Fatal error after updating Manage Properties Photos plug-in
Okay, I have done it and seems to be working.
Many thanks again!
Offline
#6 2020-06-01 23:27:08
- Ed69
- Member
- 2020-06-01
- 6
Re: Fatal error after updating Manage Properties Photos plug-in
For other members of the forum having this same issue:
1) Open your database (I did it using myphpadmin)
2) Look for the plug-ins table( in my case it was called piwigo_plugins)
3) Look for the "Manage_Properties_Photos" entry
4) Edit the field value to 2.9.a as instructed by ddtddt
5) Navigate to your piwigo webpage and login as admin
6) Select the Manage plugins option
7) Update the plugin (it should update to 2.10.c)
8) Deactivate the plugin
9) Activate it again
This worked for me like a charm... many many thanks ddtddt
Last edited by Ed69 (2020-06-01 23:28:28)
Offline