Re: [Webcollab-users] contact notes
Brought to you by:
andrewsimpson
|
From: Andrew S. <and...@pa...> - 2007-03-22 09:19:16
|
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
|