YAFLogo

nathanw
  • nathanw
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
11 years ago
Hi Everyone

I am new to YAF and am trying to install it on a fresh install of DNN 7 which I am hosting on the PowerDNN servers. The DNN install is working fine and am now trying to install the latest YAF module.

I have followed the changes to the win.config etc and the installation wizard has started. I get to the page where you specify the forum name, fill in the details and click next but I get the following error.

The 'System.Web.Security.SqlRoleProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

As this is a hosted site I do not have access to the server so cannot install anything. How do I get around this issue so that I can use YAF?

Thanks

Nathan

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
11 years ago
This is a bug in DNN 7.0 the needed sql Scripts are not executed.

I attached the sql script to register the roles and profile sql scripts

Simply execute it in dnn unter Host -> SQL -> SQL File -> Upload the File - > Check "Run as Script"-> Run Script

P.S: This Fix is only needed on a new DNN 7.0.0 Installation.

nathanw
  • nathanw
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
11 years ago
Thanks, I have run the script which all ran fine. When I now go back to the page I get the following error:

"A critical error has occurred. Could not locate the guest user for the board id 1. You might have deleted the guest group or removed the guest user."

Is it possible to rerun the install to set it up again or should I do something else?

Thanks again for your help.

Nathan

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

Thanks, I have run the script which all ran fine. When I now go back to the page I get the following error:

"A critical error has occurred. Could not locate the guest user for the board id 1. You might have deleted the guest group or removed the guest user."

Is it possible to rerun the install to set it up again or should I do something else?

Thanks again for your help.

Nathan

Originally Posted by: nathanw 

Simply try to deinstall the Module via the Extensions Page, this should delete all Tables. Then you Install the Module again.

nathanw
  • nathanw
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
11 years ago
Brilliant that has worked great. Thanks for all your help.

Nathan

billyba
  • billyba
  • 51.4% (Neutral)
  • YAF Camper
11 years ago
I'm going to revive this topic. I am running DNN 7.00.05 and tried to install the YAF module. I received the exact same error as Nathan in his first post. I downloaded and tried the fix by tha_watcha, but the script won't successfully run. I get the following error:

"System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Resource'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:046bd2e2-4712-40cc-96ed-93a598cfcc4b PRINT '---------------------------------------' PRINT 'Completed execution of InstallRoles.SQL' PRINT '---------------------------------------' Error: Resource has been moved or is unavailable. Please contact the forum admin."

Any idea what the problem is?

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

Any idea what the problem is?

Originally Posted by: billyba 

Did you check the check box "Run as Script"?

billyba
  • billyba
  • 51.4% (Neutral)
  • YAF Camper
11 years ago
Yes, it was checked. I also tried uninstalling the module and then running the script, but I received the same error.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
11 years ago

Yes, it was checked. I also tried uninstalling the module and then running the script, but I received the same error.

Originally Posted by: billyba 

Sorry found the problem, yaf breaks the script. Before you execute the scrip open it in a text editor (ike notepad) and remove the last line

"Error: Resource has been moved or is unavailable. Please contact the forum admin."

Then the script should run.

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
11 years ago
I upadted the download Page on Codeplex now the Release Includes the fix.

De-install, download again and install.

billyba
  • billyba
  • 51.4% (Neutral)
  • YAF Camper
11 years ago
Worked like a charm! Thanks for the quick support!