Zone Gamerz Register Problem

[evilbaz]

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

REMOVED

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

 

[jbeitz107]

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

 

[evilbaz]

REMOVED

do you mean this primary key ??

i already do that but still not fix

 

[A v a r a]

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

 

[jbeitz107]

My Version:

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:

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);

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.

 

[evilbaz]

ahh thanks jbeitz

i wrong in birthday

and just add ZGactivation and fix thanks