Top 20 at reviews not working...

[Krug]

When I go to the Top 20 page I get:

Position/Product Publisher Score Reviews
error '80020009'
Exception occurred.

/top20.asp, line 186

 

[Khan the Warlord]

Ditto.

 

[EricNoah]

Crap. Spycraft was in the top 20 wasn't it? I'm sure that I screwed that entry up recently and can't fix it.

Let me try something...

 

[EricNoah]

Well I got the product ID problem fixed but somehow some of the reviews for the product aren't "linking up" to the Spycraft RPG entry correctly. Hopefully this is something Russ can look into when he gets back.

And sadly it didn't fix the Top 20 problem...

 

[EricNoah]

Well I think you can look at the Top 20 now. Except you'll see a notable boo boo -- Spycraft is nowhere to be found!

My guess is that the reviews are still in there somewhere but not linking up to the Spycraft entry.

We'll see what Russ can do once he gets back. Or ... Liquide ... are you out there somewhere??

 

[Liquide]

I'm here mate and doing my very best to fixit , hmm 2am here think I need lots of coffee !

 

[Krug]

I figure it contains info that the illumanati doesn't want the world to know.

 

[EricNoah]

Ok here is the scoop at the moment...

Some weird bug allowed me to accidentally overwrite the ABRV field in the Spycraft RPG record. When I tried to change it back to its original value I somehow got it merged with the Spycraft GM Screen entry. Long story short, I wiped out the mangled entry and re-entered both products. As you can see, the Spycraft RPG reviews have vanished. Ick!

Good news is that Liquide has a backup from a couple of months ago, and so will likely be able to restore those reviews of the Spycraft RPG that were written prior to that date. Any reviews written on the Spycraft RPG after that time would have to be re-entered (if the reviewer has saved his or her work, or cares to write a new review).

I'm really sorry about that, folks -- I'm usually a lot more careful than that.

 

[Liquide]

OK will have the reviews that exist fixed today, was a lot of searching and cross-refernce that had to be done to check that I didn't deleted anything else by mistake

Will post here again when I'm done.

 

[EricNoah]

Cool, looking good! Spycraft is even back in the top 20. Good work!