1
bjuti
News module no. of characters limit?
  • 2010/3/3 0:29

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


I'm using a News module, and I've posted text, splitted in 9 pages. Then I started to add some photos and noticed that one whole page is missing. It breaked.

I'm using utf-8 and cyrilic. The same post without photos is ok. Is this maybe a XOOPS issue?

Tnx

2
bjuti
Xoops no. of characters limit?
  • 2010/3/3 0:46

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


It's not news module issue. I tried content module, with tiny mce and ckeditor and it's the same.

The text contains about 31500 chars and it's ok when I paste it. Adding about 45 photos with it's definitions and elements, I suppose that it breaks in ~30000 chars.

Any idea?

3
bjuti
Re: News module no. of characters limit?
  • 2010/3/3 1:26

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


I've found what seems to be the problem.

In phpMyAdmin field bodytext is TEXT. Sin'ce the cyrillc is multibyte my 30000+ is more than 65000 what's the limit of that field. MEDIUMTEXT is limit 16 milion bytes.

Joomla have MEDIUMTEXT fields, why is TEXT in Xoops?

4
andrey3761
Re: News module no. of characters limit?

TEXT - maximum 65536 bytes
MEDIUMTEXT - maximum 16777216 bytes
LONGTEXT - maximum 4294967296 bytes

5
bjuti
Re: News module no. of characters limit?
  • 2010/3/3 11:36

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Yup :)

And.. may I change it in phpMyAdmin without any consequence?

6
bjuti
Re: News module no. of characters limit?
  • 2010/3/3 13:45

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


I've change it to MEDIUMTEXT and all seems to run ok. Now my text isn't cropped.

My advise to module developers and XOOPS developers to think about this issue.

7
andrey3761
Re: News module no. of characters limit?

Quote:
may I change it in phpMyAdmin without any consequence?


Yup :)

Login

Who's Online

288 user(s) are online (215 user(s) are browsing Support Forums)


Members: 0


Guests: 288


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits