WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: WP-DBManager] Does not work after wordpress 2.9 (45 posts)

  1. Granit
    Member
    Posted 4 years ago #

    Hi,

    After i updated to WordPress 2.9 this plugin no longer work.
    No backups are sent by email no more.

    Do you plan to fix this in a coming version? If so when will a new version come?

    Thanks.

    http://wordpress.org/extend/plugins/wp-dbmanager/

  2. Lester Chan
    Member
    Posted 4 years ago #

    There is nothing wrong with the current version, it works fine with WP2.9.

  3. Granit
    Member
    Posted 4 years ago #

    How come i no longer getting any emails?

  4. Lester Chan
    Member
    Posted 4 years ago #

    I have no idea, cron timeout? Try the manual backup to see if the backup works fine.

  5. bobjones
    Member
    Posted 4 years ago #

    Lester, I'm having the same problem with both sites I manage.

    WP-DB-Manager will perform manual backups, but it has not performed the automatic backups since December 23.

    Again, two different sites, on different servers, both running WP 2.9, same problem.

    We need a fix.

    You're awesome. Thanks!

  6. Lester Chan
    Member
    Posted 4 years ago #

  7. bobjones
    Member
    Posted 4 years ago #

    We could use more information than a link, Lester.

    Should we presume this job ticket relates to a problem that is preventing WP-DB-Manager from performing its scheduled backups?

    If so, do you feel that WordPress is addressing the issue? Is a fix likely and imminent?

    Thank you.

  8. mrmist
    Forum Janitor
    Posted 4 years ago #

    The ticket relates to failures of the cron system, so I'd guess so.

    It has a committed fix, which means that the fix should appear in the next WordPress release, whenever that is.

  9. Lester Chan
    Member
    Posted 4 years ago #

    bobjones: mrmist is right, there is a problem with the CRON in WP2.9, it has something to do with the CURL timeout as mentioned in the trac. WP2.9.1 should fix this issue.

    Having said that, I think it only affects some servers as it works fine for my end.

  10. Amit Gupta
    Member
    Posted 4 years ago #

    Err... even manual backups are not working on 1 of my blogs which I upgraded to v2.9 couple of days back. :( When I try to backup db using the manual option, I get following PHP warnings & it doesn't backup anything:

    Warning: filesize() [function.filesize]: stat failed for /home/userx/public_html/databasebackup/1262142716_-_userx_wrddb1.sql.gz in /home/userx/public_html/wp-content/plugins/wp-dbmanager/database-backup.php on line 57
    
    Warning: unlink(/home/userx/public_html/databasebackup/1262142716_-_userx_wrddb1.sql.gz) [function.unlink]: No such file or directory in /home/userx/public_html/wp-content/plugins/wp-dbmanager/database-backup.php on line 58

    In the function checks, all is green & it says - Excellent. You Are Good To Go.

    What can be the issue here? My other blogs which are still running v2.8.6 on the same server don't have any such issues & (automatic & manual) backup is working fine on them & I get the backup emails everyday. Only this blog which I upgraded to v2.9 stopped getting backed up after the upgrade.

  11. Lester Chan
    Member
    Posted 4 years ago #

  12. Amit Gupta
    Member
    Posted 4 years ago #

    @GamerZ

    The check_backup_files() function isn't there in database-backup.php!! I echoed out the command after execute_backup() function & here's what I get:

    /usr/bin/mysqldump --host="localhost" --user="dbuser" --password="dbpwrd" --add-drop-table --skip-lock-tables userx_wrddb1 | gzip > /home/userx/public_html/databasebackup/1262281649_-_userx_wrddb1.sql.gz

  13. Choto Cheeta
    Member
    Posted 4 years ago #

    Me too facing the same issue :(

  14. Lester Chan
    Member
    Posted 4 years ago #

    Amit: run that code in SSH of your host. If you no idea what that is contact your host

  15. Amit Gupta
    Member
    Posted 4 years ago #

    @GamerZ
    I've a cron running DB backups using that command & its working perfectly. Like I said earlier, I've other wordpress blogs (v2.8.6) running same plugin version on same server & mysql & they're all working fine & the plugin is making regular backups. Its just this 1 blog which I upgraded to v2.9 & after that the plugin stopped making backups & started giving these errors! :(

  16. Lester Chan
    Member
    Posted 4 years ago #

    As mentioned earlier in the thread, this is a problem with cron with WP 2.9. That is why I asked you to run that SSH command in your shell to see if it works. If it works, most likely it that WP issue, if not then if maybe a plugin issue.

  17. Amit Gupta
    Member
    Posted 4 years ago #

    Cron issue I get in WP, but shouldn't the manual backup work then?

  18. Lester Chan
    Member
    Posted 4 years ago #

    Yeap, manual should work. I doubt the upgrade to WP broke it. Most likely it is a permission issue or something. You still have not answered me whether the SSH command works, so please try it before asking more questions as when you run it natively in SSH command it will give your some user feedback. The plugin simply executes the command in your host SSH.

    If not another alternative plugin is http://wordpress.org/extend/plugins/wp-db-backup/ where it uses PHP to generate backup rather than relying on SSH

  19. Amit Gupta
    Member
    Posted 4 years ago #

    Just ran the same command in SSH, no errors etc there & the backup got made without an issue. Checked in the backup directory & the backup file is there!!

  20. Lester Chan
    Member
    Posted 4 years ago #

    cool, so we can narrow down to the PHP issue.

    1. Is the folder CHMOD to 777?
    2. Besides the Warning: filesize() and unlink() what error does DBManager tells you? Like "Backup File Size is 0?"

    On line 218 of wp-dbmanager.php,
    Find:
    passthru($command, $error);

    Replace With:
    system($command, $error);
    or if it still does not work try
    exec($command, $error);

  21. Amit Gupta
    Member
    Posted 4 years ago #

    1. Yes the folder is CHMOD to 777, I just checked it again.

    2. Besides the warnings I listed above, the DB Manager gives following as WordPress error (this is the one I just copied)

    Database Failed To Backup On 'January 4, 2010 @ 6:59 pm'. Backup File Size Is 0KB.

    3. I replaced the passthru() with system() & same warning & error came. I then tried exec() & the result was again same.

  22. Lester Chan
    Member
    Posted 4 years ago #

    Hmm, weird. Sorry, I ran out of ideas.

  23. Choto Cheeta
    Member
    Posted 4 years ago #

    just to let all know.. Since I upgraded to WordPress 2.9.1, the issue has been solved..

    I didnt play with any settings in both case, I mean the 2.9.0 (when it stooped) and just waited for 2.9.1, where i see it has started it self and I can receive those emails again with my DB backup :)

    Thanks again..

  24. Amit Gupta
    Member
    Posted 4 years ago #

    I just upgraded one of my other blogs to v2.9.1 from v2.8.6. The plugin was working fine on this blog (as mentioned earlier, it was not upgraded) but just now after WordPress upgrade, its no longer working & gives following error:

    -- MySQL dump 10.11 -- -- Host: localhost Database: userb_wpdbt -- ------------------------------------------------------ -- Server version 5.0.87-community
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    
    Warning: filesize() [function.filesize]: stat failed for /home/userb/public_html/dtbbak/1263186652_-_userb_wpdbt.sql.gz in /home/userb/public_html/wp-content/plugins/wp-dbmanager/database-backup.php on line 57
    
    Warning: unlink(/home/userb/public_html/dtbbak/1263186652_-_userb_wpdbt.sql.gz) [function.unlink]: No such file or directory in /home/userb/public_html/wp-content/plugins/wp-dbmanager/database-backup.php on line 58

    Seems to me something in WordPress is at play here because it was working alright just before upgrade.

  25. Lester Chan
    Member
    Posted 4 years ago #

    Hmm weird, if you see the error you posted.

    Means the MYSQLUMP command did indeed got executed by PHP, but it has the wrong arguments and hence MYSQLDUMP return the 40*** lines

    Did you try running the command in SSH again for this blog?

  26. Anonymous
    Unregistered
    Posted 4 years ago #

    Will load the site with some delay.

  27. design-is
    Member
    Posted 4 years ago #

    I am also having problems - when I save my options on the options page, the time of next backup is set the time I pressed save - therefore never coming as that time has already passed.

    I run this on several sites across a few different hosts and they all seemed to stop working a while ago (I don't remember exactly when I'm afraid).

    Any help would be greatly appreciated.

    (Would your forum be a better place to post than here?)

    /Doug

  28. Lester Chan
    Member
    Posted 4 years ago #

    When you press backup, the time is saved and the backup will be executed for the first time. If you did not receive the backup, it maybe because of WordPress's cron issue. I can't really do anything much because this type of issue is really very server and WP specific.

    You may want to try http://wordpress.org/extend/plugins/wp-db-backup/ as an alternative.

  29. design-is
    Member
    Posted 4 years ago #

    All my servers are linux based, and used to work. All are now up on 2.9.1 which apparently fixed a cron issue(?)

    I appreciate your efforts in making the plugin in the first place and understand its a freebie. I'll happily keep using it regardless of automated backups. But live in hope that it will start working again :)

    If you're ever curious to fix, let me know and I might be able to set up a test install of wordpress where it doesn't work.

    Cheers

    /Doug

  30. Lester Chan
    Member
    Posted 4 years ago #

    Yea, 2.9.1 should fix the cron issue. It is the case for some users and for me.

    Could you try the debugging method which I mentioned earlier in this thread to see if the command does work in SSH.

Topic Closed

This topic has been closed to new replies.

About this Topic