Tasho

yah your right ... my.conf was running from /usr/db/mysql ... I've added sql_mode="" and it is working. Thank you so much.

my conf is in temp/ -- i don`t think this is a problem ... I`ve edited like this : [mysqld] sql_mode="" max_connections = 4000 max_connect_errors=20000 query_cache_type=1 query_cache_limit=20M query_cache_size=256M log-slow-queries=slow.log long_query_time=2 still : Incorrect integer value: '' for column 'attrvalue0' at row 1

Hi devs, I have a problem when I want to creat a item with Admin pannel (site) ... I have this error: Incorrect integer value: '' for column 'attrvalue0' at row 1 On frebds 8.2 I didn't have this error ... What can I do?

give permision 0777 with rightclick on the db file

if you had read the other posts, you had discovered that you neet to update your system to freebds 9.2

same error here

It looks like it's not showing the currently equipped items in the slots. yes ... I tryed to delet the line from CONFIG or add 1 insted of 0 ... but still the same

HOSTNAME: channel1_1 AsyncSQL: connected to localhost (reconnect 1) CommonSQL connected Setting Locale "romania" (Path: locale/romania) Setting DB to locale latin2 AsyncSQL: connected to localhost (reconnect 1) PlayerSQL connected LogSQL connected ... EMPIRE_CHAT: 1 TRADE_EFFECT: 1 BAN_FORCE_REASON: 1 START_GOLD: 4 GLASS_ENABLE: 1 TRADE_EFFECT_EXCHANGE_THRESHOLD: 600000 BIGGER_INVENTORY: 0 ~~~> VANILLA project rev54180 <~~~ same here

I have plenty of space ... the strange part is that it works on 5.1 and not on 5.6

the only version who works is 5.1 but it has lost of errors ... when I try to install 5.6 .. the mysql won't start ... could someone please give me a solution this error is deleting players status: SYSERR: Apr 30 19:19:00 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 851101, y = 263856, z = 0, map_index = 43, exit_x = 851101, exit_y = 263856, exit_map_index = 43, hp = 10675, mp = 730, stamina = 1320, random_hp = 636, random_sp = 332, playtime = 28, level = 17, level_step = 3, st = 56, ht = 4, dx = 3, iq = 3, gold = 9533286, exp = 187681, stat_point = 1, skill_point = 0, sub_skill_point = 8, stat_reset_count = 0, ip = '79.118.69.36', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 3226, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:19:30 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 7, voice = 0, dir = 0, x = 63194, y = 167609, z = 0, map_index = 21, exit_x = 63194, exit_y = 167609, exit_map_index = 21, hp = 15064, mp = 4256, stamina = 1250, random_hp = 4264, random_sp = 1976, playtime = 198, level = 105, level_step = 0, st = 90, ht = 90, dx = 40, iq = 90, gold = 999541999, exp = 0, stat_point = 0, skill_point = 104, sub_skill_point = 46, stat_reset_count = 0, ip = '5.14.224.144', part_main = 41117, part_hair = 5005, last_play = NOW(), skill_group = 2, alignment = 405, horse_level = 31, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1399064067, horse_stamina = 200, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:19:55 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 936639, y = 234547, z = 0, map_index = 41, exit_x = 936639, exit_y = 234547, exit_map_index = 41, hp = 1192, mp = 570, stamina = 1320, random_hp = 432, random_sp = 219, playtime = 7, level = 12, level_step = 0, st = 39, ht = 4, dx = 3, iq = 3, gold = 2911042, exp = 704, stat_point = 0, skill_point = 11, sub_skill_point = 3, stat_reset_count = 0, ip = '93.115.40.87', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 5777, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399133624, horse_stamina = 30, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:20:19 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 886565, y = 287425, z = 0, map_index = 43, exit_x = 886565, exit_y = 287425, exit_map_index = 43, hp = 7169, mp = 980, stamina = 1320, random_hp = 1048, random_sp = 512, playtime = 96, level = 27, level_step = 0, st = 83, ht = 4, dx = 3, iq = 4, gold = 7477281, exp = 116726, stat_point = 0, skill_point = 0, sub_skill_point = 18, stat_reset_count = 0, ip = '93.115.41.103', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 12079, horse_level = 1, horse_riding = 0, horse_hp = 3, horse_hp_droptime = 1399128099, horse_stamina = 4, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:20:29 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 856751, y = 292175, z = 0, map_index = 43, exit_x = 856751, exit_y = 292175, exit_map_index = 43, hp = 9840, mp = 3029, stamina = 1415, random_hp = 930, random_sp = 468, playtime = 55, level = 24, level_step = 1, st = 5, ht = 3, dx = 3, iq = 74, gold = 5565253, exp = 306493, stat_point = 1, skill_point = 0, sub_skill_point = 13, stat_reset_count = 0, ip = '83.88.70.97', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8680, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131808, horse_stamina = 30, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:20:34 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 3, voice = 0, dir = 0, x = 63031, y = 166550, z = 0, map_index = 21, exit_x = 63031, exit_y = 166550, exit_map_index = 21, hp = 9032, mp = 384, stamina = 911, random_hp = 0, random_sp = 0, playtime = 36, level = 1, level_step = 0, st = 3, ht = 4, dx = 3, iq = 6, gold = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '79.118.250.5', part_main = 41124, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 20, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:20:53 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 962212, y = 249251, z = 0, map_index = 41, exit_x = 962212, exit_y = 249251, exit_map_index = 41, hp = 760, mp = 260, stamina = 1320, random_hp = 0, random_sp = 0, playtime = 35, level = 1, level_step = 2, st = 6, ht = 4, dx = 3, iq = 3, gold = 18615, exp = 150, stat_point = 2, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '86.125.110.12', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 185, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SYSERR: Apr 30 19:21:00 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 959600, y = 269700, z = 0, map_index = 41, exit_x = 959600, exit_y = 269700, exit_map_index = 41, hp = 11261, mp = 740, stamina = 1320, random_hp = 708, random_sp = 357, playtime = 35, level = 19, level_step = 2, st = 60, ht = 4, dx = 3, iq = 3, gold = 8259895, exp = 211147, stat_point = 2, skill_point = 0, sub_skill_point = 10, stat_reset_count = 0, ip = '5.61.1.90', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8275, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131878, horse_stamina = 30, horse_skill_point = 0, skill_level = '0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

