URL to your eFiction: http://fanfic.sonny-and-carly.net/index.php
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2.2
Version of MySQL: 5
Have you searched for your problem: Yes
If so, what terms did you try: word count, cutting story off
State the nature of your problem: Really long chapters seem to cut off. I have unlimited words and it stores the stories to sql. You only realize after you post the story that it cuts it off.
I'm guessing you are storing stories in the databse instead of file? This isn't a bug. This is cause by storing stories in the database. Even though you've set no limit on the length of fics, database fields have pre-determined limitations.
How would I switch from already a current database system to a file system without losing the existing stories?
You'd have to write yourself a script to convert it. There's no way currently to do this.
You'd have to write yourself a script to convert it. There's no way currently to do this.
Well I can't write scripts well so in the meantime I will suggest they break up their stories into parts.
Why not just change the datatype of the storytext column from text to mediumtext. That would increase them maximum size from 64Kb to 16Mb.
ALTER TABLE <yourprefix>fanfiction_chapters MODIFY COLUMN storytext MEDIUMTEXT NOT NULL;
Usual Caveat: backup your database before changing it.
One thing to beware of: mysql defaults it's max_allowed_packet setting to 1Mb which means if the overall size of any query request or response is larger than that would fail. You should increase this - 32Mb is the normally recommended value. In the[mysqld] section of your my.cnf add:
max_allowed_packet = 32M
You can check what yours is set to at the moment by running the following from phpmysqladmin:
SHOW GLOBAL VARIABLES;
If you can't edit my.cnf, you can make efiction set it on each connection - add a line at the bottom of include/dbfunctions.php:
dbquery("SET max_allowed_packet = 33554432");
If you're going to use the dbquery jrabbit suggests, I'd suggest you just add that to stories.php rather than include/dbrunctions.php That way it only runs that query when stories are being added. It'll be kinder on your site resources.
Moving to general since it is a not a bug report, and is solved.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
