Can not add a new site.

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.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
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.
This thread is closed to new posts. You must sign in to post in the forums.
7/2/2005 6:40:35 PM
Gravatar
Total Posts 15

Re: Can not add a new site.

On Fedora Core 3 Mono 1.1.7-1 I get this error when I try and ad a new site I get an error message like this.

Any Ideas?

Description: Error processing request.

Error Message: HTTP 500.

Stack Trace:

Npgsql.NpgsqlException:
null value in column "displayname" violates not-null constraint
Severity: ERROR
Code: 23502
in <0x00056> Npgsql.NpgsqlConnector:CheckErrors ()
in <0x0001c> Npgsql.NpgsqlConnector:CheckErrorsAndNotifications ()
in <0x0005e> Npgsql.NpgsqlCommand:ExecuteCommand ()
in <0x00049> Npgsql.NpgsqlCommand:ExecuteScalar ()
in (wrapper remoting-invoke-with-check) Npgsql.NpgsqlCommand:ExecuteScalar ()
in <0x0005c> mojoPortal.Data.NpgsqlHelper:ExecuteScalar (Npgsql.NpgsqlConnection connection, CommandType commandType, System.String commandText, Npgsql.NpgsqlParameter[] commandParameters)
in <0x00220> mojoPortal.Data.dbPortal:Role_Create (Int32 SiteID, System.String RoleName)

 

 

7/3/2005 3:03:15 AM
Gravatar
Total Posts 18444

Re: Can not add a new site.

If you are using the latest release of mojoportal, download it again and run the script to create the stored procedures. I have updated it to correct the problem.

Joe
7/3/2005 3:50:26 AM
Gravatar
Total Posts 18444

Re: Can not add a new site.

Hmm, I just got a similar error using my demo site. I'll have to look further into this. Apparently my update to the stored procedures did not fix the problem.
7/3/2005 4:30:29 PM
Gravatar
Total Posts 18444

Re: Can not add a new site.

I will look into this more tomorrow. I had family in for the weekend and didn't get a chance today.
7/3/2005 5:06:39 PM
Gravatar
Total Posts 15

Re: Can not add a new site.

No problem I actually got the site running by tinkering in the database.

I am also having some problems with the photo gallery's I'll post once I have all the details

Thanks for the help

7/4/2005 10:35:21 AM
Gravatar
Total Posts 18444

Re: Can not add a new site.

I have corrected the stored procedure script and created a new download for postgresql on the download page.
Anyone experiencing this problem, please re-download and re-run the script to create the stored procedures.

I sent the script to Philip and he tested it before I updated the download.

Thanks Philip!

Also, I am making good progress on the new Search feature and should have another release within 2 weeks.

Joe
You must sign in to post in the forums. This thread is closed to new posts.