Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

videojs sync breaks with database error - incorrect handling of quotation marks? #213

Open
outdoorbits opened this issue Aug 28, 2023 · 1 comment

Comments

@outdoorbits
Copy link

The synchronization of VideoJS breaks off when I activate "Synchronize metadata". Unfortunately I don't get an error message in the log file ($conf['log_level'] = 'DEBUG';).

php error message is:
<br /> <b>Fatal error</b>: Uncaught mysqli_sql_exception: Data truncated for column 'longitude' at row 1 in /www/piwigo/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /www/piwigo/include/dblayer/functions_mysqli.inc.php(132): mysqli-&gt;query() #1 /www/piwigo/plugins/piwigo-videojs/include/function_sync2.php(102): pwg_query() #2 /www/piwigo/plugins/piwigo-videojs/admin/admin_sync.php(140): require_once('...') #3 /www/piwigo/plugins/piwigo-videojs/admin/admin.php(68): include_once('...') #4 /www/piwigo/admin/plugin.php(53): include_once('...') #5 /www/piwigo/admin.php(345): include('...') #6 {main} thrown in <b>/www/piwigo/include/dblayer/functions_mysqli.inc.php</b> on line <b>132</b><br />
Probably the error might show up here:
GPS Longitude : 8 deg 32' 25.80" E
Is there a problem about the quotation marks?

upgrade.php says "No upgrade required, the database structure is up to date".

update piwigo_config set value = 'a:0:{}' where param = 'vjs_sync'; didn't change anything.

Could anybody help me to get error messages or did anybody solve this problem?

Thank you!

Here is my config.inc.php:
`<?php
$conf['show_php_errors'] = E_ALL & ~E_NOTICE & ~E_DEPRECATED;
// +-----------------------------------------------------------------------+
// | log |
// +-----------------------------------------------------------------------+
// Logs directory, relative to $conf['data_location']
$conf['log_dir'] = '/logs';

// Log level (OFF, CRITICAL, ERROR, WARNING, NOTICE, INFO, DEBUG)
// development = DEBUG, production = ERROR
$conf['log_level'] = 'DEBUG';

// Keep logs file during X days
$conf['log_archive_days'] = 30;

$conf['upload_form_all_types'] = true;
$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_. ]+$/';
$conf['use_exif'] = true;
$conf['use_exif_mapping'] = array(
'date_creation' => 'DateTimeOriginal',
);
$conf['show_exif'] = true;
$conf['show_exif_fields'] = array(
'ExposureTime',
// 'ShutterSpeed',
// 'COMPUTED;ApertureFNumber',
'FNumber',
'ISOSpeedRatings',
'ExposureMode',
'DateTimeOriginal',
// 'FocalLengthIn35mmFilm',
'Flash',
'FocalLength',
'UndefinedTag:0xA434',
'Make',
'Model',
'make',
'model',
'Software',
'ExposureBiasValue',
'FILE;FileSize',
'WhiteBalance',
'filesize',
'format',
'formatprofile',
'codecid',
'frame_rate',
'resolution',
'MeteringMode',
'ExposureProgram',
'LightSource',
// 'Contrast',
// 'Saturation',
// 'Sharpness',
'bitrate',
'channel',
'date_creation',
'display_aspect_ratio',
'duration',
'latitude',
'longitude',
'playtime_seconds',
'sampling_rate',
// 'type',
'rotation',
'ExifVersion',
);
$conf['sync_exclude_folders'] = array (
'NEF',
'.videoThumbnails',
'NKSC PARAM','NKS PARAM',
'darktable exported',
'.Thumbnails',
'.thumbnails',
);
$conf['inheritance_by_default'] = true;
$conf['derivative_default_size'] = 'xlarge';

// picture_ext : file extensions for picture file, must be a subset of
// file_ext
$conf['picture_ext'] = array('jpg','jpeg','png','gif');

// file_ext : file extensions (case sensitive) authorized
$conf['file_ext'] = array_merge(
$conf['picture_ext'],
array('tiff', 'tif', 'mpg','avi','mp3','ogg','svg')
);

// enable_formats: should Piwigo search for multiple formats?
$conf['enable_formats'] = false;

// format_ext : file extensions for formats, ie additional versions of a
// photo (or nay other file). Formats are in sub-directory pwg_format.
$conf['format_ext'] = array('cr2', 'tif', 'tiff', 'nef', 'dng', 'ai', 'psd');
?>`

Piwigo 13.8.0

Environment:
Ubuntu 22.04.2 LTS
Apache/2.4.52 (Ubuntu)
10.6.12-MariaDB-0ubuntu0.22.04.1
MediaInfoLib - v21.09
ffprobe version 4.4.2-0ubuntu0.22.04.1
exiftool 12.4
ffmpeg version 4.4.2-0ubuntu0.22.04.1

@GJSchaller
Copy link

GJSchaller commented Dec 20, 2023

Edit - my error was different, related to: #205

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants