PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > ReviewPost Pro Support Forums > ReviewPost How do I...?

ReviewPost How do I...? Wondering how to do something in ReviewPost?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old 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
CGMathis is offline   Reply With Quote
Old December 17th, 2006, 05:01 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 17th, 2006, 06:07 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 116
Quote:
Originally Posted by Chuck S View Post
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
CGMathis is offline   Reply With Quote
Old December 17th, 2006, 06:36 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,945
You would run that query in phpmyadmin to change the field I noted.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old 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?
CGMathis is offline   Reply With Quote
Old December 18th, 2006, 07:28 AM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 19th, 2006, 09:21 PM   #7 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 116
Quote:
Originally Posted by Chuck S View Post
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?
CGMathis is offline   Reply With Quote
Old December 20th, 2006, 08:06 AM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,945
Yes It Does
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old 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!
CGMathis is offline   Reply With Quote
Old January 11th, 2007, 12:09 PM   #10 (permalink)
Member
Verified Customer
 
Join Date: Oct 2003
Location: NJ
Posts: 31
Send a message via AIM to Tattooz
Worked for me too, thanks!
Tattooz is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Announcement box help rmnapa Classifieds How do I...? 2 June 5th, 2006 11:52 AM
Need to Clear announcement Title Box Stumeister2 Photopost Pro Bug Reports 2 November 27th, 2005 09:50 AM
Announcement box will not clear out Suziqz Photopost Pro Installation & Upgrades 2 July 8th, 2005 11:08 AM


All times are GMT -5. The time now is 06:43 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0