Piwigo.org

xaero27 · 2020-11-23 21:24:40

Hi,

I have a piwigo server with about 80k images which is synchronized once every hour.

This has been working for months. However, since the last MySQL-Update, following error is thrown during sync:

I have already tried a completely new installation, but got the same result.

Is it possible that MySQL is misconfigured in some way?

Any help would be appreciated!

Kind regards
Fabian

Code:

Warning:  [mysql error 1264] Out of range value for column 'id' at row 1

INSERT  INTO `piwigo_categories`
  (`id`,`dir`,`name`,`site_id`,`id_uppercat`,`uppercats`,`commentable`,`visible`,`status`,`rank`,`global_rank`)
  VALUES('65536','berprüfung_Rauchabzugsklappe','berprüfung Rauchabzugsklappe','1','32144','32138,32144,65536','true','true','public','3','3.5.3')
  , ('65537','laustritt Kupplung-Getriebe M2','laustritt Kupplung-Getriebe M2','1','32241','32138,32209,32237,32241,65537','true','true','public','13','3.23.3.4.13')
  , ('65538','Test','Test','1','65537','32138,32209,32237,32241,65537,65538','true','true','public','1','3.23.3.4.13.1')
  , ('65539','Alte Leistungsschalter','Alte Leistungsschalter','1','32341','32278,32338,32341,65539','true','true','public','3','4.14.2.3')
  , ('65540','BB 08.10.2002','BB 08.10.2002','1','32508','32503,32508,65540','true','true','public','7','2.3.7')
  , ('65541','labscheider','labscheider','1','32540','32503,32540,65541','true','true','public','7','2.6.7')
  , ('65542','lab in /var/www/html/Fotos/include/dblayer/functions_mysqli.inc.php on line 856



Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
    AND status = 'private'' at line 3

SELECT id
  FROM piwigo_categories
  WHERE id IN ()
    AND status = 'private'
; in /var/www/html/Fotos/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/html/Fotos/include/dblayer/functions_mysqli.inc.php:917 Stack trace: #0 /var/www/html/Fotos/admin/include/functions.php(2702): query2array('\nSELECT id\n FR...', NULL, 'id') #1 /var/www/html/Fotos/admin/site_update.php(413): add_permission_on_category(Array, Array) #2 /var/www/html/Fotos/admin.php(309): include('/var/www/html/F...') #3 {main} thrown in /var/www/html/Fotos/include/dblayer/functions_mysqli.inc.php on line 917

Piwigo 2.10.2
Betriebssystem: Linux
PHP: 7.2.24 (Info anzeigen) [2020-11-23 20:16:31]
MySQL: 5.5.68-MariaDB [2020-11-23 21:16:31]
Grafikbibliothek: ImageMagick 6.9.10-68

erAck · 2020-11-24 00:14:13

Do you really have more than 65535 categories? Or did something run wild?

The piwigo_categories id field is of type smallint(5), so can't hold values greater than 65535. Which "'65536','berprüfung_Rauchabzugsklappe',..." exceeds and fails at and the following as well.

Apart from that, those category 'dir' and 'name' names look odd, like omitting or split at some character ('berprüfung_Rauchabzugsklappe','laustritt Kupplung-Getriebe M2','labscheider'). Maybe upper case umlauts are missing from your sync_chars_regex.

What is your $conf['sync_chars_regex'] value anyway? Maybe that's part of your problem.

xaero27 · 2020-11-30 20:05:03

Hello erAck, thanks for the reply.

Indeed, there must be something wrong with the categories.

I've done a fresh install, and added the pictures once again. After defining the correct regex, I get no errors at importing, but the strange thing is, that every time I synchronize, piwigo finds 26 new folders and deletes 25 new folders. Maybe there is a bug in the import routine?

Is there a possibility to display the added and deleted albums in the log file?

Kind regards
Fabian

erAck · 2020-11-30 22:17:43

I presume you did not define a correct sync_chars_regex matching your directories, so what is it?

Check log files in your _data/logs/ directory if they reveal something, if the config's
$conf['log_dir'] = '/logs';
isn't set differently and there's
$conf['log_level'] = 'DEBUG';

Or find a strategic entry point in admin/site_update.php in the directories / categories section around where sync_chars_regex is used to hook in a logging.

Piwigo.org

Announcement

#1 2020-11-23 21:24:40

Sync not possible after update to MariaDB 5.5.68

Code:

#2 2020-11-24 00:14:13

Re: Sync not possible after update to MariaDB 5.5.68

#3 2020-11-30 20:05:03

Re: Sync not possible after update to MariaDB 5.5.68

#4 2020-11-30 22:17:43

Re: Sync not possible after update to MariaDB 5.5.68

Board footer