Piwigo.org

jroest · 2014-06-20 18:05:40

Hello,

When I try to add photos as admin I get this and only this on the page:

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

INSERT INTO piwi_history
(
date,
time,
user_id,
IP,
section,
category_id,
image_id,
image_type,
tag_ids
)
VALUES
(
CURRENT_DATE,
CURRENT_TIME,
1,
'81.229.73.186',
'add_photos',
NULL,
NULL,
NULL,
NULL
)
; in /home/roestse/public_html/pwphoto/include/dblayer/functions_mysqli.inc.php on line 798

When I try as a user to add photos I get the same but at the end of the page.

How to solve this?
ps. the gallery is open only for loged in users

Piwigo version: 2.6.3
PHP version: 5.3.28
MySQL version: 5.5.37-cll
Piwigo URL: http://roest.se/pwphoto/

Last edited by mistic100 (2014-06-20 18:07:18)

flop25 · 2014-06-20 18:17:19

Hello

Is that a fresh new gallery? If yes how was it installed?

Could you go in your database manager provided by your hoster and check what is the Type set for the column "section" of the the table piwi_history

jroest · 2014-06-20 20:40:53

Installed the gallery a few weeks ago using the Softaculous app installer provided by my host.
It reads Type: ENUM at piwi_history

flop25 · 2014-06-20 20:53:35

very weird

did you activated the history for admin? What's your plugins?

jroest · 2014-06-20 21:21:11

History activated for admins and users.

Plugins are as follows;
Community, Exif View, Icy Modify Picture, Image Preview, Language Switch, LocalFiles Editor, NBM Subscriber, Smilies Support, Theme Switch

I get this in Firefox, Chrome, IE. Tried them all just in case :-)

flop25 · 2014-06-20 21:28:32

Could you try to disable them one by one please

mistic100 · 2014-06-20 21:39:47

You used Community to upload right ?

it think the problem is that pwg_log() function reads $page['section'] global var, which values "add_photos" on upload page

I notify the author

jroest · 2014-06-20 22:59:55

Yes, I use Community to upload.

Any other way to upload? Maybe something that gives you the possibility to set Tags at the same time. As it is now you have to edit the picture after upload to set Tags for that picture.

The other info you wrote doesn't tell me much :-D But I'll wait for e respons from the Author via you.
Happy for the support so far. Thanks

mistic100 · 2014-06-20 23:01:01

of course there are other ways !

Admin->Photos->Add (that's pretty obvious)

and the Batch Manager to set tags

jroest · 2014-06-20 23:06:17

Additional info:
If I turn off History for admins I get a blank page when I try to upload a photo, ie not able to upload a photo.
For users the warning dissappears when history is turned off and the upload works.

jroest · 2014-06-20 23:18:50

mistic100 wrote:
of course there are other ways !

Admin->Photos->Add (that's pretty obvious)

and the Batch Manager to set tags

I'm truly sorry, I was not clear in what I was meaning and looking for. I was thinking of the users not having admin rights when uploading their photos. Meaning I would like them to have the possibility under Photo properties to set the Tags prior to uploading the photo. Just a thing I would like to see in a future update of Piwigo.

jroest · 2014-06-20 23:40:37

flop25 wrote:
Could you try to disable them one by one please

Turning them off one by one did not remove the warning. However when turning off Icy Modify Picture I got the upload page to load with the warning text at the end of that page.

Piwigo.org

Announcement

#1 2014-06-20 18:05:40

mysql error 1265

#2 2014-06-20 18:17:19

Re: mysql error 1265

#3 2014-06-20 20:40:53

Re: mysql error 1265

#4 2014-06-20 20:53:35

Re: mysql error 1265

#5 2014-06-20 21:21:11

Re: mysql error 1265

#6 2014-06-20 21:28:32

Re: mysql error 1265

#7 2014-06-20 21:39:47

Re: mysql error 1265

#8 2014-06-20 22:59:55

Re: mysql error 1265

#9 2014-06-20 23:01:01

Re: mysql error 1265

#10 2014-06-20 23:06:17

Re: mysql error 1265

#11 2014-06-20 23:18:50

Re: mysql error 1265

mistic100 wrote:

#12 2014-06-20 23:40:37

Re: mysql error 1265

flop25 wrote:

Board footer