Support Forum

Not able to access a post…

GI Giovanna
Giovanna
Member

A new user of my forum just tried to create a new topic but after having done that she cannot access it anymore. I can see the topic, actualy there are 2 now, but it’s not possible to open either of them andh it displays this message: “Access denied – you do not have permission to view this page”.

I am not sure what to check, the slug seems good!confused

 

edit: I just realised that there’s no author or time in the post title line …

corrupted-posts.jpg

50 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Rather odd.
Can you take a look in the SP error log (forum admin > toolbox > error log). You would be looking for those shaded pink – i.e.m, actual errors. If there are any can you copy and paste them here…

GI Giovanna
Giovanna
Member

yes there are some pink… in reverse order here they are the ones from today:

ps: what does i.e.m. stand for?

 

giugno 5, 2015 3:30 pm | spaErrError | 1 | database


file: /membri/mspforum/mspforum/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php
line: 490
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 avwp_sftopics SET post_id=, post_count=0, post_id_held=0, post_count_held=0 WHERE topic_id=37

giugno 5, 2015 3:23 pm | spaErrError | 1 | database


file: /membri/mspforum/mspforum/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php
line: 247
function: sp_subscriptions_do_topic_delete
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 ” at line 1

DELETE FROM avwp_sfdigest WHERE topic_id=

giugno 5, 2015 3:29 pm | spaErrError | 3 | database


file: /membri/mspforum/mspforum/wp-content/plugins/simple-press/sp-api/sp-api-class-post.php
line: 531
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 avwp_sftopics SET post_id=, post_count=0, post_id_held=0, post_count_held=0 WHERE topic_id=35

MP Mr Papa
Mr Papa
Member

both these posts were from same user? and not a guest?  was either in moderation from that user?  any messages when the user created it?

did some one try to do something with the topic, like move or delete it?  several actions appear to have been attempted…

can you go to forum – toolbox – houskeeping and try rebuilding the index for that topic? 

GI Giovanna
Giovanna
Member

Hi Mr Papa,

I am new to the simple:press plugin and have never seen the log file till today that Yellow Swordfish mentioned it. I just copied down the pink entries.
The situation was that one user inserted a new topic. Then she reported to me saying: I created it but cannot access it. And I tried too and the error I mentioned in the first post. Then I made a test topic and it worked. So I delete hers and asked her to make another one and another one with longer title. Didn’t work. Other users have been creating topics without problems. The forum is very young and there aren’t many people yet.
This is the background, I will now go to the Toolbox and try to find out how to do what you suggests! 

GI Giovanna
Giovanna
Member

already stuck: what exactly do I do in the Housekeeping screen?

MP Mr Papa
Mr Papa
Member

on the housekeeping tab in the upper left is a rebuild index section… in the dropdown, select the forum these topics are in and try rebuilding the index… dont think it will matter, but worth a try…

GI Giovanna
Giovanna
Member

yes I got to it and did it but no difference, I still get “Access denied – you do not have permission to view this page” on those topics 🙁

YS Yellow Swordfish
Yellow Swordfish
Member

@mr-papa – do you think could have anything to do with the post content?

GI Giovanna
Giovanna
Member

Ho can I examine the post content? The lady who wrote the post won’t be back till tomorrow…

MP Mr Papa
Mr Papa
Member

only thing that comes to mind would be illegal characters in the topic title that makes the post inaccessible…  so knowing true topic title might give clue…

to see the content,  you would have to view in the db…  sfposts table…

to get the topic title, in db, sftopic table…

GI Giovanna
Giovanna
Member

I managed to access the database and look and the entries with problems, they have NULL in the fields “post_id” and “post_id_held”… does this help you to understand what is happening?

corrupted-posts-db-entries.jpg
MP Mr Papa
Mr Papa
Member

not surprised actually…  just indicates neither topic has any posts… which is what I would expect given what you are seeing…   just not sure how they got in that state…

can your remove the topics?

and then ask the user to create a new one?  and take note of any messages… and see if they have same problem…

if I understood correctly, other users are creating posts fine…

GI Giovanna
Giovanna
Member

I can do that bt it’s exactly how we got into having two messages. I already deleted the first, then asked her to create another one, that didn’t work, so I asked for another one with a longer title (I was thinking that “notification” could have been a reserved word for the slug)… and that’s the result. So I don’t see the point to ask her to create some more. Also that lady was the worse person for this to happen: she is not technical at all and amongst my readers I don’t know her very well. 
Yes a very few others are posting fine, the only difference this lady has is a username very short: only 3 letters. Can that cause any issue?
After this I cannot think about anything else, only that she cannot use the forum as it is now confused

MP Mr Papa
Mr Papa
Member

and can she relay what the message was after creating the topic?  success?

and what about in the php error log after creating the topic?  not ours but the php one… 

since time has elapsed might be easier to look now as its tried again…

short names dont matter…. we have many here with 3 chars (look at the top posters)…  any non standard characters in that name?