_GOTOBOTTOM
Site Talk
Site announcements, comments, or feedback about the site.
Reviews FUBAR'd
staff_Jim
Staff MemberPublisher
KITMAKER NETWORK
Visit this Community
New Hampshire, United States
Joined: December 15, 2001
KitMaker: 12,571 posts
Armorama: 6,599 posts
Posted: Tuesday, September 19, 2006 - 05:08 AM UTC
Our review table just suffered some major data loss when I tried to be clever and not do a backup prior to manually re-associating some dutch reviews. Basically every review in the entire network is currently residing in Armorama's Armor/AFV section. So if you are wondering why a link takes you there or why you can't find any in other areas that is why.

Hopefully I can get this resolved in quick order but with 1937 reviews it may be a while if I have to edit them line by line.



Jim
Pedro
Visit this Community
Wojewodztwo Pomorskie, Poland
Joined: May 26, 2003
KitMaker: 1,208 posts
Armorama: 1,023 posts
Posted: Tuesday, September 19, 2006 - 05:26 AM UTC
Just recently I've learned what FUBAR means in english, very useful...
Good luck with setting the reviews straight Jim!

Cheers
Greg
Grumpyoldman
Staff MemberConsigliere
KITMAKER NETWORK
Visit this Community
Florida, United States
Joined: October 17, 2003
KitMaker: 15,338 posts
Armorama: 7,297 posts
Posted: Tuesday, September 19, 2006 - 06:02 AM UTC
Ah, I see, now that I've checked the MG homepage. No problem, and good luck in getting it sorted out.
Henk
Visit this Community
England - South West, United Kingdom
Joined: August 07, 2004
KitMaker: 6,391 posts
Armorama: 4,258 posts
Posted: Tuesday, September 19, 2006 - 07:03 AM UTC
Jim, If you need a hand with any Dutch Language problems, give me a shout.

On this note, could somebody please PM me the url address for squirel, as I lost my bookmarks during my computers last hissy-fit...

Thanks

Henk
Henk
Visit this Community
England - South West, United Kingdom
Joined: August 07, 2004
KitMaker: 6,391 posts
Armorama: 4,258 posts
Posted: Tuesday, September 19, 2006 - 07:44 AM UTC
Thanks for the link Scott, I'm back in.

Cheers
Henk
staff_Jim
Staff MemberPublisher
KITMAKER NETWORK
Visit this Community
New Hampshire, United States
Joined: December 15, 2001
KitMaker: 12,571 posts
Armorama: 6,599 posts
Posted: Tuesday, September 19, 2006 - 07:49 AM UTC
I have restored a handful of the most recent reviews. However this is going to be a long painstaking process to do the rest. I will probably have to enlist help from the staff in editing some SQL files so the updates can happen more quickly.

:(

Jim
TUGA
#034
Visit this Community
Setubal, Portugal
Joined: April 26, 2002
KitMaker: 1,718 posts
Armorama: 1,130 posts
Posted: Tuesday, September 19, 2006 - 01:08 PM UTC
Hi,

Quoted Text

.... I will probably have to enlist help from the staff in editing some SQL files so the updates can happen more quickly. ...



If you think I can help count on me.


jimbrae
Visit this Community
Provincia de Lugo, Spain / España
Joined: April 23, 2003
KitMaker: 12,927 posts
Armorama: 9,486 posts
Posted: Tuesday, September 19, 2006 - 01:35 PM UTC
I'm correcting all of mine at the moment.

Just something to watch out for - They are set to the 'Default' Value 'User_Purchased' - so, if they're vendor supplied, they have to be changed...
jimbrae
Visit this Community
Provincia de Lugo, Spain / España
Joined: April 23, 2003
KitMaker: 12,927 posts
Armorama: 9,486 posts
Posted: Tuesday, September 19, 2006 - 02:28 PM UTC
All done....
Tarok
Visit this Community
Victoria, Australia
Joined: July 28, 2004
KitMaker: 10,889 posts
Armorama: 3,245 posts
Posted: Tuesday, September 19, 2006 - 04:01 PM UTC

Quoted Text

I will probably have to enlist help from the staff in editing some SQL files so the updates can happen more quickly



SQL... that's my game, baby!!

Jim, gimme a shout if you require my assistance.

Ahhh, the age old whoopsie of not backing up before making changes... don't worry, boss, I'm sure it's happened to every since IT geek in eternity - and then some! While working in the IT department of a dairy company I once rolled out changes to a remote branch without ensuring that I had a recent backup, and accidentally dropped their products table! Took me the whole night to fix my mistake... :-)

BTW, noticed a wingy-thing review over on HFM, guess we'd better all be on the lookout for those

Rudi

slodder
Visit this Community
North Carolina, United States
Joined: February 22, 2002
KitMaker: 11,718 posts
Armorama: 7,138 posts
Posted: Tuesday, September 19, 2006 - 04:08 PM UTC
Hate to say - I've tried to help but can't. There are SQL errors on MG review page.
I can't edit anything on Armorama and I know there are some over there that are MG reviews.

Gunny
Visit this Community
Pennsylvania, United States
Joined: July 13, 2004
KitMaker: 6,705 posts
Armorama: 713 posts
Posted: Tuesday, September 19, 2006 - 04:12 PM UTC
Ooooh Doggie!
FUBAR Maximus! (but not irrepairable)

As always, Jim, I'm here if need be! Just give a shout!
 _GOTOTOP