[plugin] [ORPHAN] rss_admin_db_manager - database backups and more

towndock · 2016-10-25 17:02:20

For the record – it is an easy fix. This plugin checks to make sure MySQL is newer than version 3.23 (a hint at how old this thing is). MariaDB is v10.x. The plugin somehow saw that as older than 3.23. The quick (and dirty) fix is to edit 3.23 in the plugin, to 0.23. And then it works like a charm.

Someone smarter than I will have a more elegant fix, but this works.

FYI, a link to the latest version of this plugin I have found – 4.3.2. It works with Textpattern 4.6.x and 4.5.7:
http://www.kreatore.it/?rah_plugin_download=rss_admin_db_manager

Last edited by towndock (2016-10-25 17:03:02)

Bloke · 2017-01-30 22:06:03

Just a quick update. If anyone relies on this plugin, I’ve forked it and fixed it for Txp 4.6.2 / MySQL clones / PHP 7. Please grab a compiled copy of v4.4 if you wish.

This doesn’t mean I’m maintaining it long-term, but if it helps someone out, then that’s a bonus.

Last edited by Bloke (2017-01-31 18:45:03)

colak · 2017-01-31 17:16:10

Hi Stef I have a v4.3 version of this plugin working on 4.6.2. I will update it to your version next week. The question is: what was it that it was not working for you?

Bloke · 2017-01-31 18:43:26

colak wrote #303771:

what was it that it was not working for you?

The 4.3 version worked, but with newer versions of MySQL, MariaDB and Percona around, it starts to fail. For starters the (now largely irrelevant) version comparison in the plugin fails for MariaDB and Percona, which means the plugin prevented you from running SQL queries.

The plugin also breaks entirely if you run PHP 7, because they’ve removed the mysql_* calls. The 4.4 version uses the mysqli_* calls instead.

EDIT: I’ve edited the post above to make it clearer, thanks for the nudge.

Last edited by Bloke (2017-01-31 18:45:29)

johnno · 2018-11-28 12:59:26

Any reason why clicking the DB Backup tab should give this error?:
User_Error “Unknown column ‘prefs_id’ in ‘field list’”.

Just this single plugin (v4.4) in a clean install of Textpattern 4.7.1
PHP v5.6.37
MySQL v5.7.16

I guess this is now really an orphaned plugin…but it’s still SO handy to have :)

Thanks

Bloke · 2018-11-28 21:26:53

johnno wrote #315430:

I guess this is now really an orphaned plugin…

Not so :) Enjoy v4.5 for Textpattern 4.7+

johnno · 2018-11-28 21:45:07

Mmm…enjoying v4.5 right now.
Thanks so much!

funtoosh · 2018-12-03 10:57:10

Bloke, thanx for keeping the plugin alive!

Bloke · 2018-12-04 11:19:51

You’re both welcome. I use it as a quick ‘n dirty MySQL runner when developing/debugging plugins, and as a backup tool when I can’t be bothered to log into my server and run stuff from the command line. I’d really like to beef up the SQL support one day so it can handle other things like DESCRIBE/SHOW.

Textpattern CMS

Textpattern CMS support forum

#316 2016-10-25 17:02:20

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#317 2017-01-30 22:06:03

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#318 2017-01-31 17:16:10

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#319 2017-01-31 18:43:26

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

colak wrote #303771:

#320 2018-11-28 12:59:26

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#321 2018-11-28 21:26:53

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

johnno wrote #315430:

#322 2018-11-28 21:45:07

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#323 2018-12-03 10:57:10

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#324 2018-12-04 11:19:51

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Board footer