Thx!!

FILE:

tables.sql

ERROR:

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

STATEMENT:

/*Version 1.0.2*/

/*

**Create missing tables

*/

if not exists (select 1 from sysobjects where id = (then a bunch of table names with type and size.

First, thank you to everyone who has been in the development of YAF! Seems like just my solution and are eager to implement.

I do have a question concerning profile providers. I'm trying to integrate 1.9.3 into my asp.net, 3.5 website with a SQL database sharing my present membership. My site uses the membership provider and does not use the profile provider. I'm fairly new and read keeping specific user info in a db is better than a string as is done in a profile (as I read it). I opted not to use profiles as I run sprocs against the db for user information retrieval. My main purpose for YAF is the private messaging portion but would like to implement the entire forum. I'm using 2 databases, mine and one named YAF. Does anyone know how I can implement the profile provider to work with my membership provider? I'd like to keep my membership logon and then utilize YAF. Everything I've read says I need the profile provider for the integration.

Any suggestions? Using Visual Studio/web developer, SQL 2008, YAF 1.9.3

Many thanks in advance!

Chris

<membership defaultProvider="YafMembershipProvider">
  <providers>
    <clear/>
    <add name="YafMembershipProvider"
         connectionStringName="AaspDatabase" 
         applicationName="AaspApplication" 
         type="System.Web.Security.SqlMembershipProvider"
         enablePasswordRetrieval="false"
         maxInvalidPasswordAttempts="5"
         minRequiredNonalphanumericCharacters="0"
         minRequiredPasswordLength="5"
         passwordAttemptWindow="10"
         passwordFormat="Hashed"
         requiresQuestionAndAnswer="false"
         requiresUniqueEmail="true"
         enablePasswordReset="true"/>
  </providers>
</membership>

<profile defaultProvider="YafProfileProvider" enabled="true" inherits="YAF.Classes.Utils.YafUserProfile">
  <providers>
    <clear/>
    <add name="YafProfileProvider"
         connectionStringName="AaspDatabase"
         applicationName="AaspApplication"
         type="System.Web.Profile.SqlProfileProvider" />
  </providers>
  <properties>
    <add name="Theme" allowAnonymous="false" defaultValue="ASPNETBlue"/>
  </properties>
</profile>

<roleManager enabled="true" defaultProvider="YafRoleProvider">
  <providers>
    <clear/>
    <add name="YafRoleProvider"
         type="System.Web.Security.SqlRoleProvider"
         connectionStringName="AaspDatabase" 
         applicationName="AaspApplication" />
  </providers>
</roleManager>

Hope this helps!

 

www.bunkerhollow.com  | www.careercomputing.com 

When I post fp:mddubs in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Mek 🙂, who stole this off Ederon 🙂 )

Thx!!!

http://bunkerhollow.com/blogs/matt/archive/2008/10/27/integrate-yetanotherforum-with-your-net-site-from-source.aspx 

Good luck!

 

www.bunkerhollow.com  | www.careercomputing.com 

When I post fp:mddubs in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Mek 🙂, who stole this off Ederon 🙂 )

Thanks for taking the time to respond today! I've read your blog previously and it did help greatly. I'm thinking I have some sort of connection string issue as it can't build the tables without erroring out. I'm keeping the strings in the config file.

I would love to see your example of:

Somewhere in my config I specified that YAF will find the ASP.NET membership tables in my existing database, but it should use this new database for all of it's stuff. I would recommend you do the same.

I need to go on the roof to check the chimney. Will check back later.

Thanks!!!!!!!!!!

I did have it in there on previous attempts but after I fixed the other problems, I guess I forgot to put it back in. I did come to this conclusion by re reading your blogs and comparing the recommended config file vs my own. There still are major issues I'm sure but at least I'm on the right path.

Thank you Mddubs for being my coach today! Kudos! Stay warm in Ill, I'm sure it's cold.

Chris

Thx!