WordPress.org

Ready to get started?Download WordPress

Forums

BackWPup Free - WordPress Backup Plugin
[resolved] 3.0.1 broken? ERROR: Can not set DB charset to ... ERROR: Dropbox API: (22 posts)

  1. BruceRawles
    Member
    Posted 1 year ago #

    I just updated BackWPup to 3.01 for a couple of my WP sites and it seemed to work for a large backup (although it took about 8 hours!) and also for a smaller site, but this 3rd site is now giving the errors below (and of course, no backups):
    (I've replaced specifics with placeholders in <brackets> )
    Any help would be appreciated! Please let me know when this (otherwise excellent) plugin is fixed. THANKS! :-)

    [INFO] BackWPup version 3.0.1; WordPress version 3.5.1; A project of Inpsyde GmbH developed by Daniel Hüsken
    [INFO] This program comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions.
    [INFO] BackWPup job: <job-name>; DBDUMP
    [INFO] BackWPup cron: 0 3 * * 3; Wed, 6 Mar 2013 @ 03:00
    [INFO] BackWPup job started manually
    [INFO] PHP ver.: 5.2.17; cgi-fcgi; Linux
    [INFO] Maximum script execution time is 30 seconds
    [INFO] MySQL ver.: 5.5.30-log
    [INFO] curl ver.: 7.24.0; OpenSSL/1.0.0
    [INFO] Temp folder is: <bu-folder-name>
    [INFO] Logfile folder is: <logfile-folder-name>
    [INFO] Backup type is: archive
    [INFO] Backup file is: <bu-folder-name>/backwpup_3_2013-02-28_08-16-54.zip
    [28-Feb-2013 08:16:54] 1. Try for database dump …
    [28-Feb-2013 08:16:54] ERROR: Can not set DB charset to
    [28-Feb-2013 08:16:54] 2. Try for database dump …
    [28-Feb-2013 08:16:54] ERROR: Can not set DB charset to
    [28-Feb-2013 08:16:55] 3. Try for database dump …
    [28-Feb-2013 08:16:55] ERROR: Can not set DB charset to
    [28-Feb-2013 08:16:56] 1. Trying to create backup archive …
    [28-Feb-2013 08:16:56] Backup archive created.
    [28-Feb-2013 08:16:56] WARNING: filesize() [function.filesize]: stat failed for <bu-folder-name>/backwpup_3_2013-02-28_08-16-54.zip
    [28-Feb-2013 08:16:56] 0 Files with  in Archive.
    [28-Feb-2013 08:16:56] 1. Try to send backup file to Dropbox …
    [28-Feb-2013 08:16:57] Authenticated with Dropbox from <username> <email>
    [28-Feb-2013 08:16:57] 803.23 MB free on Dropbox
    [28-Feb-2013 08:16:57] Upload to Dropbox now started …
    [28-Feb-2013 08:16:57] ERROR: Dropbox API: Error: File "<bu-folder-name>/backwpup_3_2013-02-28_08-16-54.zip" is not readable or doesn't exist.
    [28-Feb-2013 08:16:57] 2. Try to send backup file to Dropbox …
    [28-Feb-2013 08:16:58] Authenticated with Dropbox from <username> <email>
    [28-Feb-2013 08:16:58] 803.23 MB free on Dropbox
    [28-Feb-2013 08:16:58] Upload to Dropbox now started …
    [28-Feb-2013 08:16:58] ERROR: Dropbox API: Error: File "<bu-folder-name>/backwpup_3_2013-02-28_08-16-54.zip" is not readable or doesn't exist.
    [28-Feb-2013 08:16:59] 3. Try to send backup file to Dropbox …
    [28-Feb-2013 08:16:59] Authenticated with Dropbox from <username> <email>
    [28-Feb-2013 08:16:59] 803.23 MB free on Dropbox
    [28-Feb-2013 08:16:59] Upload to Dropbox now started …
    [28-Feb-2013 08:16:59] ERROR: Dropbox API: Error: File "<bu-folder-name>/backwpup_3_2013-02-28_08-16-54.zip" is not readable or doesn't exist.
    [28-Feb-2013 08:17:00] One old log deleted
    [28-Feb-2013 08:17:00] Job done in 6 seconds.

    http://wordpress.org/extend/plugins/backwpup/

  2. Daniel Hüsken
    Member
    Plugin Author

    Posted 1 year ago #

    fixed with next update

  3. mll
    Member
    Posted 1 year ago #

    Thnaks daniel ; this actually still happens with 3.0.4 on *some* of my sites, see below :

    [INFO] BackWPup version 3.0.4; WordPress version 3.5.1; A project of Inpsyde GmbH developed by Daniel Hüsken
    [INFO] This program comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions.
    [INFO] BackWPup job: Backup db; DBDUMP
    [INFO] BackWPup cron: 0 2 * * *; ven, 1 mar 2013 @ 02:00
    [INFO] BackWPup job started manually
    [INFO] PHP ver.: 5.4.6; cgi-fcgi; Linux
    [INFO] Maximum script execution time is 120 seconds
    [INFO] MySQL ver.: 5.1.49-3-log
    [INFO] curl ver.: 7.21.0; OpenSSL/0.9.8o
    [INFO] Temp folder is: /homez.671/<snip>
    [INFO] Logfile folder is: /homez.68/<snip>
    [INFO] Backup type is: archive
    [INFO] Backup file is: /homez.671/<snip>
    [06-mar-2013 09:13:32] 1. Try for database dump …
    [06-mar-2013 09:13:32] ERROR: Can not set DB charset to DB_CHARSET
    [06-mar-2013 09:13:33] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Create() should be compatible with OpenCloud\PersistentObject::Create($params = Array)
    [06-mar-2013 09:13:33] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Update() should be compatible with OpenCloud\PersistentObject::Update($params = Array)
    [06-mar-2013 09:13:33] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Delete() should be compatible with OpenCloud\PersistentObject::Delete()
    [06-mar-2013 09:13:33] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::UpdateJson() should be compatible with OpenCloud\PersistentObject::UpdateJson($params = Array)
    [06-mar-2013 09:13:33] 2. Try for database dump …
    [06-mar-2013 09:13:33] ERROR: Can not set DB charset to DB_CHARSET
    [06-mar-2013 09:13:35] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Create() should be compatible with OpenCloud\PersistentObject::Create($params = Array)
    [06-mar-2013 09:13:35] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Update() should be compatible with OpenCloud\PersistentObject::Update($params = Array)
    [06-mar-2013 09:13:35] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Delete() should be compatible with OpenCloud\PersistentObject::Delete()
    [06-mar-2013 09:13:35] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::UpdateJson() should be compatible with OpenCloud\PersistentObject::UpdateJson($params = Array)
    [06-mar-2013 09:13:35] 3. Try for database dump …
    [06-mar-2013 09:13:35] ERROR: Can not set DB charset to DB_CHARSET
    [06-mar-2013 09:13:36] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Create() should be compatible with OpenCloud\PersistentObject::Create($params = Array)
    [06-mar-2013 09:13:36] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Update() should be compatible with OpenCloud\PersistentObject::Update($params = Array)
    [06-mar-2013 09:13:36] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::Delete() should be compatible with OpenCloud\PersistentObject::Delete()
    [06-mar-2013 09:13:36] STRICT NOTICE: Declaration of OpenCloud\DNS\PtrRecord::UpdateJson() should be compatible with OpenCloud\PersistentObject::UpdateJson($params = Array)
    [06-mar-2013 09:13:36] 1. Trying to create backup archive …
    [06-mar-2013 09:13:36] Compression method is ZipArchive
    [06-mar-2013 09:13:37] Backup archive created.
    [06-mar-2013 09:13:37] WARNING: filesize(): stat failed for /homez.671/<snip>
    [06-mar-2013 09:13:37] 0 Files with in Archive.
  4. wp.20.mat77@spamgourmet.org
    Member
    Posted 1 year ago #

    After BackWPUp has been running silently and efficiently for 2 years, I now start receiving my first emails with this error in the logs!

      [10-Mar-2013 10:18:44] ERROR: Can not set DB charset to DB_CHARSET

    It seems that this error is not fixed on my site either. Any hint how to fix it (log-file excerpts below).

    Matthias

    [INFO] BackWPup version 3.0.4; WordPress version 3.5.1;
    [INFO] BackWPup job: New; DBCHECK+DBDUMP+DBOPTIMIZE+FILE+WPPLUGIN [INFO] BackWPup cron: 15 3 * * 0; Sun, 17 Mar 2013 @ 03:15
    [INFO] BackWPup job started manually
    [INFO] PHP ver.: 5.3.13; cgi-fcgi; Linux [INFO] Maximum script execution time is 30 seconds
    [INFO] MySQL ver.: 5.1.56-log
    [INFO] curl ver.: 7.21.0; OpenSSL/0.9.8o
    [10-Mar-2013 10:18:43] Set blog into maintenance mode
    [10-Mar-2013 10:18:44] ERROR: Can not set DB charset to DB_CHARSET
    [10-Mar-2013 10:18:44] 2. Try for database dump …
    [10-Mar-2013 10:18:44] Set blog into maintenance mode
  5. Chad Warner
    Member
    Posted 1 year ago #

    I still have this problem with version 3.0.4 of the plugin. Please let me know what details you need to troubleshoot.

    [INFO] BackWPup version 3.0.4; WordPress version 3.5.1;
    [INFO] BackWPup job: Database, files, uploads (local & offsite); DBCHECK+DBDUMP+DBOPTIMIZE+FILE+WPPLUGIN
    [INFO] BackWPup cron: 0 3 * * 1; Mon, 18 Mar 2013 @ 03:00
    [INFO] BackWPup job started manually
    [INFO] PHP ver.: 5.2.17; cgi-fcgi; Linux
    [INFO] Maximum script execution time is 30 seconds
    [INFO] MySQL ver.: 5.1.53-log
    [INFO] curl ver.: 7.18.2; OpenSSL/0.9.8g
    [11-Mar-2013 07:35:18] 1. Try for database dump …
    [11-Mar-2013 07:35:18] ERROR: Can not set DB charset to DB_CHARSET
    [11-Mar-2013 07:35:20] 2. Try for database dump …
    [11-Mar-2013 07:35:20] ERROR: Can not set DB charset to DB_CHARSET
    [11-Mar-2013 07:35:21] 3. Try for database dump …
    [11-Mar-2013 07:35:21] ERROR: Can not set DB charset to DB_CHARSET
    [11-Mar-2013 07:35:22] 1. Trying to make a list of folders to back up …
  6. wormeyman
    Member
    Posted 1 year ago #

    I am getting the same error as well on 3.04.

  7. chrispix
    Member
    Posted 1 year ago #

    If you go to /wp-admin/admin.php?page=backwpupsettings and click the Information tab, you'll see that Blog charset is set to 'DB_CHARSET', which is the root of the problem.

    To fix this, you need to set the DB_CHARSET environment variable in your wp-config.php, with the rest of your database settings. For example:

    define('DB_CHARSET', 'utf8');

  8. wp.20.mat77@spamgourmet.org
    Member
    Posted 1 year ago #

    Thanks! It seems as this hint has resolved my problem:
    I added this line to the config and BackWPup now works without any complaints!

  9. Gabe
    Member
    Posted 1 year ago #

    Still have same issue, and think it's related to issue @chrispix identified above.

  10. mll
    Member
    Posted 1 year ago #

    Thanks chrispix.

    But why did BackWPup work while in v2.x ?

    And if I provide a value for DB_CHARSET, will it have other consequences ?

  11. chrispix
    Member
    Posted 1 year ago #

    I don't have access to the 2.x code, but I assume it didn't use that variable. You can find out your database's character set by logging into mysql and running the following:

    select CCSA.character_set_name, T.table_name from information_schema.collation_character_set_applicability CCSA, information_schema.tables T where T.table_collation = CCSA.collation_name and T.table_name like 'wp%';

  12. Gabe
    Member
    Posted 1 year ago #

    Just took the risk and upgraded my database to UTF-8, and added UTF-8 to wp-config.php

    http://wordpress.org/extend/plugins/utf-8-database-converter/

    (this worked on 3.5.1)

  13. katootje
    Member
    Posted 1 year ago #

    Added the line to the wp-config file. That is no solution since after that all the special characters are changed to all kind of strange characters, so I had to delete the line. Going back to an older version is no option, since the plugin changed something in the database and I get errormessages. Had to switch to another plugin now. I want to have a backup of the database.
    I'm a little worried to convert the database. It's a really big one and the owner of the site gets really nervous when something goes wrong....

  14. BruceRawles
    Member
    Posted 1 year ago #

    Since the 2.x version is still working for me, I think I'll use that (and revert the few sites I updated to 3.x by copying the plugin files from other ones that I hadn't converted yet) ... Please let me know when there's a solid 3.x version... I REALLY like the plugin, just want to make sure it's working reliably before I update any more sites to 3.x. THANKS! :-)

  15. katootje
    Member
    Posted 1 year ago #

    For me it was not possible just put the old plugin files with ftp. There was an error with some database table. So i'm stuck to either this new, not working on this site version, or find another backup plugin.

  16. chrispix
    Member
    Posted 1 year ago #

    @katooje did you check what charset your database is actually set to? From what you describe, it sounds like the setting you put in the wp-config doesn't match the database's character set.

  17. Chad Warner
    Member
    Posted 1 year ago #

    Thanks, chrispix. I checked the Settings > Info tab, and it showed Blog charset as UTF-8. I checked wp-config.php, and DB_CHARSET wasn't defined. I added define('DB_CHARSET', 'utf8'); and ran a backup, and it worked!

  18. katootje
    Member
    Posted 1 year ago #

    @chrispix - when I look in de wp-options tabel, the blog_charset is set tuo UTF-8

  19. Chad Warner
    Member
    Posted 1 year ago #

    In my last post, I said that I added define('DB_CHARSET', 'utf8'); to wp-config.php and ran a backup, and it worked. However, I later noticed that many of the characters on my site (in Spanish posts) were messed up. So, I commented the DB_CHARSET out of wp-config.php again. The Codex article Converting Database Character Sets appears beyond my ability to follow, so I'm looking for other options.

    My BackWPup Settings > Information tab shows MySQL Client encoding: DB_CHARSET and Blog charset: UTF-8. When I look at the tables in phpMyAdmin, they have collation utf8_general_ci or latin1_swedish_ci (only for a few of the Wordfence plugin tables).

  20. Daniel Hüsken
    Member
    Plugin Author

    Posted 1 year ago #

    ok. i hae improved it again for next update.

  21. wormeyman
    Member
    Posted 1 year ago #

    Looking forward to the new update, i'm really nervous to change my char set!

  22. Chad Warner
    Member
    Posted 1 year ago #

    Version 3.0.7 fixed this for me, on the 2 sites that were having the problem.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic