search

DNNCommunity / DNN.Forum

DNN.Forum
9 stars 7 forks source link

Problem with attachments #8

Closed trouble2 closed 7 years ago

trouble2 commented 7 years ago

Just tried to set up a forum module on dnn 8.0.3 When I try to add an attachment DNN errors:

he INSERT statement conflicted with the FOREIGN KEY constraint "FK_Forum_Attachment_Forum_Posts". The conflict occurred in database "dnn803", table "dbo.Forum_Posts", column 'PostID'. The statement has been terminated.

juvander commented 7 years ago

So it seems, will check this later on today.

trouble2 commented 7 years ago

Cool, thanks for you quick reply…. So, your not travelling through Mongolia at the moment so it seems…. I’ve talked to you a while back in Spain and France, at the DNN conference. Very funny to see you are managing the forum module now. You’re doing a great job!!!

Marnix Bouwman [cid:image006.png@01D0344A.F84A7D80]bond for web solutions

Van: Ilpo Juvander [mailto:notifications@github.com] Verzonden: Wednesday, March 1, 2017 5:22 PM Aan: juvander/DotNetNuke-Forum DotNetNuke-Forum@noreply.github.com CC: Marnix Bouwman marnixbouwman@bondforwebsolutions.nl; Author author@noreply.github.com Onderwerp: Re: [juvander/DotNetNuke-Forum] Problem with attachments (#8)

So it seems, will check this later on today.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/juvander/DotNetNuke-Forum/issues/8#issuecomment-283388750, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABvi5yxCEYT7RJC3A_DPd8uB8gCujaZ4ks5rhZsmgaJpZM4MP2pk.

juvander commented 7 years ago

Aa - I see you when looking closer 😀 No, I'm already back and next longer trip is to DNNConnect again.

Looks like this bug has been there from version 4.5... need to see how this could be fixed...

juvander commented 7 years ago

Ok, here's the fix: execute this in your database:

ALTER TABLE [dbo].[Forum_Attachments] NOCHECK CONSTRAINT [FK_Forum_Attachment_Forum_Posts]

So this just adds WITH NOCHECK to the key, there is no other simple way to fix this before next release :(

trouble2 commented 7 years ago

Wow, I wish everyone was that quick in fixing problems!!! Thanks a lot Ilpo. Perhaps I’ll see you again in Spain ☺

Marnix Bouwman [cid:image006.png@01D0344A.F84A7D80]bond for web solutions

Van: Ilpo Juvander [mailto:notifications@github.com] Verzonden: Wednesday, March 1, 2017 7:45 PM Aan: juvander/DotNetNuke-Forum DotNetNuke-Forum@noreply.github.com CC: Marnix Bouwman marnixbouwman@bondforwebsolutions.nl; Author author@noreply.github.com Onderwerp: Re: [juvander/DotNetNuke-Forum] Problem with attachments (#8)

Ok, here's the fix: execute this in your database:

ALTER TABLE [dbo].[Forum_Attachments] NOCHECK CONSTRAINT [FK_Forum_Attachment_Forum_Posts]

So this just adds WITH NOCHECK to the key, there is no other simple way to fix this before next release :(

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/juvander/DotNetNuke-Forum/issues/8#issuecomment-283430999, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABvi52PGKhu0l1pEuI26Lpm-8CjxZtSAks5rhbyxgaJpZM4MP2pk.

trouble2 commented 7 years ago

Hi Ilpo, Do you know if the DNN forum has an integration with the DNN Journal module. Because in the Journal module you can select to display “Forum posts” etc. However, I don’t think it is working….

Regards,

Van: Ilpo Juvander [mailto:notifications@github.com] Verzonden: Wednesday, March 1, 2017 5:22 PM Aan: juvander/DotNetNuke-Forum DotNetNuke-Forum@noreply.github.com CC: Marnix Bouwman marnixbouwman@bondforwebsolutions.nl; Author author@noreply.github.com Onderwerp: Re: [juvander/DotNetNuke-Forum] Problem with attachments (#8)

So it seems, will check this later on today.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/juvander/DotNetNuke-Forum/issues/8#issuecomment-283388750, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABvi5yxCEYT7RJC3A_DPd8uB8gCujaZ4ks5rhZsmgaJpZM4MP2pk.

juvander commented 7 years ago

Nothing on that in the source code. Forum module was already forgotten when that feature came out so no development has been around that.

trouble2 commented 7 years ago

OK, thanks!

Marnix Bouwman [cid:image006.png@01D0344A.F84A7D80]bond for web solutions

Van: Ilpo Juvander [mailto:notifications@github.com] Verzonden: Wednesday, March 15, 2017 9:40 AM Aan: juvander/DotNetNuke-Forum DotNetNuke-Forum@noreply.github.com CC: Marnix Bouwman marnixbouwman@bondforwebsolutions.nl; Author author@noreply.github.com Onderwerp: Re: [juvander/DotNetNuke-Forum] Problem with attachments (#8)

Nothing on that in the source code. Forum module was already forgotten when that feature came out so no development has been around that.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/juvander/DotNetNuke-Forum/issues/8#issuecomment-286675212, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABvi5_s_icJUA7rX_IaDCQ4VNgbLTITPks5rl6PLgaJpZM4MP2pk.

juvander commented 7 years ago

See with this: https://github.com/juvander/DotNetNuke-Forum/releases/tag/05.01.00_DNN8

trouble2 commented 7 years ago

Wow, you’ve been busy… Is it ok for production, or do you expect a lot of bugs?

Marnix Bouwman [cid:image006.png@01D0344A.F84A7D80]bond for web solutions

Van: Ilpo Juvander [mailto:notifications@github.com] Verzonden: Thursday, March 16, 2017 11:45 AM Aan: juvander/DotNetNuke-Forum DotNetNuke-Forum@noreply.github.com CC: Marnix Bouwman marnixbouwman@bondforwebsolutions.nl; Author author@noreply.github.com Onderwerp: Re: [juvander/DotNetNuke-Forum] Problem with attachments (#8)

See with this: https://github.com/juvander/DotNetNuke-Forum/releases/tag/05.01.00_DNN8

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/juvander/DotNetNuke-Forum/issues/8#issuecomment-287020349, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABvi53q83KRkF8xZeWmWGeA4bsh5yLhJks5rmRKngaJpZM4MP2pk.

juvander commented 7 years ago

I have this version now running on my own + few other sites. Not much other changes compared to previous one - yet. But of course, see how the journal now works before putting it into production. Especially the visibility of those entries ;)