Support Forum

Text in all my posts disappeared, some forums are no longer visible to users (after upgrade to 5.1.2/8910

EG Eric Grey
Eric Grey
Member

Hey there,

My forum is members only, exists at http://deepesthealth.com/forum/ – Simplepress has been running ok.  Recent upgrade seems to have broken things.  The posts in my forums are no longer visible on the front end.  There are also several forums fully missing (visible on backend, but not frontend).

Most recent error reads:

file: /mnt/stor7-wc2-dfw1/538952/582652/www.deepesthealth.com/web/content/wp-content/plugins/simple-press/admin/panel-toolbox/support/spa-toolbox-save.php
line: 66
function: sp_build_post_index
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ post_count=0, post_id_held=0, post_count_held=0 WHERE topic_id=’ at line 2

UPDATE wp_sftopics SET post_id=, post_count=0, post_id_held=0, post_count_held=0 WHERE topic_id=1

39 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Obviously I can’t take an actual look at the forum page as it is members only. And it looks like you have tried to rebuild indexing – which I may have suggested.

So we need to start with a question or two…

Were there any noticeable problems during the upgrade process?
The error you pasted above – did that come from your php error log or from the SP Toolbox error log?
Could you please check the Permission Sets in admin to ensure they are all intact?

I suppose I should also ask if you have a db backup so we can restore and run the upgrade again. The one thing that comes to mind is if the upgrade failed to make some planned database changes for any reason.

It may be that the only way to get to the bottom of this wopuldbe for me to actually look at the database itself so would that be possible if necessary?

EG Eric Grey
Eric Grey
Member

1.  Problems during upgrade process:  Yes, but I’d be hard pressed to explain it.  I ran the upgrade, which gave no error messages, seemed to proceed normally.  Later, when I logged in, no problems.  However, when I went to actually visit the forum, it gave me an error message saying the forum was in maintenance mode!

I went to the backend to check it out, and there was a message indicating that some plugins/themes needed to be updated.  I did that, and everything was fine as far as the “maintenance mode” message went.  However, I did not then check to see if the message text was actually showing up – so I’m not sure if the text was absent from that point forward, or if the problem happened later.

2. The error came from the SP toolbox error log.

3. Regarding permission sets : in SP admin, all the permission sets appear, the settings are as before, and the forums seem to have retained the permissions that I originally gave to them.  Is there anything else I should check?

I do have a backup, but it’s a bit old, unfortunately.  It seems that the backup I did before upgrading my plugins this time is corrupted.  Of course.  :

Happy to give you access to the database.  You’ve already been in there when I was first installing, so don’t see any reason to avoid it now.  The PMd details should still be accurate, actually, if you still have those.

YS Yellow Swordfish
Yellow Swordfish
Member

1: Did it really say ‘Maintenance Mode’? That is not a phrase we use anywhere in SP so I am confused by that…

2: If you did not run an index rebuild then can I assume this message was old? It will be dated.

3: That’s good news.

We do not retain credentials once the problem they were given us for has been resolved. Please PM credentials to both myself and to ‘Mr Papa’. Please include in the PM a link to your site, a link to this thread and brief reminder of the problem. And one of us will take a look for you.

if you can make that an SP admin as well then please do. And if you want to add database access then that could prove useful.

EG Eric Grey
Eric Grey
Member

1.  Well, probably different language.  It said something along the lines of “forum software is being updated,” I don’t recall the specific language, sorry.  Should have taken a screenshot.

2.  I did rebuild the index – trying everything.  The message is dated 7/30 at 4am.

I will PM the relevant info immediately.

EG Eric Grey
Eric Grey
Member

I did respond – unless there’s one that I’m not seeing.  You have all the credential information you need, as far as I know.

YS Yellow Swordfish
Yellow Swordfish
Member

You’re right – I misread the last line of the PM – sorry.
However – using those credentials to loads the forum page results in a ‘Membership Cancelled’ page…

YS Yellow Swordfish
Yellow Swordfish
Member

Wow! Now that is VERY weird!

would it be possible to have ftp access to the SP code files? I am going to need to put some debug statements in the code to try and find the point that the individual posts content is removed…

RB Richard Bonk
Richard Bonk
Member

Has this been resolved? The same thing has happened to my forum. See example here: http://premiumwebservices.co.uk/forum/plugins-and-addons/add-top-menu-to-premiumpress-not-working-on-directorypress-simple-child-themes/

All the text has disappeared. I have tried disabling all plugins etc. but nothing seems to work.

Any help would be appreciated.

Kind regards,

 

Richard

MP Mr Papa
Mr Papa
Member

this single occurrance?  not yet, but I highly doubt that is the issue you are having…

can you look in your error log for more info – suspect the error is being supressed (which is good)…

or go to wp – settings – reading and enable the smiley conversion… should fix it up…  and will be fixed so you can disable in day or two with a new release…

RB Richard Bonk
Richard Bonk
Member

Thank you Mr Papa, enabling the smiley conversion has fixed it!

Any specific reason for that behavior?

Kind regards,

Richard

YS Yellow Swordfish
Yellow Swordfish
Member

Yes – hands up – it was my fault!

I tapped into the WP core code for smiley conversion without realising that it was, in fact, an option.