Story Info it's not...
 
Notifications
Clear all

Story Info it's not appearing - NEW PROBLEM

22 Posts
3 Users
0 Reactions
2,719 Views
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

URL to your eFiction: http://tokiohotelfictionpt.com
Version of eFiction: 3.5.1

Version of PHP: can be found out from your host - PHP version 5.2.5
Version of MySQL: can be found out from your host - MySQL version 4
Have you searched for your problem: yes
If so, what terms did you try: story showing
State the nature of your problem: when I click on the story it doesn't shows any information
test account you can use:
(adm test  account)
nick:test
pass: ***** Admin removed for security reasons. Please contact Poster directly for this if you want to help

Hi,(again lol)
if you login on my site, and click on any fic of the homepage, the fiction info like the title and author, text itself, etc does not shows.

It appears like the  print screen of this topic: https://efiction.org/forums/index.php?topic=6762.0  where Tammy said maybe there was something wrong with the mysql connectiom..
My account on mysql it's recent and yesterday the test fics were showing normally...it's this something I can resolve uploading a file again?

I can't delete any of that stories either, it just says there was an error.
Thanks!


 
Posted : 05/06/2009 7:05 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Firstly, I'm not sure how wise it is to give the whole general internet access to an admin level 1 account to your site. You should probably reserve that for people who request it and you can send it via PM, and maybe change it to level 3 so they can get past maintenance mode but don't have full admin powers. (Level 4 may also work for that, not sure.)

Anyway, it's not a basic problem with a database connection. I'm seeing all kind of other stuff from the database, like story titles, genres, all that stuff, on pages like this Categories page (Note: maybe not totally work-safe in Portuguese...): http://tokiohotelfictionpt.com/browse.php?type=categories&catid=2  But if I view the story 'teste' then all the info disappears, which makes me think it might be an issue with viewstory.php.

One thing to check, although it may not help, is in Admin > Settings > Submissions Settings, you've got where stories saved to set to MySQL. Is this correct, or is story text really being saved to the stories folder?

Also, this isn't related to your current issues, but eventually you'll want to go into Admin > Archive Maintenance and run all the recalc tools, as your counts are off.


 
Posted : 05/06/2009 7:23 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

Thanks for the level tip, I changed the count to level 3 πŸ™‚

when I first saw the error I updated viewstory.php again just to check if it could resolved the problem, I did it again now and it does not work...

about the site settings, when I first installed efiction I creted the fold stories with CHMOD 777 as explained on the instructions but then I read on wiki (at least I'm mistaken) that to use mysql would be more easy at the beginning and I changed to mysql,can that be the problem?

you said the counts are off, you're talking about read times and so on right? that was working fine before this problem.


 
Posted : 05/06/2009 8:18 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

For the counts, I was talking about when I viewed the categories it said there were two stories in one of them, but there were really three. It's a common thing and easy to fix with those tools in Archive Maintenance and unrelated.

What I think you should do is turn debug on and see if you get any additional warnings to show up. If nothing, it might be worth deleting all the test stories you've got up there and switching to using the stories folder. Maybe having the text in the database is too much for it. It could be timing out connections or something like that. I've seen threads where people talk about similar occurrences.


 
Posted : 05/06/2009 10:14 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

thanks, I will do as you said but my debug mode never worked, it's on right now, could you just tell me if you can the see errors?(if the level 3 lets you?* I can't forget to read about the different levels later*))

debug or not, I can't delete the fics so I can change the settings, as I said when I try it appears a warning saying there was an error and to try again


 
Posted : 05/06/2009 10:24 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Anyone can see the messages, so long as they can see the pages they're being generated on. (Sometimes admins see more or less messages, though, depending on if the admin-related code works with the page being viewed.) Anyway, I don't see anything new when just viewing the page. When I tried deleting, I got this:


Error! Foi encontrado um erro. Por favor retrocede e tenta de novo.

That looks like a translated version of the message from en.php. Have you translated your language file? There was another thread where someone else had that message coming up when they tried to edit/delete stories. It's related to the line that tries to pull info from the database. Both of you are having the same issue; I don't really know why.

Here's the other thread I'm talking about: https://efiction.org/forums/index.php?topic=7111.

Anyway, if you can access your database directly, through PHPMyAdmin or the like, you can delete the story yourself. This isn't recommended because you have to do more than just delete the entries in fanfiction_chapters and fanfiction_stories. There's coauthors and series and favorites and reviews, and then the fields in fanfiction_authorprefs that deal with the number of reviews and unresponded reviews, and the total story count for each author. Then in fanfiction_categories there's the numitems, which is the number of chapters per category (there's a recalculation tool for this in Archive Maintenance). Then there's modules like the Story Tracker module, and so on.

But, for your site, which is brand new, most of those would either be empty tables, or fields reset to 0. I suppose it's up for you to decide whether you want to go that route, or to maybe consider starting over again with a new database and make sure to use the stories folder, and then see if it works.

Sorry I can't offer better advice than that. :   Maybe someone else has got something better to try.


 
Posted : 05/06/2009 10:51 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

Okay, I'm checking that topic right now seeing what I can do!! Probably I will have to intall efiction all over again. damn.

But thanks for trying to help!! πŸ˜‰


 
Posted : 06/06/2009 11:01 am
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

Now I'm really freaking out, I already reinstalled efiction a few times - deleted the old database and each time with a new one,totally original files, and in the end the problem is there all the same,

I don't even know what this means!! it's a mysql, host, WHAT problem???  😑
HELP, please!


 
Posted : 06/06/2009 2:05 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Have you tried a new install using the stories folder for your text instead of MySQL? If so, what was the result?


 
Posted : 06/06/2009 5:55 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

yeah,both times I tried to install, one time just with the old file where I changed some things on default and the other with the original dowload of efiction, I used stories instead of mysql. It works just fine but when I add a story, the problem is the same - the info does not appears and I can't delete it. as I said just to be safe I used new and different mysql accounts.


 
Posted : 06/06/2009 9:41 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Hmm, I don't know, then. If it's not working even with a completely fresh install, it might be something to do with your host.


 
Posted : 06/06/2009 9:47 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

I would ask them, but I don't even know what to ask, knowing they don't know this software
ps: I noticed the other girl problem in the topic you gave me was the config.php, ...but again, if that was the problem in the 2nd install it would work right?


 
Posted : 06/06/2009 9:49 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

If the config.php isn't right, it shouldn't connect at all, I'd think.


 
Posted : 07/06/2009 1:09 am
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

okay,
to be true I don't know what I will do now after working on the site for weeks, I guess I will keep trying to find a solution.
thanks for your support!

ediited: ok, I'm done, I definetly can't find the solution after trying the whole day and i'm sure the host can't do anything about it,what's pretty frustating after spending a good bunch of money and time in this project , not only me but friends who worked hard to get it done *angry with the world right now* πŸ™


 
Posted : 07/06/2009 6:03 pm
 lipa
(@lipa)
Posts: 48
Eminent Member
Topic starter
 

I already conctacted the host, but for now I have a new problem that won't let them see what's wrong:

I validate the stories but if another person that not the admn. makes the login and clicks on the test story it's says "Access denied. This story has not been validated by the adminstrators of this site" - I'm sure I validated the story - but you can see by the test account it's says it wasn't, at least this problem has solution so the host can work on the main problem?


 
Posted : 08/06/2009 3:48 pm
Page 1 / 2
Share: