This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
Error while installing MojoPortal with Postgresql 8.4.2 on Windows XP.
I used the: mojoportal-2-3-3-2-pgsql-deploymentfiles.zip
Probing system... File system permissions ok. pgsql database connection ok. database permissions are sufficient to alter schema. database initial schema needs to be created. Running script mojoportal-core - 2.2.7.8 - 00:00:01.2812500 Running script mojoportal-core - 2.2.7.9 - 00:00:06.6250000 Running script mojoportal-core - 2.2.8.0 - 00:00:06.8593750 Running script mojoportal-core - 2.2.8.1 - 00:00:07.0156250 Running script mojoportal-core - 2.2.8.2 - 00:00:07.1718750 Running script mojoportal-core - 2.2.8.3 - 00:00:07.3125000 Running script mojoportal-core - 2.2.8.4 - 00:00:07.5937500 Running script mojoportal-core - 2.2.8.5 - 00:00:07.9375000 Running script mojoportal-core - 2.2.8.6 - 00:00:08.1562500 Running script mojoportal-core - 2.2.8.7 - 00:00:08.3593750 Running script mojoportal-core - 2.2.8.8 - 00:00:08.6250000 Running script mojoportal-core - 2.2.8.9 - 00:00:08.8437500 Running script mojoportal-core - 2.2.9.0 - 00:00:09.0312500 Running script mojoportal-core - 2.2.9.1 - 00:00:09.5625000 Running script mojoportal-core - 2.2.9.2 - 00:00:09.7031250 Running script mojoportal-core - 2.2.9.3 - 00:00:10.3750000 Running script mojoportal-core - 2.2.9.4 - 00:00:10.5156250 Running script mojoportal-core - 2.2.9.5 - 00:00:10.9375000 Running script mojoportal-core - 2.2.9.6 - 00:00:11.4375000 Running script mojoportal-core - 2.2.9.7 - 00:00:11.6406250 Running script mojoportal-core - 2.2.9.8 - 00:00:11.9218750 Running script mojoportal-core - 2.2.9.9 - 00:00:12.0781250 Running script mojoportal-core - 2.3.0.0 - 00:00:12.4375000 Running script mojoportal-core - 2.3.0.1 - 00:00:12.6406250 Running script mojoportal-core - 2.3.0.2 - 00:00:12.8281250 Running script mojoportal-core - 2.3.0.3 - 00:00:12.9843750 Running script mojoportal-core - 2.3.0.4 - 00:00:13.1875000 Running script mojoportal-core - 2.3.0.5 - 00:00:13.3750000 Running script mojoportal-core - 2.3.0.6 - 00:00:13.5781250 Running script mojoportal-core - 2.3.0.7 - 00:00:13.8750000 Running script mojoportal-core - 2.3.0.8 - 00:00:14.3750000 Running script mojoportal-core - 2.3.0.9 - 00:00:14.5625000 Running script mojoportal-core - 2.3.1.0 - 00:00:14.7656250 Running script mojoportal-core - 2.3.1.1 - 00:00:14.9218750 Running script mojoportal-core - 2.3.1.2 - 00:00:15.4687500 Running script mojoportal-core - 2.3.1.3 - 00:00:15.6093750 Running script mojoportal-core - 2.3.1.4 - 00:00:15.7656250 Running script mojoportal-core - 2.3.1.5 - 00:00:15.9218750 Running script mojoportal-core - 2.3.1.6 - 00:00:16.1093750 Running script mojoportal-core - 2.3.1.7 - 00:00:16.2656250 Running script mojoportal-core - 2.3.1.8 - 00:00:16.4687500 Running script mojoportal-core - 2.3.1.9 - 00:00:16.6250000 Running script mojoportal-core - 2.3.2.0 - 00:00:16.8437500 Running script mojoportal-core - 2.3.2.1 - 00:00:17.4062500 Running script mojoportal-core - 2.3.2.2 - 00:00:17.6093750 Running script mojoportal-core - 2.3.2.3 - 00:00:17.7968750 Running script mojoportal-core - 2.3.2.4 - 00:00:17.9843750 Running script mojoportal-core - 2.3.2.5 - 00:00:18.1406250 Running script mojoportal-core - 2.3.2.6 - 00:00:18.4375000 Running script mojoportal-core - 2.3.2.7 - 00:00:18.5781250 Running script mojoportal-core - 2.3.2.8 - 00:00:18.7343750 Running script mojoportal-core - 2.3.2.9 - 00:00:18.8906250 Running script mojoportal-core - 2.3.3.0 - 00:00:19.0312500 Running script mojoportal-core - 2.3.3.1 - 00:00:19.1875000 Running script mojoportal-core - 2.3.3.2 - 00:00:19.6562500 Creating site with default settings... - 00:00:20.0312500 Creating roles and admin user... - 00:00:27.1875000 An Error Occurred:ERROR: 42601: syntax error at or near ":" Source:Npgsql Stack Trace at Npgsql.NpgsqlState.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.DBSiteUser.UpdateUser(Int32 userId, String fullName, String loginName, String email, String password, String gender, Boolean profileApproved, Boolean approvedForForums, Boolean trusted, Boolean displayInMemberList, String webSiteUrl, String country, String state, String occupation, String interests, String msn, String yahoo, String aim, String icq, String avatarUrl, String signature, String skin, String loweredEmail, String passwordQuestion, String passwordAnswer, String comment, Int32 timeOffsetHours, String openIdUri, String windowsLiveId, Boolean mustChangePwd) at mojoPortal.Business.SiteUser.Update() at mojoPortal.Business.SiteUser.Create() at mojoPortal.Business.SiteUser.Save() at mojoPortal.Web.mojoSetup.CreateRequiredRolesAndAdminUser(SiteSettings site) at mojoPortal.Web.UI.Pages.SetupHome.CreateSiteAndAdminUser() at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Hi,
Sorry, it is a bug. I've put up a more recent build that has this fixed. If you go to our Novell Forge download page, and get the
mojoportal-pgsql-deploymentfiles-20100102.zip
it will work, and also has a nicer File Manager and a new SQL Query tool as discussed in this thread.
Best,
Joe
Hello, Joe
I was busy these days, but when I tried to install "mojoportal-pgsql-deploymentfiles-20100102.zip" I could not find it on the Novell Forge download?
Please advice.
Cheers,
Anton
My bad, I had put up an even newer build for MS SQL and meant to delete the older MS SQL one but apparently I deleted the pgsql one.
I've put it back up on the Novell Forge page.