In Progress

Error on ASP Form.

We have not long transferred a website to a new host.

The site contains a form used for customer to register. When attempting to register we get the below error:

The error can be recreated live when filling out test data here: [url removed, login to view]

I am looking for someone who has lots of experience working with ASP & SQL based websites.

- - - - - - - - - - -

Server Error in '/' Application.

Cannot insert the value NULL into column 'ProcessServerId', table '[url removed, login to view]'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: [url removed, login to view]: Cannot insert the value NULL into column 'ProcessServerId', table '[url removed, login to view]'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Source Error:

Line 453: if (!IsAvailable)

Line 454: {

Line 455: [url removed, login to view](server);

Line 456: //[url removed, login to view](("<script language=javascript> alert('Successfully submitted. Upon review of the submission the information will be posted within 24 hours to the site.');</script>"));

Line 457: [url removed, login to view]("<script>[url removed, login to view] = '[url removed, login to view]';</script>");

Source File: c:\inetpub\vhosts\[url removed, login to view]\httpdocs\[url removed, login to view] Line: 455

Skills: ASP, HTML, SQL, Troubleshooting

See more: form stack review, execution table, test execution, error 0, test website error, paypal form working, trace stack, server error application, line asp, form data filling, insert form site, write code language, javascript error null, javascript null, sql web form, write form, statement application, attempting, sqlexception, site server error, server error website application, asp insert data, web based data submission, response code error, asp test

About the Employer:
( 7 reviews ) Newcastle, Australia

Project ID: #1265035

Awarded to:

BitsLogic

Dear Sir, We are interested in working with you. Over the years we have worked on many projects, both large and small. They have varied in complexity from simple reusable modules to enterprise-wide web-enabled applica More

$30 AUD in 5 days
(18 Reviews)
5.6

22 freelancers are bidding on average $42 for this job

asarfraz

Problem is minor. Please check PM

$35 AUD in 2 days
(42 Reviews)
5.8
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

$30 AUD in 1 day
(82 Reviews)
5.8
intechwebworks

Hello can i fix this error for you.?

$70 AUD in 2 days
(13 Reviews)
5.4
dracco

really interested in your project and ready to start now! Best regards. Dracco.

$50 AUD in 0 days
(68 Reviews)
5.3
snsTechnologies

I can remove the errors in 5 hours. Please see PM. Thanks!

$49 AUD in 0 days
(11 Reviews)
5.1
gaupoo

Hello, Like to inform you that we checked the link which you have provided and want to confirm you that we will complete this task in limited time and budget. We have an expertise in technologies like Asp, Asp.Ne More

$30 AUD in 1 day
(11 Reviews)
4.7
GediminasB

I will need remote connection to your SQL server. Here is solution for free (if you do the procedure yourself): Launch MS SQL Server Management Studio, Connect to the database and right click on “ServeAmerica3.dbo. More

$30 AUD in 1 day
(4 Reviews)
4.6
RashidCh

Sir i am ready for this job.

$40 AUD in 2 days
(5 Reviews)
2.6
roopamumbai

Hi, I have 5+ years experience with Microsoft Technologies (.Net & Sql Server). Kindly refer PM for details. Regards, Roopa

$40 AUD in 1 day
(3 Reviews)
2.1
yehia111111

Hi,Kindly check your PMB

$35 AUD in 0 days
(2 Reviews)
1.8
iosifrn

Hello, I have over 15 years of programming experience in Web Development, ASP, ASP.NET, MS Access, SQL Server, ORACLE, C#, Visual Basic, VBA and others. I can help you with this project and any other projects you may More

$75 AUD in 2 days
(2 Reviews)
1.6
uniquecode1

Hi, Please see PMB.

$30 AUD in 1 day
(1 Review)
1.6
matatika

This error is caused by an attempt to insert a NULL value into a filed that does not allow NULL values. I have over 6 years experience working with SQL Server, ASP and ASP.NET in industries such as finance, rail, ga More

$50 AUD in 1 day
(0 Reviews)
0.0
waqarahmad90

i have good experienced in Microsoft technologies. i m interested in this project and ready to start now.

$30 AUD in 2 days
(0 Reviews)
0.0
wwwwizcoorg

5 years of experience of asp.net and sql server and good web development skills and catchy to errors

$45 AUD in 3 days
(0 Reviews)
0.0
anikanodia

I can resolve this issue as I have been working on web development, trouble-shooting and bug-fixing from last 4+ years.

$30 AUD in 2 days
(0 Reviews)
0.0
UsmanRaza2

I developed a complete application recently, www.usmaniacomplex.com; and I corrected many errors of these kind. Don't worry! 1 day if not sat, sun; 2 days if holidays come.

$100 AUD in 2 days
(0 Reviews)
0.0
UmakantaSwain

I think I am capable of doing the job without any obstacle. I am sure the job will be done.

$30 AUD in 1 day
(0 Reviews)
0.0
m2websolution

Please check PM!!!

$47 AUD in 1 day
(0 Reviews)
1.3
mfrison

Hi, I have realized your error and can solve it quite quickly (< 1 day). I have extensive experience with ASP and SQL languages as my work (penetration tester) requires deep knowledge of both. Please let me know fo More

$35 AUD in 1 day
(0 Reviews)
0.0