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

azw · 2008-03-27 08:51:11

Thanks for the really fast reply, thebombsite.

Yes, I did install the new privileges and still no tabs.

After I installed 4.0.6, my Preflight Check shows some issues. Maybe this is related?

Pre-flight check 
Some Textpattern files are out of date: 
/include/txp_file.php, 
/include/txp_prefs.php, 
/lib/taglib.php ? 
Some Textpattern files have been modified: 
/include/txp_category.php, 
/include/txp_form.php, 
/include/txp_import.php, 
/include/txp_link.php, 
/include/txp_preview.php, 
/lib/IXRClass.php, 
/lib/admin_config.php, 
/lib/class.thumb.php, 
/lib/constants.php, 
/lib/txplib_db.php, 
/lib/txplib_update.php, 
/publish/log.php, 
/publish/search.php, 
/update/_to_4.0.3.php ?

I’m running the MLP (for multilingual websites). I think that plugin causes at least one of those reports, but not usually so many of them.

Last edited by azw (2008-03-27 08:54:34)

thebombsite · 2008-03-27 08:59:27

I presume this was an upgrade rather than a new install?

azw · 2008-03-27 09:01:44

Yes, the 4.0.6 was an upgrade.
I wonder if I should upload the textpattern files again?

Last edited by azw (2008-03-27 09:02:08)

thebombsite · 2008-03-27 09:04:52

Well I’ve noticed a couple of posts from people who have upgraded and had similar pre-flight diagnostics. It might simply be a problem with “over-writing” an existing file. Try deleting the current file first then upload the new version. I would work on those top 3 first and see how it goes, particularly as they include the txp_prefs.php file. If that goes well then do the same with the others.

azw · 2008-03-27 09:20:48

Thanks, again, Stuart. Reuploading seems to have done the trick.

All of the errors went away except for the one for /lib/taglib.php , which is normal for the MLP.

The db tabs now appear in the Extensions section along with the Templates tab. I thought it was supposed to be in the Admin section, but I don’t care where it shows up as long as it works! The db tabs weren’t there a few minutes ago. The rss_admin_db_manager worked, too, so it’s really fixed.

Last edited by azw (2008-03-27 09:21:46)

thebombsite · 2008-03-27 09:41:05

Excellent! :) As far as I can recall, and certainly in my current set-up, the tabs appear under “Extensions”.

azw · 2008-03-27 09:59:16

Yeah, that seems familiar. I probably misread the text of the plugin description.

The rss_admin_db_manager plugin adds 3 new tabs to your Textpattern admin interface. Each tab contains different functionality to help manage your MySQL database. …

Reading that again, it doesn’t actually say which section it appears in.

northtoronto · 2008-03-28 22:59:28

Hello. I am trying to install the rss_admin_db_manager. I have Textpattern 4.0.1. I am getting two errors:

Badly formed or empty plugin code

Notice: unserialize() [function.unserialize]: Error at offset 0 of 6544 bytes in /users/home/northtoronto/public_html/textpattern/include/txp_plugin.php on line 152

Any ideas??

azw · 2008-03-30 17:27:48

NorthToronto, you are running an old version of Textpattern. I think that’s five versions ago! I serioulsly doubt that anyone is going to be willing to help you make the plugin work with an old version of the CMS.

I haven’t looked at the underlying code, but your plugin may be trying to access code that only appears in newer versions of Txp. It’s likely that this problem will go away when you update Txp.

It’s not that hard to update Txp and, besides, it’s usually a security risk to run old versions.

Good luck!

THE BLUE DRAGON · 2008-04-23 19:14:16

Hi need some help please.
When I’m trying to make a backup in .sql file I’m geting the next error: BACKUP FAILED. ERROR NO: 2
mmm…what is error #2 please?

I got textpattern 4.0.6 with ruud’s fix on rss_admin_db_manager v4.3

merz1 · 2008-04-23 19:31:41

Hmm, the code part regarding $error is:

      $error = "";

      if (function_exists('passthru')) {
        passthru($backup_cmd, $error);
      } else {
        $dumpIt=popen($backup_cmd, 'r');
        pclose($dumpIt);
      }

      if(!is_writable($bkpath)) {
        pagetop("DB Manager", "BACKUP FAILED: folder is not writable");
      } elseif($error) {
        unlink($backup_path);
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else if(!is_file($backup_path)) {
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else if(filesize($backup_path) == 0) {
        unlink($backup_path);
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else {
        pagetop("DB Manager", "Backed Up: ".$DB->db." to ".$filename);
      }

Doesn’t help much but at least it tells you that the error number is coming from the database engine itself. Google didn’t help to bring up something for #2 :-(

Is the gzip backup working? If yes the not zipped file is too big. If I remember right there is a (2MB?) border.

Last edited by merz1 (2008-04-23 19:32:47)

azw · 2008-04-23 19:40:10

There are several previous messages about that error here:
Google search for Error No. 2

In particular, this one may be helpful by Arnski:
http://forum.textpattern.com/viewtopic.php?id=10395&p=16 (post # 153)

For all folks still getting the Error No: 02

I got it working using another MySQL-User (you can’t change that via the admin-interface, but you can change the config.php-file located in your textpattern-folder).

The user seems to need special rights “selecting a database” or something – DB-experts might correct me.

I got to this solution when i used the console.app under OS X to watch the httpd-error log. It spit out the following error-message:

mysqldump: Got error: 1044: Access denied for user ‘’@‘localhost’ to database ‘textpattern_test’ when selecting the database

I simply changed to the root-user which might not be the best solution in a production-environment ;)

So basically i think you need to specify a user with these “selecting the database”- rights or change your current users rights accordingly.

Hope it helps,

Arne

Textpattern CMS

Textpattern CMS support forum

#217 2008-03-27 08:51:11

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

#218 2008-03-27 08:59:27

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

#219 2008-03-27 09:01:44

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

#220 2008-03-27 09:04:52

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

#221 2008-03-27 09:20:48

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

#222 2008-03-27 09:41:05

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

#223 2008-03-27 09:59:16

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

#224 2008-03-28 22:59:28

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

#225 2008-03-30 17:27:48

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

#226 2008-04-23 19:14:16

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

#227 2008-04-23 19:31:41

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

#228 2008-04-23 19:40:10

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

Board footer