Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 08:58 am EST

Geeklog Forums

How can I change story input size?


TastyBanana

Anonymous
nerdy
I searched the code and wasn't able to glean where I can make the following change:

I need to be able to input large stories. Whenever I try to post a very large file (150k) as a story, geeklog seems to truncate it. I'd like to alter the PHP/MySQL/whatever to allow me to post stories of unlimited length.

If I'm missing something, let me know. Otherwise I'm not sure where to start looking...
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
in the database table, gl_stories, you will have to change the column type from "text" to "medium text" on the intro and body columns.

easily accomplished with phpmyAdmin or some similar tool. Otherwise use the "alter table" syntax in a mySQL query.
 Quote

TastyBanana

Anonymous
happy
Big Celebration

Thank you! It worked out just great. For those who want to know what I did, here are the MySQL commands that fixed my text length issue:

mysql> alter table gl_stories change introtext introtext mediumtext;
Query OK, 13 rows affected (0.11 sec)

mysql> alter table gl_stories change bodytext bodytext mediumtext;
Query OK, 13 rows affected (0.06 sec)
Records: 13 Duplicates: 0 Warnings: 0

 Quote

All times are EST. The time is now 08:58 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