Field length for subscription detail

[TheMusicMan]

How do I increase the field length of the description associated with a subscription. I added the text in the ACP Subscription Manager, but it cut it off short when I viewed it on the UserCP page.

Can this be increased...? if so, how...? Do I need to amend MySQL db and a template, or just one...?

[Jake Bunce]

Run this query on your database:

ALTER TABLE subscription CHANGE description description MEDIUMTEXT NOT NULL

[TheMusicMan]

Thanks Jake... how many characters will I be allowed to put into the field now?

[Jake Bunce]

16,777,215 characters.

[TheMusicMan]

hehehe.. I can just tell Jake... you really enjoyed posting that didn't you... hehe

Thanks... should be enough room then...

[Jake Bunce]

heh

[TheMusicMan]

Hey Jake et al... sorry for resurecting an old thread of mine but following on from this, is there a way to get images to appear in the description area? I tried using the [img] tag but no joy...

I'd like to include the rank image a user obtains if they subscribe to a product.

[Colin F]

Hi John

You can use HTML img tags like this:

<img src="path/to/image.gif" />

[TheMusicMan]

Thanks Colin, that worked fine. Cheers.

[Removed-1078464]

Group,

I tried doing this on my board VB 3.5.4 and I ended up getting an error message for some reason.

Please attached screen shot.

The first time I got the error instead of showing .subscriptions, it said .forum.

Anyone know whats going on here?

Thanks

Doug

[conqsoft]

That means the table "subscription" doesn't exist. You must be used table prefixes?

[Removed-1078464]

Yes correct, I used table prefixes of VB3_

Was I not suppose to for some reason?

Also was anything altered in the database? Or was everything untouched when it shows this error, just wondering if it got half way through changing things and then errored out or if it checked right away and never touched anything. Wondering if i need to do a database restore from my backup or if im ok?

Doug

P.S. Just something to add to this. I noticed that the tables forum and subscriptions are both in my database its just that both of them have a prefix of VB3_ . Please see screen shots attached.

[conqsoft]

So that means you need to use vb3_subscription in your statement....

[Removed-1078464]

So then right after ALTER TABLE instead of having "forum" or "subscription" I would have in there VB3_Subscriptions or VB3_Forum depending on which one I want to edit, correct?

Doug

[Removed-1078464]

Also was anything altered in the database? Or was everything untouched when it shows this error, just wondering if it got half way through changing things and then errored out or if it checked right away and never touched anything. Wondering if i need to do a database restore from my backup or if im ok?

Just wondering about this, any idea if im ok on having to restore the database?

I beleive im ok, but I just want to get a second opinion on this.

Thanks

Doug