Support Forum

Invalid database query Of Death in my Forum 5.1 updated

MA MacBravO
MacBravO
Member
Member since Feb 2012
4 posts
Mar 5, 2012 · 10:10 pm · Edited

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

7 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Mar 5, 2012 · 10:36 pm

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…

MA MacBravO
MacBravO
Member
Member since Feb 2012
4 posts
Mar 5, 2012 · 11:18 pm

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.


YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 6, 2012 · 3:41 am

I will add that making regular visits to your database and optimising all tables is worth the effort in increased performance and overall stability.

MA MacBravO
MacBravO
Member
Member since Feb 2012
4 posts
Mar 6, 2012 · 8:47 am

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:inetpubvhostslopgo.com.brhttpdocswp-contentpluginssimple-pressforumcontentclassessp-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
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 6, 2012 · 8:56 am

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/installation/troubleshooting/increase-php-memory/) but you may need to ask your host for more – or reduce the volume of code that is being loaded by your site.

MA MacBravO
MacBravO
Member
Member since Feb 2012
4 posts
Mar 7, 2012 · 4:06 pm

Thx Yellow Swordfish, my problem is Solved!

 

Actually it was a problem in the hosting of my homepage.
Ordered that increased the PHP memory to a higher value and now everything is ok.Case Closed!

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 7, 2012 · 4:47 pm

Ah – excellent news. Thanks for the update.