Piwigo.org

Averell · 2013-11-05 00:08:38

Hello,

Since I upgraded to the last version, or install a new plugin, I can no longer insert images. Pictures are correctly uploaded, but not inserted into the database.

I get this error right after the upload:

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('brompton profil.jpg','brompton profil','2013-11-04 23:42:55','./upload/2013/11/04/20131104234255-759b553a.jpg','50','150','169','759b553a80c12407735124a57db6df00','1','0','undefined') in C:\inetpub\wwwroot\piwigo\include\dblayer\functions_mysqli.inc.php on line 834

Looks like there is a mismatch between value and field.

Thank for your help.

flop25 · 2013-11-05 00:11:45

Hi
from which version to which did you updated? Try first to download and reupload by overwriting existing files, your current version of Piwigo (the new one)

Averell · 2013-11-05 23:11:50

Well,

After my different tries, I restored a 2.5.2 on which upload worked:
=> Upload is now working (without touching the database)

I then upgraded to 2.5.3 ==> upload KO !!
I happened without touching anything in the administration nor the database.

I truly think the insite upgrade process is screwing the website.
At least it does on my server...

flop25 · 2013-11-05 23:15:59

flop25 wrote:
Try first to download and reupload by overwriting existing files, your current version of Piwigo (the new one)

Averell · 2013-11-05 23:42:33

I have already tried to overwrite the install on the upgraded 2.5.2 with no luck

I don't need actually the 2.5.3 and I've spent too much time on this issue.

I upgraded because it was available and easy to execute !

I'd better wait for a major release now :)

flop25 · 2013-11-05 23:58:28

nothing has changed in 2.5.3 about upload. I just checked the files

do you have any plugin enabled and uptodate

granddub · 2014-08-29 16:09:38

I had the same problem.

I don't know exactly the consequences of my change but it's work.

In then file plugins/community/main.inc.php, I search:

add_event_handler('init', 'community_uploadify_privacy_level');
function community_uploadify_privacy_level()
{
if (script_basename() == 'uploadify' and !is_admin())
{
$_POST['level'] = 16;
}
}

and replace with:
add_event_handler('init', 'community_uploadify_privacy_level');
function community_uploadify_privacy_level()
{
if (script_basename() == 'uploadify' and !is_admin())
{
$_POST['level'] = 16;
}
$_POST['level'] = 16; // <--- my change
}

If an community plugin expert can explain, I will thank

flop25 · 2014-08-29 16:18:31

oh ! that's a community plugin issue Ok
author notified

videastic · 2015-09-25 09:31:33

granddub's solution solves the community plugin flash upload issue but breaks the Album Manager. Does anybody knows a way around this?
Thanks!

Piwigo.org

Announcement

#1 2013-11-05 00:08:38

INSERT into piwigo_images failed

#2 2013-11-05 00:11:45

Re: INSERT into piwigo_images failed

#3 2013-11-05 23:11:50

Re: INSERT into piwigo_images failed

#4 2013-11-05 23:15:59

Re: INSERT into piwigo_images failed

flop25 wrote:

#5 2013-11-05 23:42:33

Re: INSERT into piwigo_images failed

#6 2013-11-05 23:58:28

Re: INSERT into piwigo_images failed

#7 2014-08-29 16:09:38

Re: INSERT into piwigo_images failed

#8 2014-08-29 16:18:31

Re: INSERT into piwigo_images failed

#9 2015-09-25 09:31:33

Re: INSERT into piwigo_images failed

Board footer