I have hacked eFiction slightly, mostly I just added two fields in the stories table, and have changed the listings template, so that it works as a database rather than an archive, because it's for fanvids, and I don't host them, just link to them.
If that doesn't make sense, my site is here: http://vidding.inthemoonlight.net/
I did not insert the vids manually, I created a huge database in excel and inserted them directly into the database via phpMyAdmin. I have manually created a "tester vid", for reference too.
My problem is that the reviews only show up on certain pages. I have only left three reviews so far, because the site isn't fully live yet. One is on "Come On" by here's luck. If you click the "1" or "Reviews" next to the vid details: "Title: Come On [Reviews - 1]" it shows up blank.
However, if you go to my profile and look at the reviews I have left, it will show the reviews under the vids.
Also, as I said, I did add a tester vid manually (through eFiction), and that one works just fine. Reviews show up everywhere that they're supposed to. Does anyone have any idea why this might be and what I can do to fix it?
If nobody has any ideas, can someone tell me which tables/columns relate to reviews, and I'll once again go through phpMyAdmin and see if I've got any problems there. When I was importing the database in, I left "rid" blank, and now there is a 1 in that column of all vids. Does that have anything to do with it?
All the information for reviews is stored in the reviews table.
I've had a look and there seems to be no difference in the reviews table between the review left on the manually entered vid and the phpMyAdmin entered vid. Any ideas why this might be happening?
Something probably isn't getting into the database correctly either in the stories table or in the reviews table. You'll have to go in and look at them.
