Support Forum
Support Forum
Offline
Hello - I wanted to open up a discussion about this issue, and get suggestions for troubleshooting it.
Whenever I restore a full copy of my site to a test site, I get the "Invalid database query" message popup whenever I access a Simple-press page (see attached). Everything seems to work fine, but this message keeps popping up. My concern is that if I ever have to restore a backup to the production site to resolve a problem, it might introduce this popup message to the production site, so I'd like to figure out what is causing it.
I have a well-running forum that is soft-launched (limited users, light traffic, no SEO etc). Vaultpress makes hourly backups of the site. Twice I have used it to restore the latest backup to an alternate site, with a different TLD. The destination of the restore is a different server with the same web host, running the same underlying server OS etc.
After both restores, simple-press seemed to work fine and all features/function etc worked without problems. However, there is a large message "Invalid database query" that appears whenever you access the forum page, and any time to take an action in the forums. This popup never happens on the source site where the backup was made.
The first time I did the restore and had this problem, the test site might not have been perfectly "clean", i.e. before the restore there may have been themes & plugins experimented with, then deleted, but folder and tables might have been left behind.
The second time I did the restore, I completely uninstalled the site, deleted all folders/files, dropped the database/tables, and even deleted the leftover site folder via FTP. I then created a fresh new Wordpress site from scratch, new database prefix etc. On the fresh WP site I deleted the extra default themes, Hello Dolly & Akismet.
Vaultpress requires that both the source and target be running the same version of Wordpress, as it doesn't copy the core Wordpress files & tables. Both the source and target were running WP 4.6.1. The restore ran normally with no apparent errors. A few other details:
- I am not using any form of caching or caching plugin
- My web host does not do any underlying caching
- I did not have the "CSS/JS Combined Caching" enabled at any time before or after the restore on either site
- I updated the forum permalink immediately after the restore
- Message still pops up if all WP plugins except SP are deactivated & twenty-sixteen theme activated
- No apparent errors in the logs either after the restore or that correspond to the popup message timing
Again, aside from the popup message, the forum and all its features, as well as the rest of the site seem to be working fine.
This most recent restore was of the latest release of SP, and the first restore with this problem was with the immediately prior release of SP.
Please let me know what you think I could check to see what might be causing this.
Thanks!
Kelly
Offline
Go to the forum admin > Toolbox > Error Log.
You might haver many entries - you can ignore notices and warnings. Just look at the pink error entries. One of them will state that it is a database error. Copy and paste the details to this topic.
 |
YELLOW
SWORDFISH
|
Offline
also sounds like vaultpress might not be really doing a full restore... by definition a restore would be to the same state...
Visit Cruise Talk Central and Mr Papa's World
Offline
I think this is the error
file: /home/leeannb1/public_html/restorativenation.net/wp-content/plugins/simple-press/admin/panel-forums/support/spa-forums-save.php
line: 280
function: sp_flush_cache
error: Table 'leeannb1_wp442.wpea_sfcache' doesn't exist
DELETE FROM wpea_sfcache WHERE cache_id LIKE '%*group'
Offline
well, it would have existed before the restore... assuming wpea_ is the proper wp db prefix... sounds like the restore didnt pull back all the database tables... its a standard simple press table...
Visit Cruise Talk Central and Mr Papa's World
Offline
Do you know how to create a table from a sql script because we can give you one...?
|
YELLOW
SWORDFISH
|
Offline
Interesting; yes, I can use the script to generate, but not sure why just this one table would be missing.
As you may know, Vaultpress is a premium service made by Automatic, which is delivered as an add-on to Jetpack. So, one would expect they are doing things "correctly" for a typical Wordpress install.
Here is what they say the do, and do not back up; can you think of any reason why this table wouldn't get picked up by the process? I can open a ticket with Vaultpress to investigate but any additional thought you have woudl be helpful:
https://help.vaultpress.com/backups/
What does VaultPress back up?
We back up your WordPress database (any tables which begin with your WordPress table prefix and also have a unique key or a primary key). We also back up any files in your plugins, themes, and uploads folders, and select files from your WordPress root directory and your wp-content directory.
This includes all the unique and irreplaceable data in WordPress, and everything properly integrated into the WordPress installation.
We do not back up WordPress core, core file modifications, files outside these locations, database tables which don’t look like they belong to WordPress, or database tables whose rows have no unique identifier.
Offline
First the table SQL:
CREATE TABLE IF NOT EXISTS xxx_sfcache ( cache_id varchar(40) NOT NULL DEFAULT '', cache_out bigint(6) DEFAULT NULL, cache mediumtext, PRIMARY KEY (cache_id))
change the 'xxx' for your WP table prefix of course.
No idea why it didn't include it in the backup I am afraid. It fit's the claimed requirements - although why there have to be any such restrictions I can see no obvious reason for.
As to JetPack being from Automattic well - all I can say is that JetPack is one of the most troublesome , problematic and conflicting plugin ever encountered and I really dislike the way it installs huge quantities of 'things' turned on whether you want them or not and doesn't make it obvious how to turn them off again. Sorry - but personally I wouldn't go near it!
|
YELLOW
SWORDFISH
|
Offline
I agree with you about Jetpack, but Vaultpress is by far the best and most trouble-free backup system I've ever used for Wordpress, and I'm pretty sure I've tried most of them. You can actually deactivate Jetpack once you set up Vaultpress and run just the Vaultpress plugin.
This is the first issue I've had with it, which is very curious as the problem happened both times I did the restore.
Thanks for the code - I'll give it a try tomorrow!
Kelly
Offline
let us know... but obviously, we have no interaction with a backup utility...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)