XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Problem with lenght description in xoops blocks
Register
1
brutalicuss
Problem with lenght description in xoops blocks

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
2
irmtfan
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.
3
brutalicuss
Re: Problem with lenght description in xoops blocks

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
4
irmtfan
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.

le="color: #000000"><?php 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:
le="color: #000000"><?php ALTER TABLE PREFIX_newblocks CHANGE content content MEDIUMTEXT;



PREFIX is your xoops database prefix
5
brutalicuss
Re: Problem with lenght description in xoops blocks

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!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits