Articles Disappeared
Last Post 12/20/2005 3:07 PM by Lee Sykes. 1 Replies.
Author Messages
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:4945


--
12/20/2005 3:45 AM
    For some reason the articles listed within the News Articles module have disappeared from the website. These provide the RSS feeds and easy search / categories / access to all of the content throughout the site.

    I am currently trying to fix the problem.

    Luckily the main tutorials and articles are added to actual pages, so the tutorials have not disappeared and you can view them through the menu, or visit the issues (on the left hand side)

    I will update this post when I have fixed the problem.

    Many thanks,

    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile
    Lee Sykes
    DNN Creative Staff
    Nuke Master VI
    Nuke Master VI
    Posts:4945


    --
    12/20/2005 3:07 PM
    Ok, I've fixed it and found the problem, incase anyone else has this problem this is what occurred:

    Recently I was viewing my log files and noticed that every other day people were trying to hack into the website by trying to log in as host.

    Therefore I decided to further secure the host account by creating a new superuser account with a different username and deleted the original host account.

    This is where the problem occurred. - The News Articles module has a reference to the user that created the original article, if that user is deleted - the News Articles module no longer displays the article.

    Therefore I had to do two updates to the DNN Forge Articles table.

    I had to update the column that contained the AuthorID and the LastUpdatedID as these contained the IDs of the original host account that I deleted.

    Therefore, I just ran this query to update both of these columns to the new User ID of the new SuperUser account (The ID here is not the correct ID number)

    UPDATE    DnnForge_NewsArticles_Article
    SET              AuthorID = 2034, LastUpdateID = 2034
    WHERE     (AuthorID = 1) OR
                          (LastUpdateID = 1)


    Panic over! - Hope this will be of some use to someone else...

    Thanks,
    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile


    ---