3.0.1 broken? ERROR: Can not set DB charset to … ERROR: Dropbox API:

  • Resolved BruceRawles

    (@brucerawles)


    11 years, 1 month 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/

Viewing 15 replies - 1 through 15 (of 21 total)
1 2
  • Plugin Author Daniel Hüsken

    (@danielhuesken)

    11 years, 1 month ago

    fixed with next update

    mll

    (@mll)

    11 years, 1 month 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.
    wp.20.mat77@spamgourmet.org

    (@wp20mat77spamgourmetorg)

    11 years, 1 month 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
    Chad Warner

    (@chad-warner)

    11 years, 1 month 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 …
    EricJohnsonGuru

    (@wormeyman)

    11 years, 1 month ago

    I am getting the same error as well on 3.04.

    chrispix

    (@chrispix)

    11 years, 1 month 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’);

    wp.20.mat77@spamgourmet.org

    (@wp20mat77spamgourmetorg)

    11 years, 1 month 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!

    Gabe

    (@gabrielwhite)

    11 years, 1 month ago

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

    mll

    (@mll)

    11 years, 1 month 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 ?

    chrispix

    (@chrispix)

    11 years, 1 month 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%';

    Gabe

    (@gabrielwhite)

    11 years, 1 month 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)

    katootje

    (@katootje)

    11 years, 1 month 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….

    Thread Starter BruceRawles

    (@brucerawles)

    11 years, 1 month 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! 🙂

    katootje

    (@katootje)

    11 years, 1 month 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.

    chrispix

    (@chrispix)

    11 years, 1 month 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.

Viewing 15 replies - 1 through 15 (of 21 total)
1 2
  • The topic ‘3.0.1 broken? ERROR: Can not set DB charset to … ERROR: Dropbox API:’ is closed to new replies.