Adding SQL table

[hOlyYy]

Greetings,

i've been trying to add sql table sid into users but after i do, I can't register, unexpected error. Any hints how to fix this?

[Mark-Artyniuk]

I know this question is old, but its a good one to have answered here somewhere.

/includes/database.php

the addNewUser function uses a method to insert data that needs to manually edited if you add a field to the users table.

Since nothing is specified you must have a value for each field. If you dont add a value to this insert (below), it will fail.

   $q = sprintf("INSERT INTO ".TBL_USERS." VALUES ('%s', '%s', '%s', '%s', '%s', $time, '1', '0', '%s', '0', '0')",
        mysql_real_escape_string($username),
        mysql_real_escape_string($password),
        mysql_real_escape_string($userid),
        mysql_real_escape_string($ulevel),
        mysql_real_escape_string($email),
        mysql_real_escape_string($name));
  return mysql_query($q, $this->connection);