Club Web Site Starter Kit

can't edit events and news pages

luigit — Tue, 17 Nov 2009 13:15:54 GMT

Hi, I'm new to this forum,

I'm testing club website on my pc, I can create photo albums as administrator but when I try to write news or events and save it the website doesn't save it...why?

Thanks

I use C#

Deleting a Photo Album

glura — Tue, 04 Jul 2006 16:11:17 GMT

Does anyone have an example or tips for what needs to be done to delete a photo album?

I know I'll have to do something like: DELETE FROM Albums WHERE (albumid = @albumid)

But I also need to delete all images associated with that album.

I'm also not sure what to do after the delete completes? For example, what page should display?

any advice would be appreciated.

Thanks,

Gary

E-mail

lhr — Fri, 20 Nov 2009 23:28:22 GMT

I am using club starter kit 2.0 final

and when I use send e-mail to just Editors it send it.

-----------------------------------------------------------------------------------------------------------------------------

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.IndexOutOfRangeException: There is no row at position 0.

Source Error:

Line 418: Return CType(Me.Rows(index),MemberInfoRow)

Line 419: End Get

Line 420: End Property

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

What does this mean?

How can I fix this?

LHR

Merge Databases

Sairento — Fri, 13 Nov 2009 20:35:16 GMT

For the Club Website Starter Kit, is it possible to merge the databases into one?

Due to the costs of my web host having 2 databases would be around £125+ per year which is an insane amount for such a small club.

however our budget would allow for one database, so i was wondering if it was possible to merge the 2 databases into one thus lowering the cost of running the site.

Edit: i have since seen about using a tool called aspnet_regsql.exe however i have tried this and it fails every time.

Recurring Calendar Events

alansmelin — Mon, 09 Nov 2009 21:18:28 GMT

Hi Guys,

Does anyone know whether it would be possible to create a calendar event and have them recurring - e.g. book a calendar event that can be recurring on a weekly basis?

Cheers

Alan

edit pages logged in as admin?

BoostedH23a1 — Wed, 28 Oct 2009 19:28:27 GMT

Hey guys be forwarned, i am a noob.

I am usings clubsite extended as my template for my webpage. i was wondering if i can create pages that i can edit the content/text just by logging into the site as ADMIN. that would be great for what i am trying to do. is that possible?

i have some existing webparts i was thinking it would be something like that but figured i would ask.

thanks in advance

lee

theme css?

Cboysworld — Thu, 05 Nov 2009 11:31:10 GMT

Is there something that I have to reset on the extended clubsite after I make a change? I am using the CodeCamp theme and I have changed some of the css but the changes are not updating.

Thanks,
Chad

css club starter kit

meminot — Thu, 18 Jun 2009 16:07:03 GMT

I am using the club starter kit. I am having problems with the CSS. I will change the background color, for example. It will change on the screen, but when I go to build it, it is still shows the old colors. I look in the actual CSS file and it is changed but it still builds without the changes. I do not understand what could be happening.

It is the first time that I used a starter kit, so when it happenned the first time, I thought it was something I was doing wrong. I had not gone very far so I strted over. It worked just fine on the new website for 10 changes or so, then quite making the changes. I started again with a fresh file. It work for awhile then quite working.

What am I doing wrong? Any ideas?

Getting Started - Help?

Cboysworld — Mon, 02 Nov 2009 03:08:27 GMT

I didnt even do anything yet and it already does not work. Any ideas how to get started? Thanks, Chad

Cannot create file 'C:\Documents and Settings\Chad\My Documents\My Web Site\ClubSite1\App_Data\Club_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.

Could not open new database 'ClubDB'. CREATE DATABASE is aborted.

Cannot attach the file 'C:\Documents and Settings\Chad\My Documents\My Web Site\ClubSite1\App_Data\Club.mdf' as database 'ClubDB'.

Line 2186:            this.Adapter.SelectCommand = this.CommandCollection[0];
Line 2187:            DataSet.SiteSettingsDataTable dataTable = new DataSet.SiteSettingsDataTable();
Line 2188:            this.Adapter.Fill(dataTable);
Line 2189:            return dataTable;
Line 2190:        }
File activation failure. The physical file name "C:\work\ClubSite\App_Data\Club_log.LDF" may be incorrect.

Does club-add.sql set up both databases?

redwoodbev — Fri, 22 May 2009 17:59:45 GMT

Hi, I'm trying to set up the clubsite on godaddy and following the excellent GoDaddy Installation Walkthrough on this forum. I'm confused about the databases. In my clubsite there are two databases under App_Data. One is ASPNETDB.mdf and one is Club.mdf. There is one club-add.sql file.

As I understand the instructions...I should create my databases in GoDaddy, then copy the club-add.sql and paste the text in the Query Analyzer and submit. This will create the tables, etc. for the database.

