NO PROBLEM I FIXED IT

I need to add a few fields in users Table.

first I created these fields directly with MySQL in Users Table.

Then I changed all related program to display/Update/Create these fields.
Display so far is perfect.

However when I try to register a new user, or try to Edit a users profile, I get an SQL error.
Also Php debug, gives the following error.

Warning: sprintf(): too few arguments in
c:\xoops\easyphp\www\cb\html\kernel\user.php on line 541
whivh refers to statements

$sql = sprintf("INSERT INTO %s (a, b etc) to register

OR

$sql = sprintf("UPDATE %s SET a = %s, b = %s, etc) to edit the user profile

Of course this happens only when I am adding my fields in the SPRINTF statement.

I guess that I am trying to invoke a function with incorrect number of parameters. Where are these sql function so I can change them. I looked Everywhere.

NO PROBLEM I FIXED IT

i have a problem too.. when i go to the
user edit page (in admin) i get follow php errors
Notice: Undefined variable: lastname_value in /var/www/localhost/htdocs/www.blogout.de/modules/system/admin/users/userform.php on line 114

Notice: Undefined variable: mobile_value in /var/www/localhost/htdocs/www.blogout.de/modules/system/admin/users/userform.php on line 115

Notice: Undefined variable: idcard_value in /var/www/localhost/htdocs/www.blogout.de/modules/system/admin/users/userform.php on line 116

but all is definied in the user.php which is included

Those notices are usually just that... notices.

In this case, I assume that the code somewhere inserts a variable somewhere, perhaps in an if statement, but the variable is empty/null. Then you get the notice.

Usually there are no problems with running the page even with notices popping up - as long as they aren't critical variables like $op or similar.

I cannot really help you as I am new in xoops.
However when I added new fields in users file I changed approximately 7-8 php's.

If you send me your email with a private message, I will send you all the code I changed to make it work,