Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Vaultpress site restores cause "Invalid database query" messages
Avatar
Kelly Brady
Member
sp_UserOfflineSmall Offline
Oct 24, 2016 - 8:16 pm

Creating the table per your instructions solved the problem - thanks!

I'm wondering, since this table is the only one that consistently doesn't get restored properly, and it seems like it is used in some way for caching... Is the table accessed in some special way that might make some backup systems unable to back it up properly?  You may very well be doing something correctly/within standards etc, yet perhaps it makes this table harder to back up.  I'd love to be able to explain to Vaultpress support a little more about how this table is used if it is used in a somewhat different way that might make it harder to back up successfully. Perhaps they can consider other methods to better ensure they can manage it properly.

Thanks,

Kelly

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 24, 2016 - 9:14 pm

There is nothing unique to this table. Well, perhaps just the name. My guess is vault press thinks it's some sort of traditional cache and ignores it. We use it a little different than a true cache so it's required. A traditional cache wouldn't need to be used for operation. So they don't save it. For us, it's really just another table we use for normal operations.

Avatar
Kelly Brady
Member
sp_UserOfflineSmall Offline
Jan 15, 2017 - 5:50 pm

UPDATE - Vaultpress support has disclosed that they don't back up any table with 'cache' in the name.  They are manually adjusting my backups to include it.  I submitted a request that they back up all table with the designated wordpress table prefix, since that is the best idea and it is also what they say they do on their website.  I kinda think it is bad logic to evaluate the table name and decide whether to include/exclude, so hopefully they will agree.

 

Kelly

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2017 - 8:52 pm

okay, thanks for the update...explains some of it...

Avatar
Kelly Brady
Member
sp_UserOfflineSmall Offline
Jan 16, 2017 - 7:45 pm

Last update; they also decided not to backup and tables with the word BACKUP in them. They told me it was in the changelog, but I suggested to them they correct this in the product info the website which is what most people are going to read.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 17, 2017 - 4:01 am

I have to say I do not agree with their logic. No problem excluding tables but I think they should ask the user before making big assumptions.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620