Hi,
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.
TIA
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
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.
TIA
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates