Announcement

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

jroest
Member
2014-06-20
7

mysql error 1265

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)

Offline

 

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

flop25
Piwigo Team
2006-07-06
7037

Re: mysql error 1265

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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

Offline

 

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

flop25
Piwigo Team
2006-07-06
7037

Re: mysql error 1265

very weird

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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 :-)

Offline

 

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

flop25
Piwigo Team
2006-07-06
7037

Re: mysql error 1265

Could you try to disable them one by one please


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

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

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: mysql error 1265

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

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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

Offline

 

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

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: mysql error 1265

of course there are other ways !

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

and the Batch Manager to set tags

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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.

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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.

Offline

 

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

jroest
Member
2014-06-20
7

Re: mysql error 1265

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.

Offline

 

Board footer

Powered by FluxBB

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