aghilmort

Suppose we manually added some external URLs. If we then click the export button, we download a text file which reads something like:

1,1,OHxr4,,
2,,7MwF3,,
0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama

However, suppose we want to add some external URLs for bulk upload purposes, say like this.

1,1,OHxr4,,
2,,7MwF3,,
0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama
0,,Fk1o8,http://www.sos.arkansas.gov/corps/search_all.php,Arkansas
0,,aZoj2,http://kepler.sos.ca.gov/,California

If we attempt to upload this file, we simply receive a bunch of warnings saying line 282 is expecting two parameters and only received one and none of the external URLs are added. Furthermore, if we then download the updated list of URLs using the export button, it looks like this:

1,1,OHxr4,,
2,,7MwF3,,
0,0,,,
0,0,,,
[... bunch more 0,0,,, rows, one per external URL we imported]
0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama

What we don’t know is if we’re somehow using the wrong file format for the import process or if there’s a glitch in the code, or if it’s something such as the file must be encoded in some specific format such as Unicode, UTF-8, etc. Thoughts?

it appears to be helpful if we actually visit the google drive folder in addition to the api console and the wp updraftplus settings page while logged into the same account. also using a debug backup appears to be helpful as compared to the backup now button. at the very least the two sites that weren’t working are now working.

Based on additional testing, we can verify the error does occur after click backup now on the settings page while not currently logged into the same Google account as the account which the backup is using.

Hmm – each site has unique client ID & secret, which is set appropriately.

It’s possible there’s an expiration setting – the Google Drive API talks about it being an hour, however, that may simply be to be using their credentials creation console or drive itself and not necessarily when using it via the API. Possibly worth looking into, though WP-cron’s most often rate, hourly refresh, is right at the same level. So if “credential refresh” proved to solve it, might need two tasks running every hour which are offset by 30 minutes each to guarantee meets the hourly requirement.

One question might be – what happens when we click Backup Now – does that perchance peek at whatever our current Google credentials are and perhaps override the original oauth – that’s the only thing I can think of based on your suggestions that could be creating the bug. Alternatively stated, should we only click backup now when also logged in as the Google account we used to create the client ID / secret?

We’re taking a look at premium – the migrator addon is perhaps our biggest need at this time. Will advise if we need to transition this thread to your paid forums due to WordPress.org guidelines.