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:

PHP Code:

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


and place this at the very end:

PHP Code:

, '' 


So that it will looks like this:

PHP Code:

        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',''),''),''),'')");

[hr]
i didnt do anything on register.php

[Bloodrun]

Originally Posted by zhiichiro

i cant find that..

only this :

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

[hr]
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]

Originally Posted by zhiichiro

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]

Originally Posted by Bloodrun

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?