Gossamer Forum
Quote Reply
Enum field
Alex,

I had problems trying to add an Enum through the built in table editor, using standard MySQL syntax:

Failed to execute query: 'ALTER TABLE Links ADD COLUMN isLive ENUM('\'No\', \'Yes\'') DEFAULT '\'No\''' Reason: Invalid default value for 'isLive'


Where the enum values were 'No', 'Yes' and the default was both - No and 'No' (neither worked).

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ


Subject Author Views Date
Thread Enum field pugdog 2664 Dec 19, 2000, 12:43 AM
Thread Re: Enum field
Alex 2605 Dec 20, 2000, 5:38 PM
Thread Re: Enum field
pugdog 2588 Dec 20, 2000, 7:55 PM
Thread Re: Enum field
Alex 2571 Dec 21, 2000, 4:03 PM
Thread Re: Enum field
pugdog 2555 Dec 21, 2000, 11:35 PM
Post Re: Enum field
Alex 2551 Dec 21, 2000, 11:47 PM