forums.marpirc.net

Please place all bug reports here. The URL? http://marp.retrogames.com/sql

--
goldengameboy@yahoo.com

Here's what I got when I tried to upload a recording for Discs of
Tron, Zwaxy:

<p>

SELECT score, confirmed, version, date, inp, description, pos, percent
FROM allscores WHERE short_name = 'dotron'
AND prefix = 'qcn'
DELETE FROM allscores WHERE short_name = 'dotron' AND prefix = 'qcn'
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 music you were listening to:

<p>

type: exceptions.TypeError
value: not enough arguments for format string
traceback:

<p>

File "main.py", line 341, in main
upload.do_upload(cmd_line)
File "upload.py", line 224, in do_upload
position = insert_high_score(short, score, tag, version, 0,
the_udt, basename, desc)
File "./scores.py", line 86, in insert_high_score
database.insert_oldscores(short, oldscore, oldconfirmed,
File "./database.py", line 307, in insert_oldscores
query = ("INSERT INTO oldscores (short_name, score,
confirmed, prefix,"

--
qan@home.com

I go to http://marp.retrogames.com/sql/, goto tournament. I'm on the
2nd marp tournament page, T2 is in the top left corner.

<p>

I login, I select the tournament 2 link. I'm in the 1st marp
tournament page, T1 is displayed in the top left corner.

<p>

All links (submit, leaders) show that its tournament 1.

<p>

BTW: Is the swatch internet time correct on MARP?

--
info@kaupp.cx

10 seconds after you left, I found another one Zwaxy: I edited the
description, and my new description had a quote (') in it. Got an
exception. Then I escaped the quote with a backslash (so ') and it
worked fine. The backslash didn't show up in the processed
description.

<p>

Ben Jos.

--
walbeehm@walbeehm.com

When selecting 'Download all firstplace recordings', the following
error.

<p>

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:

<p>

type: exceptions.IndexError
value: list index out of range
traceback:

<p>

File "./main.py", line 317, in main
zip.do_tops(cmd_line)
File "zip.py", line 30, in do_tops
filenames = filenames + ' %s/%s.zip' %

--
info@kaupp.cx

Downloading a T2 recording gives this result.
The requested URL /inp/bjw_t2-pooyan_1234567890_mame34.zip was not
found on this server.

<p>

Manually putting in the following works.
marp.retrogames.com/sql/inp/bjw_t2-pooyan_1234567890_mame34.zip

--
info@kaupp.cx

This is what happens when I try to put an apostrophe in the comments.
<p>

type: MySQL.error
value: parse error near 'm not counting my second one)', 0, 0)'
at line 1
traceback:

<p>

File "./main.py", line 341, in main
upload.do_upload(cmd_line)
File "upload.py", line 224, in do_upload
position = insert_high_score(short, score, tag, version, 0,
the_udt, basename, desc)
File "scores.py", line 90, in insert_high_score
database.insert_allscores(short, new, 0, player,
File "database.py", line 79, in insert_allscores
return DB[query]

<p>

IN ADDITION, when I tried to reupload for LDRUN, I got this...

<p>

there is no entry in the table for t2-ldrun
not even an empty one
that shouldn't happen
Error updating high score table? - upload aborted

<p>

correct the bad stuff and resubmit, or whinge to Zwaxy

--
goldengameboy@yahoo.com

I recieved 3 upload notifcations from gameboy, 2 of tjem beat my
scores, 1 did not.

<p>

The 2 that beat my score, listed my score and not gameboys in the
notification. The one that did not beat my score had gamenoys score in
the notification.
Your account (login 'djk') is set up to email you about
any upload for a game for which you already have a score.

<p>

<FIRST>
The new recording was made by gameboy9 using version mame34
and scores 5240 on t2-scramble (Scramble).

<p>

The new recording is in position 1.

<p>

The new recording reduces your leaderboard score.

<p>

You may view a list of scores for this game by visiting:

http://marp.retrogames.com/index.cgi?mo ... 99&tourn=2

<p>

It can be downloaded from the Action Replay Page, as usual, or from:

<p>

http://marp.retrogames.com/inp/plf_t2-s ... mame34.zip

<p>

<FIRST>

<p>

<SECOND>
The new recording was made by gameboy9 using version mame34
and scores 7170 on t2-lrescue (Lunar Rescue).

<p>

The new recording is in position 2.
<SECOND>
<THIRD>
The new recording was made by gameboy9 using version mame34
and scores 9400 on t2-ccastles (Crystal Castles (set 1)).

<p>

The new recording is in position 1.
<THIRD>

--
info@kaupp.cx

When editing my score the following occured:
<p>

changed the score from 55556558 to 9876543210

<p>

somebody wrote some code to move the modified score up or down if
needed - if it didn't work, please email Zwaxy

<p>

new score '9876543210' -> 9876543210.0
recalculating positions...
raw data: [[2147483647, 'jg'], [1234567890, 'bjw'], [124100, 'plf']]
top score is 2147483647
score of 2147483647 by jg in position 1 gets 100 points
score of 1234567890 by bjw in position 2 gets 49 points
score of 124100 by plf in position 3 gets 0 points
The old score wasn't confirmed, so there's no need to unconfirm it.
edited the description
searching for score for t2-pooyan by jg
didn't find score 9876543210 for t2-pooyan by jg on version mame34
Changes applied successfully.

--
pinballwiz1@msn.com

Dave....now the links are correct....but I would like to see link for
T1 still active....for "documentation"...

<p>

The Internet Swatch Time is correct....actually it should be rounded
to units, but it's ok !

<p>

Cicca

--
cicca@writeme.com

Two more things, I tried to reset the error myself, but when I tried
to delete the recordings...

<p>

Problem with score data for 't2-ldrun' - please email Zwaxy.

<p>

Another problem... when I try to edit the rules of the tournament, I
get this:

<p>

Specify tournament number as &tourn=2 or whatever

<p>

One final thing, the point values for the tournament are incorrect.
It's saying for rastan that Dave scored 100 points for his recording,
and I scored 13 points. It should be Dave scored 4 points, and I
scored 3 per the T2 rules.

<p>

Thanks again

--
goldengameboy@yahoo.com

A whole slew of SQL follies...
T2

<p>

When selecting (2 games have no score yet...)

<p>

running MySQL query: SELECT a.short_name, score, confirmed, a.prefix,
version, date, inp, description, original, full_name, long_name, pos,
percent FROM allscores a, tagdata t, gamedata g WHERE tournament = 2
AND pos <= 3 AND pos >= 1 AND a.prefix = t.prefix AND a.short_name =
g.short_name ORDER BY g.short_name, score desc, full_name LIMIT 1000

<p>

query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took
0.018s

<p>

When selecting gameboy's name

<p>

running MySQL query: SELECT a.short_name, score, confirmed, a.prefix,
version, date, inp, description, original, full_name, long_name, pos,
percent FROM allscores a, tagdata t, gamedata g WHERE full_name LIKE
'gameboy9' AND tournament = 2 AND pos <= 99 AND pos >= 1 AND a.prefix
= t.prefix AND a.short_name = g.short_name ORDER BY g.short_name,
score desc, full_name LIMIT 1000

<p>

query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took
0.214s

<p>

running MySQL query: SELECT a.short_name, score, confirmed, a.prefix,
version, date, inp, description, original, full_name, long_name, pos,
percent FROM allscores a, tagdata t, gamedata g WHERE (a.short_name =
't2-ccastles' AND score > 171950 OR a.short_name = 't2-jrpacman' AND
score > 44220 OR a.short_name = 't2-kungfum' AND score > 33260 OR
a.short_name = 't2-lrescue' AND score > 7170 OR a.short_name = 't2-
pooyan' AND score > 124100 OR a.short_name = 't2-rastan' AND score >
47600 OR a.short_name = 't2-scramble' AND score > 15450 OR
a.short_name = 't2-ssprint' AND score > 13210) AND a.prefix =
t.prefix AND a.short_name = g.short_name ORDER BY g.short_name, score
desc, full_name LIMIT 992

<p>

query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took
0.018s

--
cparsley1@hotmail.com

The "running SQL query" messages are normal. That is just additional
output that can be helpful in debugging, and it will be turned off
once Zwaxy is satisfied with how things are working.

<p>

As long as it doesn't say "exception" or "error" or shows you an
unexpected or missing page (so an incorrect link), it probably is not
the result of a bug.

<p>

Ben Jos.

--
walbeehm@walbeehm.com

Caught me another one. Submitting for tailgunner, no idea what caused
it.

<p>

type: MySQL.error
value: parse error near 'll do even better yet.', 0, 0)' at line
1
traceback:

<p>

File "main.py", line 348, in main
upload.do_upload(cmd_line)
File "upload.py", line 224, in do_upload
position = insert_high_score(short, score, tag, version, 0,
the_udt, basename, desc)
File "scores.py", line 91, in insert_high_score
database.insert_allscores(short, new, 0, player,
File "database.py", line 79, in insert_allscores
return DB[query]

--
qan@home.com

When submitting a T2 score for ccastles:
<p>

there is no entry in the table for t2-ccastles
not even an empty one
that shouldn't happen
Error updating high score table? - upload aborted

<p>

When submitting a T2 score for pbobble:

<p>

there is no entry in the table for t2-pbobble
not even an empty one
that shouldn't happen
Error updating high score table? - upload aborted

--
pinballwiz1@msn.com