After install everything seems to work fine with the admin user created on initial setup, but, when a new developer tries to create a new account gets an error:
DB Error: no such field
insert into bugtrack_user_group (user_id, group_id, created_by, created_date) select 5, group_id, 0, 1198758050 from bugtrack_auth_group where group_name = User [nativecode=1054 ** Unknown column 'User' in 'where clause']
let me know if you need more details....
thanks in advance
Diego
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
What if you create the new user from the administrative side ( bugs/admin/user.php )?
Can you describe exactly where the error is happening. "User" is a text string that obviously does not match a column name. The question is where that string came from.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Okay, I want try to describe it. I think the error ist in the code of newaccount.php
[code]$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = ".NEW_ACCOUNTS_GROUP);[/code]
I have fixed it with code from the 1.0.1 release of the newaccount.php
[code]$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = 'User'"); [/code]
After that it worked for me. I have to delete all users in DB that are registered on frontend, because of the error the users are not complete registered in DB, only in phpbt_auth_user.
Don't know why the original code from 1.0.3 is working for others but not for me.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now I have registered here in the forum, because I don't want no more be a Nobody. I only want to tell you that it is me who have written here since 2008-01-26 14:31
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After install everything seems to work fine with the admin user created on initial setup, but, when a new developer tries to create a new account gets an error:
DB Error: no such field
insert into bugtrack_user_group (user_id, group_id, created_by, created_date) select 5, group_id, 0, 1198758050 from bugtrack_auth_group where group_name = User [nativecode=1054 ** Unknown column 'User' in 'where clause']
let me know if you need more details....
thanks in advance
Diego
I forgot to mention that im using:
phpbt 1.0.3
IIS 6
MySQL 5.0.20
PHP 5.2.4
thanks again!
What if you create the new user from the administrative side ( bugs/admin/user.php )?
Can you describe exactly where the error is happening. "User" is a text string that obviously does not match a column name. The question is where that string came from.
The string came from the newaccount.php
[code]$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = ".NEW_ACCOUNTS_GROUP);[/code]
and the text string "User" came from .NEW_ACCOUNTS_GROUP
I've got the same error and don't know how to fix and don't know why in TBL_AUTH_GROUP two groups exist with the name user.
Sorry for my not so good english, im from germany.
A more step by step description of how to repeat the issue would help -- and it would help overcome the language barrier.
Leider, mein Deutch is nicht so güt...
Okay, I want try to describe it. I think the error ist in the code of newaccount.php
[code]$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = ".NEW_ACCOUNTS_GROUP);[/code]
I have fixed it with code from the 1.0.1 release of the newaccount.php
[code]$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = 'User'"); [/code]
After that it worked for me. I have to delete all users in DB that are registered on frontend, because of the error the users are not complete registered in DB, only in phpbt_auth_user.
Don't know why the original code from 1.0.3 is working for others but not for me.
Now I have registered here in the forum, because I don't want no more be a Nobody. I only want to tell you that it is me who have written here since 2008-01-26 14:31
This bug is now fixed. Please update from cvs to get the fix.
There was a missing quote character.