This project is read-only.

Problem installing Slick Ticket

Mar 19, 2010 at 3:59 PM
Edited Mar 19, 2010 at 4:01 PM
I'm getting this error just trying to open the initial website (before I even get a chance to click Start Setup). I've created the Database on a SQL2005 (64bit) server and created the user (modified the connection string as well) and even logged into the database using Management Studio to verify I could access it. No go. Server Error in '/' Application. -------------------------------------------------------------------------------- Invalid object name 'dbo.users'. 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.users'. Source Error: Line 14: public static bool Exists(dbDataContext db, string _user) Line 15: { Line 16: bool exists = (from p in db.users where p.userName.Equals(_user) select p).Count() > 0; Line 17: HttpContext.Current.Session["isUser"] = exists.ToString(); Line 18: if (!exists) Source File: c:\inetpub\wwwroot\App_Code\Users.cs Line: 16 Stack Trace: [SqlException (0x80131904): Invalid object name 'dbo.users'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1951450 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849003 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33 System.Data.SqlClient.SqlDataReader.get_MetaData() +83 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954 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.ExecuteReader() +12 System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +332 System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +113 System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +344 System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +23 System.Linq.Queryable.Count(IQueryable`1 source) +240 Users.Exists(dbDataContext db, String _user) in c:\inetpub\wwwroot\App_Code\Users.cs:16 MasterPage.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\MasterPage.master.cs:34 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) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927
Mar 25, 2010 at 5:28 AM
Did you run the setup? Looks as if the DB hasn't even been populated yet.
Mar 26, 2010 at 3:43 AM

I never get to the setup.  I get that error  before anything even happens...

Mar 26, 2010 at 2:44 PM

Have you tried going directly to the Setup URL?

for example:

http://SlickTicketServer/SlickTicketVirtualDirectory/Setup

Apr 18, 2011 at 12:11 PM

Documentation should be updated, it says "Navigate to your webstie, you will automatically be redirected to root/setup". Doing so it will give the same error of Overseer, going directly yo the setup URL will solve the problem.

Apr 18, 2011 at 6:01 PM

You are correct - it is updated - also keep in mind that it is a Wiki and you can update when there are errors.