phpwcms 1.9.33 error while manual installation on MYSQL 5.5 about phpwcms

[slackero]

Seems your MySQL doesn't support MyISAM. I cannot really test this. I would recommend also to check the my.cnf to have a more compatible setting. Newer MySQL is often too strict. Is it a productive system or for testing?

[prbt2016]

Hello @slackero ,

I am using Server version: 5.5.62 Source distribution. My server supports MYISAM.

This is the output of 'show engines' command on mysql prompt.

This is the screenshot for your reference.

Also strict mode isn't enabled :

The earlier version 1.9.30 installs fine without any such issues.

I see that the storage engine in the earlier version i.e 1.9.30, was explicitly set to 'MYISAM' which is commented in this version i.e 1.9.33,

/setup/inc/setup.check.inc.php on line 159 i.e this code :

mysqli_query($db, 'SET storage_engine=MYISAM');

so the storage engine picked up is INNODB, which is the default engine in my case, as you can see in the screenshot.

Could you please try and find a fix for this ?. Or any suggestions to make the script work on the environment?.

[slackero]

I need to check the whole database schema, as I wrote in the readme. I cannot rely on MYISAM any longer. As workaround for you remove the comment.

[prbt2016]

Hello @slackero ,

It would be really better if you could fix this by code, as many users would face the issue while installation on MYSQL 5.5,
since the default storage engine in MYSQL is set to INNODB and full text indexes are only supported only by MYISAM before MYSQL 5.6 ,

Many users would have this same issue on the above environment.

I have tested on another server which has MYSQL 5.6 (with InnoDB as default engine), and there it works fine.

It would be better if you raise MYSQL requirements to MYSQL 5.6 and above and update them in docs or make changes in code to make it compliant with MYSQL 5.5.

Kindly let me know.

[prbt2016]

Hello @slackero ,

Any updates regarding the same ?.

[slackero]

Should be solved, requirements updated