Re: Problem with lenght description in xoops blocks [Module troubleshooting]

Problem with lenght description in xoops blocks

2013/3/14 18:28
brutalicuss
Not too shy to talk
Posts: 128
Since: 2012/6/9 1

Hi guys,

I have problem with lenght description in xoops blocks
There are 100K in 1K lines and block cuts to 70K
I tried with substr, mb_substr, mb_strimwidth (Im utf-8 gen_ci) but no luck

Is there a way to fix this?

10x a lot

Re: Problem with lenght description in xoops blocks

2013/3/15 3:10
irmtfan
Module Developer
Posts: 3419
Since: 2003/12/7

huum i cannot understand you.
1- do you mean the length of block title?

2- if your answer to the first question is yes, there is 255 english characters limitation for you.

If you need more you need to hack core files.

Re: Problem with lenght description in xoops blocks

2013/3/15 8:22
brutalicuss
Not too shy to talk
Posts: 128
Since: 2012/6/9 1

No mg no title, I mean all description. The lenght of the content is 100000 symbols and after saving the system cuts characters to about 70000

Re: Problem with lenght description in xoops blocks

2013/3/17 2:32
irmtfan
Module Developer
Posts: 3419
Since: 2003/12/7

Now i understand your issue.
it is because the content field is "TEXT" and its length is limited to 65,535 bytes ~64kb.

 TINYTEXT     256 bytes       
TEXT     65,535 bytes     ~64kb 
MEDIUMTEXT      16,777,215 bytes     ~16MB 
LONGTEXT     4,294,967,295 bytes     ~4GB

you need to use MEDIUMTEXT or LONGTEXT instead.
Alter table newblocks

eg:

ALTER TABLE PREFIX_newblocks CHANGE content content MEDIUMTEXT;

PREFIX is your xoops database prefix

Re: Problem with lenght description in xoops blocks

2013/3/17 6:39
brutalicuss
Not too shy to talk
Posts: 128
Since: 2012/6/9 1

Thank you very much man! You save my ass:)

I tried with longtext in my table, but I was blind for this table "newblock"
Now its ok, long life for you :)

xoops will be, again and again, regards!

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Problem with lenght description in xoops blocks

Re: Problem with lenght description in xoops blocks

Re: Problem with lenght description in xoops blocks

Re: Problem with lenght description in xoops blocks

Re: Problem with lenght description in xoops blocks

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}