after some unsuccesfull trys installing refbase from the browser, I decided to create the database with phpMyAdmin manually.
I found some "errors" in the installing.sql files, which prevents the implementation of the whole database structure. One error is caused by TYPE=MyISAM; I changed it to ENGINE=MyISAM, but not really succesfull. A second error occurs: SQL Error #1071 - Specified key was too long; max key length is 1000 bytes. This is caused from the queries table. One of the columns (query_name) is specified with a char size of 255. I'm not sure if 255 chars are needed, so I changed it to 128.
Result: This few script changes allows to create all tables.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
after some unsuccesfull trys installing refbase from the browser, I decided to create the database with phpMyAdmin manually.
I found some "errors" in the installing.sql files, which prevents the implementation of the whole database structure. One error is caused by
TYPE=MyISAM;I changed it toENGINE=MyISAM, but not really succesfull. A second error occurs:SQL Error #1071 - Specified key was too long; max key length is 1000 bytes. This is caused from the queries table. One of the columns (query_name) is specified with a char size of 255. I'm not sure if 255 chars are needed, so I changed it to 128.Result: This few script changes allows to create all tables.