chrisgr
  • Posts: 29
  • Joined: 24/01/2009
I am so close, however now I am getting this message during the install. Does anyone know where to go? I've tried multiple items to no avail. This is a virgin install into a working app under a sub directory YAF. I get this error after entering the config password (and originaly after the password creation). I'm working on a local machine.
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
chrisgr
  • Posts: 29
  • Joined: 24/01/2009
:oops: Shameless bump to top......
mddubs
  • Posts: 476
  • Joined: 07/08/2008
You don't need to implement a custom profile provider to use YAF, and it's much easier if you don't. I integrated YAF 1.9.3 with my existing application that used the .NET Membership defaults. I basically just changed my membership, profile, and role manager key names to the ones that YAF is looking for:

<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!
UserPostedImage 
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 🙂 )
chrisgr
  • Posts: 29
  • Joined: 24/01/2009
Thanks 'MD' but I'm not at that point yet. Originally I thought the profile/provider section of the web.config was keeping my app from compiling. However I've fixed that and it compiles (don't know about the membership part yet). But now when I run the YAF\Install\default.aspx, I can't get past the password section of the install. It accepts the password I created but can't build the tables in my new DB. I'm going to walk away for a few and maybe the gremlins will leave :lol:
Thx!!!
mddubs
  • Posts: 476
  • Joined: 07/08/2008
Getting it up and running the first time can be a little tricky. Try comparing your process with my notes...

http://bunkerhollow.com/...et-site-from-source.aspx 

Good luck!
UserPostedImage 
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 🙂 )
chrisgr
  • Posts: 29
  • Joined: 24/01/2009

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!!!!!!!!!!
chrisgr
  • Posts: 29
  • Joined: 24/01/2009
Well.... I found out why it didn't populate the tables. I was missing the tag in the web.config file of
<appSettings configSource="app.config"/>
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
mddubs
  • Posts: 476
  • Joined: 07/08/2008
In the membership keys above you'll see they point to my existing database, then the YAFNET config key points to the YAF database I created.

<add name="AaspDatabase" connectionString="Data Source=localhost;Initial Catalog=Aasp;User ID=xxx;Password=xxx;" />
    <add name="yafnet" connectionString="Data Source=localhost;Initial Catalog=AaspYaf;User ID=xxx;Password=xxx;" />

UserPostedImage 
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 🙂 )
chrisgr
  • Posts: 29
  • Joined: 24/01/2009
SWEET! Again, thank you! I'm all up and running now and it looks very interesting. I've been using the BIN files and just starting to jump into the SRC files to do some altering. Although I'm more of a VB guy, the curve could be interesting to say the least. YAF has more than I need but a great start! Again, hats off to all you code people! Now if I can find those CS files I need........

Thx!
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved