Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Can't connect to DigitalOcean managed databases
If that works – and I suspect it will – I can patch this today so you can specify the storage engine in config.php.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: Can't connect to DigitalOcean managed databases
What happens if you replace the two occurrences of MyISAM to InnoDB /textpattern/lib/txplib_db.php and re-run the setup?
It works terrifically and sets up exactly as one expects.
Thank you.
Offline
Re: Can't connect to DigitalOcean managed databases
amordecosmos wrote #323010:
It works terrifically and sets up exactly as one expects.
Great! Thanks for being a guinea pig.
Offline
Re: Can't connect to DigitalOcean managed databases
Brilliant, thank you for testing. Patched for the imminent 4.8.1. When you download/copy ‘n’ paste your config.php file, add:
$txpcfg['dbengine'] = 'InnoDB';to override the default MyISAM table type.
EDIT: Longer term, would it make sense to add this to the db collection step during setup? A dropdown of supported engines? I’ve no idea what the other types are for, nor if they’d even work with Txp. But perhaps we could offer a choice between MyISAM (default) and InnoDB at the very least.
Last edited by Bloke (2020-05-16 14:56:20)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: Can't connect to DigitalOcean managed databases
…and here are some basic examples in docs.
Offline
Re: Can't connect to DigitalOcean managed databases
Bloke wrote #323012:
Longer term, would it make sense to add this to the db collection step during setup? A dropdown of supported engines?
Yes, please. Opened github.com/textpattern/textpattern/issues/1859 to track viability.
Offline