can't registered

[zhiichiro]

can't register a new account on my site it says:

Something is Wrong!

Something is very, very wrong. Please contact Rusnak PHP Scripts about this error.

my last registered user is bloodrun =.="

any help?

 

[Bloodrun]

Then, go to your register.php file, find where it says:

        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0')");

and place this at the very end:

, ''

So that it will looks like this:

        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");

Why do we do this?
Let's let BMR777 explain that one:
Adding an extra field onto the users table requires you to edit register.php so the SQL query for creating a new user matches with the new database table structure. Failure to do this will BREAK the user registration system.

 

[zhiichiro]

ok tnc

 

[BMR777]

That error occurs only if the system cannot automatically log in the new user after registration, which normally should never happen. What modifications have you made to register.php or to the script in general?

 

[zhiichiro]

i cant find that..

only this :

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0',''),''),''),'')");

---

i didnt do anything on register.php

 

[Bloodrun]

i cant find that..

only this :

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0',''),''),''),'')");

---

i didnt do anything on register.php

---

omg, well theres your problem.
You only need the two parenthesis at the end, it should look like this:

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','')");

 

[zhiichiro]

change it already to

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");

 

[Bloodrun]

change it already to

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");

No, you need those other ones, because the of spaces needs to match up with your adopts_users table.

 

[zhiichiro]

i cant find that..

only this :

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0',''),''),''),'')");

---

i didnt do anything on register.php

---

omg, well theres your problem.
You only need the two parenthesis at the end, it should look like this:

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','')");

---

done. still can't register

 

[Saphira]

how many fields do you have in your adopts_users table in your database?

 

[zhiichiro]

there are ten.. the yahoo msn others + age location and others from profile modification, which i removed on profile.php and account.php..

and there's only 6 ,'' ..... i just added 4, so it will be 10. and it works

everyone... pls try to register the link is on my signature.

thnx for the help