MARP partially broken

General discussion on MAME, MARP, or whatever else that doesn't belong in any of the other forums

Moderators: mahlemiut, seymour, QRS

Post Reply
User avatar
giro-X
MARPaltunnel Wrists
MARPaltunnel Wrists
Posts: 582
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy
Contact:

MARP partially broken

Post by giro-X »

I believe I'm not alone in seeing a crash into some areas of the site.
This is happening when loading "Loads".

Code: Select all

exception! Please copy and paste the text from this page into a mail message to Zwaxy, telling him what you were doing when this happened. And what drugs/medication you were on:
type:
value: (145, "Table './mamereplay/allscores' is marked as crashed and should be repaired")
traceback:
  File "/home/dooglus/replay.marpirc.net/main.py", line 400, in main
    search.do_search(cmd_line)
  File "/home/dooglus/replay.marpirc.net/search.py", line 1012, in do_search
    data = database.select_allscores(where_clauses, joins, sort, maxlines, ignore_string)
  File "/home/dooglus/replay.marpirc.net/database.py", line 246, in select_allscores
    ret = run_query(query, debug)
  File "/home/dooglus/replay.marpirc.net/database.py", line 86, in run_query
    cursor.execute(query)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
The same error message appears when doing any research with any criteria.
"Up" is working (very useful to know there have been 5 new easy first places to catch because nobody played those games, that I missed from my last visit).
Didn't test Submit yet with a real submission.
"Leaders" is a blank page.
No problem with other pages such as Index, 1st, Top3, Confirms, etc.
Experts in IT will laugh at me probably if I say I confirm it doesn't depend on user logged in or visitor, or browser used.

Of course somebody would have noticed it anyway (always if it's not a trouble affecting only me), so making a topic to report what's happening is sort of silly.
I'd like to understand what's happening, and if there's anything that can be done. Considering the visits frequency of Zwaxy lately in the years, dunno how useful is to send him a mail with this error messages.
User avatar
Zhorik
MARP Seer
MARP Seer
Posts: 788
Joined: Mon Sep 27, 2004 8:16 pm

Re: MARP partially broken

Post by Zhorik »

giro-X wrote:I believe I'm not alone in seeing a crash into some areas of the site.
This is happening when loading "Loads".

Code: Select all

exception! Please copy and paste the text from this page into a mail message to Zwaxy, telling him what you were doing when this happened. And what drugs/medication you were on:
type:
value: (145, "Table './mamereplay/allscores' is marked as crashed and should be repaired")
traceback:
  File "/home/dooglus/replay.marpirc.net/main.py", line 400, in main
    search.do_search(cmd_line)
  File "/home/dooglus/replay.marpirc.net/search.py", line 1012, in do_search
    data = database.select_allscores(where_clauses, joins, sort, maxlines, ignore_string)
  File "/home/dooglus/replay.marpirc.net/database.py", line 246, in select_allscores
    ret = run_query(query, debug)
  File "/home/dooglus/replay.marpirc.net/database.py", line 86, in run_query
    cursor.execute(query)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
The same error message appears when doing any research with any criteria.
"Up" is working (very useful to know there have been 5 new easy first places to catch because nobody played those games, that I missed from my last visit).
Didn't test Submit yet with a real submission.
"Leaders" is a blank page.
No problem with other pages such as Index, 1st, Top3, Confirms, etc.
Experts in IT will laugh at me probably if I say I confirm it doesn't depend on user logged in or visitor, or browser used.

Of course somebody would have noticed it anyway (always if it's not a trouble affecting only me), so making a topic to report what's happening is sort of silly.
I'd like to understand what's happening, and if there's anything that can be done. Considering the visits frequency of Zwaxy lately in the years, dunno how useful is to send him a mail with this error messages.
I'm seeing the same errors. I've sent Zwaxy a PM about the issue and am also trying to get mahlemiut engaged to see if he can help.
User avatar
giro-X
MARPaltunnel Wrists
MARPaltunnel Wrists
Posts: 582
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy
Contact:

Re: MARP partially broken

Post by giro-X »

Working properly again. Thank you for the fix, "person" or "entity" that did the thing. :D
Now, I would like to know how I have to behave if this should happen again in the future.
User avatar
Zwaxy
MARP Founder
Posts: 129
Joined: Tue Jul 16, 2002 9:17 am
Location: British Columbia, Canada

Re: MARP partially broken

Post by Zwaxy »

Thanks for the PM.

I logged in to look at the error but it was already fixed.

I also got the email alerts working again.
User avatar
giro-X
MARPaltunnel Wrists
MARPaltunnel Wrists
Posts: 582
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy
Contact:

Re: MARP partially broken

Post by giro-X »

Zwaxy wrote:Thanks for the PM.

I logged in to look at the error but it was already fixed.

I also got the email alerts working again.
Good to know, thanks :)
User avatar
Cicca
MARP Knight
MARP Knight
Posts: 209
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: MARP partially broken

Post by Cicca »

Zwaxy wrote:Thanks for the PM.
......
I also got the email alerts working again.
Do you mean....those when one of your scores is beaten...?! That's great !!! :)
User avatar
diabolik
MARP Knight
MARP Knight
Posts: 287
Joined: Sat Mar 09, 2002 6:48 pm
Location: Finland

Re: MARP partially broken

Post by diabolik »

Zwaxy wrote: I also got the email alerts working again.
A big thank you for fixing this!
User avatar
giro-X
MARPaltunnel Wrists
MARPaltunnel Wrists
Posts: 582
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy
Contact:

Re: MARP partially broken

Post by giro-X »

It's up again, the error reported on main post of this thread.
User avatar
simpsons99
MARP Seer
MARP Seer
Posts: 740
Joined: Mon May 16, 2011 3:23 am
Location: Snohomish Washington
Contact:

Re: MARP partially broken

Post by simpsons99 »

yes i am getting that message now on everything .. I clicked on the leader board because of the other topic .. Leader Board is completely gone.
If you have a FB Account I'm Brian Allen
On KLOV and other sites I'm Simpsons99
Arcade Game Scores
DKJR 1,073,800 Level F Kill screen !
DK3 TG MED Skill Level 1,365,000 Level 80?
User avatar
mahlemiut
Editor
Posts: 4183
Joined: Mon Feb 04, 2002 10:05 pm
Location: New Zealand
Contact:

Re: MARP partially broken

Post by mahlemiut »

Appears to be working again.
- Barry Rodewald
MARP Assistant Web Maintainer
Image
Post Reply