Change the Database engine MyISAM to InnoDB? 👈

SuiteCRM Forum - English Language Installation & Upgrade Help
21

Very nice. Thank you @pgr !!
Never even could to the repair& rebuild script because it generated that DB error. I ran it but it now gives me this:

image
image1530×638 42 KB

I need to run that SQL query I suppose? Is there anything else that I need to do?

Kind regards
PowerQuest

22

Hmm ran the SQL query and now:
image
:sob:

Kind regards
PowerQuest

23

It would be useful to know the entire SQL that it was executing, and then to know the complete DB error from the logs.

1 Like
24

Thanks @pgr
I went to phpMyAdmin on our VPS and ran the SQL query there instead of inside SuiteCRM and it seem to have worked. I need to confirm it though a bit more that it really worked.

If everything is fine and dandy should I also continue and change the DB tables to InnoDB do you think?

Thanks a bunch again! :smiley:

Kind regards
PowerQuest

1 Like
25

I don’t know about the InnoDB stuff. If you have a proper backup or a clone system to test, you can try it beforehand

1 Like
26

Ok, thank you so much :heart:
I appreciate you and your kind help. :facepunch:

Kind regards
PowerQuest

27

I did ran this on another system too. Everything seems to be working which is great!

But however when running the SQL query MySQL in MyPHPmyadmin does say that the table for the user password reset it absent…

image
image1608×139 11 KB

Is this something that can be repaired or it maybe doesn´t matter at all and can be ignored? :thinking:

Also it should be noted that the system does report good status when running the the “Quick repair and Rebuild” tool:
image

So all good maybe then? :smiley:

Kind regards
PowerQuest

28

I think you’re probably all good :+1:

1 Like
29

Thank you so much for the help @pgr I really appreciate it. You’re a star! :star:
Sorry for my slow reply!

Kind regards
PowerQuest

1 Like