+- 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: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: GameServer Error (/showthread.php?tid=4409)
- ZikseL_qp - 01-18-2015
startup GameServer such an error
2015-01-18 14:11:01,060 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[Table 'newproject_db.t_syndicate_jewel_point' doesn't exist] query[sELECT * FROM t_syndicate_jewel_point]
2015-01-18 14:11:01,060 ERROR [ Syndicate.cpp : 28] - DB ERROR : LOAD CHARACTER SYNDICATE_HISTORY TABLE / query[sELECT * FROM t_syndicate_jewel_point] / error[Table 'newproject_db.t_syndicate_jewel_point' doesn't exist]
2015-01-18 14:11:01,060 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[unknown column 'a_syndicate_point_k' in 'field list'] query[sELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999]
2015-01-18 14:11:01,060 ERROR [ Syndicate.cpp : 70] - DB ERROR : LOAD CHARACTER SYNDICATE KING DATA / query[sELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999] / error[unknown column 'a_syndicate_point_k' in 'field list']
2015-01-18 14:11:01,061 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[unknown column 'a_syndicate_point_d' in 'field list'] query[sELECT a_nick, a_index, a_syndicate_point_d FROM t_characters WHERE a_syndicate_type = 2 and a_syndicate_point_d > 2078999999]
2015-01-18 14:11:01,061 ERROR [ Syndicate.cpp
- LikeToMove - 01-18-2015
2015-01-18 14:11:01,060 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[Table 'newproject_db.t_syndicate_jewel_point' doesn't exist] query[SELECT * FROM t_syndicate_jewel_point]
2015-01-18 14:11:01,060 ERROR [ Syndicate.cpp : 28] - DB ERROR : LOAD CHARACTER SYNDICATE_HISTORY TABLE / query[SELECT * FROM t_syndicate_jewel_point] / error[Table 'newproject_db.t_syndicate_jewel_point' doesn't exist]
t_syndicate_jewel_point exists on your *_db database? Check it.
2015-01-18 14:11:01,060 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[Unknown column 'a_syndicate_point_k' in 'field list'] query[SELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999]
2015-01-18 14:11:01,060 ERROR [ Syndicate.cpp : 70] - DB ERROR : LOAD CHARACTER SYNDICATE KING DATA / query[SELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999] / error[Unknown column 'a_syndicate_point_k' in 'field list']
2015-01-18 14:11:01,061 ERROR [ DBCmd.cpp : 42] - query error (mysql_real_query) : error[Unknown column 'a_syndicate_point_d' in 'field list'] query[SELECT a_nick, a_index, a_syndicate_point_d FROM t_characters WHERE a_syndicate_type = 2 and a_syndicate_point_d > 2078999999]
2015-01-18 14:11:01,061 ERROR [ Syndicate.cpp
Same, check your t_characters on *_db database. If a_syndicate_point_d and a_syndicate_point_k doesn't exists, probably you're using a wrong db.
- Darkface - 01-18-2015
Use fixed db.
- ZikseL_qp - 01-18-2015
thank you