Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#311 2015-06-01 16:19:03
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,208
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Thanks for your reply, Yiannis. Unfortunately I need something foolproof (it’s not about the client this time ;)
After finally getting logged in for DB access (darn NetCologne admin UI!!), I’ve also tried maniqui’s tip on deleting the plugin and removing rss_dbbk
entries from txp_prefs, then re-installing and yahoo-ing, but alas …
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#312 2015-07-01 13:46:53
- gomedia
- Plugin Author
- Registered: 2008-06-01
- Posts: 1,226
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
uli wrote #291234:
Can anyone remember what causes backup files of only 20 bytes?
Off the top of my head, I think it indicates command not found – i.e. there’s a problem with the path to the mysql/mysqldump command.
Offline
#313 2015-07-01 14:52:07
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,208
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
gomedia wrote #292441:
Off the top of my head, I think it indicates command not found
Seems to be correct what comes off the top of your head :) I contacted the support, and days later they replied (translated from German)
mysqldump isn’t installed in our system.
I never thought there were hosting providers with such a Spartan feature set. I also asked them for passthru
, popen
, & pclose
which I found mentioned here in this topic re the 20 bytes problem, and they answered:
popen,pclose aren’t deactivated. We’re happy to set any values for you.
Can any of these be part of or add to my problem? (Last hope before I give in.)
Last edited by uli (2015-07-01 15:14:03)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#314 2015-07-01 21:08:59
- gomedia
- Plugin Author
- Registered: 2008-06-01
- Posts: 1,226
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
PHP commands passthru
or popen
are used by the plugin (it tries both in that order) to run the mysql/mysqldump commands on the server … so, yes, they’re essential!
Offline
#315 2016-10-22 00:55:53
- towndock
- Member
- From: Oriental, NC USA
- Registered: 2007-04-06
- Posts: 282
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Just switched a server to MariaDB (from mySQL) for its supposed benefits.
All is working re core Textpattern functionality, but this great plugin isn’t.
Anybody got rss_admin_db_manager going with MariaDB?
Offline
#316 2016-10-25 17:02:20
- towndock
- Member
- From: Oriental, NC USA
- Registered: 2007-04-06
- Posts: 282
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
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)
Offline
#317 2017-01-30 22:06:03
- Bloke
- Developer
- From: Leeds, UK
- Registered: 2006-01-29
- Posts: 8,826
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
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)
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
#318 2017-01-31 17:16:10
- colak
- Admin
- From: Cyprus
- Registered: 2004-11-20
- Posts: 7,374
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
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?
Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github
Offline
#319 2017-01-31 18:43:26
- Bloke
- Developer
- From: Leeds, UK
- Registered: 2006-01-29
- Posts: 8,826
- Website
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
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)
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
#320 2018-11-28 12:59:26
- johnno
- Member
- Registered: 2007-06-14
- Posts: 27
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
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
Offline