sig length

Nuke Soldier Joined: May 22, 2003 Posts: 10

I have been looking for a solution for this problem for some time now but with no success. Basically, the signature length will not go past 255 characters, even if you set it at 9999 in the admin panel it will just erase anything over 255. Any help on this matter would be greatly apprieciated.

Thanks in advance,
Jessie00721

Joined: Jan 31, 2004 Posts: -88

it needs to be changed in the database using phpMyAdmin too.

AI

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Use phpMyAdmin and issue the following statement

Code:

ALTER TABLE `nuke_users` CHANGE `user_sig` `user_sig` VARCHAR( 500 ) NULL

Keep in mind that this alters the user table. Also, you need to be aware that the varchar() type has a limit of 2000, if I remember right. It might even be 1000. Check the manual.

Nuke Cadet Joined: May 22, 2003 Posts: 2

Hello,

I'm Trying to do what u guys said but i get this Error:

Quote:

Database onestcdn_nuke - table nuke_users running on localhost
Error

SQL-query :

ALTER TABLE `nuke_users` CHANGE `user_sig` `user_sig` VARCHAR( 4750 ) NULL

MySQL said:

Too big column length for column 'user_sig' (max = 255). Use BLOB instead

Can u help me?

Thanks,

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Did you read my previous post closely? I warned you that there was a maximum length limit on type varchar(). That's what it is telling you. You need to change VARCHAR to BLOB or TEXT. Try using BLOB.