Hello!

I'm rather new to Piwigo, but I'm accustomed to CMS like Joomla, Wordpress and some more.

Recently I set up my own Website using Piwigo and everything worked fine. Some days ago I moved it to a new host (webgo.de) and my site is broken since then.

I followed these instructions to move my site: https://piwigo.org/forum/viewtopic.php?id=29175

Searching the forum I found out that there have been several problems with 'reserved name' and 'rank', but I could figure out a solution for my problem.

Any help is really appreciated!

Here are the details:

Server Environment
* Piwigo 2.9.5
* OS: Linux
* PHP: 7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626 [2019-06-08 11:53:09]
* MySQL: 8.0.15 [2019-06-08 11:53:09]
* Graphics library: ImageMagick 6.9.7-4

URL https://baerbel.at/index.php (Please don't forget to include index.php at the end, otherwise you only see my "Under construction" message)

Warning:  [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 '' at line 16

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    nb_categories,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc
    ON id = cat_id
    AND user_id = 1
  WHERE id_uppercat is NULL
     
  ORDER BY rank in /home/www/baerbel.at/include/dblayer/functions_mysqli.inc.php on line 845

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/www/baerbel.at/include/dblayer/functions_mysqli.inc.php:226 Stack trace: #0 /home/www/baerbel.at/include/category_cats.inc.php(76): pwg_db_fetch_assoc(false) #1 /home/www/baerbel.at/index.php(318): include('/home/www/baerb...') #2 {main} thrown in /home/www/baerbel.at/include/dblayer/functions_mysqli.inc.php on line 226

PHP Info
https://baerbel.at/phpinfo.php

Thank you!

Barbara (Bärbel)