[mgw-dev] [ moregroupware-Bugs-612588 ] Error on create new user

[<no...@so...>]

Bugs item #612588, was opened at 2002-09-21 20:13
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=612588&group_id=32034

Category: Admin
Group: 0.6.x
>Status: Closed
Resolution: Works For Me
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Karsten Dambekalns (k-fish)
Summary: Error on create new user

Initial Comment:
After create a first user I was create the second and...


Problem in Moregroupware found!
Version (config.inc.php): 
Version (version.inc): 0.6.4pl1 - Neo
PHP version: 4.1.1
Server software: Apache/1.3.26 (Unix) (Conectiva/Linux) 
mod_perl/1.25 PHP/4.1.1 mod_ssl/2.8.10 OpenSSL/0.9.6a
Program: /modules/admin/usermanager.php
File: /home/httpd/html/groupware/modules/admin/usermanager.
php
File revision: 1.41
Line: 64
dump:
(POST) Array ( [PHPSESSID] => 
f1b6d382d5121d164397f506c0bdc1f3 [id] => [usernameform] => 
alexandre [firstname] => Alexandre [lastname] => Garrido [email] 
=> ale...@st... [mobile] => [pw] => garrido 
[pwagain] => garrido [language] => pt_br [group] => 0 [create] => 
Salvar ) 
(GET) Array ( ) 

Error (SQL): insert into mgw_groups_members (groupid, userid, 
lu_user, lu_date) values (0, 0, 1, '2002-09-21 15:19:06')

Error (MSG): Duplicate entry '0-0' for key 1

Please report this error to our Bugtracker



----------------------------------------------------------------------

>Comment By: Karsten Dambekalns (k-fish)
Date: 2002-09-28 21:06

Message:
Logged In: YES 
user_id=105527

No responses, closing now.

----------------------------------------------------------------------

Comment By: Karsten Dambekalns (k-fish)
Date: 2002-09-22 16:35

Message:
Logged In: YES 
user_id=105527

I tried this today with latest CVS code, and it worked. This
error usually apperas after the database was somehow changed
outside the application, or some upgrade and/or data import
attempt was made.

Could you compare the maximum id from the mgw_users table
with the value stored in mgw__seq_users? If they are equal,
set the value in mgw__seq_users accordingly. Then it should
work again.

Setting this to pending, please report your findings here.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=612588&group_id=32034