Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Can't change URL Not null from Yes > No

Quote Reply
Can't change URL Not null from Yes > No
As I use LinksSQL for links to websites AND as system for users to post classified ads (URL not necessary) I would like to change the link properties of URL - Not Null - from Yes to NO.

The system won't let me!

> A column must be defined as not null if you want to index it.

How do I deal with this? Thanks in advance! - Diederick
Quote Reply
Re: [diederick] Can't change URL Not null from Yes > No In reply to
Just set the field type to non-index too.

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!
Quote Reply
Re: [Andy] Can't change URL Not null from Yes > No In reply to
thank you!
Quote Reply
Re: [diederick] Can't change URL Not null from Yes > No In reply to
oooops - still not working...

In Links Table Editor the following are the settings for URL:

Column name = URL
Column Type = CHAR
Column Index = None
Column Size = 255
Not Null = No
----
Form Display = URL
Form Type = TEXT
Form size = 20
File Save Method = HASHED
From Regex = ^\w+:
Search Weight = 1

All other fields are empty.

Whilst adding a new link, in which the field for URL is left empty, user still gets message that value is not allowed.

Should I change something else?
Quote Reply
Re: [diederick] Can't change URL Not null from Yes > No In reply to
Remove;

^\w+:

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!