Hello/Hi/Greetings,

Click on Dashboard icon while on admin page gives php error. Had to add a new table piwigo_comments_categories to the MySQL database to resolve the first error.
Unfortunately there are other php errors that seem to be related, so it seems that the install does not actually create this table. I have no idea what the field names or datatypes should be!

Curiously enough, this happens when using a browser (Chrome or Firefox) on a PC, but it seems to work using Safari on an iphone.

Piwigo version: 2.9.3
PHP version: 7
MySQL version: 5.7.23
Piwigo URL: http://cinematiks.com/services/piwigo/

=======first error message===========

Warning:  [mysql error 1146] Table 'xxx.piwigo_comments_categories' doesn't exist

SELECT COUNT(*)
  FROM piwigo_comments_categories
; in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Uncaught Error: Call to a member function fetch_row() on boolean in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php:231 Stack trace: #0 /home/xxx/public_html/services/piwigo/plugins/Comments_on_Albums/include/events.inc.php(35): pwg_db_fetch_row(false) #1 /home/xxx/public_html/services/piwigo/include/functions_plugins.inc.php(279): coa_admin_intro() #2 /home/xxx/public_html/services/piwigo/admin.php(311): trigger_notify('loc_begin_admin...') #3 {main} thrown in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php on line 231

==========another error message==============

Warning:  [mysql error 1054] Unknown column 'category_id' in 'where clause'

SELECT
    COUNT(*) AS nb_comments
  FROM piwigo_comments_categories
  WHERE category_id = 1 AND validated = 'true'
; in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php:226 Stack trace: #0 /home/xxx/public_html/services/piwigo/plugins/Comments_on_Albums/include/coa_albums.php(199): pwg_db_fetch_assoc(false) #1 /home/xxx/public_html/services/piwigo/plugins/Comments_on_Albums/include/events.inc.php(13): include('/home/fogcityci...') #2 /home/xxx/public_html/services/piwigo/include/functions_plugins.inc.php(279): coa_albums() #3 /home/xxx/public_html/services/piwigo/include/page_header.php(104): trigger_notify('loc_after_page_...') #4 /home/xxxa/public_html/services/piwigo/index.php(367): include('/home/fogcityci...') #5 {main} thrown in /home/xxx/public_html/services/piwigo/include/dblayer/functions_mysqli.inc.php on line 226

Last edited by rieka (2018-08-28 04:33:48)