Textpattern CMS

#1 2008-11-11 04:42:08

vergerus

New Member

Registered: 2008-11-11

Posts: 2

Extend 255 char limit in site slogan

Hello, how can I increase the 255 character limit in the site_slogan tag? Thanks for any help.

#2 2008-11-11 06:09:42

joebaich

Member

From: DC Metro Area and elsewhere

Registered: 2006-09-24

Posts: 507

Website

Re: Extend 255 char limit in site slogan

The site slogan is contained in the val field in one of the records in the txp_prefs table in your database. Change the length of the field from 255 to whatever you need using phpmyadmin or similar. Understand though that you are changing the length of that field for all the preferences records so you would need to test for unintended consequences thoroughly. Be prepared to have to change the length back to 255 and come up with a less verbose slogan :-).

#3 2008-11-11 15:35:34

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Extend 255 char limit in site slogan

joebaich wrote:

The site slogan is contained in the val field in one of the records in the txp_prefs table in your database. Change the length of the field from 255 to whatever you need using phpmyadmin or similar. Understand though that you are changing the length of that field for all the preferences records so you would need to test for unintended consequences thoroughly. Be prepared to have to change the length back to 255 and come up with a less verbose slogan :-).

You need to change field type not the lenght only, if you are using MySQL version older than 5.0.3. The varchar type can contain only maximum of 255 chars before version 5.0.3.

---

Rah | GitHub

#4 2008-11-13 04:43:41

vergerus

New Member

Registered: 2008-11-11

Posts: 2

Re: Extend 255 char limit in site slogan

Thanks and I appreciate your replies joe and jukka, I will try to keep the superfluity to a modicum of irrationality!