1.9.5.5 BETA to 1.9.6.2 BETA · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago

I have a 1.9.5.5 BETA forum that was imported from Snitz 2000 -- We are using Mek's instructions on the provider settings to allow the old Snitz Passwords...

I believe I have properly adopted the various config files, but for some reason, I'm getting a weird exception. Note that installation scripts reported success connection to database, and installation script completed with no errors. This is on forum first run, and subsequent changes/tests of different config options are still revealing same result...


Exception Details: YAF.Core.Data.NoValidDbAccessProviderFoundException: No Valid Database Access Module Found for Provider Named "System.Data.SqlClient".

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NoValidDbAccessProviderFoundException: No Valid Database Access Module Found for Provider Named "System.Data.SqlClient".]
   YAF.Core.Data.DbAccessProvider.get_Instance() +165
   YAF.Core.Data.DynamicDbFunction.DbFunctionExecute(DbFunctionType functionType, InvokeMemberBinder binder, IList`1 parameters, Func`2 executeDb, Object& result) +183
   YAF.Core.Data.DynamicDbFunction.InvokeGetData(InvokeMemberBinder binder, Object[] args, Object& result) +87
   YAF.Core.Data.TryInvokeMemberProxy.TryInvokeMember(InvokeMemberBinder binder, Object[] args, Object& result) +21
   CallSite.Target(Closure , CallSite , Object , Boolean ) +188
   System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) +707
   YAF.Core.Services.YafDBBroker.<GetModerators>b__41(Object cdb) +224
   CallSite.Target(Closure , CallSite , Func`2 , Object ) +81
   System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) +699
   YAF.Types.Interfaces.IDbFunctionExtensions.GetAsDataTable(IDbFunction dbFunction, Func`2 function) +385
   YAF.Core.Services.YafDBBroker.GetModerators() +47
   YAF.Core.HttpRuntimeCache.GetOrSetInternal(String key, Func`1 getValue, Action`1 addToCacheFunction) +312
   YAF.Core.HttpRuntimeCache.GetOrSet(String key, Func`1 getValue, TimeSpan timeout) +256
   YAF.Core.Services.YafDBBroker.BoardLayout(Int32 boardID, Int32 userID, Nullable`1 categoryID, Nullable`1 parentID) +278
   YAF.Controls.ForumCategoryList.BindData() +153
   YAF.Controls.ForumCategoryList.Page_Load(Object sender, EventArgs e) +5
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

It's got to be something obvious but I need a kick in the right direction --

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA

12 years ago

Please check your connection string in the db.config it needs to include the providerName

providerName="System.Data.SqlClient"

something like this...

<add name="yafnet" connectionString="data source=(local);initial catalog=yafnet;integrated security=SSPI" providerName="System.Data.SqlClient" />

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago

It's already there -- contents of the current db.config:


<connectionStrings>
  <!-- Connection String for SQL Server 2005/2008 -->
  <!--<add name="yafnet" connectionString="data source=(local);initial catalog=yafnet;integrated security=SSPI" />-->
  <!-- Connection String for SQL Server 2005/2008 Express -->
  <add name="yafnet" connectionString="server=.\SQLExpress;User Id=xxxx;Password=xxxx;Trusted_Connection=False;database=xxxx" providerName="System.Data.SqlClient" />
</connectionStrings>

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago


<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="rewriter" type="Intelligencia.UrlRewriter.Configuration.RewriterConfigurationSectionHandler, Intelligencia.UrlRewriter" requirePermission="false"/>
  </configSections>
  
  <connectionStrings configSource="db.config"/>
  
  <appSettings configSource="app.config"/>
  
  <rewriter configSource="URLRewriter.config"/>
  
  <system.net>
    <mailSettings>
      <smtp configSource="mail.config"/>
    </mailSettings>
  </system.net>
  
  <system.web> 
    <machineKey validationKey="xxxx" decryptionKey="xxxx" validation="SHA1" decryption="AES" />
  
    <httpRuntime requestValidationMode="2.0" maxRequestLength="28192" executionTimeout="6000" requestLengthDiskThreshold="18192" />
    
    <xhtmlConformance mode="Strict"/>
    
    <customErrors defaultRedirect="Error.aspx" mode="On"/>
    
    <!--  GLOBALIZATION
    This section sets the globalization settings of the application. 
    Utf-8 is not supported on Netscape 4.x 
    If you need netscape compatiblity leave iso-8859-1.
    UTF-8 is recommended for complex languages
    -->    
    <globalization culture="en-US" uiCulture="en" requestEncoding="UTF-8" responseEncoding="UTF-8" fileEncoding="UTF-8" />
    <!--<globalization culture="en-US" uiCulture="en"  fileEncoding="iso-8859-1" requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"/>-->
    
    <authentication mode="Forms">
      <forms name=".YAFNET_Authentication" protection="All" timeout="43200" cookieless="UseCookies" slidingExpiration="True" />
    </authentication>
    
    <!-- Set debug to "true" to test out the system in development -->
    <compilation debug="false" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        <add assembly="System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
        <add assembly="System.ServiceModel.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
      </assemblies>
    </compilation>
    
    <httpHandlers>
      <add verb="GET" path="Resource.ashx" type="YAF.YafResourceHandler, YAF" />
    </httpHandlers>
    
    <httpModules>
      <add name="YafTaskModule" type="YAF.Core.YafTaskModule, YAF.Core"/>
      <add name="UrlRewriter" type="Intelligencia.UrlRewriter.RewriterHttpModule,Intelligencia.UrlRewriter"/>
    </httpModules>
    
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID" enableEventValidation="false" validateRequest="false">
      <controls>
        <!-- Default: use non-dynamic (compiled classes) in YAF -->
        <add tagPrefix="YAF" namespace="YAF.Controls" assembly="YAF.Controls"/>
        <add tagPrefix="YAF" namespace="YAF.Controls.Statistics" assembly="YAF.Controls"/>
        <add tagPrefix="YAF" namespace="YAF.Classes"/>
        <add tagPrefix="YAF" namespace="YAF"/>
      </controls>
      <namespaces>
        <add namespace="YAF.Core"/>
        <add namespace="YAF.Controls"/>
        <add namespace="YAF.Utils"/>
        <add namespace="YAF.Types.Interfaces"/>
        <add namespace="YAF.Types"/>
      </namespaces>
    </pages>
    
<!--
    <membership defaultProvider="YafMembershipProvider" hashAlgorithmType="SHA1">
      <providers>
        <clear />
        <add name="YafMembershipProvider" applicationName="YetAnotherForum" connectionStringName="yafnet" requiresUniqueEmail="true" useSalt="true" type="YAF.Providers.Membership.YafMembershipProvider"/>
        <add name="AspNetSqlMembershipProvider" applicationName="YetAnotherForum" connectionStringName="yafnet" enablePasswordReset="false" enablePasswordRetrieval="true" maxInvalidPasswordAttempts="5" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="5" passwordAttemptWindow="15" passwordFormat="Encrypted" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" type="System.Web.Security.SqlMembershipProvider" />
      </providers>
    </membership>
-->
    <membership defaultProvider="YafMembershipProvider" hashAlgorithmType="SHA256">
       <providers>
          <clear/>
          <add connectionStringName="yafnet" applicationName="YetAnotherForum" name="YafMembershipProvider" requiresUniqueEmail="true" useSalt="false" minRequiredNonAlphanumericCharacters="0" minRequiredPasswordLength="6" requiresQuestionAndAnswer="false" type="YAF.Providers.Membership.YafMembershipProvider" hashHex="true" hashCase="lower"/>
       </providers>
    </membership>

    <roleManager enabled="true" defaultProvider="YafRoleProvider">
      <providers>
        <clear />
        <!-- YAF's ASP.NET Role Provider is designed to work a bit better with YAF.NET options, but is by no means required.
             But, you will not be able to switch providers after installing your forum. -->
        <add name="YafRoleProvider" applicationName="YetAnotherForum"  connectionStringName="yafnet" type="YAF.Providers.Roles.YafRoleProvider"/>
        <!-- Set as default if you want to use use the built-in ASP.NET role provider. -->
        <add name="AspNetSqlRoleProvider" applicationName="YetAnotherForum" connectionStringName="yafnet" type="System.Web.Security.SqlRoleProvider" />
      </providers>
    </roleManager>

    <profile enabled="true" defaultProvider="YafProfileProvider" inherits="YAF.Utils.YafUserProfile">
      <providers>
        <clear/>
        <!-- YAF's ASP.NET Profile Provider is designed to work a bit better with YAF.NET options, but is by no means required.
             But, you will not be able to switch providers after installing your forum. -->
        <add name="YafProfileProvider" applicationName="YetAnotherForum" connectionStringName="yafnet" type="YAF.Providers.Profile.YafProfileProvider"/>
        <!-- Set as default if you want to use use the built-in ASP.NET profile provider. -->
        <add name="AspNetSqlProfileProvider" applicationName="YetAnotherForum" connectionStringName="yafnet" type="System.Web.Profile.SqlProfileProvider"/>
      </providers>
    </profile>
    

  </system.web>
  
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false"/>
    <modules>
      <remove name="YafTaskModule"/>
      <remove name="UrlRewriter"/>
      <add name="YafTaskModule" type="YAF.Core.YafTaskModule, YAF.Core" preCondition="managedHandler"/>
      <add name="UrlRewriter" type="Intelligencia.UrlRewriter.RewriterHttpModule,Intelligencia.UrlRewriter" preCondition="managedHandler"/>
    </modules>
    <handlers>
      <add name="YafHandler" preCondition="integratedMode" verb="GET" path="Resource.ashx" type="YAF.YafResourceHandler, YAF" />
    </handlers>
  </system.webServer>
</configuration>

web.config with the membership provider settings migrated from previous web.config - otherwise it's a stock 1.9.6.2 web.config

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA

12 years ago

There is a new YAF.Data.MsSql.dll looks like this is missing in your bin folder

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago

Thanks - that was it -- I'm going to have to check that stuff closer next time -

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

12 years ago

I wiped out my beta site , installed the latest RTW from codeplex, everything was fine.

Downloaded the latest changeset here

http://yafnet.codeplex.com/SourceControl/changeset/view/c47f5cd295e8

Ran the .bat file to compile the source code

Then uploaded the contents from

yafnet_c47f5cd295e8\yafsrc\YetAnotherForum.NET to the root directory

and I'm getting this error...

Method 'get_GetReader' in type 'YAF.Core.Data.DynamicDbFunction' from assembly 'YAF.Core, Version=1.9.6.2, Culture=neutral, PublicKeyToken=8b49dc47f4701f66' does not have an implementation.

I seen this thread and I looked for the YAF.Data.MsSql.dll and I'm not able to find it. So the question after all that is ... where can I find that DLL? :)

Edit, UGH! I can't open the solution because it was created in VS2012! I'll try downloading and using the express version.

Edited by user 12 years ago | Reason: Not specified

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago

I was able to open the solution in VS-2010. The DLL file you're missing is in the folder yafsrc/yaf.data.mssql - there should be an obj folder created in there somewhere when you are done compiling.

If you need, I can load and compile and post you the DLL if you needed it --

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

12 years ago

I was able to open the solution in VS-2010. The DLL file you're missing is in the folder yafsrc/yaf.data.mssql - there should be an obj folder created in there somewhere when you are done compiling.

If you need, I can load and compile and post you the DLL if you needed it --

Originally Posted by: squirrel

Thank you for the offer, but I want to learn how to fish, not have a fish given to me. I find it incredibly embarrassing that I can't figure this out. The YAF team does such a great job on taking suggestions from the community and i can't reap the benefits of their hard work ... it sucks for me. But maybe its a good thing as I think bbob mentioned some errors with the latest build.

When I have more time to dedicate more than 2 of my active brain cells on this, I'm going to give it another shot. Another hurdle I have is I'm using tha_watcha's YAF ASP.NET solution and I'm pretty timid on how to update it properly. My first step though is getting a normal YAF install upgraded with source code first. Then I'll try to graduate to my full site.

Again, thanks for the offer, but I just really want to figure out what I'm doing wrong here on what everyone does without a hiccup.

squirrel
100% (Exalted)
YAF Leader Topic Starter

12 years ago

#10

I was able to open the solution in VS-2010. The DLL file you're missing is in the folder yafsrc/yaf.data.mssql - there should be an obj folder created in there somewhere when you are done compiling.

If you need, I can load and compile and post you the DLL if you needed it --

Originally Posted by: Zero2Cool

Again, thanks for the offer, but I just really want to figure out what I'm doing wrong here on what everyone does without a hiccup.

Originally Posted by: squirrel

Part of it might be that lately in the current beta there are some real changes being made towards the 2.0 roadmap and they might be causing quirks until an RC comes out with some of those kinks fixed.

The only thing I can suggest, other than that path I mentioned earlier, is to grab a new source copy and see if there have been any fixes in the last couple revisions --

Additionally, I got errors over nuget when I ran the commandline compiler - so there might have to be a run of the 'build packages' before you can just run 'build' -- tha_watcha might be able to clarify. When I had issues, I tracked down the missing DLLs and just downloaded them individually and dropped them in YAF bin folder when done -- I think nuget needed to be present for build though.

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA

12 years ago

#11

Ok to clarify. You dont need nuget present before build it will be automatically downloaded on build.

- The Build.bat simply compiles all Projects and recompiles the dlls

- The BuildPackages.bat compiles everything and Creates 3 Zip Packages - Install, Upgrade and one Source Package

With the latest change set also the missing nuget repositories should work now.

At least it works now on my build server 🙂

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

12 years ago

#12

Originally Posted by: tha_watcha

Ok to clarify. You dont need nuget present before build it will be automatically downloaded on build.

- The Build.bat simply compiles all Projects and recompiles the dlls

- The BuildPackages.bat compiles everything and Creates 3 Zip Packages - Install, Upgrade and one Source Package

With the latest change set also the missing nuget repositories should work now.

At least it works now on my build server 🙂

I downloaded the latest source build from the link below.

http://yafnet.codeplex.com/SourceControl/list/changesets

I unzipped it and ran the .bat file right away and this is what I got.

Microsoft Windows [Version 6.1.7600]

C:\Users\Kevin>C:\Users\Kevin\Desktop\yafnet_e06c4c8452ff\yafsrc\build.bat

C:\Users\Kevin>msbuild.exe YetAnotherForum.NET.sln /p:Configuration=Release /t:

Clean;Build /p:WarningLevel=0

Microsoft (R) Build Engine version 4.0.30319.17929

[Microsoft .NET Framework, version 4.0.30319.17929]

MSBUILD : error MSB1009: Project file does not exist.

Switch: YetAnotherForum.NET.sln

When I double click the .bat file, things happen quick on the DOS like window that I can't read what's happening, so I dragged the file into the DOS window and hit enter.

Edit, I think I have to download/install this... downloading now.

http://www.microsoft.com/visualstudio/eng/downloads#d-2012-express

Edited by moderator 12 years ago | Reason: Not specified

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

12 years ago

#13

That download/install did the trick, but now I'm getting a failure to download the NuGet.exe ... its probably a proxy issue from the network.

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA

12 years ago

#14

Looks like the solution file (sln) can not be found. Are you extracted all files, and is the sln file in the same folder as the build.bat?

I just tested it on my new laptop without Visual Studio, without any problems.

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

12 years ago

#15

Looks like the solution file (sln) can not be found. Are you extracted all files, and is the sln file in the same folder as the build.bat?

I just tested it on my new laptop without Visual Studio, without any problems.

Originally Posted by: tha_watcha

I downloaded VS2012 for Web, express and opened the solution, and ...

========== Rebuild All: 11 succeeded, 0 failed, 0 skipped ==========

There are 187 warnings, but hey, no errors! I'm going to see if I can get the DLL's an files to my beta site.

Edit, dang, didn't work.

Show Spoiler

Procedure or function yaf_bannedip_list has too many arguments specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function yaf_bannedip_list has too many arguments specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Procedure or function yaf_bannedip_list has too many arguments specified.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073486

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064444

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275

System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33

System.Data.SqlClient.SqlDataReader.get_MetaData() +86

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141

System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12

System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94

YAF.Classes.Data.MsSqlDbAccess.GetDatasetBasic(IDbCommand cmd, Boolean transaction) +768

YAF.Classes.Data.MsSqlDbAccess.GetData(IDbCommand cmd, Boolean transaction) +134

YAF.Types.Interfaces.Data.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd) +85

YAF.Classes.Data.LegacyDb.bannedip_list(Object boardID, Object ID, Object pageIndex, Object pageSize) +256

YAF.Core.Services.StartupCheckBannedIps.b__0() +204

YAF.Core.HttpRuntimeCache.GetOrSetInternal(String key, Func`1 getValue, Action`1 addToCacheFunction) +486

YAF.Core.HttpRuntimeCache.GetOrSet(String key, Func`1 getValue) +353

YAF.Core.Services.StartupCheckBannedIps.RunService() +187

YAF.Core.Services.BaseStartupService.Run() +74

YAF.Core.IHaveServiceLocatorExtensions.b__5(IStartupService service) +29

YAF.Types.Extensions.EnumerableExtensions.ForEach(IEnumerable`1 list, Action`1 action) +330

YAF.Core.IHaveServiceLocatorExtensions.RunStartupServices(IHaveServiceLocator serviceLocator) +635

YAF.Core.Services.PageRequestLoadServices.RequestedPage_PreInit(Object sender, EventArgs e) +90

System.Web.UI.Page.OnPreInit(EventArgs e) +9010534

System.Web.UI.Page.PerformPreInit() +31

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +328

Edited by moderator 12 years ago | Reason: Not specified

Important Information: