Menu

Error creating new users

Help
Diego
2007-12-27
2013-04-16
  • Diego

    Diego - 2007-12-27

    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

     
    • Diego

      Diego - 2007-12-27

      I forgot to mention that im using:

      phpbt 1.0.3
      IIS 6
      MySQL 5.0.20
      PHP 5.2.4

      thanks again!

       
      • Bryce Nesbitt

        Bryce Nesbitt - 2007-12-29

        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.

         
    • Nobody/Anonymous

      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.

       
      • Bryce Nesbitt

        Bryce Nesbitt - 2008-01-27

        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...

         
    • Nobody/Anonymous

      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.

       
    • Patrick

      Patrick - 2008-01-27

      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

       
    • Bryce Nesbitt

      Bryce Nesbitt - 2008-01-27

      This bug is now fixed.  Please update from cvs to get the fix.
      There was a missing quote character.

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.