I got the following error my version 3.0 of Chat and messenger (Cuteportal.zip). It appears that a call for the 'Dateadd' column doesn't exist on the Database that was created using the SQL script included with cuteportal.zip. There's a 'Dateadded' column in the table. I simply went around it by adding the 'dateadd' column. It doesn't write to that column and everything works. This happens when you "add announcement" where the error below is produced by 'addannouncements.aspx'. Are you guys gonna fix this?
Server Error in '/' Application.
Invalid column name 'DateAdd'.
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 column name 'DateAdd'.
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: Invalid column name 'DateAdd'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteScalar() +177
CutePortal.SqlScopeDAL.Data.DbScope.ExecuteScalar(String cmdtext, Object[] dbparams) in C:\Community Forum\CutePortal\Engine\11.SqlScopeDAL\Data\DataScope\DbScope.cs:344
CutePortal.SqlScopeDAL.Data.DbScope.ExecuteInt32(String cmdtext, Object[] dbparams) in C:\Community Forum\CutePortal\Engine\11.SqlScopeDAL\Data\DataScope\DbScope.cs:378
CutePortal.SqlScopeDAL.AnnouncementModerator.CreateAnnouncement(Announcement announcement) in C:\Community Forum\CutePortal\Engine\11.SqlScopeDAL\AnnouncementModerator.cs:21
CutePortal.Business.AnnouncementModerator.CreateAnnouncement(Announcement announcement) in C:\Community Forum\CutePortal\Engine\10.Business\PlacardManager.cs:13
CutePortal.Web.Admin.addannouncement.Button1_Click(Object sender, EventArgs e) in c:\community forum\cuteportal\web\admin\addannouncement.aspx.cs:53
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1273
|
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300