Noven
Exalted Member
So i've been trying to run this sql a couple of times;
But I am receiving this error everytime I try it; http://pastebin.com/eHk2H2H3
Which is weird because there are no aa_item folder which it says it is. I've also been looking through my mysql data folder to check if there are any there, but no.
So what exactly am I doing wrong here?
DROP TABLE IF EXISTS `aa_item_dbc`;
CREATE TABLE `aa_item_dbc` (
`id` INT(11) NOT NULL DEFAULT '0',
`class` INT(11) NOT NULL DEFAULT '0',
`subclass` INT(11) NOT NULL DEFAULT '0',
`SoundOverrideSubclass` INT(11) NOT NULL DEFAULT '0',
`material` INT(11) NOT NULL DEFAULT '0',
`displayid` INT(11) NOT NULL DEFAULT '0',
`inventorytype` INT(11) NOT NULL DEFAULT '0',
`sheath` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
ALTER TABLE `aa_item_dbc`
CHANGE `id` `id` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `class` `class` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `subclass` `subclass` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `SoundOverrideSubclass` `SoundOverrideSubclass` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `material` `material` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `displayid` `displayid` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `inventorytype` `inventorytype` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `sheath` `sheath` VARCHAR(255) DEFAULT '0' NOT NULL,
DROP PRIMARY KEY;
INSERT INTO `aa_item_dbc` VALUES ('int','int','int','int','int','int','int','int');
INSERT INTO `aa_item_dbc`
SELECT
`item_template`.entry,
`item_template`.class,
`item_template`.subclass,
`item_template`.SoundOverrideSubclass,
`item_template`.Material,
`item_template`.displayid,
`item_template`.InventoryType,
`item_template`.sheath
FROM `item_template` WHERE `item_template`.entry = `item_template`.entry;
But I am receiving this error everytime I try it; http://pastebin.com/eHk2H2H3
Which is weird because there are no aa_item folder which it says it is. I've also been looking through my mysql data folder to check if there are any there, but no.
So what exactly am I doing wrong here?