Forums

Resolved
0 votes
Hello,

I use ClearOs with autoupdate on since 2 or 3 years to publish a Tiki website (and do demos).
My workflow is the following; I setup my configuration on a Tiki software on my local MAMP => mysqldump of the database => copy to the server => mysql < database.
It worked flawlessly a hundred of times.

Since a few days (48h I’m trying) this is not working anymore and I have an error on importing on the ClearOs database server side.
ERROR 1214 (HY000) at line 25: The used table type doesn't support FULLTEXT indexes

(creation of the first table)

I googled and check basic things like if my database source was innoDB, the default was innoDB, etc.
Seems that everything is ok on the source side and working fine.

I found this : https://dev.mysql.com/doc/refman/5.5/en/fulltext-restrictions.html
Full-text searches are supported for MyISAM tables only. (In MySQL 5.6 and up, they can also be used with InnoDB tables.)


What could have changed ?
Can I upgrade my ClearOs mysql version above 5.6?

Bernard
Thursday, July 04 2019, 07:25 AM
Share this post:

Accepted Answer

Thursday, July 04 2019, 07:55 AM - #Permalink
Resolved
0 votes
Assuming you are using ClearOS7, in reality it uses MariaDB and not MySQL so you'll need to upgrade to MariaDB 10+. There are plenty of references on the internet for Centos such as https://www.tecmint.com/install-mariadb-in-centos-7/ and these should be applicable to ClearOS. I have not heard other people doing this in ClearOS, but I would assume it works.

There is no upgrade route directly in ClearOS using ClearOS repos.
The reply is currently minimized Show
Responses (1)
  • Accepted Answer

    Thursday, July 04 2019, 09:29 AM - #Permalink
    Resolved
    0 votes
    Thanks Nick !
    Once again you saved my day sharing your knowledge.

    I followed the guide you indicated and all is working fine.

    Bernard
    The reply is currently minimized Show
Your Reply