Top 20 at reviews not working...

Krug · 13th August 2002, 12:29 AM

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 · 13th August 2002, 01:27 AM

Ditto.

EricNoah · 13th August 2002, 04:31 AM

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 · 13th August 2002, 04:40 AM

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 · 13th August 2002, 10:36 PM

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 · 14th August 2002, 02:12 AM

I'm here mate and doing my very best to fixit

, hmm 2am here think I need lots of coffee

!

Krug · 14th August 2002, 03:42 AM

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

EricNoah · 14th August 2002, 05:33 AM

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 · 15th August 2002, 12:16 PM

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 · 16th August 2002, 03:54 AM

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

Liquide · 16th August 2002, 03:54 AM

OK managed to retrieve 5 reviews for spycraft now and I have added them to the database, if you cannot find a review just send me an e-mail ( liquide@calandyr.com ) and I'll have another look at it again.

And the top20 list works as normal again.