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
Re: Zone Gamerz Register Problem
You need to set the ID as primary key. Google it for how to do that in the sql database.
Re: Zone Gamerz Register Problem
http://s24.postimg.org/5e34hyimd/Untitled.jpg
do you mean this primary key ??
i already do that but still not fix
Re: Zone Gamerz Register Problem
Please open C:\xampp\htdocs\include\form.php and paste here Line 145. I want to see what's in there.
Re: Zone Gamerz Register Problem
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.
Re: Zone Gamerz Register Problem
ahh thanks jbeitz
i wrong in birthday
and just add ZGactivation and fix thanks