MySQL error | Support | Support

Support Forum

We use and recommend UK2 for hosting - get a month free

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
MySQL error
22nd October 2019
6:49 pm
Avatar
Essex, UK
Member
Members
Forum Posts: 4
Member Since:
21st August 2019
sp_UserOfflineSmall Offline

Hi,

We have recently upgraded to a better hosting provider, but the new MySQL server only supports InnoDB. At various places around the admin plugin, the following error is being thrown up:
"Storage engine MyISAM is disabled (Table creation is disallowed)."
It also prevents certain shortcodes from being used, and shows SQL queries under searches

Is there any way to avoid these errors?

Thanks

22nd October 2019
11:02 pm
Avatar
Admin
Forum Posts: 735
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Yes sure. I’ll update the plugin so those tables get installed and everything works. I’m away until Fri so will do it then.

I can’t access anything to help further. If you know what you are doing you can remove Myisam references from the queries that setup the tables in includes/install.php

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription

4th November 2019
5:24 pm
Avatar
Essex, UK
Member
Members
Forum Posts: 4
Member Since:
21st August 2019
sp_UserOfflineSmall Offline

Thanks for your help!

Forum Timezone: Europe/London

Most Users Ever Online: 57

Currently Online: PastorAndres
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

David Z.: 81

Rich Cox: 60

PastorAndres: 53

Allen: 51

rrfranks: 40

Gavin: 35

Jon: 23

Janeen: 23

365sussex: 21

ehout: 20

Member Stats:

Guest Posters: 40

Members: 378

Moderators: 0

Admins: 1

Forum Stats:

Groups: 4

Forums: 13

Topics: 479

Posts: 1772

Administrators: andymoyle: 735