emaratilicious / stacked Goto Github PK

What is the expected output? What do you see instead?
When I use debugging mode, there is an error for ra ajax and when I use IIS, I 
got an error... see attach image.

What version of the product are you using? On what operating system?
- Stacked Source 0.6, on windows XP

What steps will reproduce the problem?
1. svn checkout
2. create web.config , configure to use mssql 2005. i.e:

  <activerecord isWeb="true">
    <config>
      <add key="hibernate.connection.driver_class" 
value="NHibernate.Driver.SqlClientDriver"/>
      <add key="hibernate.dialect" 
value="NHibernate.Dialect.MsSql2005Dialect"/>
      <add key="hibernate.connection.provider" 
value="NHibernate.Connection.DriverConnectionProvider"/>
      <add key="hibernate.connection.connection_string" value="Data 
Source=BARTEK-2K3;Initial Catalog=Stacked;Integrated Security=True"/>
    </config>
  </activerecord>

3. Start

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

Expected clean homepage. 

Got exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM 
and 12/31/9999 11:59:59 PM.
Line 35:             oper.FriendlyName = "default";
Line 36:             oper.IsAdmin = true;
Line 37:             oper.Create();
Line 38:         }
Line 39:     }
Source File: c:\prj\!ro\stacked-read-only\WebSite\Global.asax    Line: 37 

After fixing this exception by using Nullable<DateTime> got another 
exception:

Incorrect syntax near 'limit'.
Incorrect syntax near the keyword 'order'.
Line 316:                        return retVal.Execute();
Source File: c:\prj\!ro\stacked-read-only\WebSite\App_Code\QuizItem.cs    



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

svn rev 74, MSSQL 2005

Please provide any additional information below.

1. http://rkse.blogspot.com/2007/06/when-it-comes-to-nhibernate-dates-
are.html

2. LIMIT is not supported on MSSQL, lets use MAX

What steps will reproduce the problem?
1. Any link that activates URL rewrite, ie .user and .quiz pages
2. Gives 404 Page not found error
3.

What is the expected output? What do you see instead?
It is supposed to rewrite to the correct page. for example ~/a.quiz should 
go to item.aspx?id=a but it is not.

What version of the product are you using? On what operating system?
latest revision with SQL DB patch provided from other issue

Please provide any additional information below.

Where i can find the database?, i checked out the code but didn't find the
database

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

What steps will reproduce the problem?
1. Create fresh installation on mySql5
2. Open page in IE, dismiss the "you fail for using IE" box
3. Press login, but then try to "close" or "move" the box

What is the expected output? What do you see instead?
If i close it, it should close. It dosnt close at all in IE 8. 
If I try moving it, it dosnt work either.


What version of the product are you using? On what operating system?
IE 8 RC1 on Vista Sp1 (home edition)

Please provide any additional information below.

Please don't tell me to not use IE... Most of my visitors are gonna be 
using IE.

[deleted issue]

What steps will reproduce the problem?
1. Launched Stacked.sln
2. Clicked Build -> Rebuild Website

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

Received 153 errors on Error List. The first two as follows. There rest are 
similar.

Error   1   Unknown server tag 'ra:Window'. D:\Documents and 
Settings\Faido\Desktop\Stacked-Source\Stacked\WebSite\UserControls\AskQuestion.a
scx 7   
Error   2   Unknown server tag 'ra:Timer'.  D:\Documents and 
Settings\Faido\Desktop\Stacked-Source\Stacked\WebSite\UserControls\AskQuestion.a
scx 14  

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

Microsoft Visual Studio 2008
Vesrion 9.0.30729.1 SP


Please provide any additional information below.