Lost edit ability in certain modules

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
9/1/2011 7:27:13 AM
Gravatar
Total Posts 116

Re: Lost edit ability in certain modules

Thanks for your continued assistance, I don't have a backup of the DB but I've downloaded the SQLCE database and am just installing webmatrix so I can take a look at the existing DB and see if I can spot anything there, if not I might be able to get a copy from my webhost company to look at.

The error started straight after I had changed something in that module.  I wanted to copy something from another module so I opened that in error mode, went to html and copied what I wanted then clicked straight to the other page via the menu - I didn't update/cancel in the page I copied from and wonder if it somehow locked something open?

9/1/2011 7:52:25 AM
Gravatar
Total Posts 18439

Re: Lost edit ability in certain modules

Hi Andy,

2.3.5.5 is pretty old, it is possible there was a bug in that SQL CE version back then. Maybe the bug wasn't apparent until versioning of content was enabled and version history was populated.

You might consider upgrading to 2.3.6.7 and see if that resolves it.

Note there is also a SQL Query tool included in mojoPortal that you could enable and then use to investigate things in the database.

Hope that helps,

Joe

9/1/2011 8:06:18 AM
Gravatar
Total Posts 116

Re: Lost edit ability in certain modules

Thanks Joe I know I should upgrade it but I'm a bit wary of doing it until I have time to iron out any issues I hit with the skin as it is a Art 2.4 skin I think.  Will try and do that as soon as I can but I was kinda hoping to fix this error to buy myself a bit of time.

........ however you comments made me pause half way through typing this as I was going to say versioning wasn't switched on....... and it wasn't at modular level but it was at site level - I've just turned in off now and can now edit everything as normal again! smiley  Strange how it affected some modules and not others eh?

Thanks to both of you for your help and patience smiley

Regards

Andrew

9/1/2011 8:20:21 AM
Gravatar
Total Posts 18439

Re: Lost edit ability in certain modules

It sounds like it happened once there was a version history. Once versioning was enabled then every edit in the html content feature generates a new history version and the error seems to be happening in data binding the history grid. So by turning off the versioning it no longer tries to bind that grid and the error doesn't happen.

I'll test the latest SQL CE version here today just to make sure that bug isn't still there.

Best,

Joe

9/1/2011 8:26:03 AM
Gravatar
Total Posts 116

Re: Lost edit ability in certain modules

The versioning would have been turned on for quite a while Joe if that makes any difference?  I have a copy of the SQLDB that I took before I turned off versioning if that is of any interest to you - you might be able to see when it was turned on or how many versions there were etc.?  I would have thought some modules would have had maybe a dozen or so different versions stored?

Let me know if you want the DB and I'll email it over to you.

Regards

Andrew

9/1/2011 9:30:32 AM
Gravatar
Total Posts 18439

Re: Lost edit ability in certain modules

Hi Andrew,

There isn't anything I could do to fix an older version so the database wouldn't really help me. I've just tested here and this bug does not seem to be in the current version.

It does seem surprising for this error to suddenly start happening if versioning has been enabled for along time, I really have no explanation for that other than to think it has not been enabled until recently.

Best,

Joe

9/1/2011 9:47:00 AM
Gravatar
Total Posts 116

Re: Lost edit ability in certain modules

Hi Joe,

Was only if it was any use to you in tracking down the problem - site seems OK now.

I've had another look at the DB in WebMatrix and the earliest versioning entry I can see in mp_ContentHistory is 04/07/11 and there are only 4 entries in total.  I'm not certain as I can't be sure from the GUID but from the ContentText I think that the point I started having problems was straight after that module was altered for the second time i.e. the entry on 04.07/11 was the first version stored and when I changed it again early this week I got problems which would fit in with your initial thoughts.  Looking at the other 3 entries they have only been changed once as well so one have one version history entry each.

I must admit I thought it must have been enabled longer than it has been and that it would have more entries but that isn't the case.

Hope that helps,

Regards

Andrew

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