VBCode Limit?

[SoloX]

Hello,

I am using about 6 lines of HTML code that will be replaced by the vb code. The problem is that only a few lines get translated and the rest is truncated. Is there any hard limit on how many characters I can subsitute with vb code?

Thanks

[Ninth Dimension]

I'm really sorry but I don't understand what you mean. But if I understand you right then I don't think there is a limit. Maybe you can give an example here??? :D

[SoloX]

ok. for example:

<BR><A HREF='javascript:play
("http://www.abc.org/gsvposts/files/{param}.wav")'>
<img border="0" src="http://www.abc.org/gsvposts/speaker.gif"
width="32" height="32"></A>
<A HREF='http://www.abc.org/gsvposts/files/{param}.wav">text link</A><br>


but when I run the vbcode, it only displays

<BR><A HREF='javascript:play
("http://www.abc.org/gsvposts/files/aaaaaa.wav")'>
<img border="0" src="http://www.abc.org/gsvposts/speaker.gif"
width="32" height="32"></A>

see how it would truncate the translation?

[Steve Machol]

The bbcodetag in the bbcode table is limited to 200 characters. You would need to change this in phpMyAdmin.

[SoloX]

thanks ...

When I try to chnage the 200 to say 400, I get:

MySQL said: Too big column length for column 'bbcodereplacement' (max = 255). Use BLOB instead.

when I try to use BLOB, I get:
MySQL said: You have an error in your SQL syntax near '(400) not null ' at line 1.


I get the same response for all BLOBs (tiny,medium,large) ... please help.

[Steve Machol]

Sorry I have no idea. Maybe someone else will know.

[the_sisko]

change the type to text and delete the lenght/value of it!

[Steve Machol]

The only caution I have is that by doing this you may affect your ability to do future upgrades. It's a very slight risk but one you need to consider.

[the_sisko]

I did the same some time ago and had no probs with updates. There isn't a big difference in varchar and text except the length in this case...

[Steve Machol]

As I said there is a very slight risk. I'm going by the changes that are being made to the vB 3.0 database and some cautions posted by the Developers.

[SoloX]

thanks all for your help. the problem was solved by changing the type to TEXT ... i will be careful when upgrading ... maybe I will note down the values and switch back while upgrading .. but with all the mods, it will be a while b4 i even think about moving to the latest and the greatest ...