Add announcement error in version 3.0

Last post 05-11-2006, 7:29 PM by Adam. 2 replies.
Sort Posts: Previous Next
  •  05-11-2006, 6:37 PM 19059

    Add announcement error in version 3.0

     
    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
  •  05-11-2006, 6:53 PM 19060 in reply to 19059

    Re: Add announcement error in version 3.0

    Thanks for pointing it out.
     
    We will fix it as soon as possible.
     
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  05-11-2006, 7:29 PM 19064 in reply to 19059

    Re: Add announcement error in version 3.0

    Danny,
     
    Please open \Engine\11.SqlScopeDAL\AnnouncementModerator.cs file.
     
    And find the following code:

    INSERT cp_Announcement (Title,Body,DateAdd) VALUES (@p0,@p1,@p2)
     
    Change it to:

    INSERT cp_Announcement (Title,Body,DateAdded) VALUES (@p0,@p1,@p2)
     
    Then recompile the project. That will resolve the problem.
     
    You can also download the software again.
     
     
     
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

View as RSS news feed in XML