adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

mysql error 1366 #1396

New Issue
Closed
opened 2026-10-05 00:42:10 +02:00 by adam · 1 comment
adam commented 2026-10-05 00:42:10 +02:00
Owner
Copy link
Copy source

My env is as follows:

    Piwigo 12.2.0
    Operating system: Linux
    PHP: 8.0.14 (Show info) [2022-01-03 00:15:10]
    MySQL: 8.0.27 [2022-01-03 00:15:10]
    Graphics Library: ImageMagick 6.9.12-32
    Cache size 898.74 Mo   calculated 1 month ago Refresh

I get the following errors in my php error log during the upgrade.

They also show up every time I go to or reload the Piwigo Administration Dashboard page.

[02-Jan-2022 23:39:14 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2)\x92\x11\x04d...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^F^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Ycache_activity_last_weeks^T^B^Q\rcalculated_on\na<D2>)<92>^Q^Ddata^T^A^F^C^T^A^F^G^T^C^Q^Gdetails^T^A^Q^DUser^T^B^Q^ELogin^Q^A1^Q^DEdit^Q^A3^Q^Fnumber^F^D^Q^Ddate^Q^USunday 2 January 2022',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:39:18 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2*\xC2\x11\x0FP...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>*<C2>^Q^OProtectedAlbums^Q^E0.5.b',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:39:52 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2)\xB8\x11\x04d...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Ycache_activity_last_weeks^T^B^Q\rcalculated_on\na<D2>)<B8>^Q^Ddata^T^A^F^C^T^A^F^G^T^C^Q^Gdetails^T^A^Q^DUser^T^B^Q^ELogin^Q^A1^Q^DEdit^Q^A3^Q^Fnumber^F^D^Q^Ddate^Q^USunday 2 January 2022',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:40:11 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2*\xF7\x11\x0FP...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>*<F7>^Q^OProtectedAlbums^Q^E0.5.b',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:41:37 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2+L\x11\x0FP...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>+L^Q^OProtectedAlbums^Q^E0.5.b',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:41:47 Europe/Vienna] PHP Warning:  [mysql error 1366] Incorrect string value: '\xD2+W\x11\x0FP...' for column 'data' at row 1

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>+W^Q^OProtectedAlbums^Q^E0.5.b',now())
; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
[02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning:  Undefined array key "U_RETURN" in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.header.tpl.php on line 104
[02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning:  Attempt to read property "value" on null in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.h
eader.tpl.php on line 104
[02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning:  Undefined array key "USERNAME" in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.header.tpl.
php on line 112
[02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning:  Attempt to read property "value" on null in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.h
eader.tpl.php on line 112
My env is as follows: ``` Piwigo 12.2.0 Operating system: Linux PHP: 8.0.14 (Show info) [2022-01-03 00:15:10] MySQL: 8.0.27 [2022-01-03 00:15:10] Graphics Library: ImageMagick 6.9.12-32 Cache size 898.74 Mo   calculated 1 month ago Refresh ``` I get the following errors in my php error log during the upgrade. They also show up every time I go to or reload the Piwigo Administration Dashboard page. ``` [02-Jan-2022 23:39:14 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2)\x92\x11\x04d...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^F^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Ycache_activity_last_weeks^T^B^Q\rcalculated_on\na<D2>)<92>^Q^Ddata^T^A^F^C^T^A^F^G^T^C^Q^Gdetails^T^A^Q^DUser^T^B^Q^ELogin^Q^A1^Q^DEdit^Q^A3^Q^Fnumber^F^D^Q^Ddate^Q^USunday 2 January 2022',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:39:18 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2*\xC2\x11\x0FP...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>*<C2>^Q^OProtectedAlbums^Q^E0.5.b',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:39:52 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2)\xB8\x11\x04d...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Ycache_activity_last_weeks^T^B^Q\rcalculated_on\na<D2>)<B8>^Q^Ddata^T^A^F^C^T^A^F^G^T^C^Q^Gdetails^T^A^Q^DUser^T^B^Q^ELogin^Q^A1^Q^DEdit^Q^A3^Q^Fnumber^F^D^Q^Ddate^Q^USunday 2 January 2022',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:40:11 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2*\xF7\x11\x0FP...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>*<F7>^Q^OProtectedAlbums^Q^E0.5.b',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:41:37 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2+L\x11\x0FP...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>+L^Q^OProtectedAlbums^Q^E0.5.b',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:41:47 Europe/Vienna] PHP Warning: [mysql error 1366] Incorrect string value: '\xD2+W\x11\x0FP...' for column 'data' at row 1 REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('25139hnbbq4iku4snfmvq3s2fj4d655v46bvqoanmr3fhi6otl19ri8q3ld987in1u8b','\0\0\0^B^T^H^Q^Qpwg_show_metadata^E^Q^Gpwg_uid^F^A^Q\npwg_device^Q^Gdesktop^Q^Tpwg_referer_image_id^Q^D2031^Q^Hpwg_caps^T^C^F\0^Q^A2^F^A^Q^D1755^F^B^Q^C999^Q^Qneed_update12.2.0^D^Q^Vextensions_need_update^T\0^Q^Tincompatible_plugins^T^B^Q\n~~expire~~\na<D2>+W^Q^OProtectedAlbums^Q^E0.5.b',now()) ; in /data/projects/piwigo/include/dblayer/functions_mysqli.inc.php on line 847 [02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning: Undefined array key "U_RETURN" in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.header.tpl.php on line 104 [02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning: Attempt to read property "value" on null in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.h eader.tpl.php on line 104 [02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning: Undefined array key "USERNAME" in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.header.tpl. php on line 112 [02-Jan-2022 23:42:00 Europe/Vienna] PHP Warning: Attempt to read property "value" on null in /data/projects/piwigo/_data/templates_c/1nje60e^8e42a03cd9623381452c626db0710cded44636ed_0.file.h eader.tpl.php on line 112 ``` <!-- github-sync-id:1092122527 -->
adam closed this issue 2026-10-05 00:42:10 +02:00
adam commented 2026-10-05 00:42:11 +02:00
Author
Owner
Copy link
Copy source

Anyone? Seriously, what is going on here? No reply on github. No reply on the forum. This community sucks. I am ok with "hey, we do not know" or "we are looking into it", but utter silence is just a bad move.

Anyone? Seriously, what is going on here? No reply on github. No reply on the forum. This community sucks. I am ok with "hey, we do not know" or "we are looking into it", but utter silence is just a bad move. <!-- github-comment-id:1016850576 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#1396