I will definately and will update you ,, fan of piwigo

Thanks,

I have come across a few things but I have put them in the Beta forum.

Kriss :)

I will be setting this up in a test to see how it goes for you ;0)

I will of course both test and upgrade, but as it is right now I am concerned about hot linking of images for one of my Piwigo sites.

Currently a couple of my members share uploaded pictures as follows, an example:
https://shots.lotrokin.me/i.php?/upload … c1d-xl.jpg

/i.php/upload/date+something-random.extension .

I really hope that will continue working or it will be a hassle, bordering on a showstopper.It has been hotlinked that way on many places, most notably a game forum and Facebook.


Before you ask me why we did it this way, I must say I posted a question on the forums asking about the "correct" way to hotlink, and above should be fine according to information available at that time: [Forum, topic 28290] Persistent hot linking.

I'm getting the error below; this is on a Beta2 install running on MySQL 8.

Piwigo encountered an irrecoverable error
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank,global_rank,commentable,visible,status)
  VALUES('asdf','0','0','true','tru' at line 2

INSERT INTO piwigo_categories
  (name,rank,global_rank,commentable,visible,status)
  VALUES('asdf','0','0','true','true','public')

#1    my_error /usr/local/www/apache24/data/piwigo/include/dblayer/functions_mysqli.inc.php(132)
#2    pwg_query /usr/local/www/apache24/data/piwigo/include/dblayer/functions_mysqli.inc.php(617)
#3    single_insert /usr/local/www/apache24/data/piwigo/admin/include/functions.php(1539)
#4    create_virtual_category /usr/local/www/apache24/data/piwigo/admin/cat_list.php(163)
#5    include /usr/local/www/apache24/data/piwigo/admin.php(310)