thx my bad ...

oke... I did it like this : uicharacter : import ui import uiScriptLocale import app import net import dbg import snd import player import mouseModule import wndMgr import skill import playerSettingModule import quest import localeInfo import uiToolTip import constInfo import emotion import chr SHOW_ONLY_ACTIVE_SKILL = FALSE SHOW_LIMIT_SUPPORT_SKILL_LIST = [] HIDE_SUPPORT_SKILL_POINT = TRUE SHOW_LIMIT_SUPPORT_SKILL_LIST = [121, 122, 123, 124, 126, 127, 129, 128, 131, 137, 138, 139, 140] FACE_IMAGE_DICT = { playerSettingModule.RACE_WARRIOR_M : "icon/face/warrior_m.tga", playerSettingModule.RACE_WARRIOR_W : "icon/face/warrior_w.tga", playerSettingModule.RACE_ASSASSIN_M : "icon/face/assassin_m.tga", playerSettingModule.RACE_ASSASSIN_W : "icon/face/assassin_w.tga", playerSettingModule.RACE_SURA_M : "icon/face/sura_m.tga", playerSettingModule.RACE_SURA_W : "icon/face/sura_w.tga", playerSettingModule.RACE_SHAMAN_M : "icon/face/shaman_m.tga", playerSettingModule.RACE_SHAMAN_W : "icon/face/shaman_w.tga", } class CharacterWindow(ui.ScriptWindow): ACTIVE_PAGE_SLOT_COUNT = 8 SUPPORT_PAGE_SLOT_COUNT = 12 PAGE_SLOT_COUNT = 12 PAGE_HORSE = 2 SKILL_GROUP_NAME_DICT = { playerSettingModule.JOB_WARRIOR : { 1 : localeInfo.SKILL_GROUP_WARRIOR_1, 2 : localeInfo.SKILL_GROUP_WARRIOR_2, }, playerSettingModule.JOB_ASSASSIN : { 1 : localeInfo.SKILL_GROUP_ASSASSIN_1, 2 : localeInfo.SKILL_GROUP_ASSASSIN_2, }, playerSettingModule.JOB_SURA : { 1 : localeInfo.SKILL_GROUP_SURA_1, 2 : localeInfo.SKILL_GROUP_SURA_2, }, playerSettingModule.JOB_SHAMAN : { 1 : localeInfo.SKILL_GROUP_SHAMAN_1, 2 : localeInfo.SKILL_GROUP_SHAMAN_2, }, } STAT_DESCRIPTION = { "HTH" : localeInfo.STAT_TOOLTIP_CON, "INT" : localeInfo.STAT_TOOLTIP_INT, "STR" : localeInfo.STAT_TOOLTIP_STR, "DEX" : localeInfo.STAT_TOOLTIP_DEX, } STAT_MINUS_DESCRIPTION = localeInfo.STAT_MINUS_DESCRIPTION def unsigned32(n): return n & 0xFFFFFFFFL and: def RefreshStatus(self): if self.isLoaded==0: return try: self.GetChild("Level_Value").SetText(str(player.GetStatus(player.LEVEL))) self.GetChild("Exp_Value").SetText(str(unsigned32(player.GetEXP()))) self.GetChild("RestExp_Value").SetText(str(unsigned32(player.GetStatus(player.NEXT_EXP)) - unsigned32(player.GetStatus(player.EXP)))) self.GetChild("HP_Value").SetText(str(player.GetStatus(player.HP)) + '/' + str(player.GetStatus(player.MAX_HP))) self.GetChild("SP_Value").SetText(str(player.GetStatus(player.SP)) + '/' + str(player.GetStatus(player.MAX_SP))) self.GetChild("STR_Value").SetText(str(player.GetStatus(player.ST))) self.GetChild("DEX_Value").SetText(str(player.GetStatus(player.DX))) self.GetChild("HTH_Value").SetText(str(player.GetStatus(player.HT))) self.GetChild("INT_Value").SetText(str(player.GetStatus(player.IQ))) self.GetChild("ATT_Value").SetText(self.__GetTotalAtkText()) self.GetChild("DEF_Value").SetText(self.__GetTotalDefText()) self.GetChild("MATT_Value").SetText(self.__GetTotalMagAtkText()) self.GetChild("MDEF_Value").SetText(str(player.GetStatus(player.MAG_DEF))) self.GetChild("ASPD_Value").SetText(str(player.GetStatus(player.ATT_SPEED))) self.GetChild("MSPD_Value").SetText(str(player.GetStatus(player.MOVING_SPEED))) self.GetChild("CSPD_Value").SetText(str(player.GetStatus(player.CASTING_SPEED))) self.GetChild("ER_Value").SetText(str(player.GetStatus(player.EVADE_RATE))) and I get status : 999 like this: where is the problem?

