Support Forum

If you want to show a shortcode in forum post - use [ instead of [ as you write it so you can see the shortcode 😉

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: 808
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: 93

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Rich Cox: 87

David Z.: 83

Pastor Andres: 83

rrfranks: 53

Allen: 51

Gavin: 36

seanmcint: 29

Jon: 29

Janeen: 23

365sussex: 21

Member Stats:

Guest Posters: 44

Members: 394

Moderators: 0

Admins: 1

Forum Stats:

Groups: 5

Forums: 14

Topics: 529

Posts: 1967

Administrators: andymoyle: 808