8000 User Thread List throws error if they have posted in a forum that is no longer published · Issue #205 · i7MEDIA/mojoportal · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

User Thread List throws error if they have posted in a forum that is no longer published #205

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
JosephMDavis opened this issue Jun 8, 2023 · 0 comments
Open

User Thread List throws error if they have posted in a forum that is no longer published #205

JosephMDavis opened this issue Jun 8, 2023 · 0 comments

Comments

@JosephMDavis
Copy link
Member

Add forum module to a page and create a forum
Add a post to the forum
Remove the forum module from the page, don't delete it
Go to Member List > Manage > User Activity > View Posts

The sql needs to return a -1 for PageId if it's null. Relevant corrected sql is below

PageID = ISNULL((SELECT TOP 1 PageID FROM mp_PageModules WHERE mp_PageModules.ModuleID = f.ModuleID AND (PublishEndDate IS NULL OR PublishEndDate > getutcdate())), -1),

which needs to replace this

(SELECT TOP 1 PageID FROM mp_PageModules WHERE mp_PageModules.ModuleID = f.ModuleID AND (PublishEndDate IS NULL OR PublishEndDate > getutcdate()) ) As PageID,

in [mp_ForumThreads_SelectPageByUser] stored procedure

need to do similar in other db layers
@JosephMDavis JosephMDavis converted this from a draft issue Jun 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
mojoPortal 2.9.1
Status: 🆕 New
Milestone
No milestone
Development

No branches or pull requests
1 participant
@JosephMDavis
0