Jump to content
metin2dev
Ekstasia2
  • 0
tristano98

open Won System Problem (inventory windows)

Question

Hello, i'm have add won system in my FS  but have this syserr :

This Fixed.... 

Spoiler

SYSERR: Aug 18 02:50:12 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=31278' at line 1 (query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)
SYSERR: Aug 18 02:50:12 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

 

New Error in Inventory Windows 

Screenshot_4.png

Share this post


Link to post
Share on other sites

10 answers to this question

Recommended Posts

  • 0

Hello,
problem in Player.player. Player table crashed
Right syntax
 

Quote

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(24) NOT NULL DEFAULT 'NONAME',
  `job` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `voice` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dir` tinyint(2) NOT NULL DEFAULT '0',
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  `z` int(11) NOT NULL DEFAULT '0',
  `map_index` int(11) NOT NULL DEFAULT '0',
  `exit_x` int(11) NOT NULL DEFAULT '0',
  `exit_y` int(11) NOT NULL DEFAULT '0',
  `exit_map_index` int(11) NOT NULL DEFAULT '0',
  `hp` smallint(4) NOT NULL DEFAULT '0',
  `mp` smallint(4) NOT NULL DEFAULT '0',
  `stamina` smallint(6) NOT NULL DEFAULT '0',
  `random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',
  `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',
  `playtime` int(11) NOT NULL DEFAULT '0',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `level_step` tinyint(1) NOT NULL DEFAULT '0',
  `st` smallint(3) NOT NULL DEFAULT '0',
  `ht` smallint(3) NOT NULL DEFAULT '0',
  `dx` smallint(3) NOT NULL DEFAULT '0',
  `iq` smallint(3) NOT NULL DEFAULT '0',
  `exp` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `stat_point` smallint(3) NOT NULL DEFAULT '0',
  `skill_point` smallint(3) NOT NULL DEFAULT '0',
  `quickslot` tinyblob NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `part_main` smallint(6) NOT NULL DEFAULT '0',
  `part_base` tinyint(4) NOT NULL DEFAULT '0',
  `part_hair` smallint(4) NOT NULL DEFAULT '0',
  `skill_group` tinyint(4) NOT NULL DEFAULT '0',
  `skill_level` blob NOT NULL,
  `alignment` int(11) NOT NULL DEFAULT '0',
  `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `change_name` tinyint(1) NOT NULL DEFAULT '0',
  `mobile` varchar(24) DEFAULT NULL,
  `sub_skill_point` smallint(3) NOT NULL DEFAULT '0',
  `stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',
  `horse_hp` smallint(4) NOT NULL DEFAULT '0',
  `horse_stamina` smallint(4) NOT NULL DEFAULT '0',
  `horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',
  `horse_riding` tinyint(1) NOT NULL DEFAULT '0',
  `horse_skill_point` smallint(3) NOT NULL DEFAULT '0',
  `bossazrail` int(11) NOT NULL DEFAULT '0',
  `bosscol` int(11) NOT NULL DEFAULT '0',
  `bossdokuz` int(11) NOT NULL DEFAULT '0',
  `bossalev` int(11) NOT NULL DEFAULT '0',
  `jatekos_nev` varchar(24) CHARACTER SET ascii NOT NULL DEFAULT 'NONAME',
  `statusz` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '0',
  `szint` varchar(20) CHARACTER SET ascii NOT NULL DEFAULT 'Inaktiv',
  `lejarati_ido` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `account_id_idx` (`account_id`),
  KEY `name_idx` (`name`),
  KEY `jatekos_nev_idx` (`jatekos_nev`) USING BTREE,
  KEY `lejarati_ido` (`lejarati_ido`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=68753 DEFAULT CHARSET=latin1;

jatekos_nev status szint lejarati ido  = my job for upgraded vip sys just delete fields

 

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, [007]DawisHU said:

Hello,
problem in Player.player. Player table crashed
Right syntax
 

 

 

not work ....  i'm login, select character and the loading bar is blocked....  not syserr client

 

Share this post


Link to post
Share on other sites
  • 0
Just now, tristano98 said:

 

not work ....  i'm login, select character and the loading bar is blocked....  not syserr client

 

check mysql player table empty u need to create new char

and old char PID give to new

easier : create new account

Share this post


Link to post
Share on other sites
  • 0

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

  • Thanks 1

Share this post


Link to post
Share on other sites
  • 0
23 hours ago, sxvoyz said:

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

fix, thanks 

Share this post


Link to post
Share on other sites
  • 0
On Monday, August 21, 2017 at 4:37 PM, sxvoyz said:

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

Not good 

In quest local coins = insert here select querry.

And quest cmdchat(""..coins.."")

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×