WordPress.org

Ready to get started?Download WordPress

Forums

Online Backup for WordPress
can't start backup, WPDB Error (41 posts)

  1. snewby
    Member
    Posted 1 year ago #

    I've backup using this plugin on this site previously.

    Now I'm getting: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)' at line 1. Last query: INSERT INTO wrd_wponlinebackup_activity_log (start, end, type, comp, media, compressed, encrypted, errors, warnings, bsize, bcount, rsize, rcount) VALUES (, NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"

    Any help would be appreciateed

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

  2. eef-ink
    Member
    Posted 1 year ago #

    I'm getting this too! It's worked fine for me in the past, but no longer will run a backup. I'm on a WP Network--not sure if that's related.

    Thanks!

  3. snewby
    Member
    Posted 1 year ago #

    yep - I'm network too - i've backup with it previously without issue.

    from the SQL syntax it looks like it can't calculate the start value which can't be NULL, this is probably the start time of when you kick it off.

    Scott

  4. snewby
    Member
    Posted 1 year ago #

    nothing - nice - time to look for another backup tool

  5. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi eef-ink,

    Is there a specific version of our plugin that used to work? Or is it just used to work and now stopped?

    We haven't yet made the plugin fully compatible with Network yet. We've been working on some fixes in the past and some worked and some didn't, as it turned out Network was more complex than we thought.

    We're working in the background gradually on fixing the problem. If there a specific version that used to work we can likely see what changed and fix it much quicker. But at the moment it's some substantial changes we need.

    Snewby - Likewise, if you remember which version worked or what changed when issue started, it will help.

    Regards,

    Jason

  6. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi guys,

    We're halfway there now. We've finished half of the changes required so it should now backup. This is beta so best to not run in production unless you are absolutely sure. I've done some thorough testing though.

    It will move the Online Backup page from Tools -> Online Backup into the Network Admin under it's own entry. So to run a backup is only possible from Network Admin. If you Network Activate it doesn't appear on individual sites. If a site admin activates it because you didn't network activate, it simply does nothing, but says "Managed by Network Administrator" next to it in the plugin list.

    You can download it here:
    https://wordpress.backup-technology.com/wponlinebackup-533-multisite.zip

    If you are able to test it, let me know how it goes. Or any suggestions on behaviour changes etc let me know.

    I'm aware of only two things at the moment:
    * Schedules are untested - I'm doing that later today
    * On General Settings the excludes will allow you to exclude the multisite builtin tables for WordPress, and individual builtin tables for other sites. This is minor and might be postponed for a future update so we can push this multisite compatibility out ASAP.

    Any feedback is welcome.

    Thanks,

    Jason

  7. eef-ink
    Member
    Posted 1 year ago #

    I deleted the previous version and installed the version you linked to in the above post, but I still get this error:

    The backup failed to start: WPDB error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)' at line 1. Last query: INSERT INTO wp_wponlinebackup_activity_log (start, end, type, comp, media, compressed, encrypted, errors, warnings, bsize, bcount, rsize, rcount) VALUES (, NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

    I honestly don't remember which previous version worked--but I did back up my network 11/19/12 if that helps--I do always update my plugins as soon as I see there are updates available.

  8. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi eef-ink,

    This is quite odd. If you go to Activity Log what happens then?

    Also, can you confirm where the Online Backup page is? Is it in Network Admin or is it in the Admin for one of your sites?

    I'll see if I can add a bit more information to the Help & Support information for multi sites that might help us.

    Regards,

    Jason

  9. freedompreneur
    Member
    Posted 1 year ago #

    Hi Jason,

    I am having the same WPDB error as eef-ink. I am running WPMU 3.5.1 and I installed your beta 533-multisite and same error occurs.

    To answer your previous questions:

    Yes the Online Backup Page is now on the Network Admin.
    Online Backup Page is not showing up in the child site admins as planned.
    Activity Log seems to be reporting the error.

    Regards,
    Michael

  10. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi freedompreneur,

    Can you post the information from Help & Support?

    Also, can you tell me, when you access Network Admin, are you logged into the main site or a different site? Are you using subdomains or subfolders for the Network?

    Thanks,

    Jason

  11. eef-ink
    Member
    Posted 1 year ago #

    Hi!
    So, when I login to the Network Admin I see the Online Backup in the WP sidebar. I don't see it when I go to any of my sites' dashboards.

    I'm logged in as Super Admin for the network--all-access to all sites.

    So the Online backup ONLY shows on the actual Network Admin, not any of the sites, including the main site on the network.

    The activity log looks like this:
    http://eef-dev.com/temp/onlinebackup.JPG

    The events listed are:
    http://eef-dev.com/temp/onlinebackup2.JPG

    Hope this helps! Thanks!

  12. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks eef-ink,

    Could you provide the multisite settings from your wp-config.php? I wonder if they've been changed. No matter how much I try here I can't seem to reproduce this problem. I wonder if there has been some change to the multisite config so it isn't "normal", such as changes to the SITE_ID_CURRENT_SITE

    Jason.

  13. eef-ink
    Member
    Posted 1 year ago #

    Hi Jason,

    I'm not sure exactly what you need... I have the file, but what specifically do you need from it? Thanks!

  14. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi eef-ink,

    If you look through notepad there should be some area with:
    define('MULTISITE_ENABLED'

    Or something similiar. If you can copy that block including the SITE_ID_CURRENT_SITE and BLOG_ID_CURRENT_SITE, it will help.

    I'm also putting in a bit more information in next version to help diagnose if we need it.

    Jason

  15. eef-ink
    Member
    Posted 1 year ago #

    This is what mine has:

    define('WP_ALLOW_MULTISITE', true);
    define( 'MULTISITE', true );
    define( 'SUNRISE', 'on' );
    define( 'SUBDOMAIN_INSTALL', false );
    $base = '/';
    define( 'DOMAIN_CURRENT_SITE', 'eef-dev.com' );
    define( 'PATH_CURRENT_SITE', '/' );
    define( 'SITE_ID_CURRENT_SITE', 1 );
    define( 'BLOG_ID_CURRENT_SITE', 1 );

  16. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Oh so the SUNRISE is on. Are you using the Domain Mapping plugin by any chance?

    Is the Network Admin page you are using to run the backup on eef-dev.com? Or another domain?

  17. eef-ink
    Member
    Posted 1 year ago #

    Yes, I'm using the domain mapping plugin. Network admin page is on eef-dev.com.

  18. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks. This is the finished multisite feature ready for use. Can you try this one? I can see a tweak that might fix the issue. You're still using the 533 I'm guessing from around a month ago.

    https://wordpress.backup-technology.com/wponlinebackup-594-multisite.zip

  19. eef-ink
    Member
    Posted 1 year ago #

    ^For some reason I get a 404 error when I try to install that version? I tried uploading the 533 again and it worked, but the 594 gives me a 404 error.

  20. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Is the 404 error when downloading from us?
    Or when installing using WordPress?
    At what point does the 404 appear?

    Make sure you delete the old version then install that new one, and login to Network Admin again, refresh the page, and click Online Backup. Maybe the link is cached for some reason to the old plugin (which will have had different name)

  21. eef-ink
    Member
    Posted 1 year ago #

    I deleted the old one, logged out, logged back in, went to plugins (on network admin) add new>upload and found the zip I downloaded, then clicked upload and it gave me a 404. =\

  22. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Does it give 404 immediately? Or after a long delay?

  23. eef-ink
    Member
    Posted 1 year ago #

    Immediately! Like it doesn't even try to upload it.

  24. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Try delete it from your computer and download again. Then try upload again. Maybe try extracting on your computer too make sure the zip file is OK.

    Just tried it on my network site and it installed OK so it should work Ok

  25. eef-ink
    Member
    Posted 1 year ago #

    Okay, got it installed. Still got this error when I tried to run it:

    The backup failed to start: WPDB error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)' at line 1. Last query: INSERT INTO wp_wponlinebackup_activity_log (start, end, type, comp, media, compressed, encrypted, errors, warnings, bsize, bcount, rsize, rcount) VALUES (, NULL, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

    =[

  26. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Can you go to Help & Support tab and post the info? There is some stuff on there that may help.

    Thanks.

  27. eef-ink
    Member
    Posted 1 year ago #

    Online Backup for WordPress Plugin Version 2.2.18-594
    WordPress Version: 3.5.1
    PHP Version: 5.3.17
    MySQL Server Version: 5.0.96-community
    MySQL Client Version: 1.0
    Mem: 256M; Post: 8M; Upload: 50M; Timeout: 30
    End of Information

  28. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Just before the error appears does it say, "Waiting for the backup to start..."?

  29. eef-ink
    Member
    Posted 1 year ago #

    ^Yes, then the next thing it says is "null"

  30. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    OK so I know what's happening I think but not sure why heh! I'll have a closer look and play around to see if I can work this out. I'll let you know if I need anything else.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic