Help Title

[Asylum]

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]

You need to add a_custom_title_index to the t_titlelis table. Also need to fix t_express_system

[dethunter12]

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]

/*
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]

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]

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]

[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