Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

[BUG] GT::SQL - adding new INT field

Quote Reply
[BUG] GT::SQL - adding new INT field

I've come across a problem when adding an INT field. Here are the steps:

1) Goto the table, click "Add Column"
2) Add the field as: Field_Name / INT / NOT NULL / default: 0
3) This gives an error about the value not being able to be empty.

If you set the default as 1, then go in and edit the default to 0 after adding the field - it works fine .

I thought it was just me being silly - but I've done more testing, and that is definatly the case.


Andy (mod)
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!