Do I do this just once into one database, or once into each database, or is there another file I should be copying and pasting for the second database? Also, must I do this first, before uploading my site to the host? Thanks.

what is up with my webpage?

BoostedH23a1 — Mon, 19 Oct 2009 03:26:14 GMT

www.frogmoreaeroclub.com

Error with Clubsite ASP admin tool

alansmelin — Wed, 21 Oct 2009 22:24:34 GMT

Hi guys,

I have published my clubsite to IIS and everything works a treat - users can register and everything else.

The problem happens when I enter into the asp.net website admin tool to add them to the administrators role.

When I access the security section, I get this error:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

So I go into the provider section and select "Single provider for all site management data" and click test - all appears to be ok. But when I go back to the security tab, I get the same message!

Is there anyway to fix this?

Also - is there a way to have any new user automatically become part of the administrators group?

Thanks in advance!

Identified bugs and fixes for the ClubSite Starter kit

BugSlayer — Wed, 08 Mar 2006 15:02:10 GMT

I thought it would be kinda cool, if we had a separate thread for user-identified bugs and fixes.

It'll allow everybody to stay on the same page, and current without having to 're-invent the wheel'-per-newbie.

Also bug-fixers can have a common area to analyse, compare, comment-on and discuss posted fixes, for a given bug... so that the best fix gets implemented by readers.

Please try to post all future Bug Reports and fixes on this thread.

If U have bookmarks of earlier bug-reports and fixes for the ClubSite Starter kit, kindly post the relevant links here (without reproducing the entire text)

Thanks you.

P.S. If any of U feel this thread wasn't necessary, pls. voice your concerns and offer alternate advice.

How to create another admin once site is online

redwoodbev — Tue, 20 Oct 2009 00:13:04 GMT

Hi, My clubsite is online and working and I have the need to assign admin privledges to another member. Is there a way to do this? I tried accessing the site through VS express 2008 and the website menu doesn't have the asp.net configuration option mentioned in the "welcome.htm". I tried going right into the data base on my server, but the darn thing is in code and I can't tell how to change a user from member to admin. I'd appreciate any suggetions if someone has done this already. Thanks.

ImageFetch.ashx?Size=2&ImageID=11

Sal — Tue, 22 Sep 2009 20:49:41 GMT

My Event Viewer keeps logging a NullReferenceException every so many minutes and the offending line is "ImageFetch.ashx?Size=2&ImageID=11". I looked at the code all day long up and down and cant seem to find anything that I know of. Anybody have any suggestions?

DB error: Invalid object name 'dbo.Events'

ferdz — Mon, 09 May 2005 21:07:24 GMT

Hi,
I am getting the error posted down below. I used the script ClubAdd.exe from MSDN to add the club tables to my SQL2000 database. I noticed in the error it is looking for dbo.Events and dbo.Locations. These tables exists in my database. However, the tables the owner is not dbo but instead my database login name. Is that the reason for the error? I don't think that that matters, but any way I would appreciate your input to this.

Thanks

Server Error in '/' Application.

Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.

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: Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.

Source Error:

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

Stack Trace:

[SqlException (0x80131904): Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +785922
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684534
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, 

        BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1751
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +37
   System.Data.SqlClient.SqlDataReader.get_MetaData() +58
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +213
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
              Boolean async) +570
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
              String method, DbAsyncResult result) +134
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
               String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, 
         IDbCommand command, CommandBehavior behavior) +141
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
         CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1837
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +129
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +41
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787

Testing for Club Starter kit on local machine

jeaninel — Tue, 22 Sep 2009 23:22:42 GMT

In the months I have been modifying the original starter kit I believe I ran across a simple way to be able to test my site locally without changing a whole ton of code related to my online server account. Of course, I can't find that now in the postings. Anyone recall what the posting was?

Application Trying To Connect To ASPNETDB - but not using it

dkilby17 — Mon, 14 Sep 2009 15:15:40 GMT

I am using the club website, and change all database connections, including the memebership, profile, and roles to a local SQL Express 2005 db, but when i run the application some pages still try and access the ASPNETDB, i can not find any references the database, i am running the application on localhost - i tried deleting the database, but then when i try and run the application, i get errors as it tries to run a script to create the database. how can i fix this, i dont want to use ASPNETDB

How to Guide for deploying club starter kit to go daddy

rkaiser58 — Thu, 31 Jan 2008 21:26:53 GMT

Hello all,

I have found a great deal of information on here about how to get the club starter kit running on a go daddy hosting account. I think I hit just about every snag listed here.

Connection String Issue, Unknown server tag 'Club:RolloverButton'. to name a few. All of the information was great, and I really thought I was going to resolve the issues...but I am at a loss.

I have followed all deployment steps, and setup everything at go daddy. I am still getting the 'Club:' error.

