[RenovanZ]

Hi, I have converted my script from Y_INI to MySQL, and I tried to run the server, when I have run the server, I logged in, and the samp-server.exe show this

pawn Код:

[10/02/2013 08:22:13] [join] Test_MySQL has joined the server (0:10.76.129.204)
[10/02/2013 08:22:18] [MySQL] Query Error - (Thread: 3) (ExtraID: 0) (ErrorID: 1146)
[10/02/2013 08:22:18] [MySQL] Check /logs/querydump.log to review the query that threw the error.

How to fix it ? Help Please ))

[Memoryz]

Post this file:

/logs/querydump.log

[RenovanZ]

This is

pawn Код:

[2013/2/9 - 21:37:49] SELECT Username from accounts WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:37:49] INSERT INTO `accounts` (`Username`) VALUES ('Gentarou_Kiyozimu')
[2013/2/9 - 21:37:52] SELECT Username from accounts WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:38:4] UPDATE `accounts` SET `Online` = 0 WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:38:46] SELECT Username from accounts WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:38:46] INSERT INTO `accounts` (`Username`) VALUES ('Gentarou_Kiyozimu')
[2013/2/9 - 21:38:46] UPDATE `accounts` SET `Key`='fckz}–ѓ€ЌЏЏ', `Level`='7', `AdminLevel`='99999', `Band`='0', `PermBand`='0', `Warnings`='0', `Disabled`=[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `FMember`='255', `Rank`='6', `DetSkill`='0', `SexSkill`='0', `BoxSkill`='0', `LawSkill`='0', `MechSkill`='500'[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `GunAmmo1`='0', `Gun2`='0', `GunAmmo2`='0', `Gun3`='0', `GunAmmo3`='0', `Gun4`='0', `GunAmmo4`='0', `Gun5`='0'[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `NewMuted`='0', `NewMutedTotal`='0', `AdMuted`='0', `AdMutedTotal`='0', `HelpMute`='0', `SPos_x`='1456.2', `SP[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pv0Fuel`='100.00', `pv0Impound`='0', `pv0Neon`='0', `pv0NumPlate`='GK 002 KZ', `pv0WeaponAmmo0`='0', `pv0Weap[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pv1WeaponAmmo0`='48', `pv1WeaponAmmo1`='0', `pv1WeaponAmmo2`='0', `pv1Mod0`='0', `pv1Mod1`='0', `pv1Mod2`='0'[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pv2Mod0`='0', `pv2Mod1`='0', `pv2Mod2`='0', `pv2Mod3`='0', `pv2Mod4`='0', `pv2Mod5`='1010', `pv2Mod6`='0', `p[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pv3Mod5`='1010', `pv3Mod6`='0', `pv3Mod7`='1080', `pv3Mod8`='0', `pv3Mod9`='1087', `pv3Mod10`='0', `pv3Mod11`[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pv4Mod9`='0', `pv4Mod10`='0', `pv4Mod11`='0', `pv4Mod12`='0', `pv4Mod13`='0', `pv4Mod14`='0', `pt0ModelID`='1[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pt2ScaleY`='1.00000', `pt2ScaleZ`='1.00000', `pt3ModelID`='18914', `pt3Bone`='2', `pt3PosX`='0.10000', `pt3Po[2013/2/9 - 21:38:46] UPDATE `accounts` SET  `pt6ModelID`='18917', `pt6Bone`='2', `pt6PosX`='0.10000', `pt6PosY`='0.03500', `pt6PosZ`='0.00000', `pt6RotX`=[2013/2/9 - 21:38:47] UPDATE `accounts` SET  `pt9PosY`='0.03500', `pt9PosZ`='0.00000', `pt9RotX`='90.00000', `pt9RotY`='180.00000', `pt9RotZ`='90.00000', `[2013/2/9 - 21:38:47] UPDATE `accounts` SET  `pt12PosZ`='0.00000', `pt12RotX`='0.00000', `pt12RotY`='0.00000', `pt12RotZ`='0.00000', `pt12ScaleX`='1.00000'[2013/2/9 - 21:38:47] UPDATE `accounts` SET  `PrisonReason`='[OOC][JAIL] Minta Gen Gua Turutin', `Flag`='', `TaxiLicense`='0', `TicketTime`='0', `Screwdriv[2013/2/9 - 21:38:47] UPDATE `accounts` SET  `KillLog6`='(13:21:38) Killed Alexander Davidson with ', `KillLog7`='(14:54:11) Kokom Radit killed me with Rif[2013/2/9 - 21:38:47] UPDATE `accounts` SET  `FreezeBank`='0', `BizID`='0', `Hunger`='0.000000', `Mask`='1', `MaskNumber`='555', `Bladder`='0.000000', `Ene[2013/2/9 - 21:38:50] SELECT Username from accounts WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:42:10] UPDATE `accounts` SET `Online` = 0 WHERE Username = 'Gentarou_Kiyozimu'
[2013/2/9 - 21:42:57] SELECT Username from accounts WHERE Username = 'Test_MySQL'
[2013/2/9 - 21:52:58] SELECT Username from accounts WHERE Username = 'Test_MySQL'
[2013/2/9 - 22:11:40] SELECT Username from accounts WHERE Username = 'Test_MySQL'
[2013/2/9 - 22:13:8] UPDATE `accounts` SET `Online` = 0 WHERE Username = 'Test_MySQL'
[2013/2/10 - 7:56:42] SELECT Username from accounts WHERE Username = 'Test_MySQL'
[2013/2/10 - 7:56:56] UPDATE `accounts` SET `Online` = 0 WHERE Username = 'Test_MySQL'
[2013/2/10 - 8:22:18] SELECT Username from accounts WHERE Username = 'Test_MySQL'

[Memoryz]

Well this query:

Код:

SELECT Username from accounts WHERE Username = 'Test_MySQL'

Is pointless, did you mean to do:

Код:

SELECT password from accounts WHERE Username = 'Test_MySQL'

[RenovanZ]

Then I should change

Код:

SELECT Username from accounts WHERE Username = 'Test_MySQL'

to

Код:

SELECT password from accounts WHERE Username = 'Test_MySQL'

Is just that ?
Sorry Im newbie on MySQL