[Solved] Story texts and SQL modifying?

IzDoodle · 2011-01-03T10:37:54Z

URL to your eFiction:of eFiction: 3.5.2Have you bridged eFiction, if so with what?: NoVersion of PHP: 5.2.2Version of MySQL: 5.0.77Have you searched for your problem: YesIf so, what terms did you try: missing story text, word count, cutting story offState the nature of your problem: If a chapter is really long it cuts off. I have my settings to no max word limits. When you are posting everything shows up just fine, but after you post your story, it cuts half or more of the chapter off depending on how long it it. I found a few threads while searching and had a few questions because there seems to be different reasons why and different answers for each one. This hasn't been an issue before. Before we opened the site up, I had to stories stored in folders instead of my SQL but when I changed it over the problem was solved. I know I've had some issues with my SQL lately, so I'm thinking this is linked since the issue just started. First, I contacted my host, and they have cURL enabled. I hope that helps in some way with addressing this problem. (this was one of the solutions I found in the wiki and while searching) I was a little confused in the wording of some of the posts, and wondered if this was what I needed it to be. If not, my host can disable it, but is that a good idea if disabling is what I need to fix this? Again, I was confused on whether or not it was disabling or enabling that would help fix it. Second, I found this threadam beyond skittish when it comes to messing with my SQL, I'm guessing because I don't really know much about it. So I'm wondering if maybe this isn't the problem and if it could fix it, but this whole thing confuses me. I use phpMyAdmin (or that's what my host uses). When I pull up the chapters table, and sort by story text like the thread said, I notice that under "type" it doesn't say "text" it says "varchar" instead. I don't know if that means anything or not, but thought I'd point that out. Thirdly, again I don't know if this means anything or not, but under the "structure" tab in phpMyAdmin, the "Null" column has yes beside notes, story text and end notes. It also says "null" in the "default" column as well. In the other thread that I posted the link to, I did see where the setting should be set at "Not Null" and it is when I filter the chapters table to story text, but not under the main "structure" tab. Lastly, past that, I don't understand what any of the rest of the directions mean. I'm not even sure if this is what can fix my problem, but in the other thread it seems to point out exactly what is going on with me. The publisher of the other thread never said whether they tried it or not and if it worked correctly if they did. Can someone maybe explain if this sounds like it could work, and if so, how to do it exactly? My site is not as large as some of the other efiction sites. We have almost 1,400 members so that's big to me, but very small in the grand scheme of most sites. I don't know if site size has anything to do with it either, but thought I'd throw that in there too. I'm trying to give as much info, relevant or not, to help fix the problem. Thanks for any help you might be able to give. I know I just threw out a lot of info, but I wanted to be thorough with my explanation.

Page 2 / 2 Prev

Version 3.x General Support

Last Post by hobert 15 years ago

17 Posts

4 Users

0 Reactions

2,325 Views

RSS

IzDoodle

(@izdoodle)

Posts: 101

Estimable Member

Topic starter

I never paid that much attention to it before now, but last week :mrgreen:, I had a lot of SQL issues. My stories and chapter tables kept crashing. My host would go in and use the backup to reload them and then a few hours later they would crash again. I know they were in there messing with stuff to get it working right, and since this issue (although it's happened before) seemed to escalate and really cause problems about the same time. And just for the record, my host is complete clueless with anything efiction related, which just seems silly to me since it's written a language they are supposed to specialize in.
My co-owner and I believe that they probably changed a bunch of stuff while trying to fix the tables and that's what caused the problem. So, that's probably how that happened. The install was nearly flawless so I'm pretty sure that everything was uploaded correctly. I didn't mess with it and I know my host did, so that's my thoughts on it. (shrugs)

http://www.twiwrite.net
Where Your Imagination Can Run Free
18+ TwiWrite Fan Fiction Archives.
efiction vs.3.5.2
SQL vs. 5.0.77
PHP vs. 5.2.2
Happily soaking up any and all php, tpl, and html knowledge I can.

Posted : 05/01/2011 8:16 pm

hobert

(@hobert)

Posts: 61

Trusted Member

This might be a time to point out that one should not rely completely on the host's backups! If they even *do* backup.

You can easily export your whole MySQL database(s) to a flat text file that you can easily import back if needed (or for comparison) using the phpMyAdmin software. That way if something goes wrong, or someone goes messing with it, you can get back to something that was working before.

Program files can easily be redownloaded (and modified again) if needed, but losing that data that was added after install (or worse, the settings you eventually settled on!) can be devastating.

efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/

Posted : 06/01/2011 11:27 am

Page 2 / 2 Prev

32 Forums
3,758 Topics
20.9 K Posts
0 Online
4,465 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Become a Patron!

[Solved] Story texts and SQL modifying?

Share this:

Like this: