Unable to make changes / "filesource class not found"

japowers / 2016-08-08 14:45:12   

I've installed Indexhibit many times but this time after install I am unable to add exhibits ("filesource class not found"), or make any changes through the module (everything just bounces back to default settings). I am using cpanel. I have reset everything, reinstalled, and made new databases. The database user has all the privileges.

Interestingly I can make changes to the code in the assets.

website: test.harrisonny.biz
username/pw: indexhibit defaults

japowers / 2016-08-11 20:28:58   

I think I am closer – it is something to do with charset, and maybe the php.ini

I set everything to utf_general_ci (database operation, table collation and structure options) and I could change some stuff (time zone and exhibit options) but not everything (admin->theme).

pkyeck / 2016-12-28 20:29:20   

any news on this issue?

just installed a completely new version of indexhibit and got a couple of error during installation. fixed those - but now I can't update/create anything :(

Vaska A / 2016-12-29 04:18:53   

I doubt this is any different of a problem than it was before (this is not a completely new version of Indexhibit). It's a collation issue and you have to deal with mysql for that (there are threads in here on this already). I believe this happens with older versions of mysql. I've never been able to replicate this problem - I only see it when I do...

I would love to know the errors you had with installation, as well.

pkyeck / 2016-12-29 08:00:27   

I downloaded version 21.19.37.
I also used a newly setup server for this - it is running:

  1. # mysql --version
  2. mysql  Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using  EditLine wrapper

# php --version
PHP 7.0.8-0ubuntu0.16.04.3 (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.8-0ubuntu0.16.04.3, Copyright (c) 1999-2016, by Zend Technologies

Collations for all tables are looking good.

  1. mysql> show table status;
  2. +---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+
  3. | Name                | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation       | Checksum | Create_options | Comment |
  4. +---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+
  5. | iptocountry         | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |           NULL | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  6. | ndxz_abstracts      | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  7. | ndxz_media          | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  8. | ndxz_objects        | MyISAM |      10 | Dynamic    |    4 |            110 |         440 | 281474976710655 |         2048 |         0 |              6 | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  9. | ndxz_objects_prefs  | MyISAM |      10 | Dynamic    |    3 |             86 |         260 | 281474976710655 |         2048 |         0 |              4 | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  10. | ndxz_plugins        | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2016-12-28 17:49:42 | 2016-12-28 17:49:42 | NULL                | utf8_general_ci |     NULL |                |         |
  11. | ndxz_sections       | MyISAM |      10 | Dynamic    |    3 |             42 |         128 | 281474976710655 |         5120 |         0 |              4 | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  12. | ndxz_settings       | MyISAM |      10 | Dynamic    |    1 |            328 |         328 | 281474976710655 |         2048 |         0 |              2 | 2016-12-28 17:49:43 | 2016-12-28 18:15:20 | NULL                | utf8_general_ci |     NULL |                |         |
  13. | ndxz_stats          | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  14. | ndxz_stats_exhibits | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |           NULL | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  15. | ndxz_stats_storage  | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |           NULL | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  16. | ndxz_subsections    | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  17. | ndxz_tagged         | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |           NULL | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  18. | ndxz_tags           | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         4096 |         0 |              1 | 2016-12-28 17:49:43 | 2016-12-28 17:49:43 | NULL                | utf8_general_ci |     NULL |                |         |
  19. | ndxz_users          | MyISAM |      10 | Dynamic    |    1 |            148 |         148 | 281474976710655 |         4096 |         0 |              2 | 2016-12-28 17:49:44 | 2016-12-28 17:49:44 | 2016-12-28 17:49:44 | utf8_general_ci |     NULL |                |         |
  20. +---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+
  21. 15 rows in set (0.01 sec)

Problems during installation were mainly in the SQL scripts: all wrong or missing DEFAULT values.

This MySQL version has these default modes:

  1. mysql> SELECT @@GLOBAL.sql_mode;
  2. +-------------------------------------------------------------------------------------------------------------------------------------------+
  3. | @@GLOBAL.sql_mode                                                                                                                         |
  4. +-------------------------------------------------------------------------------------------------------------------------------------------+
  5. | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
  6. +-------------------------------------------------------------------------------------------------------------------------------------------+
  7. 1 row in set (0.00 sec)

So '0000-00-00 00:00:00' as a DEFAULT value for DATETIME isn't working. Also, VARCHAR(20) NOT NULL without a DEFAULT throws an error.

I don't know much about PHP but searching for 'class filesource' doesn't find anything. there are filesourceall and other filesource* files but no 'filesource'.

This thread has been closed, thank you.