Zer
15-12-2007, 10:47 PM
these are errors i got during the day while uploading with the "old" client, the 1st one is a repost from the version not supported thread
15.12.2007 10:13:47 | Upload started
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '17422' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '17422:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Horde Banner'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '17422' AND `F_ITEMRA' at line 1;
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBLOC select for exact; SELECT * FROM `T_GAMEOBJECT_LOCATION` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND `F_AREA_ID` = '2597' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' AND `F_CONT_ID` = '-1' AND `F_ZONE_ID` = '-1' AND F_TIMES_SEEN = -1; 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 'Horde Banner'' AND `F_AREA_ID` = '2597' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' at line 1;
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBDAT select for exact; SELECT * FROM `T_GAMEOBJECT_DATA` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_MONEY_MIN` = IF(F_MONEY_MIN>0,IF('679'>0,LEAST(F_MONEY_MIN,'679 '),F_MONEY_MIN),'679') AND `F_MONEY_MAX` = GREATEST(F_MONEY_MAX,'679') AND `F_MONEY_COUNT` = `F_MONEY_COUNT` + 1 AND `F_MONEY_SUM` = `F_MONEY_SUM` + 679; 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 'Horde Banner'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_' at line 1;
15.12.2007 10:14:36 | Upload finished Successfully (Duration : 00:00:53)
15.12.2007 22:38:35 | Upload started
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '27461' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '27461:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '27461' ' at line 1;
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '29434' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '29434:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '29434' ' at line 1;
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBLOC select for exact; SELECT * FROM `T_GAMEOBJECT_LOCATION` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_AREA_ID` = '3562' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' AND `F_CONT_ID` = '-1' AND `F_ZONE_ID` = '-1' AND F_TIMES_SEEN = -1; 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 'Reinforced Fel Iron Chest'' AND `F_AREA_ID` = '3562' AND `F_XCOORD` = '0' AND `F' at line 1;
15.12.2007 22:39:46 | NO || UTF-8,UTF-8,UTF-8 || Failed OBDAT select for exact; SELECT * FROM `T_GAMEOBJECT_DATA` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_MONEY_MIN` = IF(F_MONEY_MIN>0,IF('0'>0,LEAST(F_MONEY_MIN,'0'),F_MONEY_MIN),'0') AND `F_MONEY_MAX` = GREATEST(F_MONEY_MAX,'0') AND `F_MONEY_COUNT` = `F_MONEY_COUNT` + 0 AND `F_MONEY_SUM` = `F_MONEY_SUM` + 0; 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 'Reinforced Fel Iron Chest'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` =' at line 1;
15.12.2007 22:39:46 | Upload finished Successfully (Duration : 00:01:19)
15.12.2007 10:13:47 | Upload started
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '17422' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '17422:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Horde Banner'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '17422' AND `F_ITEMRA' at line 1;
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBLOC select for exact; SELECT * FROM `T_GAMEOBJECT_LOCATION` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND `F_AREA_ID` = '2597' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' AND `F_CONT_ID` = '-1' AND `F_ZONE_ID` = '-1' AND F_TIMES_SEEN = -1; 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 'Horde Banner'' AND `F_AREA_ID` = '2597' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' at line 1;
15.12.2007 10:14:36 | NO || UTF-8,UTF-8,UTF-8 || Failed OBDAT select for exact; SELECT * FROM `T_GAMEOBJECT_DATA` WHERE `F_OBJECT_ID` = ''Horde Banner'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_MONEY_MIN` = IF(F_MONEY_MIN>0,IF('679'>0,LEAST(F_MONEY_MIN,'679 '),F_MONEY_MIN),'679') AND `F_MONEY_MAX` = GREATEST(F_MONEY_MAX,'679') AND `F_MONEY_COUNT` = `F_MONEY_COUNT` + 1 AND `F_MONEY_SUM` = `F_MONEY_SUM` + 679; 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 'Horde Banner'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_' at line 1;
15.12.2007 10:14:36 | Upload finished Successfully (Duration : 00:00:53)
15.12.2007 22:38:35 | Upload started
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '27461' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '27461:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '27461' ' at line 1;
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBITM select for exact; SELECT * FROM `T_GAMEOBJECT_ITEM` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '29434' AND `F_ITEMRANDOMPROPERTIES_ID` = '0' AND `F_GEM01_ITEM_ID` = '0' AND `F_GEM02_ITEM_ID` = '0' AND `F_GEM03_ITEM_ID` = '0' AND `F_GEM04_ITEM_ID` = '0' AND ( `F_UNIQUE_ID` = '0' OR `F_UNIQUE_ID` = '0') AND `F_ITEMLINK` = '29434:0:0:0:0:0:0:0' AND `F_TIMES_OBTAINED` = `F_TIMES_OBTAINED` + 1; 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 'Reinforced Fel Iron Chest'' AND `F_LOOTTYPE_ID` = '5' AND `F_ITEM_ID` = '29434' ' at line 1;
15.12.2007 22:39:45 | NO || UTF-8,UTF-8,UTF-8 || Failed OBLOC select for exact; SELECT * FROM `T_GAMEOBJECT_LOCATION` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND `F_AREA_ID` = '3562' AND `F_XCOORD` = '0' AND `F_YCOORD` = '0' AND `F_CONT_ID` = '-1' AND `F_ZONE_ID` = '-1' AND F_TIMES_SEEN = -1; 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 'Reinforced Fel Iron Chest'' AND `F_AREA_ID` = '3562' AND `F_XCOORD` = '0' AND `F' at line 1;
15.12.2007 22:39:46 | NO || UTF-8,UTF-8,UTF-8 || Failed OBDAT select for exact; SELECT * FROM `T_GAMEOBJECT_DATA` WHERE `F_OBJECT_ID` = ''Reinforced Fel Iron Chest'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` = '0') AND `F_MONEY_MIN` = IF(F_MONEY_MIN>0,IF('0'>0,LEAST(F_MONEY_MIN,'0'),F_MONEY_MIN),'0') AND `F_MONEY_MAX` = GREATEST(F_MONEY_MAX,'0') AND `F_MONEY_COUNT` = `F_MONEY_COUNT` + 0 AND `F_MONEY_SUM` = `F_MONEY_SUM` + 0; 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 'Reinforced Fel Iron Chest'' AND ( `F_DIFFICULTY_ID` = '2' OR `F_DIFFICULTY_ID` =' at line 1;
15.12.2007 22:39:46 | Upload finished Successfully (Duration : 00:01:19)