Announcement

#1 2023-02-18 16:50:08

jlarget
Member
2023-02-18
2

SQL Table piwigo_images: Out of range value for column 'latitude';

Hello/Hi/Greetings,

I recently upgraded to piwigo 13.5 and am attempting clean up my piwigo site at http://argets.com on my localhost server. All seems to work well except that I get lmysqli exceptions for out of range values at column 'latitude' when batch loading albums. This problem seems to be unique to the upgrade of piwigo as my "online" site running piwigo 13.4 and PHP7.4 seems to accept new photos with gps coordinates. Below the error message is a description of the two environments. I have tried many things to figure out the problem but the code is two complicated for me (I'm 77 years old), but would be glad to explain the trooubleshooting I've done if anyone is willing to help me and is interested in more information.
Thanks Jerry A

Error Messages:
Fatal error: Uncaught mysqli_sql_exception: Out of range value for column 'latitude' at row 7 in /Work/www/argets/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /Work/www/argets/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /Work/www/argets/include/dblayer/functions_mysqli.inc.php(550): pwg_query() #2 /Work/www/argets/include/dblayer/functions_mysqli.inc.php(385): mass_inserts() #3 /Work/www/argets/admin/site_update.php(915): mass_updates() #4 /Work/www/argets/admin.php(345): include('...') #5 {main} thrown in /Work/www/argets/include/dblayer/functions_mysqli.inc.php on line 132

Earlier I also recieved several of these warnings:
piwigo Warning: [mysql error 1264] Out of range value for column 'latitude' at row 2

My environment for the localhost is this:
localhost/argets
Piwigo 13.5.0
Installed on 17 February 2023, 19 hours ago
Operating system: Linux
PHP: 8.1.2-1ubuntu2.10 (Show info) [2023-02-18 07:41:08]
MySQL: 8.0.32-0ubuntu0.22.04.2 [2023-02-18 07:41:08]
Graphics Library: ImageMagick 6.9.11-60
Cache size 4.43 Mo   calculated 14 hours ago
Activated plugin list
Additional Pages
FCK Editor
Grum Plugins Classes.3
LocalFiles Editor
OpenStreetMap

Environment for argets.com (at hostgator hosting site) is:
Argets.com
Piwigo 13.4.0 Check for upgrade
Installed on 8 January 2022, 1 year 1 month 1 week 2 days ago
Operating system: Linux
PHP: 7.4.33 (Show info) [2023-02-18 09:16:39]
MySQL: 5.7.23-23 [2023-02-18 09:16:39]
Graphics Library: ImageMagick 6.9.10-68
Cache size 426.35 Mo   calculated 4 days ago Refresh
Activated plugin list12
Additional Pages
Advanced Menu Manager
Contact Form
Crypto Captcha
FCK Editor
Grum Plugins Classes.3
LocalFiles Editor
Perso Footer
PWG Stuffs
RV Maps&Earth
Stop Spammers
Take A Tour of Your Piwigo

Offline

 

#2 2023-02-26 01:12:39

BigIsland270972
Member
Norway
2022-03-15
374

Re: SQL Table piwigo_images: Out of range value for column 'latitude';

Hello. The latitude exif data is somehow wrong. Check your jpg files with exiftool.org this happens when you syncronize the albums and jpgs I guess.


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#3 2023-02-26 14:22:13

jlarget
Member
2023-02-18
2

Re: SQL Table piwigo_images: Out of range value for column 'latitude';

Thanks, Pics work with digikam, exiftool, and Piwigo 13.4.  I'm giving up on Piwigo.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact