Zone Gamerz Register Problem

hello ragezone

anyone know about this problem

error says

Warning: mssql_query() [function.mssql-query]: message: An explicit value for the identity column in table 'Account' can only be specified when a column list is used and IDENTITY_INSERT is ON. (severity 16) in C:\xampp\htdocs\include\form.php on line 145

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\include\form.php on line 145
7bf6a5111a982b58

http://s2.postimg.org/9442m6aax/Untitled.jpg

and here my line 145 on form.php

mssql_query("INSERT INTO Account VALUES ('$Email', '$UserID', '$Password' , '$UserKey', '0', NULL, NULL, NULL, '$SecretQuestion', '$Answer', '$FirstName', '$MI', '$LastName', '$Birthday', '00:00:00', '$Sex', '$Address', NULL, NULL, '$Country', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$_SERVER[REMOTE_ADDR]', newid(), GETDATE(), 0, NULL, 0, 0, 0, NULL, 0, 1, NULL, 0, 0, NULL, NULL, 0, '$KSCode', 0, '$KSActivation')") or die($KSActivation);

Big Thanks To Anyone who help me and Also ragezone

You need to set the ID as primary key. Google it for how to do that in the sql database.

http://s24.postimg.org/5e34hyimd/Untitled.jpg

do you mean this primary key ??

i already do that but still not fix

Please open C:\xampp\htdocs\include\form.php and paste here Line 145. I want to see what's in there.

My Version:

PHP Code:

---

mssql_query("INSERT INTO Account VALUES ('$Email', '$UserID', '$Password' , '$UserKey', '0', NULL, NULL, NULL, '$SecretQuestion', '$Answer', '$FirstName', '$MI', '$LastName', '$Month/$Day/$Year 00:00:00', '$Sex', '$Address', NULL, NULL, '$Country', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$_SERVER[REMOTE_ADDR]', newid(), GETDATE(), 0, NULL, 0, 0, 0, NULL, 0, 1, NULL, 0, 0, NULL, NULL, 0, '$KSCode', 0, '$KSActivation')") or die($KSActivation); 


---

Your Corrected Version:

PHP Code:

---

mssql_query("INSERT INTO Account VALUES ('$Email', '$UserID', '$Password' , '$UserKey', '0', NULL, NULL, NULL, '$SecretQuestion', '$Answer', '$FirstName', '$MI', '$LastName', '$Birthday 00:00:00', '$Sex', '$Address', NULL, NULL, '$Country', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$_SERVER[REMOTE_ADDR]', newid(), GETDATE(), 0, NULL, 0, 0, 0, NULL, 0, 1, NULL, 0, 0, NULL, NULL, 0, '$KSCode', 0, '$KSActivation')") or die($KSActivation); 


---

- - - Updated - - -

You are adding one more row than what is needed there. This is the correct registration for the database. Look at the Birthday and you will see exactly what I mean.

ahh thanks jbeitz

i wrong in birthday

and just add ZGactivation and fix thanks