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 usage questions 
  4.  / Wiwimod 0.8.3 - document size limit?
Register
1
Anonymous
Wiwimod 0.8.3 - document size limit?

  • 2006/12/22 14:21

  • Anonymous

  • Posts: 0

  • Since:


Hi,

Come across an interesting problem in that day or so.

One of my users is putting together a rather large document and it looks like he's come across a limit to the amount of text he can put in a document.

Adding pagebreaks doesn't help.

Anyone know if there's a limit and, if so, is it a 2software limit", i.e. constrained by XOOPS or wiwimod, or is a limit imposed by, say, the database?
2
skenow
Re: Wiwimod 0.8.3 - document size limit?

  • 2006/12/22 15:55

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


From the MySQL documentation -
Quote:
A TEXT column with a maximum length of 65,535 (216 – 1) characters.

Beginning with MySQL 4.1, an optional length M can be given for this type. MySQL creates the column as the smallest TEXT type large enough to hold values M characters long.


Possibly a DB issue. I wouldn't want a page much larger than that, anyway - for loading and reading purposes
3
wizanda
Re: Wiwimod 0.8.3 - document size limit?

  • 2006/12/22 17:30

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


Looking at this the other day, as it could be stored as blob and not text...
Yet reason for it being text is it is easiest to edit later...yet do believe blob can have a larger sums of data? Best check first as unsure, yet have done that in the past to increase size limit of certain modules...
4
Anonymous
Re: Wiwimod 0.8.3 - document size limit?

  • 2006/12/22 23:15

  • Anonymous

  • Posts: 0

  • Since:


Quote:

wizanda wrote:
Looking at this the other day, as it could be stored as blob and not text...


WHOOOOOOSSSSSHHHHHHhhhhhhhhhhhhhhhh

That was the sound of that going right over my head

I thought a "blob" was some sort of white wined-based beverage?

Please enlighten me and, more to the point, explain how I save text as a blob. Or whatever.
5
skenow
Re: Wiwimod 0.8.3 - document size limit?

  • 2006/12/23 3:40

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


LONGTEXT would be more than sufficient -
Quote:
A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 – 1) characters. Up to MySQL 3.23, the client/server protocol and MyISAM tables had a limit of 16MB per communication packet or table row. From MySQL 4.0, the maximum allowed length of LONGTEXT columns depends on the configured maximum packet size in the client/server protocol and available memory


@JAVesey - this would involve, at a minimum, changing the data type of the field that stores the page information in the database. phpMyAdmin has this capability.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

559 user(s) are online (61 user(s) are browsing Support Forums)

Members: 0

Guests: 559

more...

Donat-O-Meter

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

Latest GitHub Commits