Hello,

I have added a new column header to the links table and I wish to set a default value; however, I continually get an error reading:

BLOB column 'largeimage' can't have a default value.

I have endeavored to modify the database directly through MySQL commands, through Links SQL and MySQLMan and I get the same error every time. I've been careful to specify NOT NULL at the same time, as well. I have also repaired and resynced all databases, still no luck. Do you have any recommendations?

Thank you.

I think you need to use a CHAR or INT if you want to use a default value.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

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!

Thanks, Andy. That finally did it!