Hi,

I have just installed mojoportal in my server, my configuration is as follows:

Window Server 2003

IIS + .Net 3.5 sp1

Postgres 8.3.5

MojoPortal 2.3.3.4

I have manage to install and test a few functions of mojoportal, but I've encounter the following error when I try to add a new feature following the tutorial on http://www.mojoportal.com/hello-world-developer-quick-start.aspx. I think its the SQL string causing the error.

ERROR: 42601: syntax error at or near ":"

Exception Details: Npgsql.NpgsqlException: ERROR: 42601: syntax error at or near ":"

Is it a bug or do I need to do something to my database? Also, when I try to debug in Visual Studio 8 Express, the IDE give me the following bug:

Error 46 Could not load type 'mojoPortal.Web.ContactUI.MessageListPage'. F:\Inetpub\wwwroot\mojo\ContactForm\MessageList.aspx 1
 

Once I exclude the file MessageList.aspx, the debugging is able to continue. Is this a missing file?

Thanks in advance.

Regards,

Stephen

Thanks Joe,

Appreciate for the speedy reply. However, back to my original question, any reason why I'm having the ERROR: 42601: syntax error at or near ":" when adding the sample feature? Do I need to upgrade to Postgres 8.4?

Best regards,

Stephen

Sure Joe, appreciate your effort in helping me out. The details are as follows:

2010-02-03 00:27:30,250 ERROR mojoPortal.Web.Global - 60.50.180.102-en-US - /Admin/ModuleDefinitions.aspx?defid=-1
Npgsql.NpgsqlException:
syntax error at or near ":"
Severity: ERROR
Code: 42601
at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
at Npgsql.ForwardsOnlyDataReader.NextResult()
at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteNonQuery()
at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlConnection connection, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters)
at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters)
at mojoPortal.Data.DBModuleDefinition.AddModuleDefinition(Guid featureGuid, Int32 siteId, String featureName, String controlSrc, Int32 sortOrder, Int32 defaultCacheTime, String icon, Boolean isAdmin, String resourceFile, Boolean isCacheable, Boolean isSearchable, String searchListName, Boolean supportsPageReuse, String deleteProvider)
at mojoPortal.Business.ModuleDefinition.Create()
at mojoPortal.Business.ModuleDefinition.Save()
at mojoPortal.Web.AdminUI.ModuleDefinitions.UpdateBtn_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Thanks in advance.

Regards,

Stephen 

Your the MAN Joe! Thanks a lot, can't wait to download the new code.