Shopping mall with AC-Web repack? menu

User Tag List

Results 1 to 6 of 6
  1. #1
    blah7's Avatar Member
    Reputation
    6
    Join Date
    Aug 2006
    Posts
    59
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Shopping mall with AC-Web repack?

    When I try to execute JulianX's shopping mall sql in my AC-Web repack I keep getting this error


    "Query:
    INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

    Error occured at:2007-08-05 17:37:51
    Line no.:81
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)

    Error occured at:2007-08-05 17:38:07
    Line no.:1
    Error Code: 1062 - Duplicate entry '593432' for key 1

    Query:
    INSERT INTO items VALUES (32004, 4, 3, -1, "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", 46017, 4, 32768, 0, 0, 5, 64, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 57, 4, 31, 32, 30, 35, 27, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 951, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18378, 1, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, "", 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 703, 165, 0, 0, 0, 0, 2, 0, 2, 0, 4, 0, 2951, 0, 1604, -1, 0)

    Error occured at:2007-08-05 17:38:17
    Line no.:162
    Error Code: 1062 - Duplicate entry '32004' for key 1

    Query:
    INSERT INTO items VALUES (32004, 4, 3, -1, "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", 46017, 4, 32768, 0, 0, 5, 64, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 57, 4, 31, 32, 30, 35, 27, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 951, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18378, 1, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, "", 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 703, 165, 0, 0, 0, 0, 2, 0, 2, 0, 4, 0, 2951, 0, 1604, -1, 0)

    Error occured at:2007-08-05 17:38:48
    Line no.:162
    Error Code: 1062 - Duplicate entry '32004' for key 1

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

    Error occured at:2007-08-05 17:41:48
    Line no.:81
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)

    Error occured at:2007-08-05 17:41:53
    Line no.:1
    Error Code: 1062 - Duplicate entry '593432' for key 1

    Query:
    INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)

    Error occured at:2007-08-05 17:41:55
    Line no.:1
    Error Code: 1062 - Duplicate entry '593432' for key 1

    Query:
    INSERT INTO `creatureloot` VALUES (593412,22917,32837,5),(593413,22917,32838,5),(593414,22917,31091,100),(593415,2 2917,31090,100),(593416,22917,31089,100),(593417,22917,32375,10),(593418,22917,3 2374,10),(593419,22917,32497,10),(593420,22917,32496,10),(593421,22917,32500,10) ,(593422,22917,32525,10),(593423,22917,32471,10),(593424,22917,32336,10),(593425 ,22917,32524,10),(593426,22917,32483,10),(593427,22917,32235,10),(593431,22917,3 2521,10)

    Error occured at:2007-08-05 17:42:00
    Line no.:1
    Error Code: 1062 - Duplicate entry '593412' for key 1

    Query:
    INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)

    Error occured at:2007-08-05 17:42:04
    Line no.:1
    Error Code: 1062 - Duplicate entry '593432' for key 1

    Query:
    INSERT INTO `creatureloot` VALUES (593412,22917,32837,5),(593413,22917,32838,5),(593414,22917,31091,100),(593415,2 2917,31090,100),(593416,22917,31089,100),(593417,22917,32375,10),(593418,22917,3 2374,10),(593419,22917,32497,10),(593420,22917,32496,10),(593421,22917,32500,10) ,(593422,22917,32525,10),(593423,22917,32471,10),(593424,22917,32336,10),(593425 ,22917,32524,10),(593426,22917,32483,10),(593427,22917,32235,10),(593431,22917,3 2521,10)

    Error occured at:2007-08-05 17:42:11
    Line no.:1
    Error Code: 1062 - Duplicate entry '593412' for key 1

    Query:
    INSERT INTO items VALUES (32004, 4, 3, -1, "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", "Merciless Gladiator's Linked Armor", 46017, 4, 32768, 0, 0, 5, 64, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 57, 4, 31, 32, 30, 35, 27, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 951, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18378, 1, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, "", 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 703, 165, 0, 0, 0, 0, 2, 0, 2, 0, 4, 0, 2951, 0, 1604, -1, 0)

    Error occured at:2007-08-05 17:42:17
    Line no.:162
    Error Code: 1062 - Duplicate entry '32004' for key 1

    Query:
    CREATE TABLE `accounts` (
    `acct` bigint(20) NOT NULL auto_increment,
    `login` varchar(255) NOT NULL default '',
    `password` varchar(2 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-08-05 17:42:28
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    INSERT INTO `creatureloot` VALUES (593385,21867,32280,10),(593386,21867,32323,10),(593387,21867,32324,10),(593388, 21867,32325,10),(593389,21867,32326,10),(593390,21867,32327,10),(593391,21867,32 328,10),(593392,21867,32329,10),(593393,21867,32330,10),(593394,21867,32348,10), (593395,21867,32510,10),(593396,21867,32512,10),(593397,21867,32737,10),(593398, 21867,32739,10),(593399,21867,32745,10),(593400,21867,32745,10),(593401,21867,32 747,10),(593402,21867,32749,10),(593403,21867,32751,10),(593404,21867,32752,10), (593405,21867,32755,10),(593406,21867,32738,10),(593407,21867,32744,10),(593408, 21867,32753,1),(593409,21867,32750,1),(593410,21867,32746,1),(593411,21867,32753 ,1)

    Error occured at:2007-08-05 17:42:34
    Line no.:1
    Error Code: 1062 - Duplicate entry '593385' for key 1

    Query:
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
    VALUES (1447144,2,7,-1,"Right handerLULZ","Right handerLULZ","Right handerLULZ","Right handerLULZ",32837,5,0,0000,124230000,13,-1,-1,0,0,0,0,0,0,0,0,0,0,1,0,3,350,19,10,28,70,5,700,4,350,30,150,15,35,13,35,0,0,0 ,0,4000,5000,0,100,500,1,0,0,0,0,0,0,0,0,0,0,200,200,200,200,200,200,1500,0,0,21 992,2,0,0,0,0,41434,2,0,0,0,0,28093,2,0,0,0,0,28414,2,0,0,0,0,32471,2,0,0,0,0,2, "Pwning",0,0,0,0,0,1,3,0,0,0,0,90000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

    Error occured at:2007-08-05 20:19:15
    Line no.:2
    Error Code: 1062 - Duplicate entry '1447144' for key 1

    Query:
    CREATE TABLE `accounts` (
    `acct` int(20) unsigned NOT NULL auto_increment,
    `login` varchar(16) NOT NULL default '',
    `password` varchar(16) default NULL,
    `gm` varchar(10) default '0',
    `banned` int(30) unsigned NOT NULL default '0',
    `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `lastip` varchar(15) default NULL,
    `email` varchar(50) default NULL,
    `flags` int(11) NOT NULL default '0',
    PRIMARY KEY (`login`),
    UNIQUE KEY `acct` (`acct`)
    ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1

    Error occured at:2007-08-11 01:12:46
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    CREATE TABLE `accounts` (
    `acct` int(20) unsigned NOT NULL auto_increment,
    `login` varchar(16) NOT NULL default '',
    `password` varchar(16) default NULL,
    `gm` varchar(10) default '0',
    `banned` int(30) unsigned NOT NULL default '0',
    `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `lastip` varchar(15) default NULL,
    `email` varchar(50) default NULL,
    `flags` int(11) NOT NULL default '0',
    PRIMARY KEY (`login`),
    UNIQUE KEY `acct` (`acct`)
    ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1

    Error occured at:2007-08-11 01:13:10
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    CREATE TABLE `accounts` (
    `acct` int(20) unsigned NOT NULL auto_increment,
    `login` varchar(16) NOT NULL default '',
    `password` varchar(16) default NULL,
    `gm` varchar(10) default '0',
    `banned` int(30) unsigned NOT NULL default '0',
    `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `lastip` varchar(15) default NULL,
    `email` varchar(50) default NULL,
    `flags` int(11) NOT NULL default '0',
    PRIMARY KEY (`login`),
    UNIQUE KEY `acct` (`acct`)
    ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1

    Error occured at:2007-08-11 01:13:12
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    CREATE TABLE `accounts` (
    `acct` int(20) unsigned NOT NULL auto_increment,
    `login` varchar(16) NOT NULL default '',
    `password` varchar(16) default NULL,
    `gm` varchar(10) default '0',
    `banned` int(30) unsigned NOT NULL default '0',
    `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `lastip` varchar(15) default NULL,
    `email` varchar(50) default NULL,
    `flags` int(11) NOT NULL default '0',
    PRIMARY KEY (`login`),
    UNIQUE KEY `acct` (`acct`)
    ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1

    Error occured at:2007-08-11 01:13:14
    Line no.:26
    Error Code: 1050 - Table 'accounts' 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-08-11 01:19:54
    Line no.:271
    Error Code: 1062 - Duplicate entry '31978' for key 1

    Query:
    CREATE TABLE `accounts` (
    `acct` bigint(20) NOT NULL auto_increment,
    `login` varchar(255) NOT NULL default '',
    `password` varchar(2 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-08-11 01:20:00
    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(2 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-08-11 01:20:02
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    INSERT INTO `creatureloot` VALUES (593428,22949,32331,10),(593429,22949,32376,10),(593430,22949,32519,10)

    Error occured at:2007-08-11 01:20:14
    Line no.:1
    Error Code: 1062 - Duplicate entry '593428' for key 1

    Query:
    CREATE TABLE `accounts` (
    `acct` bigint(20) NOT NULL auto_increment,
    `login` varchar(255) NOT NULL default '',
    `password` varchar(2 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-08-11 01:20:41
    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(2 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-08-11 01:20:43
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    CREATE TABLE `ai_agents` (
    `entryId` int(6) NOT NULL default '0',
    `AI_AGENT` int(2) NOT NULL default '0',
    `procEvent` int(2) NOT NULL default '0',
    `procChance` int(3) NOT NULL default '0',
    `procCount` int(6) NOT NULL default '0',
    `spellId` int(6) NOT NULL default '0',
    `spellType` int(2) NOT NULL default '0',
    `spelltargetType` int(2) NOT NULL default '0',
    `spellCooldown` int( NOT NULL default '0',
    `floatMisc1` float NOT NULL default '0',
    `Misc2` int(6) NOT NULL default '0',
    PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2007-08-11 21:27:44
    Line no.:44
    Error Code: 1050 - Table 'ai_agents' already exists

    Query:
    CREATE TABLE `accounts` (
    `acct` bigint(20) NOT NULL auto_increment,
    `login` varchar(255) NOT NULL default '',
    `password` varchar(2 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-08-11 21:27:49
    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(2 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-08-11 23:35:19
    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(2 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-08-11 23:35:39
    Line no.:26
    Error Code: 1050 - Table 'accounts' already exists

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

    Error occured at:2007-08-30 23:56:28
    Line no.:132
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

    Error occured at:2007-08-31 22:43:53
    Line no.:132
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

    Error occured at:2007-08-31 22:45:04
    Line no.:132
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

    Error occured at:2007-08-31 22:45:50
    Line no.:132
    Error Code: 1136 - Column count doesn't match value count at row 1

    Query:
    INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)

    Error occured at:2007-08-31 22:46:11
    Line no.:132
    Error Code: 1136 - Column count doesn't match value count at row 1

    "




    anyone know whats up?

    Shopping mall with AC-Web repack?
  2. #2
    Herzeleid's Avatar Banned
    Reputation
    77
    Join Date
    May 2007
    Posts
    820
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Shopping mall with AC-Web repack?

    that's a lot of errors....

    but your problem is most likely this:

    youre custom items you are putting in have ENTRY IDs already used in your DB.

    do you have custom items before this?
    I Wonder why Errage, Dragonsky, and Conflag Pretend to Be Girls. Little Creepy in my Opinion.

  3. #3
    blah7's Avatar Member
    Reputation
    6
    Join Date
    Aug 2006
    Posts
    59
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Shopping mall with AC-Web repack?

    Nope... I created an entire new database for his repack... named it ascent3 and then restored from a sql dump (his repack)

  4. #4
    Saridormi's Avatar Contributor
    Reputation
    306
    Join Date
    Mar 2007
    Posts
    556
    Thanks G/R
    19/16
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Shopping mall with AC-Web repack?

    Originally Posted by Mesmoras View Post
    Next time just post in his thread. No question posts aloud in this section







  5. #5
    blah7's Avatar Member
    Reputation
    6
    Join Date
    Aug 2006
    Posts
    59
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Shopping mall with AC-Web repack?

    anyways... anyone know whats up?

  6. #6
    Rake2's Avatar Active Member
    Reputation
    18
    Join Date
    Mar 2007
    Posts
    144
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Shopping mall with AC-Web repack?

    ac-web ultimate repack already got vendors with the same id thats the problem

Similar Threads

  1. I Have a Problem With Ac-Web Repack
    By Mikmas in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 05-29-2008, 12:41 PM
  2. Problem with Ac-web repack....
    By Mikmas in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 05-26-2008, 05:03 PM
  3. [HELP]I need help with ac-web repack buggs
    By jackdaripper in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 05-21-2008, 06:14 AM
  4. How to make a private server with ac web repack
    By Wonderchild in forum WoW EMU Guides & Tutorials
    Replies: 19
    Last Post: 02-24-2008, 01:12 PM
  5. Need help with ac web repack
    By Denelly in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 10-31-2007, 04:26 PM
All times are GMT -5. The time now is 05:14 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search