Welcome Guest! To enable all features please Login or Register.
Options
View
Go to last post Go to first unread
Offline banana  
#1 Posted : Monday, August 25, 2014 11:28:12 AM(UTC)
banana


Rank: YAF Forumling

Reputation:

Joined: 8/25/2014(UTC)
Posts: 1

I just updated YAF 1.9.6.1 to 2.1.2 on DNN 7.3.2 and could not get it to work.

1) Get error on admin_edituser - PageLoadException: Invalid object name 'dbo.yaf_prov_Profile'.
I have a separate database for YAF and DNN.
When I add the table 'dbo.yaf_prov_Profile' to the DNN database I get a new error - PageLoadException: Could not find stored procedure 'dbo.yaf_prov_profile_getprofiles'
It seems as if YAF is accessing the DNN database instead of the YAF database ?

2) In 1.9.6.1 posts are accessed with .aspx extensions but the are omitted in 2.1.2 causing 404 errors. If I manually add the .aspx extensions all pages work.

Please advise
Sponsor
Offline tha_watcha  
#2 Posted : Wednesday, August 27, 2014 2:29:28 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
Originally Posted by: banana Go to Quoted Post
I just updated YAF 1.9.6.1 to 2.1.2 on DNN 7.3.2 and could not get it to work.

1) Get error on admin_edituser - PageLoadException: Invalid object name 'dbo.yaf_prov_Profile'.
I have a separate database for YAF and DNN.
When I add the table 'dbo.yaf_prov_Profile' to the DNN database I get a new error - PageLoadException: Could not find stored procedure 'dbo.yaf_prov_profile_getprofiles'
It seems as if YAF is accessing the DNN database instead of the YAF database ?

2) In 1.9.6.1 posts are accessed with .aspx extensions but the are omitted in 2.1.2 causing 404 errors. If I manually add the .aspx extensions all pages work.

Please advise


Quote:
It seems as if YAF is accessing the DNN database instead of the YAF database ?


You need to have both on one db, or modify the stored procedures.

2. turn off url rewriting in the appSettings section of the web.config

Code:
<add key="YAF.EnableURLRewriting" value="false" />
Offline hienta  
#3 Posted : Wednesday, August 30, 2017 8:48:42 PM(UTC)
hienta


Rank: YAF Forumling

Reputation:

Joined: 8/29/2017(UTC)
Posts: 5
Viet Nam
Location: Thua Thien Hue

I am using DNN 9.1.1 and when install then error Invalid object name 'dbo.yaf_prov_Profile'
I checked database then exist that table.
Who can help me this problems?.
Thanks!!!
Offline tha_watcha  
#4 Posted : Sunday, September 3, 2017 8:41:59 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
Originally Posted by: hienta Go to Quoted Post
I am using DNN 9.1.1 and when install then error Invalid object name 'dbo.yaf_prov_Profile'
I checked database then exist that table.
Who can help me this problems?.
Thanks!!!


i assume that you use dbo as default database object qualifier? This happens on the forum install wizard right? did you select the correct database onnection string in the installation wizard?

Offline hienta  
#5 Posted : Monday, September 4, 2017 6:57:04 PM(UTC)
hienta


Rank: YAF Forumling

Reputation:

Joined: 8/29/2017(UTC)
Posts: 5
Viet Nam
Location: Thua Thien Hue

Originally Posted by: tha_watcha Go to Quoted Post
Originally Posted by: hienta Go to Quoted Post
I am using DNN 9.1.1 and when install then error Invalid object name 'dbo.yaf_prov_Profile'
I checked database then exist that table.
Who can help me this problems?.
Thanks!!!


i assume that you use dbo as default database object qualifier? This happens on the forum install wizard right? did you select the correct database onnection string in the installation wizard?


Yes, i installation wizard it not error. i create new topic successful but when I awser or click username then it error Invalid object name 'dbo.yaf_prov_Profile'

Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error