WordPress.org

Ready to get started?Download WordPress

Forums

WP-DBManager
Scheduling does not work any more (52 posts)

  1. csigncsign
    Member
    Posted 1 year ago #

    Hi,

    since WP 3.5.1 the automatic scheduling of backup, optimize and repairing does not work any more.

    When I make my settings - for example to backup all 3 days -, then it shows me "the next backup" the current date/time and not the date in three days. Same at "optimize" and "repair".

    When I make manually the backup of the database, it works, and a backup is made - but the automatic scheduling doesn't work.
    I activated and de-activated the plugin, de-installed and re-installed it again ... this problem remains.

    What can I do?
    Thanks.

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

  2. ozbod1959
    Member
    Posted 1 year ago #

    Yes I am observing the same conditions:

    Automatic Backing Up Of DB: Next backup date: April 1, 2013 @ 12:07 pm

    Every Gzip

    E-mail backup to: (Leave blank to disable this feature)

    WP-DBManager can automatically backup your database after a certain period.
    Automatic Optimizing Of DB: Next optimize date: April 1, 2013 @ 12:07 pm

    Every 60 minutes gzip yes

    This was set up at noon on 1 april 2013

  3. ozbod1959
    Member
    Posted 1 year ago #

    get follow up message

  4. utnalove
    Member
    Posted 1 year ago #

    I'm also interested in this.

  5. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    are you using some sort of caching plugin?

  6. utnalove
    Member
    Posted 1 year ago #

    W3TC - are you aware of some incompatibility with W3TC?

  7. csigncsign
    Member
    Posted 1 year ago #

    no, I for myself use NO caching plugin. I have de-activated ALL other plugins for testing this, but it makes no difference.

  8. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    @utnalove: yes do a search on this forum or Google on W3TC with scheduled backup
    @CsignCsign: Try this debug http://forums.lesterchan.net/index.php/topic,4549.0.html

  9. utnalove
    Member
    Posted 1 year ago #

    @Lester: I have turned off W3TV and then I've changed the scheduling options to 1 hour. And 1,5 hours passed and no backup.

    Then I changed it to every 5 minutes.... but nothing. The timer goes "Next backup date: 14 kwietnia 2013 @ 18:31", then appeared "Next backup date: 14 kwietnia 2013 @ 18:36", then Next backup date: 14 kwietnia 2013 @ 18:41.

    But I am not receiving any mail. Only if I send it manually. And W3TC was off. Now I am turning it on again.

  10. csigncsign
    Member
    Posted 1 year ago #

    thanks, Lester, but this doesn't help me anything :-(

  11. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    @utnalove: try the debugging method here http://forums.lesterchan.net/index.php/topic,4549.0.html, what is the output?

    @CsignCsign: if it doesn't work, I am afraid you have to try other plugins.

  12. utnalove
    Member
    Posted 1 year ago #

    Hi I have done that. The command is (I have hidden sensitive data WITH XXX):

    /usr/bin/mysqldump --host="localhost" --user="XXX" --password="XXX" --add-drop-table --skip-lock-tables XXX | gzip > /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz

    And this is the output. It takes a while, and gives no error. It sucessfully runs the command.

    XXX@glamourina.pl [~]# /usr/bin/mysqldump --host="localhost" --user="XXX" --password="XXX" --add-drop-table --skip-lock-tables XXX | gzip > /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz
    XXX@glamourina.pl [~]#

    Other info you'd like to have:

    Checking Backup Status
    
    Checking Backup Folder (/home/glamouri/public_html/wp-content/backup-db) ...
    Backup folder exists
    Backup folder is writable
    
    Checking MYSQL Dump Path (/path/mysqldump) ...
    MYSQL dump path exists.
    
    Checking MYSQL Path (/path/mysql) ...
    MYSQL path exists.
    
    Checking PHP Functions (passthru(), system() and exec()) ...
    passthru() enabled.
    system() enabled.
    exec() enabled.
    
    Excellent. You Are Good To Go.
  13. csigncsign
    Member
    Posted 1 year ago #

    I had the same command output as utnalove.

  14. ozbod1959
    Member
    Posted 1 year ago #

    unsubscribe

  15. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    utnalove: could you check if the file exists on /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz ?

  16. utnalove
    Member
    Posted 1 year ago #

    Hi, yes. I confirm that the files are being well generated: http://img405.imageshack.us/img405/4792/backups.png

  17. Beej
    Member
    Posted 1 year ago #

    I'm having the same trouble. Manual backup works fine. Does not run automatically.

  18. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    I can't reproduce this problem on my end =(

    Do me a favour (if that is not too much to ask for). Install a new installation of WP with WP-DBManager, test to see if the schedule cron does work.

    On top of that try plugins like http://wordpress.org/extend/plugins/cron-view/ to see if the cron is being created.

  19. utnalove
    Member
    Posted 1 year ago #

    Hi, I did the following:
    -Installed cron view. The result is the following:
    http://img35.imageshack.us/img35/2158/cron.png

    Translations
    "Dwa razy dziennie" 2 times a day
    "Co godzinÄ™" every hour
    "Raz dziennie" once per day

    =====
    I have also installed a new copy of WP on the same server.
    I have installed also W3TC and I have configured W3TC exactly the same way as in the production blog. I have also put the same theme copied from the production blog, and activated it. And in this new installed blog, the schedule works fine.

    And this is the cron view on the newly installed blog: http://img824.imageshack.us/img824/7273/cron2a.png

    So from my understanding the chron works fine. But only the code that sends the mails automatically for some reason doesn't work. Backups are being made, but not sent

    Regards

  20. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    is there any server/email log u can check? How big is the backup file?

  21. utnalove
    Member
    Posted 1 year ago #

    Yes, I always have the plugin "Email Log" on. All the emails SETN appear there, even if for some reason are not received.
    With regards to wp-dbmanager, in this email log I can see only the emails that it sends when I click to send the backup to my mail MANUALLY, but the automatic/scheduled mails do not appear in this mail log.

    The same in the server mail log. The automatic email do not appear.

  22. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    sorry man I run out of ideas. The only think I can think of is the DB is too big to be send by email like a php timeout or something

  23. utnalove
    Member
    Posted 1 year ago #

    I think that if there was a problem with the file too big or php timeout, then also then manual sending in "Manage Backup Database" would fail.

    Is there a way to test the code? To see what happens? Some way to log the behavior of the script?

  24. utnalove
    Member
    Posted 1 year ago #

    I have done other things:
    -I have moved ALL the plugins but WP-DBmanager to another folder
    -changed the theme to a clean twentytwelve
    -uninstalled wp-dbmanager from wp-admin/admin.php?page=wp-dbmanager/database-uninstall.php and removed the files, then reinstalled and reconfigured

    the problem still remains

    I have also contacted my support, they troubleshooted it, but they see that the mails work fine, both php and smtp.
    In the mail logs nothing appears. In the mail logs there are info only for the backups sent manually, not automatically.

    And also tried with php 5.3, 5.4, 5.2

  25. utnalove
    Member
    Posted 1 year ago #

    In addition I can add that I found some errors with:

    define('WP_DEBUG', true);
    define('WP_DEBUG_LOG', true);
    define('WP_DEBUG_DISPLAY', false);
    [20-Apr-2013 21:41:24 Europe/Warsaw] PHP Notice:  Undefined variable: folder_content in /home/mysite/public_html/wp-content/plugins/wp-dbmanager/wp-dbmanager.php on line 293
    
    [20-Apr-2013 21:42:36 Europe/Warsaw] PHP Notice:  Undefined index: Submit in /home/mysite/public_html/wp-content/plugins/wp-dbmanager/wp-dbmanager.php on line 398

    Maybe these are causing this problem?

  26. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    nope notices are fine. Your new blog that you installed it works fine? Including the sending of email?

  27. utnalove
    Member
    Posted 1 year ago #

    hi, yes the new test blog is in a subfolder of the production blog and it works fine also with the same theme.
    maybe some issue in the database?

    Isn't there a way to check what the plugin is doing? I know the wp debug. It shows the errors. But what about some kind of verbose loggin of all that a script does? To see what happens when the dbmanager_cron_backup runs.... it first create a new backup... and then? what happens? why it doesn't send the mail?

  28. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    I don't think so, I am still guessing might be due to the db size, how big is your DB?

  29. utnalove
    Member
    Posted 1 year ago #

    here you have: http://img405.imageshack.us/img405/4792/backups.png

    Gzipped they are less than 5MB.
    If it was the db size, then I think that the manual mail would fail also?!

  30. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    Yea that is true as well. Okie, I am officially out of ideas =(

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic