FUDforum: Bug Reports » fud26_ses.action column type too small

Home » FUDforum Development » Bug Reports » fud26_ses.action column type too small

Show: Today's Messages :: Polls :: Message Navigator

fud26_ses.action column type too small [message #15671]

Tue, 30 December 2003 19:32

BadExample

Messages: 1
Registered: December 2003

Karma: 0

Junior Member

I'm using 2.6.0RC11 with a Postgres 7.3.4 database.

On a posting with a rather long Subject, I get (SQL Error Log):

(/home/apache/htdocs/fud/index.php:141
/home/apache/htdocs/fud/index.php:406
/home/apache/htdocs/fud/theme/default/tree.php:795
/home/apache/htdocs/fud/index.php:1175
) : ERROR: value too long for type character varying(255)
Query: UPDATE fud26_ses SET sys_id='eee8eab0d6b7983ffe541fe547d3c0d6', forum_id=11, time_sec=1072809454, action='Browsing topic (tree view) <a class=\"GenLink\" href=\"https://www..org/fud/index.php?t=tree&amp;th=11&amp;rid=3&amp;S=de2f65d65b6a5e9bdc5c0dfe2f2af0ad&amp;SQ=2bc4af96a7abc46660a38a5b0ff041ba\">Polygon Simplification requirements (rough draft) Nov 2003</a>', returnto='t=tree&th=11&start=0&rid=3&S=de2f65d65b6a5e9bdc5c0dfe2f2af0ad&SQ=2bc4af96a7abc46660a38a5b0ff041ba' WHERE id=87
Server Version:
[Referring Page] https://www..org/fud/index.php?t=thread&frm_id=4&rid=3&S=de2f65d65b6a5e9bdc5c0dfe2f2af0ad&SQ=2bc4af96a7abc46660a38a5b0ff041ba

I manually changed the action column type from char varying(255) to text and retried. Worked.

Is this the real problem? If so, how do I make the change persistent (want action column type to stay the same when I upgrade FUDforum).

Report message to a moderator