ready to scream

Hi Folks:

I have a site on MOSS2007. I've enabled Anonymous access to one list on the
site. it's for an IT Service Request list form.

I followed the instructions here:

http://blah.winsmarts.com/2007-5-Customize_the_-and-quot;NewFormaspx-and-quot;_page_for_a_SharePoint_List.aspx

to modify the newform.aspx. Basically, I didn't want users to fill out
anything but the basics (Issue, Customer Name, What office are you from,
problem description).

So i followed the instructions above and now have my own file called
EndUserEntry.aspx that has a Custom List Form on it with just the fields the
user is required to fill out.

During the design process with Sharepoint designer, the form was working
initially for ANONYMOUS users to add new support requests. I added one
additional field to the list (that is just a choice box indicating status on
the task). SInce i've added that one additional field, it now gives the
following error when ANONYMOUS users use my EndUserEntry.aspx page.

http://blah.winsmarts.com/2007-5-Customize_the_-and-quot;NewFormaspx-and-quot;_page_for_a_SharePoint_List.aspx

if an authenticated user runs the list, it runs perfect.

I'm ready to scream. I've searched all over the web for possible solutions
with no luck. i've seen people suggest rebuilding the list from scratch and
starting over. Which I've done four times so far. Each time, the initial form
creation works great. but the moment i add one other field to the list, it
throws that error.

I turned customerrors off on the web.config to see if there's any more
detail, but it's useless.

The thing is, their ticket they enter actually gets into the list. So the
error message is misleading because the insert actually takes place in the
list. but they get the error message.

I'm ready to barf on this issue. I'm so afraid of sharepoint designer now in
terms of it's abiity to allow me to make a custom data entry form for a list
that actually WORKS.

Please for give me for expressing my frustrations. it's not fair to you all.

I REALLY REALLY REALLY REALLY need some help in understanding how to get a
custom data entry form for a list for use by an anonymous user.

It's so funny really. ALl i'm really doing in Sharepoint Designer 2007 is
removing a couple of fields from the dataformwebpart taht the user shouldn't
see and adding a pretty little picture of an IT support jpeg photo to spice
up the view a little.

I need to understand why sharepoint thinks the insert is failing. what more
can i do to troubleshoot this issue?

The exact error is as follows:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/27/2008 1:31:48 PM
Event time (UTC): 3/27/2008 8:31:48 PM
Event ID: 8466ff91c76940c792a901a28dcc76ae
Event sequence: 3518
Event occurrence: 5
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1156006261/Root-1-128510814287655727
Trust level: WSS_Minimal
Application Virtual Path: /
Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\80\
Machine name: PPVSHPT07

Process information:
Process ID: 2300
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: DataFormWebPartException
Exception message: The data source control failed to execute the insert
command.

Request information:
Request URL: http://sp2007.ppaz.org/it/Lists/test/enduserentry.aspx
Request path: /it/Lists/test/enduserentry.aspx
User host address: 10.0.1.200
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at
Microsoft.SharePoint.WebPartPages.DataFormWebPart.InsertCallback(Int32
affectedRecords, Exception ex)
at System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback)
at Microsoft.SharePoint.WebPartPages.DataFormWebPart.FlatCommit()
at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PerformCommit()
at Microsoft.SharePoint.WebPartPages.DataFormWebPart.HandleOnSave(Object
sender, EventArgs e)
at
Microsoft.SharePoint.WebPartPages.DataFormWebPart.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at


.