banana
  • Posts: 1
  • Joined: 25/08/2014
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
tha_watcha
  • Posts: 4037
  • Joined: 06/03/2010
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" />

UserPostedImage
hienta
  • Posts: 5
  • Joined: 29/08/2017
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
  • Posts: 4037
  • Joined: 06/03/2010
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?


UserPostedImage
hienta
  • Posts: 5
  • Joined: 29/08/2017
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'

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.

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

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved