How to resolve "Insufficient parameters" (Registration)

Question

I'm trying to add extra field(s) in Registration, but getting "Insufficient parameters" SQL errors on registration. I've successfully altered the qa_users table as needed, and added the info needed to INSERT in /qa-include/qa-db-users.php.

Is there another file I need to edit to add/edit/define these parameters? Thanks for any help.

Answer 1

It may be that you're not understanding the way that parameter substitution works in Q2A's qa_db_query_sub(...) function. It's worth reading some of the comments in qa-db.php. For each new parameter, you need to add something in 4 places:

1. Add the parameter to the function qa_db_user_create(...) declaration.
2. Add the column name (e.g.  inside the brackets after INSERT...
3. Add a $ (or # for numbers) sign inside the brackets after VALUES...
4. Add the parameter after the other parameter to qa_db_query_sub(...).

Here's an example using a new column named gender:

function qa_db_user_create($email, $password, $handle, $level, $ip, $gender)
{

require_once QA_INCLUDE_DIR.'qa-util-string.php';

 

$salt=isset($password) ? qa_random_alphanum(16) : null;

 

qa_db_query_sub(

'INSERT INTO ^users (created, createip, email, passsalt, passcheck, level, handle, loggedin, loginip, gender) '.

'VALUES (NOW(), COALESCE(INET_ATON($), 0), $, $, UNHEX($), #, $, NOW(), COALESCE(INET_ATON($), 0), $)',

$ip, $email, $salt, isset($password) ? qa_db_calc_passcheck($password, $salt) : null, (int)$level, $handle, $ip, $gender

);

 

return qa_db_last_insert_id();

}