10.05.2013, 23:20
Hello Guys , i had a probleme with my SQL!
When i login and /createvehicle [ID] [Model] [Color etc...]
It spawn, but when i relog , i can't find it anymore Check out !
When i login and /createvehicle [ID] [Model] [Color etc...]
It spawn, but when i relog , i can't find it anymore Check out !
Код:
[00:19:40] [join] Steve_McGarrett has joined the server (0:127.0.0.1) [00:19:47] Steve McGarrett has logged in. [00:20:35] Steve McGarrett (0) saving their 490 (slot 0)... [00:20:35] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:20:35] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:20:35] Dumping query from 2013/5/10 (0:20:35) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:20:35] UPDATE `accounts` SET `pv0PosX` = 1262.288208, `pv0PosY` = -726.299682, `pv0PosZ` = 94.058601, `pv0PosAngle` = 266.485687, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:21:18] Steve McGarrett (0) saving their 490 (slot 0)... [00:21:18] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:21:18] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:21:18] Dumping query from 2013/5/10 (0:21:18) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:21:18] UPDATE `accounts` SET `pv0PosX` = 1262.288208, `pv0PosY` = -726.299682, `pv0PosZ` = 94.058601, `pv0PosAngle` = 266.485687, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:21:22] Steve McGarrett (0) saving their 490 (slot 0)... [00:21:22] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:21:22] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:21:22] Dumping query from 2013/5/10 (0:21:22) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:21:22] UPDATE `accounts` SET `pv0PosX` = 1262.288208, `pv0PosY` = -726.299682, `pv0PosZ` = 94.058601, `pv0PosAngle` = 266.485687, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:21:30] Steve McGarrett (0) saving their 490 (slot 0)... [00:21:30] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:21:30] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:21:30] Dumping query from 2013/5/10 (0:21:30) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:21:30] UPDATE `accounts` SET `pv0PosX` = 1262.288208, `pv0PosY` = -726.299682, `pv0PosZ` = 94.058601, `pv0PosAngle` = 266.485687, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:21:34] Steve McGarrett (0) saving their 490 (slot 0)... [00:21:34] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:21:34] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:21:34] Dumping query from 2013/5/10 (0:21:34) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:21:34] UPDATE `accounts` SET `pv0PosX` = 1262.288208, `pv0PosY` = -726.299682, `pv0PosZ` = 94.058601, `pv0PosAngle` = 266.485687, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:23:02] Steve McGarrett (0) saving their 490 (slot 0)... [00:23:02] Steve McGarrett (0) saving their 490 (slot 0)... [00:23:02] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:23:02] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:23:02] Dumping query from 2013/5/10 (0:23:2) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:23:02] UPDATE `accounts` SET `pv0PosX` = 1283.562622, `pv0PosY` = -721.188720, `pv0PosZ` = 93.417541, `pv0PosAngle` = 290.832946, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:23:02] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [00:23:02] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:23:02] Dumping query from 2013/5/10 (0:23:2) Description: Unknown column 'pv0Plate' in 'field list' (index 0). Query: [00:23:02] UPDATE `accounts` SET `pv0PosX` = 1283.562622, `pv0PosY` = -721.188720, `pv0PosZ` = 93.417541, `pv0PosAngle` = 290.832946, `pv0ModelId` = 490, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 1, `pv0Price` = 2000000, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0Lock` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 100.000000, `pv0Impound` = 0, `pv0Disabled` = 0, `pv0Plate` = '', `pv0Ticket` = 0, `pv0Restricted` = 0, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0 WHERE `id` = '3' [00:49:01] Account Saving Complete [00:54:13] [part] Steve_McGarrett has left the server (0:1)
