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

-- Gameboy9 (goldengameboy@yahoo.com), October 31, 1999

Answers

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

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:

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

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,"

-- Q.T.Quazar (qan@home.com), October 31, 1999.

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.

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

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

BTW: Is the swatch internet time correct on MARP?

-- Dave Kaupp (info@kaupp.cx), October 31, 1999.

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.

Ben Jos.

-- Ben Jos Walbeehm (walbeehm@walbeehm.com), October 31, 1999.

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

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: exceptions.IndexError value: list index out of range traceback:

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' % \

-- Dave Kaupp (info@kaupp.cx), November 01, 1999.

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

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

-- Dave Kaupp (info@kaupp.cx), November 01, 1999.

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

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

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]

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

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

correct the bad stuff and resubmit, or whinge to Zwaxy

-- Gameboy9 (goldengameboy@yahoo.com), November 01, 1999.

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

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.

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

The new recording is in position 1.

The new recording reduces your leaderboard score.

You may view a list of scores for this game by visiting: http://marp.retrogames.com/index.cgi?mode=frames&mode2=search&short=^t2-scramble$&per_game=99&tourn=2

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

http://marp.retrogames.com/inp/plf_t2-scramble_15450_mame34.zip

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

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

The new recording is in position 1.

-- Dave Kaupp (info@kaupp.cx), November 01, 1999.

When editing my score the following occured:

changed the score from 55556558 to 9876543210

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

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.

-- JoustGod (pinballwiz1@msn.com), November 02, 1999.

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

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

Cicca

-- Cicca (cicca@writeme.com), November 02, 1999.

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

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

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

Specify tournament number as &tourn=2 or whatever

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.

Thanks again :)

-- Gameboy9 (goldengameboy@yahoo.com), November 02, 1999.

A whole slew of SQL follies... T2

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

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

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

When selecting gameboy's name

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

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

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

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

-- Chris Parsley (cparsley1@hotmail.com), November 02, 1999.

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.

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.

Ben Jos.

-- Ben Jos Walbeehm (walbeehm@walbeehm.com), November 02, 1999.

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

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

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]

-- Q.T.Quazar (qan@home.com), November 03, 1999.

When submitting a T2 score for ccastles:

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

When submitting a T2 score for pbobble:

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

-- JoustGod (pinballwiz1@msn.com), November 03, 1999.

When submitting a recording for the tournament, the text still uses the T1 example. Might want to change it to T2 to avoid confusion.

This is the text. "t this is a tournament entry, put 't1-' in front of the name, like"

-- Dave Kaupp (info@kaupp.cx), November 03, 1999.

using the index.cgi?mode=search works fine, but using index.cgi?mode_frames search brings up only uploads from October and before.

The sql statement that is run is identical using search verses frame_search but the results are different.

-- Chad (churritz@cts.com), November 03, 1999.

OK. Now that MARP is using MySQL, I found that a lot (if not all) of the submissions of the past few days have disappeared. Some examples:

Brian McLean's submission on pooyan is no longer there. Buddude1's submission on dkongjp is no longer there. German Krol's 20 or 30 #1 earning submissions have vanished.

Ben Jos.

-- Ben Jos Walbeehm (walbeehm@walbeehm.com), November 03, 1999.

Here's another one. It's regarding e-mail notifications for T2.

I got two notifications for t2-pooyan submissions, one by Brian McLean, and one by gameboy9. Here are the critical lines:

The new recording was made by Brian McLean using version mame34 and scores 98120 on t2-pooyan (Pooyan).

The new recording was made by gameboy9 using version mame34 and scores 98120 on t2-pooyan (Pooyan).

The scores aren't correct! The scores that are displayed here are actually the score of Dave Kaupp's t2-pooyan submission...

Ben Jos.

-- Ben Jos Walbeehm (walbeehm@walbeehm.com), November 03, 1999.

Doesn't seem like the leaderboard is updating the positions at all Zwaxy. Could you check this out?

Another thing...I'm assuming anything uploaded to the old MARP site in the last few weeks was dumped, whereas the new scores to the SQL site were saved? I think you said something about this two weeks ago.

Thanx. The site's working better and better all the time. Q.T.Quazar

-- Q.T.Quazar (qan@home.com), November 03, 1999.

One the Up "Loads" page, the link associated with the screenshot (which used to display all clones (sf2|sf2ce|sf2dude)) returns zero hits, but the link associated with the specifc game name sf2dude works just fine.

-- Chad (churritz@cts.com), November 04, 1999.

The leaderboard and points are correct with those "lost" recordings now, Zwaxy, but the personal high score pages aren't. Krol and I both have first acording to our first-place lists on Arabian (Atari), even though he actually has the first place. Again, the leaderboard credits him with the points (I know, because I took a 2000 point nosedive) but my personal scores page lists me as having 100 points and 1st place on the game, while his lists him as having 0 points and 1st place on the game.

Food for thought, Q.T.Quazar

-- Q.T.Quazar (qan@home.com), November 04, 1999.