FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » fud26_ses.action column type too small
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
fud26_ses.action column type too small [message #15671] Tue, 30 December 2003 14:32 Go to next message
BadExample is currently offline  BadExample   United States
Messages: 1
Registered: December 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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).

Re: fud26_ses.action column type too small [message #15674 is a reply to message #15671] Tue, 30 December 2003 17:19 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is a real problem, I've updated the SQL schema of FUD to use TEXT for that field.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Can't open file: 'fud26_index.MYI'. (errno: 145)
Next Topic: Mismatched Text in Global Configuaration.
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 22 02:43:18 EDT 2017

Total time taken to generate the page: 0.00630 seconds