Support Forum
Support Forum
Offline
I just upgraded my SP version 5.0 to version 5.1. However, this update since I faced some problems that just destroyed my forumcloser to the date of his inauguration:
1 - The first problem was the location of Custom Icons. I changed the location of the icons and since then experienced a problemabsurdity: A pop-up: "Invalid database query", making my forum becomes inaccessible, impossible to be read or edited.
2 - experienced an automatic update of the default theme that was unsuccessful, what killed the theme of my site.
I have not the smallest idea how to reverse this problem of "Invalid database query" Please help me!
You can check the unfortunate situation of my forum here: http://www.lopgo.com.br/?page_id=1640
Offline
not sure I understand some stuff...
'destroyed my forumcloser to the date of his inauguration' => what does that mean???
are you saying the wp updater failed when updating the sp default theme? if so, like you imply, wp probably left in bad state... just download the theme from our downloads page and reupload...
not sure what you mean by inaccessible and impossible to be read??? I have no problem browsing your site... yes, I see the query message but it fades right away... but the site is working...
as to the message, please go to forum - toolbox - error log and report the latest error listed there... you may find it best to empty the error log at bottom, visit the forum on front end and then look at the error log... lets see the message and if we can track it down...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr. Papa Sorry for bad English. All I meant is that the forum has problems on the day of his inauguration!
Thanks for the tip, could repair the problem indirectly, Referring to the tool box> error logs, I noticed that was an error in the mysql table "wp_sfposts
| Date | Type | Description |
|---|---|---|
| 06/03/2012 1:57 |
database | file: C:inetpubvhostslopgo.com.brhttpdocswp-contentpluginssimple-pressforumcontentclassessp-group-view-class.php line: 463 function: select error: Table '.kanenwp_sfposts' is marked as crashed and should be repaired SELECT wp_sfposts.post_id, wp_sfposts.topic_id, topic_name, wp_sfposts.forum_id, post_date, guest_name, guest_email, wp_sfposts.user_id, post_content, post_status, wp_sfmembers.display_name, post_index, topic_slug FROM wp_sfposts LEFT JOIN wp_sftopics ON wp_sfposts.topic_id = wp_sftopics.topic_id LEFT JOIN wp_sfmembers ON wp_sfposts.user_id = wp_sfmembers.user_id WHERE wp_sfposts.post_id IN (121,17,38,122,126,24,25,41,120,43,115,31,32,33) |
Here's a tip for those who experience the problem.
Access your PHPMyAdmin
Click on the left to select the database where the table is
On the right side, select the checkbox on the table with the problem
Scroll to the bottom of the page "right frame", and select the following option to select: Repair table, ready.
With respect to the template, there was no way I'll have to rebuild.
Offline
I will add that making regular visits to your database and optimising all tables is worth the effort in increased performance and overall stability.
 |
YELLOW
SWORDFISH
|
Offline
Yellow Swordfish said
I will add that making regular visits to your database and optimising all tables is worth the effort in increased performance and overall stability.
I have another problem and I have no idea how to solve it:
| Date | Type | Description |
|---|---|---|
| 06/03/2012 11:38 |
database | file: C:\inetpub\vhosts\lopgo.com.br\httpdocs\wp-content\plugins\simple-press\forum\content\classes\sp-list-topic-class.php line: 282 function: select error: Out of memory (Needed 27787220 bytes) SELECT wp_sfposts.topic_id, wp_sfposts.post_id, post_index, post_date, guest_name, wp_sfposts.user_id, display_name, post_count-post_index+1 AS new_post_count FROM wp_sfposts JOIN wp_sftopics ON wp_sfposts.topic_id = wp_sftopics.topic_id LEFT JOIN wp_sfmembers ON wp_sfmembers.user_id = wp_sfposts.user_id WHERE wp_sfposts.topic_id IN (59,57) AND (post_date > "2012-03-06 05:58:10") OR (wp_sfposts.post_id IN (103,104)) ORDER BY topic_id, post_id |
Offline
The message is very clear. It says 'Out of Memory'.
You can try this possible solution from our old V4 wiki which might help (http://wiki.simple-press.com/i.....hp-memory/) but you may need to ask your host for more - or reduce the volume of code that is being loaded by your site.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)