Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogcancan't read or edit blog text
Previous
 
Next
New Post
4/17/2008 4:12 PM
 

Since I recently moved my DNN 4.6.0 site to a new hosting service, links on the blog module entry list page do not work. They all default back to the base URL of the blog module:

http://www.arttartare.net/dnn/Blog/tabid/158/Default.aspx

Click either Read More, Edit Entry, or Comments, and the browser defaults back to the URL above. Even if I manually enter the entryID in the address window, the same thing happens. Does anyone know why this would happen

And btw, I upgraded blog from 3.0.1 to 3.4.0, and I upgraded DNN from 4.6.0 to 4.6.2 to 4.7.0 trying to fix this. It apparently does not come from any file issue.

Thanks for any help anyone can provide.

 
New Post
4/17/2008 6:00 PM
 

Hi David,

I believe I've seen this happen in the past when the stored procedures aren't updated properly.  Here's a quick way to see if the stored procedures are retrieving the right data.  Find out what your portal id is. If it's the default portal, then your portal id is 0.  You can check this in Host | Portals.  Next go to Host | SQL and execute the following SQL:

EXEC {databaseOwner}{objectQualifier}Blog_GetEntry 72,0

Where 72 is the EntryId of the latest post I found on your site and 0 would be the portal Id you looked up above.  You should see data returned from this query.  If not, then you may want to check your web.config file to make sure that the connections strings are pointed to the right version of the database.  I've had issues before where my web.config was pointing to a backup version and not the upgraded version.

Of course, before you do anything that would update the database, like the steps I recommend next, please backup your database and your DotNetNuke folder to ensure that you don't lose data in the process!

If this doesn't work then you may want to manually execute the SQL found in the SqlDataProvider files starting with 03.01.04.SqlDataProvider.  You can execute these using the same Host | SQL tool referenced above.  Also, make sure to execute these files sequentially starting with the earlier versions first.

If you recieve error messages while executing these files, then copy these messages into Notepad or some editor and then you can include them in a post back here on the forum to see if others can help figure out what might be the problem.

HTH,

Don



Don Worthley
Software Architect
Element Eleven

 
New Post
4/17/2008 10:24 PM
 

Thanks for the detailed response, Don. I'll look into this and report back on what's found.

 
New Post
4/18/2008 5:51 PM
 

I got this reply from the database guy who's been helping me. Any suggestions?

I was able to execute all of them up to 03.01.21.SqlDataProvider at which point I got this error:

Msg 515, Level 16, State 2, Line 3
Cannot insert the value NULL into column 'TabID', table 'dreamtimers.dbo.Blog_Settings'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2705, Level 16, State 4, Line 9
Column names in each table must be unique. Column name 'TabID' in table 'Blog_Settings' is specified more than once.

(2 row(s) affected)
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'AllowTrackbacks' in table 'Blog_Blogs' is specified more than once.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'Approved' in table 'Blog_Comments' is specified more than once.

(25 row(s) affected)

(11 row(s) affected)

 

 
New Post
4/20/2008 12:47 AM
 

Hi David,

Sorry for the delay. All of these errors are the normal errors you'll see if you run the scripts more than once.  The first error occurs becuase of changes made later in the script which make the TabId a part of the primary key in the Blog_Settings table.  Because of this change, you'll get an error on the earlier part of this script the second time it's run becuase the insert doesn't specify a value for the TabId column which is now required.  The rest of the errors are related to code which attempts to add a column to the database. 

So, short answer is that these errors are nothing to worry about.  Keep running the scripts in order and let us know if you run into any more errors. 

Thanks,

Don



Don Worthley
Software Architect
Element Eleven

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogcancan't read or edit blog text


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out