Question Change table type from InnoDB to MyIsam

Hello,
I'm using Joomla 3.4.3 and Kunena 4.0.3.
is it allowed to change type of kunena_messages table from InnoDB to MyIsam? Won't it affect the forum?

Hello,

Why do-you want to change to MyIsam ?

xillibit wrote: Why do-you want to change to MyIsam ?

... and why is this topic in the "reporting defects" category?

sulpher wrote: I'm using Joomla 3.4.3 and Kunena 4.0.3.
is it allowed to change type of kunena_messages table from InnoDB to MyIsam? Won't it affect the forum?

Most of the discussions I have read (like this one ) are about people wanting to convert from myISAM to InnoDB, not the other way around. This information may be useful to you: groups.google.com/forum/#!msg/joomla-dev...8nH_LOg/em_dJr4l7I8J

To be completely honest, I don't know if this affects Kunena or not but, by the same token, I really don't see any benefit in moving away from InnoDB. There may not even be a right or wrong answer. I have not seen this particular question asked before about going from InnoDB -> myISAM ... and I think there's an almost zero-chance that we will see this question asked again in future.

I guess the simple answer is that myISAM is probably not supported. :S

xillibit wrote: Hello,
Why do-you want to change to MyIsam ?

I would like add fulltext index to "subject" field. That's supported only for MyIsam table types.

P.S. I am sorry I posted topic in wrong category, it's better to move it in General questions.

sulpher wrote: ... I posted topic in wrong category, it's better to move it in General questions.

It's probably better if this was moved to the Miscellaneous, off-topic and general Joomla category. As I said before, I have never seen this question asked before and I don't think I will see it asked again.

One think we both agree on: this is not a defect in Kunena.

Sozzled, everyone understands that this is not a defect. Sulpher excused already, that was wrong category. You write a lot, but not on the subject. I think it's a flood.

Forum has excellent features for moderation. If necessary, administrators will move this topic to a different category. Or Sulpher creates another one in the right category.

The question is: Forum uses any Innodb extra features (like transactions or something else), or it is MyISAM compatible?