were should I put this? : def unsigned32(n): return n & 0xFFFFFFFFL

I use 52k (vanilla) and yes database runs with .txt SOLVED!

you don't have the libs update freebds top 9.2

Hi, I have a strange problem ... I`ve added to shop add bonus and switch bonus ... I've edited the price from item_proto, then I rebooted the server like 5 timpes but same strange problem : 71084 Àç°æºñ¼­ ITEM_USE USE_CHANGE_ATTRIBUTE 1 ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_MYSHOP ITEM_STACKABLE | LOG NONE NONE 200 200 0 0 0 LIMIT_NONE 0 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 0 0 0 0 0 0 0 0 0 71085 Àç°¡ºñ¼­ ITEM_USE USE_ADD_ATTRIBUTE 1 ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_MYSHOP ITEM_STACKABLE | LOG NONE NONE 300 300 0 0 0 LIMIT_NONE 0 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 0 0 0 0 0 0 0 0 0 same with the costumes ... I've edited the thime from 1 day to 7 days but stillit wont change the time. 41123 ???? ???? ITEM_COSTUME COSTUME_BODY 2 ANTI_FEMALE | ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_STACK | ANTI_MYSHOP| ANTI_SAFEBOX NONE NONE NONE 0 0 0 0 0 REAL_TIME 604800 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 5 0 0 40064 0 0 0 0 0 41124 ???? ???? ITEM_COSTUME COSTUME_BODY 2 ANTI_MALE | ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_STACK | ANTI_MYSHOP| ANTI_SAFEBOX NONE NONE NONE 0 0 0 0 0 REAL_TIME 604800 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 5 0 0 40064 0 0 0 0 0 Any ideas?

The query hasn't refine_set 530. 11299 Èæ½Åö°©+9 ITEM_ARMOR ARMOR_BODY 2 ANTI_ASSASSIN | ANTI_SURA | ANTI_MUDANG | ANTI_SELL ITEM_TUNABLE WEAR_BODY NONE 120000 0 12010 530 15 LEVEL 70 LIMIT_NONE 0 APPLY_MOV_SPEED -6 APPLY_RESIST_MAGIC 20 APPLY_NONE 0 0 90 0 12 0 27 100 3 0 ok .. thanks, I did the same thing ... but I edited and other file... stupid me... thanks.

I still have a prob that I dont manage to repair ... when I whant to evolve from Black Steel plate to Pos ... or from battle to Sirius ... it just won`t work ... I have all I need in refine_proto, item_proto : item_proto: 11299 Èæ½Åö°©+9 ITEM_ARMOR ARMOR_BODY 2 ANTI_ASSASSIN | ANTI_SURA | ANTI_MUDANG | ANTI_SELL ITEM_TUNABLE WEAR_BODY NONE 120000 0 12010 800 15 LEVEL 70 LIMIT_NONE 0 APPLY_MOV_SPEED -6 APPLY_RESIST_MAGIC 20 APPLY_NONE 0 0 90 0 12 0 27 100 3 0 refine_proto: INSERT INTO `refine_proto` VALUES (530, 71123, 3, 71129, 4, 0, 0, 0, 0, 0, 0, 2000000, 0, 0, 100); syserr: SYSERR: Apr 26 12:46:23 :: RefineInformation: RefineInformation NOT GET REFINE SET 530

