YAFLogo

banana
  • banana
  • 50.6% (Neutral)
  • YAF Forumling Topic Starter
8 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: 3.0.3
8 years ago
Originally Posted by: banana 

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

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

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?

hienta
  • hienta
  • 53% (Neutral)
  • YAF Forumling
5 years ago
Originally Posted by: tha_watcha 

Originally Posted by: hienta 

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'

YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button