Support Forum
Support Forum
Offline
I just moved my site to a new server.
Took a file dump of everything and moved the raw database via PHPmyAdmin
The site is working and the forum is working but everytime i go to the forum page it says "Invalid database query" in the header - see here:
http://resilientlivelihoods.ch.....iscussion/
Any ideas?
Update: it actually happens on every page.
Offline
Please look in the error log (admin > toolbox > error log) and find the entry for the SQL error and copy and paste the message here...
 |
YELLOW
SWORDFISH
|
Offline
Here is the error log from when we moved the site a few days ago:
Date # Type Description 04/11/2013
6:54 pm4 php file: s/simple-press/sp-api/sp-api-plugins.php
line: 611
function: unlink
Warning | unlink(D:\CTA\WWW\resilientlivelihoods.christianaid.org.uk/wp-content/sp-resources/forum-cache//sp-plugin-styles-all.css) [function.unlink]: Permission denied04/11/2013
6:47 pm1 php file: WWW/resilientlivelihoods.christianaid.org.uk/wp-content/sp-resources/forum-plugins/captcha/sp-captcha-upgrade.php
line: 15
function: sp_captcha_do_upgrade_check
Notice | Undefined index: dbversion04/11/2013
7:01 pm127 database file: D:\CTA\WWW\resilientlivelihoods.christianaid.org.uk\wp-content\plugins\simple-press\sp-api\sp-api-error.php
line: 57
function: sp_update_error
error: Out of range value for column 'error_count' at row 26UPDATE carl_sferrorlog SET error_date = '2013-11-04 18:22:18', error_count = 128 WHERE keycheck = "1127-press\sp-api\sp-api-error.php"
04/11/2013
5:56 pm1 php file: s/simple-press/sp-startup/admin/spa-admin-updater.php
line: 46
function: sp_core_plugin_info
Notice | Trying to get property of non-object04/11/2013
6:22 pm127 database file: D:\CTA\WWW\resilientlivelihoods.christianaid.org.uk\wp-content\plugins\simple-press\sp-api\sp-api-error.php
line: 127
function: sp_update_error
error: Out of range value for column 'error_count' at row 1UPDATE carl_sferrorlog SET error_date = '2013-11-04 13:57:17', error_count = 128 WHERE keycheck = "Notice31-press/sp-api/sp-api-auths.php"
Offline
Ohhh. I think I see the problem and that comes down to us. I will make sure that is corrected in the next update.
Meanwhile could you please go to the errorlog panel again and this time clear it out (button at the bottom).
See if this resolves the error display issue. If it comes back clear it out again. If it comes back too quickly I can give you a fix but it does mean a small change to a table structure in the database.
I couldn't help noticing that the top error there does not give SP permission to delete a file that it created in the first place. That seems to be a server permissions issue and it would be useful to get that resolved.
|
YELLOW
SWORDFISH
|
Offline
Clearing the log cleared it.
It's not appearing anymore! Great Stuff!
The permissions issue has been resolved. We moved the site form a linux to a Windows server so there have been several permissions issues but all getting sorted as we go!
All RSS1 Guest(s)