News

Review Count Bug

I uploaded the patch for the review count bug. If anyone still has bugs, let me know.

Posted by Megh on Jan 26, 2006 02:02 pm (13 Comments)
Comments

I still seem to have inflated review counts on two of my stories: "Coming Home" and "The More Things Stay the Same". Both are in Long and Completed. If there is anything I need to do, please let me know.

Embellished @ Jan 27, 2006 03:33 am


Somewhat of a different Bug, but for me, the Tens for "Most Reviewed Stories" aren't showing up. I use the Photobooth skin, if that helps any :)

Thanks for all your hard work Megh!!

Mika @ Jan 27, 2006 05:40 am


I still have an inflated review count for "Back to You". It's under "Works in Progress". Oh, and I was using the DGArchive skin but it seemed to disappear - I was just wondering if that was just my computer going wonky or if you guys actually took it down? Thanks for all the hard work!

CharmedLife19 @ Jan 27, 2006 06:08 am


AHHHHH! I LOVE THE NEW LAYOUT!!!

Funnykido @ Jan 27, 2006 10:32 am


Megh, I've got inflated review counts on my two WIPs - 'Homecoming' and 'Primrose Path'. Thanks!

Adelagia @ Jan 27, 2006 04:35 pm


There is a most scary message appearing when I try clicking on "Short Stories" or "Essays", etc. It looks like this -

A fatal MySQL error was encountered.
Query: SELECT stories.*, stories.title as title, author.penname, DATE_FORMAT(stories.updated, '%Y.%m.%d') as updatesort, DATE_FORMAT(stories.date, '%m/%d/%y') as date, DATE_FORMAT(stories.updated, '%m/%d/%y') as updated FROM secondfanfiction_authors as author, secondfanfiction_stories as stories WHERE FIND_IN_SET(1, stories.catid) > 0 AND stories.uid = author.uid AND stories.validated = '1'_ORDERBY LIMIT 0, 32
Error: (1064) You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '_ORDERBY LIMIT 0, 32' at line 1

Ylime @ Jan 28, 2006 04:35 am


Same here. All my other stories are okay but Exquisite Irony is registering over 1000 reviews, and as much as I'd love to have that many, I'm pretty sure it's nowhere near that number. LOL

Myanceris @ Jan 28, 2006 11:54 am


Actually, I stand corrected. Most of the counts are wrong. I was being a dunce.

Myanceris @ Jan 28, 2006 11:55 am


My review counts are way out for "Dragon and Angel". As nice as it would be I don't have over 25,000 reviews.

dragonsangel68 @ Jan 28, 2006 07:01 pm


FCM is showing up with 5,000+ reviews, which I'm sure isn't right.

smprsgrrl @ Jan 29, 2006 04:10 pm


My story 'Ice' still shows far too many reviews, sorry!

Sophinna @ Jan 30, 2006 02:33 am


I'm sure you're sick of hearing it, but it's still not right on one of my stories (the other 2 are fine).

Sue Bridehead @ Jan 30, 2006 09:14 am


At the risk of sounding cliched, i got one of those review bugs on 'Accountants'. Eek, sorry for causing any more problems...

Jewels @ Mar 01, 2006 08:30 am