Extend Mchat static message char

Support for mods released by phpbbmodders.net found at either https://github.com/phpbbmodders/ or the MODDB at http://www.phpbb.com
Forum rules
Please only request support for mods released by phpbbmodders.net found at either https://github.com/phpbbmodders/ or the MODDB at http://www.phpbb.com
Novation
Member
Member
Posts: 78
Joined: 25 Jun 2009, 00:08

Extend Mchat static message char

Postby Novation » 04 Apr 2015, 21:26

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
New member
New member
Posts: 34
Joined: 16 Sep 2009, 08:16

Re: Extend Mchat static message char

Postby Oyabun1 » 08 Apr 2015, 10:04

Novation wrote: but it doesn't work
What does that mean? What were you expecting to happen?

Novation
Member
Member
Posts: 78
Joined: 25 Jun 2009, 00:08

Re: Extend Mchat static message char

Postby Novation » 08 Apr 2015, 10:11

Oyabun1 wrote:
Novation wrote: 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.

User avatar
RMcGirr83
Past Contributor
Past Contributor
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: Extend Mchat static message char

Postby RMcGirr83 » 08 Apr 2015, 10:22

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
Member
Member
Posts: 78
Joined: 25 Jun 2009, 00:08

Re: Extend Mchat static message char

Postby Novation » 08 Apr 2015, 10:27

RMcGirr83 wrote:

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 :rock:

Nice to see you around again btw :cool:

Novation
Member
Member
Posts: 78
Joined: 25 Jun 2009, 00:08

Re: Extend Mchat static message char

Postby Novation » 08 Apr 2015, 10:32

Tested and working :clap:


Return to “Modders MOD support”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 2 guests