[SOLVED] Mysql error

[Noven]

So i've been trying to run this sql a couple of times;

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?

 

[MrPixelMC]

Have you tried using "DROP TABLE" instead of "DROP TABLE IF EXISTS" ? The former is a standard while the latter is not always supported.

 

[Rochet2]

It says
"Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab"

can you do that?

 

[Noven]

Tried it,

<e>Query: DROP TABLE `aa_item_dbc`

Error Code: 1051
Unknown table 'aa_item_dbc'

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0 sec

- - - Updated - - -

Hold on rochet, I'll try

- - - Updated - - -

When I use DROP TABLE, I do not get any warning, just errors

 

[Rochet2]

Maybe try
REPAIR TABLE aa_item_dbc;

if it doesnt work then see this
http://stackoverflow.com/a/12086798/3586583

 

[Noven]

when I type in a extra "a" in aa_item_dbc, it seems to create the table just fine, but keeps saying that just aa_item_dbc exists, when it doesn't

 

[Noven]

Yeah, just renamed aa to aaa, works fine now, thanks for your help guys!