Extend Mchat static message char

[Novation]

Hi,

How can i extend the mysql char for the static message section in the acp.

I tried the following but it doesn't work

Code: Select all

ALTER TABLE phpbb_mchat_config MODIFY config_value varchar(500);

[Oyabun1]

but it doesn't work

What does that mean? What were you expecting to happen?

[Novation]

but it doesn't work

What does that mean? What were you expecting to happen?

when i try to add more than 255 characters into mchat's Static Message section, i get the following error.

Warning

The static message value is too long.

I want to extend the characters allowed.

[RMcGirr83]

Code: Select all

ALTER TABLE phpbb_mchat_config MODIFY config_value VARCHAR(500)

or

Code: Select all

ALTER TABLE phpbb_mchat_config CHANGE COLUMN config_value config_value VARCHAR(500)

[Novation]

Code: Select all

ALTER TABLE phpbb_mchat_config MODIFY config_value VARCHAR(500)

or

Code: Select all

ALTER TABLE phpbb_mchat_config CHANGE COLUMN config_value config_value VARCHAR(500)

I almost had it correct.... Thanks RMcGirr83

Nice to see you around again btw

[Novation]

Tested and working