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: 507
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy

MARP partially broken

Post by giro-X » Mon Jun 13, 2016 6:25 pm

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: 785
Joined: Mon Sep 27, 2004 8:16 pm

Re: MARP partially broken

Post by Zhorik » Mon Jun 13, 2016 7:35 pm

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: 507
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy

Re: MARP partially broken

Post by giro-X » Mon Jun 13, 2016 7:52 pm

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 » Mon Jun 13, 2016 9:36 pm

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: 507
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy

Re: MARP partially broken

Post by giro-X » Mon Jun 13, 2016 9:57 pm

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 Serf
MARP Serf
Posts: 182
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: MARP partially broken

Post by Cicca » Tue Jun 14, 2016 5:28 am

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 » Tue Jun 14, 2016 11:14 am

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: 507
Joined: Sun Dec 12, 2010 10:00 am
Location: Italy

Re: MARP partially broken

Post by giro-X » Sat Jul 16, 2016 11:56 pm

It's up again, the error reported on main post of this thread.

User avatar
simpsons99
MARP Seer
MARP Seer
Posts: 725
Joined: Mon May 16, 2011 3:23 am
Location: Snohomish Washington
Contact:

Re: MARP partially broken

Post by simpsons99 » Sun Jul 17, 2016 1:20 am

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: 4122
Joined: Mon Feb 04, 2002 10:05 pm
Location: New Zealand
Contact:

Re: MARP partially broken

Post by mahlemiut » Sun Jul 17, 2016 9:00 am

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

Post Reply