+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep4 Support (https://lckb.dev/forum/forumdisplay.php?fid=128)
+----- Thread: mysql query error (/showthread.php?tid=5032)
- kdy - 03-12-2023
hi, i have this error when i go to enter the game
query error (mysql_real_query) : error[Unknown column 'a_cid' in 'field list'] query[SELECT RIGHT(a_cid, 7) as a_cid FROM bg_user WHERE a_idname = 'test1' LIMIT 1]
2023-03-12 12:22:43,942 ERROR - not found row in bg_user. user_id[test1]
2
2
could someone help me to solve it? i am using november files btw
- Desarija - 03-12-2023
Add field a_cid to bg_user ? i think that’s something like a security code for stash password and a maybe a few other things
- kdy - 03-12-2023
22 minutes ago, Desarija said:
Add field a_cid to bg_user ? i think that’s something like a security code for stash password and a maybe a few other things
and now i get this error
(mysql_real_query) : error[Unknown column 'a_idname' in 'where clause'] query[SELECT RIGHT(a_cid, 7) as a_cid FROM b g_user WHERE a_idname = 'test1' LIMIT 1]
2023-03-12 13:42:26,461 ERROR - not found row in bg_user. user_id[test1]
- Desarija - 03-12-2023
i think a_idname should be user_id or vice versa
- kdy - 03-12-2023
25 minutes ago, Desarija said:
i think a_idname should be user_id or vice versa
now i only get this error
2
not found row in bg_user. user_id[test3]