lekha126 / stacked

Automatically exported from code.google.com/p/stacked
0 stars 0 forks source link

It won't automatically build the database schema. #8

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Expand Stacked Binaries, and create IIS Application
2. Configure MySQL host, user, & pswd
3. Open Virtual Directory in Browser

What is the expected output? What do you see instead?

*. The stacked 'home' page.  An error page (see below for error contents)

What version of the product are you using? On what operating system?

*.  Binaries version 0.6, on Windows 7 Ultimate, with IIS 7

__________________________________________________________________
Error Contents:
__________________________________________________________________

Server Error in '/Stacked' Application.

Table 'stacked.quizitems' doesn't exist

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: MySql.Data.MySqlClient.MySqlException: Table 
'stacked.quizitems' doesn't exist

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: 

[MySqlException (0x80004005): Table 'stacked.quizitems' doesn't exist]
   MySql.Data.MySqlClient.MySqlStream.OpenPacket() +280
   MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +59
   MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +62
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1161
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1582
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +9
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +21
   NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +54
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +430
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +217
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +84
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +80

[ADOException: could not execute query
[ select this_.* from QuizItems this_
where this_.FK_Parent is null 
order by (select max(Created) from QuizItems q2 
    where this_.ID = q2.ID or q2.FK_Parent = this_.ID 
    ) desc
 ]
[SQL: select this_.* from QuizItems this_
where this_.FK_Parent is null 
order by (select max(Created) from QuizItems q2 
    where this_.ID = q2.ID or q2.FK_Parent = this_.ID 
    ) desc
]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +287
   NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +128
   NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +145
   NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +60
   NHibernate.Impl.SqlQueryImpl.List() +206
   Castle.ActiveRecord.ActiveRecordBaseQuery.InternalExecute(ISession session) +34
   Castle.ActiveRecord.Queries.SimpleQuery`1.InternalExecute(ISession session) +17
   Castle.ActiveRecord.ActiveRecordBase.ExecuteQuery(IActiveRecordQuery query) +132

[ActiveRecordException: Could not perform ExecuteQuery for QuizItem]
   Castle.ActiveRecord.ActiveRecordBase.ExecuteQuery(IActiveRecordQuery query) +358
   Castle.ActiveRecord.ActiveRecordBase`1.ExecuteQuery2(IActiveRecordQuery`1 query) +16
   Castle.ActiveRecord.Queries.SimpleQuery`1.Execute() +75
   Entities.QuizItem.GetQuestions(OrderBy order) +178
   _Default.DataBindGrid() +295
   _Default.Page_Load(Object sender, EventArgs e) +407
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

Version Information: Microsoft .NET Framework Version:2.0.50727.5448; ASP.NET 
Version:2.0.50727.5456

Original issue reported on code.google.com by Practica...@gmail.com on 10 May 2012 at 12:14