Piwigo.org

videastic · 2015-09-24 12:58:16

Hello/Hi/Greetings,

Can somebody please help me solving this error?: Warning: [mysql error 1366] Incorrect integer value: 'undefined' for column 'level' at row 1

INSERT INTO piwigo_images
(file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
VALUES('DSC06470.jpg','DSC06470','2015-09-23 18:06:38','./upload/2015/09/23/20150923180638-1f5bc981.jpg','877','1280','853','1f5bc9814f8e390e7b98fc2030fdea6c','1','0','undefined') in /Users/home/Sites/piwigo/include/dblayer/functions_mysqli.inc.php on line 830

What's going on?
I get it every time when uploading any size photo with the community flash uploader.

Piwigo version: 2.7.4
PHP version: 5.5.27
MySQL version: 5.6.26
Piwigo URL: http://

Last edited by videastic (2015-09-24 17:00:15)

Torsten · 2015-10-17 13:54:27

Hello all,

does nobody has an idea? I have the same error reproducible.

Piwigo version: 2.7.4
PHP version: 5.6.1
MySQL version: MariaDB 10.0.21
Piwigo URL: http://

Client PC:
Windows 7 up to date
Firefox and Flash latest version

Best

plg · 2015-10-17 19:01:22

Hi Torsten and videastic,

Does it happen when you try to set a "who can see this photo"? (ie, the permission level)
Does it happen when moderation is on or off?

videastic · 2015-10-18 11:40:48

Hi plg,

It happens regardless of any specific settings. I fixed it by making changes to the mysql database. The problem is related to the 'level' Type value in the database. Changing the Type value solved the problem. I don't remember exactly what the value was before but this is how it looks now.
Hope it helps.

Something else, I am running Piwigo on a mac server. Since I upgraded to El Capitan the jplayer doesn't work anymore.

Last edited by videastic (2015-10-18 11:49:53)

Torsten · 2015-10-19 19:50:30

Hi plg,

I can only set "title", "author" and "description". So I can't test to set a permission.
I also tested it with moderation and got the same error.

My current type for level in the database is "tinyint(3)". Which makes sense if a number between 0 and 4 should be in there. Just making it possible to have "undefined" does seems to be real solution. @videastic: Are you changing the value in the database afterwords or are you leaving the "undefined"?

Best
Torsten

videastic · 2015-10-19 22:26:12

Hi Torsten,

I don't understand your question exactly. I use phpmyadmin to make changes to the database. I indeed changed the Type value from tinyint(3) to char(16) in the 'piwigo_images' table. After that the error was gone. Works like a charm.
P.

Ibanez · 2016-08-01 02:49:28

@videastic thanks bro your solution works fine for me ! Hope that will be no bugs

Piwigo.org

Announcement

#1 2015-09-24 12:58:16

[Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#2 2015-10-17 13:54:27

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#3 2015-10-17 19:01:22

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#4 2015-10-18 11:40:48

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#5 2015-10-19 19:50:30

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#6 2015-10-19 22:26:12

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

#7 2016-08-01 02:49:28

Re: [Plugin] Community (flash) uploader: Warning: [mysql error 1366]

Board footer