07-08-2015, 07:49 PM
In my database column user_code in bg_user is unsigned, so I wonder how the code can be -1
user index -1 cant found, how looks your bg_user ? and your t_user?
Code Snipp of the Error, so the user cant found, the user will be load from the gserver userlist with the subno so i think database problem
bg_user :
+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+
| user_code | user_id | truepasswd | passwd | chk_tester | jumin | chk_service | partner_id | active_passwd | active_time | create_date | email | ip | hashigh | send | question | answer | cash | team | refby | cashused | cashtotalused | event_id | tier | write_time | used_all | enc_jumin1 | enc_jumin3 |
+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+
| 0 | tester | tester | tester | N | 0 | Y | LC | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | NULL | 0 | 0 | 1 | 0 | NULL | NULL | NULL | NULL |
+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+
t_users :
+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+
| a_index | a_idname | a_passwd | a_portal_index | a_regi_date | a_end_date | a_enable | a_server_num | a_subnum | a_zone_num | a_timestamp | a_preopen_chk | a_eventpoint | a_eventpoint_use | a_stash_passwd | a_stash_sealed | a_stash_password | a_pcbang_time | a_login_time | a_restart | bancount | banreson | bantime | a_block_time | a_fail_count |
+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+
| 0 | tester | tester | 2 | 2015-01-17 18:05:46 | 2015-01-20 01:01:07 | 1 | 1 | 1 | -1 | 1421544419 | 0 | 10 | 0 | | 0 | | 0 | 0 | 0 | 0 | | 0 | 0 | 0 |
+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+
Is your login an connector config correct ? Please post it, so we can see if there is a problem.
Connector :
;-------------------------------------------------------------------------
; SERVER CONFIG
;-------------------------------------------------------------------------
[server]
Number=1
MaxSubServer=1
IP=127.0.0.1
Port=4006
HARDCORE=FALE
;-------------------------------------------------------------------------
; DATA CONFIG
;-------------------------------------------------------------------------
[user DB]
IP=localhost
DBName=newproject_db_auth
User=root
Password=
[Auth DB]
IP=localhost
DBName=newproject_db_auth
User=root
Password=
[Event DB]
IP=localhost
DBName=newproject_db_auth
User=root
Password=
;-------------------------------------------------------------------------
; BILLING CONNECTION
;-------------------------------------------------------------------------
[billing Server]
IP=127.0.0.1
Port=2072
LoginServer :
;-------------------------------------------------------------------------
; SERVER CONFIG
;-------------------------------------------------------------------------
[server]
No=1
IP=192.168.1.35
Port=4001
AllowExternalIP=TRUE
[GM ID]
egbs=1
;-------------------------------------------------------------------------
; DATA CONFIG
;-------------------------------------------------------------------------
[user DB]
IP=localhost
DBName=newproject_db
User=root
Password=
[Data DB]
IP=localhost
DBName=newproject_data
User=root
Password=
[Auth DB]
IP=localhost
DBName=newproject_db_auth
User=root
Password=
;-------------------------------------------------------------------------
; SERVER CONNECTION
;-------------------------------------------------------------------------
[Messenger Server]
IP=127.0.0.1
Port=4000
[Connector Server]
Count=1
[Connector_0]
Number=1
MaxSubNumber=1
IP=127.0.0.1
Port=4006
[Connector_1]
Number=1
MaxSubNumber=1
IP=127.0.0.1
Port=4016
;-------------------------------------------------------------------------
; IP CONFIG
;-------------------------------------------------------------------------
[block IP]
Number=0
[block Band]
Number=0
Band0=A-211.094.000.000-211.103.255.255
[Auto Block]
Refresh=2
MaxTry=5
ExIP61.104.44.146=1
[block ExID]
ExIDckh386=1
Thanks in advance
!