+- 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)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=158)
+------ Thread: Mysterious Statue dont work (/showthread.php?tid=4634)
- BangGro - 02-02-2016
Hello Community,
i have Ep4 March files and the Agent Trader / Mysterious Statue dont work.
If i buy anything out of Trading Agent i dont get this to Mysterious Statue.
This error come all time into our GameServer if i click at Mysterious Statue :
query error : query[sELECT a_index, a_item_index, a_plus, a_plus2, a_flag, a_serial,a_item_count, a_option_count, a_option_0_type, a_option_0_level, a_option_1_type,a_option_1_level, a_option_2_type, a_option_2_level, a_option_3_type, a_option_3_level, a_option_4_type, a_option_4_level,a_socket0, a_socket1, a_socket2, a_socket3, a_socket4, a_socket5, a_socket6,a_item_origin_var0, a_item_origin_var1, a_item_origin_var2, a_item_origin_var3, a_item_origin_var4, a_item_origin_var5, a_now_dur, a_max_dur,a_nas, a_send_type, a_sender, UNIX_TIMESTAMP(a_registe_date) as a_registe_date, UNIX_TIMESTAMP(a_expire_date) as a_expire_date, a_tradeagent_nas, a_tradeagent_itemIndex, a_tradeagent_itemCount FROM t_express_system WHERE a_char_index=3 AND now() < a_expire_date LIMIT 0, 11] / error[unknown column 'a_plus2' in 'field list']
2016-02-02 10:11:58,459 FATAL [ SignalProcess.cpp : 39] - receive SIGNAL : 2
Can anyone help me please ?
- WorldOfWars - 02-02-2016
missing columns
- BangGro - 02-02-2016
Where missing columns ? What table ?
- DamonA - 02-02-2016
Where missing columns ? What table ?
look into the subhelper or gameserver output he will tell you
- Groby - 02-02-2016
newproject_db -> texpress-system add column a-plus2 done
- kravens - 02-02-2016
This post already exist.
- ZaTii - 02-02-2016
Hi there.
As your topic has been answered, and from this topic you can solve your problem or already have I am going to move this topic into our Solved section database.
Thankyou,
-LCKB Staff