Announcement

#1 2011-06-08 12:58:24

broadstairs
Member
2011-05-28
11

MySQL errors using 2.2.2

I have a family user that when they go to the upload page they get

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

INSERT INTO piwigo_history
  (
    date,
    time,
    user_id,
    IP,
    section,
    category_id,
    image_id,
    image_type,
    tag_ids
  )
  VALUES
  (
    CURRENT_DATE,
    CURRENT_TIME,
    3,
    '127.0.0.1',
    'add_photos',
    NULL,
    NULL,
    NULL,
    NULL
  )
; in /home/stuart/Work/Web-SSI/piwigo/include/dblayer/functions_mysql.inc.php on line 654

This is after installing 2.2.2 over the top of 2.2.1. Is this a known error or what am I doing wrong?

The upgrade.php script said there was nothing to do.

Stuart

Last edited by broadstairs (2011-06-08 13:00:09)

Offline

 

#2 2011-06-09 11:35:58

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

Re: MySQL errors using 2.2.2

Hi broadstairs,

I see the problem. I have to deactivate the history log for the "add_photos" page.

I don't understand why this problem didn't occur during my own tests! Which version of MySQL are you using?

Offline

 

#3 2011-06-09 11:39:00

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

Re: MySQL errors using 2.2.2

Offline

 

#4 2011-06-09 11:40:02

broadstairs
Member
2011-05-28
11

Re: MySQL errors using 2.2.2

It is an early version of V5 MySQL.

The problem does not happen if I use my admin user id though.

Stuart

Offline

 

#5 2011-06-09 11:41:17

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

Re: MySQL errors using 2.2.2

broadstairs wrote:

The problem does not happen if I use my admin user id though.

Probably because Piwigo doesn't log your own visits into history, see your settings on screen [Administration > Configuration > Options > History]

Offline

 

Board footer

Powered by FluxBB

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