+- 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: Help Title (/showthread.php?tid=2450)
- Asylum - 01-10-2021
Hi, everyone help me with title system
2021-01-09 18:10:58,431 INFO - no row : query[SELECT a_index FROM t_express_system WHERE a_char_index=262 AND now() < a_expire_date LIMIT 1]
2021-01-09 18:10:58,433 INFO - no row : query[SELECT a_msg_type, a_item_index, a_item_count FROM t_tradeagent_after_sell_returned WHERE a_char_index = 262]
2021-01-09 18:11:00,674 INFO - query : query[INSERT INTO t_syndicate_jewel_point VALUES(0, 0, 0, 0),(1, 0, 0, 0),(2, 0, 0, 0),(3, 0, 0, 0)]
2021-01-09 18:11:00,674 INFO - RVR System Save. K_Jewel_Point : 0, K_UserCount : 0, D_Jewel_Point : 0, D_UserCount : 0
2021-01-09 18:11:00,766 INFO - DB INSERT TO TITLE LIST > : CHAR_INDEX : 262 : TITLE_INDEX : 23 : CUSTOM_TITLE_INDEX : -1
2021-01-09 18:11:00,767 ERROR - query error (mysql_real_query) : error[Unknown column 'a_custom_title_index' in 'field list'] query[INSERT DELAYED INTO t_titlelist(a_char_index, a_title_index, a_endtime, a_custom_title_index) values(262, 23, 1610849460, -1)]
and i use this: 2
And i cant title on userbar any title has broken or .... ?
- cooldude - 01-10-2021
You need to add a_custom_title_index to the t_titlelis table. Also need to fix t_express_system
- dethunter12 - 01-11-2021
right click database table t_titlelist under the _db database and click design .
Modify it so it looks like the following :/monthly_2021_01/image.png.2eb7096ca278c6e722611d163d7d0e5e.png" />
- rondo157 - 01-11-2021
/*
Navicat Premium Data Transfer
Source Server : servak
Source Server Type : MySQL
Source Server Version : 50732
Source Host : localhost:3306
Source Schema : ep5_lcdbusa
Target Server Type : MySQL
Target Server Version : 50732
File Encoding : 65001
Date: 11/01/2021 08:23:27
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_titlelist
-- ----------------------------
DROP TABLE IF EXISTS `t_titlelist`;
CREATE TABLE `t_titlelist` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_title_index` int(11) NOT NULL DEFAULT 0,
`a_endtime` int(11) NOT NULL DEFAULT 0,
`a_custom_title_index` int(11) NULL DEFAULT -1,
INDEX `a_char_index`(`a_char_index`, `a_title_index`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = FIXED;
SET FOREIGN_KEY_CHECKS = 1;
- Asylum - 01-11-2021
But on client title system is not working, but this fix i already done.
I click Title on bar and nothing shown menu.
Please help me ? Its not easy to fix that fu.ck.. problem ?
- cooldude - 01-11-2021
2 hours ago, Asylum said:
But on client title system is not working, but this fix i already done.
I click Title on bar and nothing shown menu.
Please help me ? Its not easy to fix that fu.ck.. problem ?
Check your newStobm.bin files. This can happen when the sub helper is not connected
- Asylum - 01-11-2021
[Server]
Number=1
IP=192.168.40.136
Port=50401
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=127.0.0.1
DBName=2015_db
User=root
Password=
[Post DB]
IP=127.0.0.1
DBName=2015_post
User=root
Password=
[Data DB]
IP=127.0.0.1
DBName=2015_data
User=root
Password=
[Messenger Server]
IP=192.168.40.136
Port=4112
SubHelper file
Can u check ?
SYSTEM > Load TitleSystem Data
021-01-11 12:34:16,417 INFO - connected to Messenger server (192.168.40.136 : 4112)
2021-01-11 12:34:16,417 INFO - connected to Connector server (192.168.40.136 : 4006)
2021-01-11 12:34:16,417 INFO - connected to Helper server (192.168.40.136 : 3000)
2021-01-11 12:34:16,417 INFO - connected to SubHelper server (192.168.40.136 : 50401)
2021-01-11 12:34:16,417 INFO - CONNECTED 192.168.40.136 600 1 1 38