Welcome to Geeklog, Anonymous Saturday, April 20 2024 @ 09:34 am EDT

Geeklog Forums

Pages are cut after certain length


lee

Anonymous
Hi every one,
I have this problem of if a static page is too long (text), it is being cut. Do you know if this is a limit of geeklog or is there any setting that we can fixed.

thanks a lot
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 02/15/02
Posts: 725
Quote by leeBig Grino you know if this is a limit of geeklog

Most probably it's a database limitation. Check the table gl_staticpages and extend it.
Geeklog Polish Support Team
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
To be more precise: The sp_content field is of type TEXT which is limited to 64 KB. Changing the type to MEDIUMTEXT would give you 16 MB theoretically, but your browser and/or webserver will probably throw in the towel much earlier.

bye, Dirk
 Quote

lee

Anonymous
Hi Dirk,
I found:
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(40) NOT NULL default '',
sp_uid mediumint(Cool NOT NULL default '1',
sp_title varchar(12Cool NOT NULL default '',
sp_content mediumtext NOT NULL,

I changed sp_content from text to mediumtext, but I don't know if that line is correct like that or not. It still doesn't extend more text for me.
thanks
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you actually change your database or did you only change the mysql_tableanddata.php file? Just checking ...

bye, Dirk
 Quote

lee

Anonymous
I just change the line in mysql_tableanddata.php file

(don't know how to change in the database itself)
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
You'll have to make the change in the database. Use phpMyAdmin or some tool like that.

bye, Dirk
 Quote

All times are EDT. The time is now 09:34 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content