Announcement

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

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

videastic
Member
2015-09-17
5

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

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)

Offline

 

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

Torsten
Guest

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

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

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13573

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

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?

Offline

 

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

videastic
Member
2015-09-17
5

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

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)

Offline

 

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

Torsten
Guest

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

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

 

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

videastic
Member
2015-09-17
5

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

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.

Offline

 

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

Ibanez
Guest

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

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

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

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact