Schema.mysql

[Xzrnoth]

Hello everyone, This is the error I recieve when I try to import the file, Ive tried more then once to upload it, and delete and dl'ed a fresh one, still get this same error, any help would be appreciated.


Error

SQL query:

CREATE TABLE `server_motd` (
`id` INT NOT NULL AUTO_INCREMENT ,
`text` TEXT NOT NULL DEFAULT '',
PRIMARY KEY ( `id` )
) ENGINE = InnoDB;

MySQL said: Documentation
#1005 - Can't create table '.\otserv\server_motd.frm' (errno: 121)

 

[Xzrnoth]

Bump?

 

[Fare]

really don't know, but...try to use latest mysql\phpmyadmin...

 

[Xzrnoth]

I have the most updated version's, and still im recieveing an error, Any scripters or anyone know whats missing in that table? or what is wrong? Cause thats straight from the schema, nothing was edited.

 

[Pvls]

Errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data dictionary, though the .frm file for the table has been deleted. This is the most common reason for getting errno 121 in table creation

 

[Xzrnoth]

wow thanx that was it, rep+