#1189 Image galleries : Comment settings broken

open-fixed
nobody
5
2004-08-27
2004-01-14
Thomas
No

In the tiki-admin.php => Image galleries administration
section, when I try to change the "comments ordering
default" to either newest first or oldest first, I get
the following error:

Warning: mysql error: Duplicate entry
'image_galleries_comments_default_orderin' for key 1 in
query:
insert into `tiki_preferences`(`name`,`value`) values(?,?)
in /html/tikiwiki/lib/tikidblib.php on line 125

Discussion

  • Logged In: YES
    user_id=738765

    I don't get that. I have "Comments default ordering" which
    proposes only Date and Points, I can't see what you're
    talking about.

     
  • Logged In: YES
    user_id=738765

    OK, this was introduced since 1.7. I have the bug on 1.8CVS.
    I don't really know what means this DB error.

     
    • summary: Image gallery comment settings broken --> Image galleries : Comment settings broken
    • milestone: 356877 --> 374908
    • status: open --> open-accepted
     
  • Logged In: YES
    user_id=751357

    I get the same error, however it's a bit more for me:

    Warning: mysql error: Duplicate entry
    'image_galleries_comments_default_orderin' for key 1 in query:
    insert into `tiki_preferences`(`name`,`value`) values(?,?)
    in /home/www/web104/html/lib/tikidblib.php on line 125
    Values:
    Array ( [0] => image_galleries_comments_default_ordering [1]
    => points_desc )
    $result is false
    $result is empty

    I'm running 1.8.1, possible entries for "Comments default
    ordering" is "newest first", "oldest first" and "points".

    Bug is reproducable, contact me for details.

     
    • milestone: 374908 --> 383505
     
  • Logged In: YES
    user_id=738765

    Yeah jspielmann everyone must have that.

     
  • Logged In: YES
    user_id=738765

    Note that This value has 41 characters while 40 is the limit
    for this field. I suppose that must be the problem since
    there's really nothing special with this.

     
    • milestone: 383505 --> 392507
     
    • milestone: 392507 -->
    • status: open-accepted --> open-fixed
     
  • Logged In: YES
    user_id=738765

    Fixed for 1.9 considering previous comment.

     
  • Damian Parker
    Damian Parker
    2004-08-26

    • status: open-fixed --> closed-fixed
     
    • status: closed-fixed --> open-fixed