Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Not able to access a post...
Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 9:39 am

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.jpgImage Enlarger

My forum (in Italian) is: MsPforum

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 5, 2015 - 11:05 am

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...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 11:20 am

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

My forum (in Italian) is: MsPforum

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jun 5, 2015 - 1:06 pm

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? 

Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 1:41 pm

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! 

My forum (in Italian) is: MsPforum

Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 1:43 pm

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

My forum (in Italian) is: MsPforum

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jun 5, 2015 - 1:45 pm

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...

Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 1:46 pm

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 🙁

My forum (in Italian) is: MsPforum

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 5, 2015 - 3:07 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
Giovanna
Nijmegen - NL
Member
sp_UserOfflineSmall Offline
Jun 5, 2015 - 3:44 pm

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

My forum (in Italian) is: MsPforum

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620