Gossamer Forum
Home : Products : Gossamer Links : Discussions :

How to Change Column Size for Username

Quote Reply
How to Change Column Size for Username
I am wanting to change the column Size for the Username from 50 to 150. However it is giving me following message:
Quote:
You cannot alter column Username, as table glinks_Users still has references to it. Remove those references first


Can someone please direct me on how can I edit this, so that the username character limit is set to 150 character.

Thank you.

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] How to Change Column Size for Username In reply to
Hi,

I would change it in MySQLMan:

glinks_Users > Properties > then click "Change" next to the "Username" field, and edit the "Length/Set" to 150, and save. Then, go in and do a Database > Users > Properties > Resync Database, and this should update it for you :)

Hope that helps.

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] How to Change Column Size for Username In reply to
Worked like Charm.. thanks a lot Andy.

Vishal
-------------------------------------------------------