Where is that file?

Did what you said, doesn't seem to make a difference.

Warning:  [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 't.date_available' which is not in SELECT list; this is incompatible with DISTINCT


SELECT DISTINCT(image_id) FROM (SELECT *
    FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    category_id = 1
 ) AS t 
  ORDER BY date_available DESC, file ASC, id ASC
; in /piwigo/include/dblayer/functions_mysqli.inc.php on line 830


Fatal error: Call to a member function fetch_assoc() on a non-object in /piwigo/include/dblayer/functions_mysqli.inc.php on line 891

you have the chance that we just released 2.8.3 which complies better with the default options of mysql 5.7 (error "... DISTINCT")
DB repair ? for what ? from what command?

flop25 wrote:

you have the chance that we just released 2.8.3 which complies better with the default options of mysql 5.7 (error "... DISTINCT")

Yes, it works, just wanted to post a "success story" on repairing from a very bad state - upgrading to 2.8.3 was not an obvious step.

flop25 wrote:

DB repair ? for what ? from what command?

Issued from UI because I was thinking it can help... because it is "repair", lol.

flop25 wrote:

and also how is the 'date' field in piwigo_comments?

mysql> desc piwigo_comments
    -> ;
Is this what you want?
+-----------------+-----------------------+------+-----+---------------------+----------------+
| Field           | Type                  | Null | Key | Default             | Extra          |
+-----------------+-----------------------+------+-----+---------------------+----------------+
| id              | int(11) unsigned      | NO   | PRI | NULL                | auto_increment |
| image_id        | mediumint(8) unsigned | NO   | MUL | 0                   |                |
| date            | datetime              | NO   |     | 0000-00-00 00:00:00 |                |
| author          | varchar(255)          | YES  |     | NULL                |                |
| email           | varchar(255)          | YES  |     | NULL                |                |
| author_id       | mediumint(8) unsigned | YES  |     | NULL                |                |
| anonymous_id    | varchar(45)           | NO   |     | NULL                |                |
| website_url     | varchar(255)          | YES  |     | NULL                |                |
| content         | longtext              | YES  |     | NULL                |                |
| validated       | enum('true','false')  | NO   |     | false               |                |
| validation_date | datetime              | YES  | MUL | NULL                |                |
+-----------------+-----------------------+------+-----+---------------------+----------------+

flop25 wrote:

for those who are reading, as carrots made, if you have access to mysql files, you can backup files directly but of course a dump for command line is much better

I am planning to write a script and a puppet module for this. Will publish it on this forum (if I succeed on fighting my laziness).