Exception when deleting content

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.
4/10/2007 12:37:07 PM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Exception when deleting content

pgsql version from /branches/joesandbox2

1. Go to /Admin/ContentManager.aspx (for any existing content module, as I can see.
2. Click "delete" button on the bottom - content is deleted from all the pages, and then an exception is thrown:

Npgsql.NpgsqlException: ERROR: 42P01: relation "mp_pagesmodules" does not exist
4/10/2007 7:59:20 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Exception when deleting content

I will look into this soon and post again.

Thanks,

Joe
4/11/2007 4:27:39 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Exception when deleting content

This should be fixed if you get the latest stored procedure script for pgsql from svn and run it.

Thanks,

Joe
4/12/2007 5:54:10 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Re: Exception when deleting content

That fixed the error. I succeded to delete some content.

But when trying to delete "Unpublished Article" content (created by setup) I get another unhandled exception:

Npgsql.NpgsqlException: ERROR: 23503: update or delete on "mp_modules" violates foreign key constraint "fk_htmltext_modules_fk" on "mp_htmlcontent"


Also, when I try to delete any non-empty "Links" content (with 1 or more links inside) I recieve another unhandled exception:

Npgsql.NpgsqlException: ERROR: 23503: update or delete on "mp_modules" violates foreign key constraint "fk_links_modules_fk" on "mp_links"
4/12/2007 10:23:35 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Exception when deleting content

This should be fixed in the latest svn.

Thanks,

Joe
4/13/2007 6:44:08 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Re: Exception when deleting content

It works now. Thanks.
5/4/2007 7:59:26 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Re: Exception when deleting content

PgSQL version.

When I try to delete old "admin" feature modules, I get an unhandled exception:

Npgsql.NpgsqlException: ERROR: 23503: update or delete on "mp_moduledefinitions" violates foreign key constraint "fk_modules_moduledefinitions_fk" on "mp_modules"

I suppose the content modules from the deleted pages are still in the database, but they are not showed in the content manager, so I cannot find and delete them.

Anyway, it would be nice to add some error message for this case (feature module still has some content).

5/4/2007 12:22:42 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Exception when deleting content

This should now show the error. Part of the problem was that NpgSqlException was inheriting from System.ApplicationException when it should inherit from System.Common.DBException. Now that it has the correct base class the message is shown as with MS SQL.

To remove the Admin Modules you may need to uncheck the "Exclude From Feature List" then save, then you can delete the module instance from Content Manager and then finally delete the module.

Thanks,

Joe

5/7/2007 12:15:45 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Re: Exception when deleting content

That helped, thanks.

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