 | |  | | | ReviewPost How do I...? Wondering how to do something in ReviewPost? |
December 17th, 2006, 04:43 PM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 116
| Announcement Box?
Where do I increase the character limit on the "Announcement Box"?
TIA
|
| |
December 17th, 2006, 05:01 PM
|
#2 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,945
|
The character limit is set by the mysql field in the database so there is no way to change it without alter the database field.
Maybe you can do this
ALTER TABLE pp_settings CHANGE setting setting TEXT
|
| |
December 17th, 2006, 06:07 PM
|
#3 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 116
| Quote:
Originally Posted by Chuck S The character limit is set by the mysql field in the database so there is no way to change it without alter the database field.
Maybe you can do this
ALTER TABLE pp_settings CHANGE setting setting TEXT | I don't find a variable called "text". I only see three variables that are set to 200 and they all have to do with images
|
| |
December 17th, 2006, 06:36 PM
|
#4 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,945
|
You would run that query in phpmyadmin to change the field I noted.
|
| |
December 17th, 2006, 07:31 PM
|
#5 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 116
|
Okay, after running that, will it offer me a field to enter the new variable? I assumed the query would have the new number in it?
|
| |
December 18th, 2006, 07:28 AM
|
#6 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,945
|
Nope all it is doing is changing that field from VARCHAR TO TEXT. A text field does not have a limit
|
| |
December 19th, 2006, 09:21 PM
|
#7 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 116
| Quote:
Originally Posted by Chuck S Nope all it is doing is changing that field from VARCHAR TO TEXT. A text field does not have a limit | There are a lot of things in the pp_settings table. By running "ALTER TABLE pp_settings CHANGE setting setting TEXT", it knows which field to change?
|
| |
December 20th, 2006, 08:06 AM
|
#8 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,945
|
Yes It Does
|
| |
December 20th, 2006, 09:51 AM
|
#9 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 116
|
After changing "pp_settings" to "rp_settings", it worked perfectly!
Thanks!
|
| |
January 11th, 2007, 12:09 PM
|
#10 (permalink)
| | Member Verified Customer
Join Date: Oct 2003 Location: NJ
Posts: 31
|
Worked for me too, thanks!
|
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread | Linear Mode | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -5. The time now is 06:43 PM. | |