Just a suggestion to add to the next revision of the "Currency" vendor:
Thottbot World of Warcraft: Arcane Rune - Arcane Rune (Scryer Currency)
Thottbot World of Warcraft: Holy Dust - Holy Dust (Aldor Currency)
Printable View
Just a suggestion to add to the next revision of the "Currency" vendor:
Thottbot World of Warcraft: Arcane Rune - Arcane Rune (Scryer Currency)
Thottbot World of Warcraft: Holy Dust - Holy Dust (Aldor Currency)
The vendors work great, however the items they sell dont. I get "Item not found". I'm guessing this is becuase whenever I try to execute the rev7 missing items to my antrix database I get the error below before it finishes.
I admit to being a antrix noob so its possiable I could be doing incorrectly. I tried a fresh install of everything so I dont know what to do next.Quote:
There was an error while executing a query.
The query and the error message has been logged at:
C:\Program Files\SQLyog Community\sqlyog.err.
Please click on "Open Error File..." to open the error file.
Thanks in advance
You have to actually click open to open the error file...
I find that this code does not affect anything in the db, i get, "affected 0 rows"Quote:
Originally Posted by channel_49
This might be tied to the problem in which i can only buy from Tier 1-3 vendors with gold, the rest require tokens.
They're suppose to require tokens, go look on wowhead.
And the tokens are in the currency vendor.
Yah I know.... The error is alot a text and was hoping you knew the prob with-out having to read trough it all.Quote:
Originally Posted by channel_49
Quote:
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-13 20:04:59
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-13 20:08:19
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
antrixaccounts
Error occured at:2007-07-13 20:40:06
Line no.:2
Error Code: 1064 - 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 'antrixaccounts' at line 1
Query:
antrixaccounts
Error occured at:2007-07-13 21:52:59
Line no.:2
Error Code: 1064 - 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 'antrixaccounts' at line 1
Query:
CREATE TABLE `npc_monstersay` (
`entry` int(11) NOT NULL,
`event` int(11) NOT NULL,
`chance` float NOT NULL,
`language` int(11) NOT NULL,
`type` int(11) NOT NULL,
`monstername` longtext,
`text0` longtext,
`text1` longtext,
`text2` longtext,
`text3` longtext,
`text4` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-14 19:36:44
Line no.:13
Error Code: 1050 - Table 'npc_monstersay' already exists
Query:
CREATE TABLE `worldmap_info` (
`mapid` int(10) NOT NULL default '0',
`screenid` int(10) default '0',
`type` int(10) default '0',
`maxplayers` int(10) default '0',
`minlevel` int(11) unsigned zerofill default '00000000001',
`repopx` float default '0',
`repopy` float default '0',
`repopz` float default '0',
`repopmapid` int(5) unsigned zerofill default '00000',
`area_name` varchar(100) default '0',
`flags` int(11) unsigned NOT NULL default '0',
`cooldown` int(15) NOT NULL default '0',
`lvl_mod_a` int(11) NOT NULL default '0',
PRIMARY KEY (`mapid`)
) TYPE=MyISAM
Error occured at:2007-07-14 19:36:57
Line no.:17
Error Code: 1050 - Table 'worldmap_info' already exists
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 06:32:07
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 06:32:14
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 06:32:17
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
CREATE TABLE `characters` (
`guid` int(11) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`banReason` varchar(50) NOT NULL,
`timestamp` text NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(1) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` longtext NOT NULL,
`deathstate` int(2) NOT NULL default '0',
`TalentResetTimes` int(3) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) unsigned NOT NULL default '0',
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL default '0',
`entrypointmap` int(4) NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) NOT NULL default '0',
`taxi_path` int(10) NOT NULL default '0',
`taxi_lastnode` int(10) NOT NULL default '0',
`taxi_mountid` int(10) NOT NULL default '0',
`transporter` int(10) NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:04:27
Line no.:269
Error Code: 1064 - 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 'flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells`' at line 68
Query:
CREATE TABLE `characters` (
`guid` int(11) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`banReason` varchar(50) NOT NULL,
`timestamp` text NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(1) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` longtext NOT NULL,
`deathstate` int(2) NOT NULL default '0',
`TalentResetTimes` int(3) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) unsigned NOT NULL default '0',
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL default '0',
`entrypointmap` int(4) NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) NOT NULL default '0',
`taxi_path` int(10) NOT NULL default '0',
`taxi_lastnode` int(10) NOT NULL default '0',
`taxi_mountid` int(10) NOT NULL default '0',
`transporter` int(10) NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:51:39
Line no.:269
Error Code: 1064 - 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 'flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells`' at line 68
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:56:51
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:56:56
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:57:36
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:58:04
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:58:39
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 16:58:54
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
Unable to establish connection
Error occured at:2007-07-15 17:26:19
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)
Query:
Unable to establish connection
Error occured at:2007-07-15 17:26:29
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)
Query:
Unable to establish connection
Error occured at:2007-07-15 17:26:37
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)
Query:
Unable to establish connection
Error occured at:2007-07-15 17:27:41
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-15 18:32:11
Line no.:1
Error Code: 1146 - Table 'lll.items' doesn't exist
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 18:32:58
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 18:37:27
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-15 18:54:40
Line no.:1
Error Code: 1146 - Table 'lll.items' doesn't exist
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 18:55:26
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 18:55:39
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 18:56:19
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-15 19:00:20
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 19:07:40
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-15 19:07:52
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-15 19:07:58
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-15 19:19:03
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-16 06:40:59
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-16 06:41:29
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-16 10:26:31
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
i will have error whyle step 3
[Err] 1046 - No database selected [Err] DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'; [Msg] Finished - Unsuccessfully --------------------------------------------------
Quote:
Originally Posted by olenjan
You dont have creature tables? Mangos perhaps?
Quote:
Originally Posted by vr4spd
First of all, it says you dont have items table, second it says that theres a duplicate entry when trying to insert into items while theres no items table. I suggest a clean install of TNDB rev7, cuz your tables seems mighty messed up.
i have a very clean install of rev7, but i have no vendors table ??? pleasw can anyone help me
do i just CREATE a new table called vendors ???
Ask someone to extract you one, my own vendor tables are for rev8 and not released yet. So cant give you mine.
Thanks for the timely response. Clean install of everything but im still getting the duplicate item entry error.Quote:
Originally Posted by channel_49
Something must be wrong in your db or its configuration if you cant even execute an item query to it.
Thanks for the help and patience channel. I'm not really sure what the root of the problem was, but I deleted the missing items as well as the DB re-downloaded and re-installed fixed the prob. Im guess one of the files was currupt somewhere....Quote:
Originally Posted by channel_49
-Nate