From: <Cir...@cs...> - 2005-04-08 08:14:20
|
OK, so I finally get the client and server compiled again - and I can't = even log in. I get weird PostGRESQL errors like this: Info: Sending connect reply info to some (yet) unknown player - Query: SELECT uid,password FROM usr_accts WHERE username=3D'pinniped' - Query: SELECT * FROM usr_logins WHERE username=3D'pinniped' AND = charname NOTNULL - Query: SELECT * FROM usr_logins WHERE username=3D'pinniped' AND = charname ISNULL - Query: INSERT INTO usr_logins (uid,username,connid,login) VALUES = ('1','pinniped','16777343-32772',CURRENT_TIMESTAMP) PostgreSQL Exception: ERROR: invalid input syntax for integer: = "16777343-32772" ERROR: error creating login entry in table (pinniped) [ Apr08 07:45:57.044 :: ocLoginMgr :: src/server/login/ocloginmgr.cpp = (222) - Error happened managing network packet (missing type or action = failed), type 'Logi' ] Can someone put a page up on the wiki with instructions on how to create = an appropriate table for Once and create a single user? This should be = kept updated and should also have instructions on how to add new fields, = how to tell what fields already exist, and how to edit fields. This = should allow devs like me who know nothing about DBs (and who has added = what to the tables) to be able to set up my own server and client and = continue working and testing, rather than wasting time waiting another = day to talk to the devs who did work on that part. - pinniped |