I'm trying to get the Extended Club Site running. I'm not using SQL Express, I'm using SQL Server 2005. I ran club-add.sql which I thought would create all the tables I needed. However I get the following errors:
Invalid object name 'SiteSettings'
Invalid object name 'SiteThemes'
I assume these are tables. I did a search for SiteSettings and SiteThemes in club-add.sql but couldn't find either. Is there another script file that I need to run. (I ran aspnet_regsql.exe to set up the Membership tables, which seemed to all work fine).
Looks like I finally got it figured out. I ended up attaching the SQL Express mdf to SQL Server on my machine. The missing tables are in there. The hosting company I use uses SQL Server 2000 so I couldn't just copy the club database from my machine to my database
at my hosting company (it kept telling me that both databases had to be SQL Server 2005). After that there's just a few entries that need to be made in the SiteSettings and SiteThemes tables. Anyway, I saved all the scripts to create the club database tables
so let me know if you need them and I can email them to you or something.
Marked as answer by hughy on Jan 14, 2007 06:04 AM
Hi, me too having the same error Invalid object name 'SiteSettings'", Please mail me the code for sql tables . And my email is
murulimadhav@gmail.com. thanks a lot
hughy
Member
18 Points
22 Posts
Invalid object name 'SiteSettings'
Dec 29, 2006 04:07 AM|LINK
I'm trying to get the Extended Club Site running. I'm not using SQL Express, I'm using SQL Server 2005. I ran club-add.sql which I thought would create all the tables I needed. However I get the following errors:
I assume these are tables. I did a search for SiteSettings and SiteThemes in club-add.sql but couldn't find either. Is there another script file that I need to run. (I ran aspnet_regsql.exe to set up the Membership tables, which seemed to all work fine).
tygarrett
Member
2 Points
1 Post
Re: Invalid object name 'SiteSettings'
Jan 01, 2007 07:58 PM|LINK
hughy
Member
18 Points
22 Posts
Re: Invalid object name 'SiteSettings'
Jan 14, 2007 06:03 AM|LINK
cali10b
Member
2 Points
1 Post
Re: Invalid object name 'SiteSettings'
Sep 20, 2007 10:58 PM|LINK
Hello,
I need a lot that scripts, please !!!.
my mail is: cali10b@yahoo.com.mx
Thank you very much !!!
charismata
Member
2 Points
1 Post
Re: Invalid object name 'SiteSettings'
Sep 24, 2007 02:47 AM|LINK
Hello
I need also that scripts,
could you please send the scripts!
My e-mail : chrismatakim@hotmail.com
Thanks
sdlust
Member
2 Points
1 Post
Re: Invalid object name 'SiteSettings'
Jan 07, 2008 04:44 PM|LINK
If you still have those scripts, I would like to get my hands on them too!
Thanks,
unnaturalinamorato@gmail.com
rkaiser58
Member
6 Points
6 Posts
Re: Invalid object name 'SiteSettings'
Feb 01, 2008 12:43 AM|LINK
Please send me the scripts as well: rkaiser@patmedia.net
Stoater
Member
151 Points
42 Posts
Re: Invalid object name 'SiteSettings'
Feb 05, 2008 08:57 PM|LINK
Could you please give me a copy of the scripts, much appreciated.
Stoater
thewateroflife@hotmail.com
khaos
Contributor
2855 Points
690 Posts
Re: Invalid object name 'SiteSettings'
Mar 05, 2008 10:10 PM|LINK
Well as of today 3/5/08 I attached the club.mdf and they are NOT in there anymore. Could someone post the script for these two tables?
If a picture is worth a 1000 words, a sample application is worth a 1000 blog entries
Remember the Constitution!
Dont forget to mark posts answered and resolved (if they are)
murulimadhav
Member
4 Points
2 Posts
Re: Invalid object name 'SiteSettings'
Jul 05, 2008 11:09 AM|LINK
Hi, me too having the same error Invalid object name 'SiteSettings'", Please mail me the code for sql tables . And my email is murulimadhav@gmail.com. thanks a lot