Members   Search      Help    Register    Login    Home
Home » Discussion Forums » M0dZ & HaCkZ » Request : Increasing the Shout Message Size?
Request : Increasing the Shout Message Size? [message #2491] Wed, 25 March 2009 10:07 Go to next message
Threedays is currently offline Threedays  Australia
Messages: 79
Registered: January 2009
Location: Australia
Seeder
Request : Increasing the Shout Message Size?

I would like to request someone to make a mode that increases the size of the shout box message size. Currently 256 sized byte VARCHAR field, set to unique and flood controlled.

I tried increasing the SQL field size and also tried "TEXT" as the type, but got errors due to the "latin_german_cs2" and other issues. Then I couldn't set the field to be flood controlled if the field was greater than 1000 bytes.

I don't know enough about SQL yet to do this properly.


Re: Request : Increasing the Shout Message Size? [message #2492 is a reply to message #2491] Sun, 29 March 2009 14:27 Go to previous messageGo to next message
Revan is currently offline Revan  Czech Republic
Messages: 125
Registered: April 2007
Super-Seeder
What was the error?
Re: Request : Increasing the Shout Message Size? [message #2493 is a reply to message #2492] Sun, 29 March 2009 20:17 Go to previous messageGo to next message
Threedays is currently offline Threedays  Australia
Messages: 79
Registered: January 2009
Location: Australia
Seeder
Revan wrote on Mon, 30 March 2009 00:27

What was the error?


I'm using PHP5 based MYSQL hosted by 1and1.com

Trying to converts a "latin_gernan_cs2" VARCHAR 256 to 999, I get;
"#1071 - Specified key was too long; max key length is 1000 bytes"

Trying to set to TXT with carious options I get mainly;
"#1170 - BLOB/TEXT column 'text' used in key specification without a key length"


-----

'anti_flood' was a UNIQUE index, sorry. I omplied in a previous message, otherwise.


[Updated on: Sun, 29 March 2009 21:05]

Report message to a moderator

Re: Request : Increasing the Shout Message Size? [message #2494 is a reply to message #2493] Mon, 30 March 2009 07:45 Go to previous messageGo to next message
Revan is currently offline Revan  Czech Republic
Messages: 125
Registered: April 2007
Super-Seeder
Ok, so how about this:
Convert text from varchar to text, drop the existing anti_flood index before it, and once you have it create a new one like this (this one should check first 10)

ALTER TABLE `torrent_shouts` ADD UNIQUE `anti_flood` ( `text ` ( 10 ) , `user` )
Re: Request : Increasing the Shout Message Size? [message #2495 is a reply to message #2494] Mon, 30 March 2009 10:43 Go to previous messageGo to next message
Threedays is currently offline Threedays  Australia
Messages: 79
Registered: January 2009
Location: Australia
Seeder
Revan wrote on Mon, 30 March 2009 17:45

Ok, so how about this:
Convert text from varchar to text, drop the existing anti_flood index before it, and once you have it create a new one like this (this one should check first 10)

ALTER TABLE `torrent_shouts` ADD UNIQUE `anti_flood` ( `text ` ( 10 ) , `user` )


Thanks Revan I removed the Index 'anti_flood' which has no code reference other than in the building of the initial datbases, so it's safe to go. Then I got no errors in changing to a TEXT type.

The shouts are now much bigger.


Re: Request : Increasing the Shout Message Size? [message #2509 is a reply to message #2495] Mon, 06 April 2009 16:45 Go to previous message
Revan is currently offline Revan  Czech Republic
Messages: 125
Registered: April 2007
Super-Seeder
Glad I could help..
But if I were you I would still create a new anti_flood index just to be on the safe side (from some bots, spammers or whatever..)
Previous Topic:Increasing Torrent Name Displayed In List [pMBT2.0.3]
Next Topic:attachment
Goto Forum:
  


Current Time: Wed Feb 08 11:57:26 GMT 2012

Total time taken to generate the page: 0.00747 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software