max chars in description field

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 07-11-2007, 08:03 PM
g.ciprian's Avatar
New Pligger
 
Join Date: Jul 2006
Posts: 23
Pligg v9.6 yget default/apache 2/php5

The max number of characters I can add in the description field is 1563 (is this the Pligg's default?).

I'v added a maxlength=9000 on the description textarea in submit_step_2.tpl as said here http://forums.pligg.com/general-help...ion-field.html and the only effect is that I can add a text with more than 1563 chars in description area but when the article is viewed still 1563 chars are displayed.

What I'm missing here?
Reply With Quote
  #2 (permalink)  
Old 07-11-2007, 08:23 PM
P1mpPanther's Avatar
Constant Pligger
 
Join Date: Feb 2007
Posts: 277
You might need to change the char limit in the database as well.

Just a guess..
Reply With Quote
  #3 (permalink)  
Old 07-11-2007, 08:51 PM
g.ciprian's Avatar
New Pligger
 
Join Date: Jul 2006
Posts: 23
Hmmm... I can't find anything like in pligg_config table
Reply With Quote
  #4 (permalink)  
Old 07-12-2007, 04:15 AM
beatniak's Avatar
Pligg Donor
 
Join Date: Apr 2006
Location: NL - 52.100863;5.108356
Posts: 197
database ? pligg_links > link_content

change those settings
Reply With Quote
  #5 (permalink)  
Old 07-12-2007, 06:15 AM
g.ciprian's Avatar
New Pligger
 
Join Date: Jul 2006
Posts: 23
It works but is a bad alternative. I will have to edit that db field every time I have a big article!? Plus I use diacritics, images etc. and the text gets wrapped. I can't spend one hour on an ~10,000 chars article to edit that db...
Reply With Quote
  #6 (permalink)  
Old 07-13-2007, 04:16 AM
g.ciprian's Avatar
New Pligger
 
Join Date: Jul 2006
Posts: 23
help please
thank you
Reply With Quote
  #7 (permalink)  
Old 07-13-2007, 06:26 AM
beatniak's Avatar
Pligg Donor
 
Join Date: Apr 2006
Location: NL - 52.100863;5.108356
Posts: 197
"Help please" ?????
Quote:
Originally Posted by beatniak View Post
database ? pligg_links > link_content

change those settings
Again: change the settings (properties) for link_content.

in phpmyadmin:
1) select your database
2) select pligg_links
3) check the box link_content
4) click on change (the pen icon)
5) change the properties and click save

You don't have to do that for every freakin link, just for that one table. Just open phpmyadmin and do my 5 step program.
Reply With Quote
  #8 (permalink)  
Old 07-14-2007, 11:28 AM
g.ciprian's Avatar
New Pligger
 
Join Date: Jul 2006
Posts: 23
A friend of mine made the following discovery:
MySQL TEXT fields have a limit of 65,000 bytes. If you insert anything larger than that in to a normal TEXT field mySQL will silently truncate your data without telling you (meaning software checks are probably a good idea). MEDIUMTEXT will store 16 million characters and LONGTEXT can handle over 4 trillion, but this information does not appear to be readily available in the online mySQL manual (although it is hinted at in this table). SMALLTEXT has a 255 character limit. Something to bare in mind when designing database applications.

Answer to my initial problem is that I'v tried to add a (the first) bigger article, more than, say 300 chars. But, the real problem was the < sign in that article (eg. "They were offering some millions (<10) for a small piece of that company"). That was the sign that 'cut' the text after in my article.

MySQL AB :: MySQL Documentation

MySQL Field Types

Thank you very much for replys.

Last edited by g.ciprian; 07-14-2007 at 11:50 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a Category Description Field, (Not Meta Desc) rrivera Questions and Comments 1 06-26-2009 05:24 PM
Removing Description Field johndango Questions and Comments 5 11-08-2007 01:34 PM
Character limit on description field projectman Questions and Comments 4 11-02-2007 11:08 PM
Description and Summary text field not holding more than 150 char ... Rayden Questions and Comments 0 09-12-2007 10:19 PM
Description Field SonHouse Questions and Comments 0 07-20-2007 04:53 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development