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
Messages when trying to view topics: "Invalid Database", "Access denied - you do not have permission to view this page"
Avatar
Anise
Portland, OR
Member
Free Members
sp_UserOfflineSmall Offline
Sep 24, 2014 - 10:07 pm

Hey all,

 

So basically, I created a new topic in a forum. Then I also posted it as a blog post. The problem was that when I went to the front page and then clicked the "join the discussion" line at the bottom, it took me to the forums... but the message at the top of the page was "invalid database" and the message right under the forum list was "Access denied - you do not have permission to view this page." I went back and checked all the permissions, and there's no reason why I shouldn't have been able to see that topic page (even leaving aside the fact that I'm the admin!)

 

Now, I might have thought that it was just something connected to the process of starting a topic and then posting it as a blog post, EXCEPT... I started another test topic and didn't link it as a blog post. I then went back in through the forums through the front page. Exactly the same thing happened!!! This is NOT good. :( Does anybody know what might be going on? I really want to open the forums up this weekend!

 

Thanks,

 

Anise

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 24, 2014 - 10:58 pm

what do you mean by created a forum topic...  and THEN also posted it as blog post?  that would normally be one action, so can you explain what you did?

what is the error message that generates the invalid database?  you can see them on forum - toolbox - error log...

what do you mean by admin?  wp admin or sp admin?  not the same thing, though a user could be both..

Avatar
Anise
Portland, OR
Member
Free Members
sp_UserOfflineSmall Offline
Sep 24, 2014 - 11:20 pm

I created a forum topic and picked the option to also create as a blog post. It did show up as a blog post. (Actually, I just tried it again with a test topic, and exactly the same things happened.)

 

I'm the only admin of anything on this page! ;) So I think I'm every kind of admin there is... ? 

 

Here are the two error messages that said "database," both from today. They're long... there's also mention of another one at the bottom; I didn't know if it might also have anything to do with it.

 

September 25, 2014 3:14 am | spaErrError | 17 | database

file: /problem-with-post-edit-buttonome/catdan/www.dracoandginnyblog.com/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php

line: 238

function: select

error: Unknown column 'attachments' in 'field list'

SELECT group_id, wp_yhg377_sftopics.topic_id, wp_yhg377_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_pinned, topic_icon, topic_opened, wp_yhg377_sftopics.post_count, forum_slug, forum_status, forum_disabled, forum_rss_private, wp_yhg377_sfposts.post_id, post_date, wp_yhg377_sfposts.user_id, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, source, post_content, NULL AS new_post, answered, blog_post_id, attachments, polls, poll, post_ratings, rating_id, vote_count, ratings_sum, ips, members, topic_subs FROM wp_yhg377_sftopics JOIN wp_yhg377_sfposts ON wp_yhg377_sftopics.topic_id=wp_yhg377_sfposts.topic_id JOIN wp_yhg377_sfforums ON wp_yhg377_sftopics.forum_id=wp_yhg377_sfforums.forum_id LEFT JOIN wp_yhg377_sfpostratings ON wp_yhg377_sfpostratings.post_id = wp_yhg377_sfposts.post_id WHERE wp_yhg377_sftopics.topic_id=1 ORDER BY post_pinned DESC, wp_yhg377_sfposts.post_id ASC LIMIT 0, 20

September 25, 2014 3:12 am | spaErrError | 7 | database

file: /problem-with-post-edit-buttonome/catdan/www.dracoandginnyblog.com/wp-content/sp-resources/forum-plugins/plupload/sp-plupload-plugin.php

line: 189

function: sp_plupload_do_forumview_query

error: Unknown column 'attachments' in 'where clause'

SELECT topic_id FROM wp_yhg377_sfposts WHERE wp_yhg377_sfposts.topic_id IN (1) AND attachments IS NOT NULL

 

That's the end of the database error messages, but when I look in the error log, I can see that a couple of "php error" messages came up too. I don't know if those are relevant or not.

 

Thank you SO much for help and advice!! I kind of promised everyone on our FB group that the forums would be open by the weekend... never a good idea to give a specific date...

 

Anise

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 25, 2014 - 1:13 am

so what versions of Simple Press and the plupload plugin?  looks like they might be mismatched...

Avatar
Anise
Portland, OR
Member
Free Members
sp_UserOfflineSmall Offline
Sep 25, 2014 - 3:00 pm

That might not be good! Okay, here's what it says at the bottom of the page:

 

Simple:Press | Version 5.5.1

 

Now, on to the plugins folder...

Updated all the plugins...

 

IT WORKS!!! YAY!!!

 

Thanks infinitely,

 

Anise

 

 
A Simple:Press plugin for uploading images, media and files in posts
Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Sep 25, 2014 - 3:04 pm

Glad you got it resolved!

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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626