Check it out

Any suggestions?

I set namespace='ClubSite' on all the pages.

Add Admin page to club kit 1

jeaninel — Tue, 25 Aug 2009 22:41:34 GMT

I have created my site and it's working well using the first starter kit. Now I am looking to add on items that are in the 3rd kit such as the Admin page so I can control users online instead of through my server. Someone (sorry, forgot who) was kind enough to post files for adding the forums page and that worked great. I am hoping someone may have done the same for the admin page, poll and possibly the files page. I'd also like to add video if I can.

Event Database appears to be corrupted How to recreate

flybob — Fri, 11 Apr 2008 16:36:47 GMT

I had an error generated when I added a location to an event. After this I can no longer add new events or edit the events in the database. How can a reset the events database and start over. It was working before this error.

Event Calendar Error on GoDaddy

dude9er — Fri, 22 May 2009 05:43:55 GMT

I am getting this error when I try to add an event. Can someone tell me what it means and how to fix it. I am using CSK 2.0 VB.

Thanks!!

Security Exception body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

Line 49:         End If
Line 50:         
Line 51:         ClubStarterKit.Data.ClubEvent.Insert(dtpicker.startDateTime, dtpicker.endDateTime, titleTextBox.Text.ToString(), description, pictureid, 0, 0, LocationNameTXT.Text, locdirections)
Line 52:         Response.Redirect("list.aspx")
Line 53:     End Sub

Source File: d:\hosting\nhsportsman\events\Add.aspx Line: 51

Stack Trace:

[SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
   SubSonic.Utilities.Utility.WriteTrace(String message) in Utility.cs:37
   SubSonic.AbstractRecord`1.ValidateColumnSettings() in AbstractRecord.cs:899
   SubSonic.ActiveRecord`1.Validate() in ActiveRecord.cs:354
   SubSonic.ActiveRecord`1.Save(String userName) in ActiveRecord.cs:366
   ClubStarterKit.Data.ClubEvent.Insert(DateTime varStarttime, Nullable`1 varEndtime, String varTitle, String varDescription, Int32 varPhoto, Nullable`1 varAlbum, Nullable`1 varCurrentAttendance, String varLocationName, String varLocationDirections) in ClubEvent.vb:435
   ASP.events_add_aspx.apply1_Click(Object sender, EventArgs e) in d:\hosting\nhsportsman\events\Add.aspx:51
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6785
   System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +242
   System.Web.UI.Page.ProcessRequest() +80
   System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
   System.Web.UI.Page.ProcessRequest(HttpContext context) +49
   ASP.events_add_aspx.ProcessRequest(HttpContext context) +37
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

The site is ready to run!

stedyer — Wed, 15 Apr 2009 14:15:27 GMT

I have downloaded the Club Site Starter Kit, and then created a new web site project from this template.

When I open the solution I get a nice welcome page that tells me "This site is ready to run! No changes are needed. Press CTRL+F5 to run this site"

When I do this though I get this error, can anyone help??

Server Error in '/ClubWebSite2' Application.

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

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.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.

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): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +4859187
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4861516
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +82

[HttpException (0x80004005): Unable to connect to SQL Server database.]
   System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +137
   System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +94
   System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +25
   System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +395

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

Event Calendar download

iamsaltman — Thu, 07 May 2009 02:27:41 GMT

I downloaded the original Club Starter kit and most everything is working fine, thanks in large part to this forum. Thank you.

However, I also downloaded the Event Calendar Control that is on the same page as the Club Starter kit and was wondering what that gives me or if there is anything I need to do to take advantage of this download.

Thank you for the help.

Adimin Password not working

ddtharangasri — Fri, 08 May 2009 12:35:49 GMT

admin password not working User name = admin Password = admin123!

Club Web Site Starter Kit

can't edit events and news pages

Deleting a Photo Album

E-mail

Merge Databases

Recurring Calendar Events

edit pages logged in as admin?

theme css?

css club starter kit

Getting Started - Help?

Does club-add.sql set up both databases?

what is up with my webpage?

Error with Clubsite ASP admin tool

Identified bugs and fixes for the ClubSite Starter kit

How to create another admin once site is online

ImageFetch.ashx?Size=2&ImageID=11

DB error: Invalid object name 'dbo.Events'

Server Error in '/' Application.

Invalid object name 'dbo.Events'.Invalid object name 'dbo.Locations'.

Testing for Club Starter kit on local machine

Application Trying To Connect To ASPNETDB - but not using it

How to Guide for deploying club starter kit to go daddy

Add Admin page to club kit 1

Event Database appears to be corrupted How to recreate

Event Calendar Error on GoDaddy

Security Exception

The site is ready to run!

Server Error in '/ClubWebSite2' Application.

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

Event Calendar download

Adimin Password not working

Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.