ASPNETFORUMS1.0 installation notes

System environment: Window2000, IIS5.0, DOTNET FRAMEWORK1.1, SQLSERVER2000

First, the initial setting will decompress the ASPNETforum to a directory DOTNETFORUM, with the following directory: - Aspnetforums - Engine - Install_Images - SQLScripts - SQLUPGRADEScripts

Set the ASPNETFORUMS as a virtual directory aspnetforumUMS in IIS (other names.), NT ACL permissions allow EVERYONE access.

SqlServer2000 a database created in AspNetForums, using a different name does not matter, in AspNetForums directory Web.Config file node This node sets the properties of the connection string, the default is ASPNETforums. Run the four SQL scripts in SQLScripts in the ASPNETforum database, executed in the order of 1, 2, 3, and 4. Since I have created a database through my own manual, run the first script prompt some errors, but there is no relationship, successfully executed.

The initial setting is complete!

Second, debugging running web.config node to so that it can debug in compilation. Then visit http: // localhost / aspnetforums /

1. Run error A error message: Unable to open the database requested in 'ASPNETforumus'. Login failed. User 'HOB / ASPNET' login failed (HOB / ASPNET is an ASPNET configuration account on my machine). According to the stack track, it is found that the system.data.sqlclient.sqlconnection connection failed, I thought it was the connection string did not set the user account, the password, so modified , but still error, look at this connection string and there is a Trusted_Connection property. It turns out that he uses Windows account credentials to verify the authentication of database access, and it is useless to add UID. So you can have two options, remove trusted_connection = true, or add HOB / ASPNET users in the database, and let him belong to the role of the DB_WNER of Aspnetforum. I chose to add HOB / ASPNET account in the database.

by! !

2. Running error two runs, an error message appears: Unable to resolve the rule of rule of Equal TO operation. According to the stack track, check the ASPNETFORUMS.DATA.SQLDATAPROVIDER.GETSITESTATISTICS method (source code can be found from Engine's project), found that he visited the stored procedure for ForuMs_getstatistics. Checking the Database Storage Procedure Find Error STATISTICS_RESETTOPPPSTERS in another stored procedure he called, there are several similar to: update users set attributes = (int, attributes) & 0xfffffff3) Where username = (Select Username from # Top500Users Where Rank = @LoopCounter) This statement. Since the result set rules of the sub-query are the default (my database is China_PRC sort), the username field of the user uses SQL_LATIN1_GENERAL_CP1_CI_AS sorting rules, thus collision with Equal TO. You can add a SQL_LATIN1_GENERAL_CP1_CI_LATIN1_GENERAL_CP1_CI_AS sorting rule to the temporary table # TOP500USERS, or use a variable to store the query result (also a result). Finally, run success! !

Recently I wanted to find a good open source forum. I hope that C # is written, so I think of Aspnetforums, I downloaded a 1.0 version, I found some problems, I recorded it. Aspnetforum has now developed for CommunityServer, it is a comparative knowledge management and collaborative platform.