Technical support This forum is closed.
Version 1.x > Technical support > bizform error View modes: 
User avatar
Member
Member
kamran - 9/22/2006 7:11:05 AM
   
bizform error
I have created a simple bizform, as instructed in the guide, which sends an email. After i have created and tested it using the bizform test form, i recieve the email, with no problems. However when i insert the bizform control into the a page and press the submit button on the website it gives me an error: which is as follows: -

An error occurred when saving data: Kentico.CMS.DataEngine.GeneralConnection.RunQueryObject: Query: INSERT INTO [contactus] ( [YourName] ) VALUES ( @YourName); SELECT @@identity AS [ItemID] caused exception: Kentico.CMS.DataProviderSQL.ExecuteQuery: Query: INSERT INTO [contactus] ( [YourName] ) VALUES ( @YourName); SELECT @@identity AS [ItemID] : caused exception: Invalid object name 'contactus'.


This is a bit strange as it works fine in the test form but as soon as you insert it and actually use it on the website, it throws an error.

User avatar
Guest
admin - 9/25/2006 6:11:08 PM
   
Re: bizform error
Could you please check your database contains table contactus and the table's owner is dbo?

User avatar
Member
Member
kamran - 10/3/2006 2:10:48 AM
   
Re: bizform error
I had made sure that the database table contactus has the right permissions but it didnot work. It still was showing the same error. Also one thing that i did notice was that it created a contactus table in the database but when when i view the table in the tree view of the database it is shows as ASP.NET/contactus. Any solution on how to resolve the issue.

User avatar
Guest
admin - 10/10/2006 9:32:31 AM
   
Re: bizform error
You may need to change the DB owner using the following SQL statement:

EXEC sp_changeobjectowner 'contactus', 'dbo'

You may also want to add the following web.config parameter:

<add key="CMSDBObjectOwner" value="dbo" />