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