+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: add new user not working (/thread-185.html)
add new user not working - lkoumis - 03-02-2010
trying to add a new user and I got this error:
Error in query: INSERT INTO odm_user (id, username, password, department, phone, Email,last_name, first_name) VALUES('', 'gmoran', password('qhga'), '2' ,'916 5991920','[email protected]', 'moran', 'gina' ). Incorrect integer value: '' for column 'id' at row 1
At row 1 there is already a record, myself as an admin.
suggestions?
Re: add new user not working - Stephen - 03-03-2010
Which version are you running?
Re: add new user not working - lkoumis - 03-03-2010
SOLVED. Mysql will add new record. No need for the id field.
Re: add new user not working - Stephen - 03-03-2010
I think that is a mysql issue. It used to accept a ('') as the auto-increment value, but It seems a newer version now barks at that? did you manually adjust the file to get it to work?