Duplicate pbx_Users

By waqarsheikh at Mon, 2009-06-29 19:31 | AstBill Software - General and Support

Hi,

I have just moved to 0.9.22 version of astbill and I have moved my database to another machine. But Everytime I create a new user I get the following error.

Duplicate entry '22' for key 1 query: INSERT INTO pbx_users (name, pass, init, mail, status, created, changed, uid) VALUES ('oneworldcafe', '8675544332a8cabe273e6735f1a01c6f', 'oneworld@v4voip.co.uk', 'oneworld@v4voip.co.uk', '1', '1246014730', '1246014730', '22') in /home/astbill/wwwroot/includes/database.mysql.inc on line 66.

Can somebody plase help me to reset the suid counter in the astcreateacc procedure to the last UID in pbx_users table.

Thanks
Waqar @ v4voip.co.uk