I've had the site up and running for about 12 months and edit it weekly for our client.  I finished editing a module a couple of nights ago but need to change it again, when I click the pencil icon I am redirected to the generic error page and the log says:

2011-09-01 09:42:43,414 ERROR mojoPortal.Web.Global - xx.xx.xx.xx-en-GB - /HtmlEdit.aspx?mid=2&pageid=2
System.IndexOutOfRangeException: LoginName
   at System.Data.SqlServerCe.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlServerCe.SqlCeDataReader.GetOrdinal(String name)
   at System.Data.SqlServerCe.SqlCeDataReader.get_Item(String name)
   at mojoPortal.Business.ContentHistory.LoadListFromReader(IDataReader reader)
   at mojoPortal.Web.ContentUI.EditHtml.BindHistory()
   at mojoPortal.Web.ContentUI.EditHtml.PopulateControls()
   at mojoPortal.Web.ContentUI.EditHtml.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at mojoPortal.Web.mojoBasePage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I can now edit some modules but not a couple of others - I've rebooted the whole server thinking that would fix it but it hasn't worked - any ideas of what to try next??

System info is:

mojoPortal Version 2.3.5.5 SqlCe
Operating System Microsoft Windows NT 5.2.3790 Service Pack 2
ASP.NET Info v4.0.30319 Running in Full Trust

Regards

Andrew

Hi,

There was only me as a user on the site but I've created another with Admin rights and I get the same error - strange there are 2 html modules on the same page, I can change one but not the other?

Login error is the same as above for the other user.

No the wrench icon works fine and I can change settings in there and save - just can't get to the html edit for that module.....??

Well that's the strange thing, I did check and non were selected so I thought it must be that and added admin etc. to the edit rights but when I checked the other module on that page non of those were selected either....... if I do change security rights to I have to recycle the app pool or touch the web.config file before they are applied?

It is a bit weird isn't it and I'm at a bit of loss of how to sort it and can only change about half of the site at the mo....

Tried recycling it and it after changing settings and it hasn't made any difference - strange and frustrating! lol

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?

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!   Strange how it affected some modules and not others eh?

Thanks to both of you for your help and patience 

Regards

Andrew

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

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