Hi to all,
I'm tring to install CWIS 4 on a Debian 9 with MariaDB 10.1.23, PHP 7.0.21, Apache 2.4.25.
I find problems on setup tables of database.
The error is:
Database command failed:
CREATE TABLE IF NOT EXISTS TaskQueue (
TaskId INT NOT NULL AUTO_INCREMENT,
Callback MEDIUMTEXT DEFAULT NULL,
Parameters MEDIUMTEXT DEFAULT NULL,
Priority INT DEFAULT 3,
Description TEXT DEFAULT NULL,
INDEX (TaskId),
INDEX (Callback(64), Parameters(256))
);
(SQL error: Specified key was too long; max key length is 1000 bytes)
In MariaDB (and also in MySQL) now the default charset of a db is uft8mb4, the default engine is InnoDB and general speakong
charset is on uft8. In this situation the CREATE command of table 'TaskQueue' is invalid.
So, what do I need to do on MariaDB/MySQL config ?
Do I need to setup deafult to Engine=MyISAM anc charset=latin1 ?
Bye
Ah, we're not currently running Debian on any of our servers at Scout, so we hadn't seen this issue. If you unpack the attached zip file and copy the enclosed
ApplicationFramework--CreateTables.sql
file into thelib/ScoutLib
directory and the enclosedCHECKSUMS
file into theinstall
directory and then run the installation, I think that should take care of the problem.Hi,
I test the patch and now CWIS 4 works in my enviroment.
But attention, if you use PHP7.0 [on every Linux env] you need to to install php7.0-mbstring.
It is not a standard part of PHP7.0, so you need to add it.
On debian/Ubuntu:
apt-get install php7.0-mbstring
More info here:
https://stackoverflow.com/questions/35756821/call-to-undefined-function-...
Bye
Glad to hear the patch worked for you!
And thank you for letting us know about the mbstring issue. If possible we'll make those functions optional in the 4.0.1 release. (And of course also fix the key length issue.)