Re: [Webcollab-users] contact notes

[Andrew S. <and...@pa...>]

On Thu, 22 Mar 2007 03:06:00 -0400
Christopher Hawkins wrote:

> My thanks to all developers for a fine piece of software! Question: When I
> post (or edit) a contact I can't seem to put more than a line or two in the
> notes field without it getting truncated when I submit the information. Is
> there a way to change this to allow for longer input? I have just installed
> the latest version... I don't know if this has always been the behavior or
> if this is new. 
> 

Thank you for your comments.  It's always good to have happy users.

Your question is very interesting - it's actually a 5 year old bug!  No one - including me - seems to have noticed this before.

The database field for 'notes' in the 'contacts' table is set to 100 characters ('VARCHAR(100)'), when it should really be 'TEXT'.  You can use a program such as phpmyadmin to change the field from VARCHAR(100) to TEXT, or you can use SQL commands from a commandline ('ALTER TABLE contacts MODIFY notes TEXT').

The database creation files are now updated in the Subversion SVN at Sourceforge too.

Andrew Simpson