search

plegall / Piwigo-community

11 stars 24 forks source link

MySQL issue Community plugin 'photo upload' in 'functions_mysqli.inc.php' #1

Open noprobs opened 9 years ago

noprobs commented 9 years ago

Piwigo 2.7.3: OS: Centos 6.6 PHP: 5.3.3 MySQL: 5.6.23 Graphics Library: External ImageMagick 6.5.4-7 Community Plugin: 2.7.a

When clicking 'Upload Photos' from Community Plugin I receive the error below. If I ignore and start upload I am then presented with a blanks screen but photo has been uploaded.

Warning: [mysql error 1265] Data truncated for column 'section' at row 1

INSERT INTO edenlodge_history ( date, time, user_id, IP, section, category_id, image_id, image_type, tag_ids ) VALUES ( CURRENT_DATE, CURRENT_TIME, 4, '192.168.1.7', 'add_photos', NULL, NULL, NULL, NULL ) ; in /var/www/html/edenlodge/piwigo/include/dblayer/functions_mysqli.inc.php on line 830

Thanks,

Jon

ghost commented 7 years ago

Sae issue here. Does anyone have a solution for this? I a using 2.8.a on Piwigo 2.9.0beta2

wpok commented 7 years ago

Sloved.

Since column "section" is enum-type, Community add a history log using "add_photos" for this section column, then cause the error.

Modify Piwigo db, table "piwigo_history" structure. Add "add_photos" to column "section" enum-type values.

shadow974 commented 7 years ago

Modify Piwigo db, table "piwigo_history" structure. Add "add_photos" to column "section" enum-type values.

works for me! thanks!

richcoremedia commented 7 years ago

works for me too! Thanks!

plepe commented 6 years ago

Any plans to automatically change the section column on enabling this module? This problems was first reported in 2015!