phpMyAdmin creating bad syntax?

[RKuhle]

I'm sure I did something wrong here, but have any of you ever had problems with phpMyAdmin creating bad SQL syntax? I tried creating a table and this error came back to me:
MySQL said: You have an error in your SQL syntax near 'not null , date DATE not null , PRIMARY KEY (ID), INDEX (ID, wallpaperID), UNI' at line 1

Here's my table creation code:
CREATE TABLE wallpaper (ID TINYINT UNSIGNED not null AUTO_INCREMENT, wallpaperID MEDIUMINT UNSIGNED not null , title TEXT not null , description TEXT not null , keywords TEXT not null , views INT UNSIGNED DEFAULT '0' not null , status ENUM not null , date DATE not null , PRIMARY KEY (ID), INDEX (ID, wallpaperID), UNIQUE (ID, wallpaperID))

Is my ENUM causing the problem? Maybe because I didn't define the enumerated values? By the way, in which field using phpMyAdmin do I define the enumerated values?

[qslack]

Yes--it's definitely your ENUM that's causing the problems. Haven't worked with phpMyAdmin at all, but ENUM is supposed to look like this:

ENUM('val1', 'val2', 'valn')

[RKuhle]

Great, that did it, thanks for the pointer Quinn.