Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

azw
Member
Registered: 2007-01-29
Posts: 279

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

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)

Offline

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

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

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

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


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

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

azw
Member
Registered: 2007-01-29
Posts: 279

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

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.

Offline

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

northtoronto
New Member
Registered: 2008-03-28
Posts: 8

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

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??

Offline

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

azw
Member
Registered: 2007-01-29
Posts: 279

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

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!

Offline

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

THE BLUE DRAGON
Member
From: Israel
Registered: 2007-11-16
Posts: 562
Website

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

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

Offline

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

merz1
Member
From: Hamburg
Registered: 2006-05-04
Posts: 994
Website

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

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)


Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML

Offline

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

azw
Member
Registered: 2007-01-29
Posts: 279

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

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

Offline

#229 2008-04-23 20:10:40

THE BLUE DRAGON
Member
From: Israel
Registered: 2007-11-16
Posts: 562
Website

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

Thanks to you two!
and the gzip backup is not working too.
I think I will stay with phpmyadmin for now,
it’s scary for me to deal with the database and the config file.

Offline

#230 2008-05-05 23:19:18

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,207

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

Once again for subscribers of this thread:

Correct paths for MAMP locale:

mysqldump Path:
/Applications/MAMP/Library/bin/mysqldump

mysql Path:
/Applications/MAMP/Library/bin/mysql


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Online

Board footer

Powered by FluxBB