Description Length Modifying

[n25an]

I need to modify the length of the description displayed for links and categories...

[n25an]

I tried changing the length in the mysql table but max length is 255 for varchar. I know that longtext or text can give me greater length. If I change the description type from varchar to longtext... where do I need to change it in the php link code so the change will ripple through with no adverse difficulties...

[n25an]

How do I go about installing a character counting script that counts the amount of characters so I know when I go into overflow. this would be handy when I submit a link...

[David]

I like the idea of a javascript character counter that you see while typing. I am considering adding a long description field option to the next version, so there woul be a short and long description, and the admin would have the option to turn the long description on/off.

[IGonza]

Content visible to registered users only.

Just change the type of fields to LONGTEXT and nothing more.

Igor.

[seothatworks]

I would also love to have long descriptions.

Igor: will just changing the description fields type in mysql to longtext be enough (plus the template maxlenght of course)? I mean, is it completely safe, will there be no problems with the code? Just to be safe...
thanks, Tom

[David]

The implications would be mostly related to mysql performance (for things like searches), but would not become much of an issue unless you had a really large directory.

[minstrel]

What files need to be modified to increase the field length for Title?

Or do I just need to modify the MySql field length?

[minstrel]

The answer (for those with the same question):

modify

/admin/dir_links_edit.tpl
submit.tpl

[blackpepper]

I know this thread is old but I searched for an answer and couldn't find.
I needed to change the description [for category and link tables] field type to TEXT or LONGTEXT which I did it already. I couldn't just modify the field so I had to drop it first then create it again with the new type spec.
That part is working fine now!!

Now, my question is, if I want to change the description field type before I install or reinstall my directory script so the description field is created as a TEXT type since the beginning, where and how do I change the lines.?

I was thinking maybe on the include/tables.php file,
on the line 'DESCRIPTION' => 'C(255)', for links table and
on the line 'DESCRIPTION' => 'C(255)', for category table.

mmh should it be like 'DESCRIPTION' => 'TEXT(800)', ??

Any help appreciated ;-)

[Boby]

For 3.0.5 we have this that turn the DESCRIPTION field into longtext. I'd preffere to change to text but AdoDB does not want to change from varchar only to longtext.

Content visible to registered users only.
You can find docs on how to change the DB tables here:
http://phplens.com/lens/adodb/docs-datadict.htm

Boby

[blackpepper]

ohh Thankyou!

I'll try those changes!