Hi devs, I have a problem ... on mai server level_max is 105 ... now I'm useing vanilla core and it haves this problem: I set in my CONFIG this: MAX_LEVEL_STATUS: 105 MAX_LEVEL: 105 But still it gets the same error...

for me works just fine My problem is this: I set in my CONFIG : MAX_LEVEL_STATUS: 105 MAX_LEVEL: 105 And when I give myself lvl 105 negative status apear :

root@metin:~ # mysqld_safe start 140424 23:43:18 mysqld_safe Logging to '/var/db/mysql/metin.hostpay.ro.err'. 140424 23:43:18 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 140424 23:43:20 mysqld_safe mysqld from pid file /var/db/mysql/metin.hostpay.ro.pid ended what I do next?

I fallowd this tutorial : Install MySQL 7. Go to the port for the MySQL server: cd /usr/ports/databases/mysql56-server make install clean 8. Add the following line to /etc/rc.conf: echo 'mysql_enable="YES"' >> /etc/rc.conf 9. And start the mysql server: /usr/local/etc/rc.d/mysql-server start 10. Then set a password for the MySQL root user: /usr/local/bin/mysqladmin -u root password 'your-password' ... but the same result...

root@metin:~ # cd /usr/ports/databases/mysql51-server root@metin:/usr/ports/databases/mysql51-server # make install clean ===> mysql51-server-5.1.73_1 cannot install: MySQL versions mismatch: mysql56-client is installed and wanted version is mysql51-client. *** [install] Error code 1

140126 21:31:55 mysqld ended 140126 21:32:34 mysqld started 140126 21:32:35 InnoDB: Started; log sequence number 0 1595695 140126 21:32:35 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.92' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.92 140126 21:42:14 [Note] /usr/local/libexec/mysqld: Normal shutdown 140126 21:42:39 InnoDB: Starting shutdown... 140126 21:42:45 InnoDB: Shutdown completed; log sequence number 0 1595695 140126 21:42:45 [Note] /usr/local/libexec/mysqld: Shutdown complete 140126 21:42:47 mysqld ended 140126 21:42:48 mysqld started 140126 21:42:53 InnoDB: Started; log sequence number 0 1595695 140126 21:42:54 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.92' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.92 140126 21:43:06 [Note] /usr/local/libexec/mysqld: Normal shutdown 140126 21:43:08 InnoDB: Starting shutdown... 140126 21:43:08 InnoDB: Shutdown completed; log sequence number 0 1595695 140126 21:43:08 [Note] /usr/local/libexec/mysqld: Shutdown complete 140126 21:43:08 mysqld ended

top : PID USERNAME THR PRI NICE SIZE RES STATE TIME WCPU COMMAND 984 root 1 20 0 13096K 4612K select 0:00 0.00% sshd 1038 root 1 20 0 15852K 5040K select 0:00 0.00% sshd 1619 root 1 20 0 15852K 5072K select 0:00 0.00% sshd 609 root 1 20 0 9544K 1564K select 0:00 0.00% syslogd 987 root 1 20 0 11296K 4132K select 0:00 0.00% sendmail 1624 root 1 20 0 10864K 2900K pause 0:00 0.00% csh 1041 root 1 20 0 9852K 2040K ttyin 0:00 0.00% sh 994 root 1 20 0 9584K 1668K nanslp 0:00 0.00% cron 2032 root 1 20 0 9872K 2104K RUN 0:00 0.00% top 1029 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 1030 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 1031 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 1033 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 1028 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 990 smmsp 1 20 0 11296K 4140K pause 0:00 0.00% sendmail 1034 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty 1035 root 1 52 0 9544K 1524K ttyin 0:00 0.00% getty my.cnf : #Mysql configuration [mysqld] user=root port=3307 socket=/tmp/mysql.sock skip-locking key_buffer=16K max_allowed_packet=8M table_cache=4 sort_buffer_size=64K read_buffer_size=256K read_rnd_buffer_size=256K net_buffer_length=2K thread_stack=128K language=/usr/local/share/mysql/romanian