YAFLogo

banana
  • banana
  • 50.6% (Neutral)
  • YAF Forumling Topic Starter
10 years ago
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
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
10 years ago

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

Originally Posted by: banana 

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

<add key="YAF.EnableURLRewriting" value="false" />
hienta
  • hienta
  • 53% (Neutral)
  • YAF Forumling
7 years ago
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!!!

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago

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

Originally Posted by: hienta 

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?

hienta
  • hienta
  • 53% (Neutral)
  • YAF Forumling
7 years ago

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

Originally Posted by: tha_watcha 

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?

Originally Posted by: hienta 

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'