2 replies to this topic

[chili5]

When I use my registration program on the CC server I get a message that looks like this:

Quote

Fatal error: Call to a member function bind_param() on a non-object in newAccount.php on line 63

Now the weird thing is, when I run the same script locally, it works. Any thoughts?

This is the code that is having the problem:

if (count($errors) == 0) {

	// no errors have occured so apply sha1 to passwords

	$pwd = sha1($pwd);

	$pwdConfirm = sha1($pwdConfirm);

	

	// submit to database

	$sql = "INSERT INTO users (user_name, user_pwd, user_regdate, user_country, user_email, user_activated, user_points, user_levelid, activation_key) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?);";

	$stmt = $dbConn->prepare($sql);


	// bind the variables to the prepared statements replacing the ? marks

	$stmt->bind_param("ssiissiis",$userName,$pwd,$regdate,$country,$email,$activated,$points,$levelId, $activateKey);

	$activated = "0"; // not yet activated

	$points = 0;

	$levelId = 0; // level id 0 means the user is a normal user without admin permissions

	$activateKey = makeKey();

	

	$stmt->execute();

	

	$message = "$userName has been registered. You may now login.<br />";

}

Any thoughts?

[chili5]

thank you!

I completely forgot that I added that field locally. :(


+rep for you.