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

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.

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

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

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

Brilliant that has worked great. Thanks for all your help.

Nathan

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?

Any idea what the problem is?

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

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

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

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.

I upadted the download Page on Codeplex now the Release Includes the fix.

De-install, download again and install.

Worked like a charm! Thanks for the quick support!