SQL Query in problem 8439

Post Reply
Monty

Post by Monty »

Can't open file: 'tries.MYI' (errno: 144), qry: SELECT COUNT(*) FROM tries WHERE problem = '8439' AND ip = '66.130.253.129'

{Posted by Monty}
geijin

Post by geijin »

The problem is global.
I think Adum modified something and messed some SQL :(
For a problem :
Can't open file: 'tries.MYI' (errno: 144), qry: SELECT COUNT(*) FROM tries WHERE problem = '1703' AND ip = '82.14.26.12'
On problems.php3 when searching for untried problems :
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/problems.php3 on line 134
It seems strange to see the ip in the where clause...

{Posted by geijin}
LCZLAPINSKI

Post by LCZLAPINSKI »

[quote]
Can't open file: 'tries.MYI' (errno: 144), qry: SELECT COUNT(*) FROM tries WHERE problem = '8439' AND ip = '66.130.253.129'
[/quote]
Yes, I'm getting the same type of error on all problems.

{Posted by LCZLAPINSKI}
postpostglock

Problems with filtering

Post by postpostglock »

Just to let adum know I'm getting the problems as well, specifically when filtering by Status:unsolved/order:easiest


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/problems.php3 on line 143

Warning: implode(): Bad arguments. in /home/.fabian/adum/html/goweb/html/problems.php3 on line 147

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/problems.php3 on line 171
Problems

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/func.html on line 307

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/func.html on line 328
None
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/.fabian/adum/html/goweb/html/func.html on line 362



{Posted by postpostglock}
eyedam

Post by eyedam »

Same here. :\ And already for some days.

It looks like there are some problems with the data base (not with SQL, IMO).

Let's hope this gets repaired soon. :)

{Posted by eyedam}
postpostglock

Fine now

Post by postpostglock »

Excellent! Working great now, thanks adum!

{Posted by postpostglock}
postpostglock

but now....

Post by postpostglock »

Now i seem to be getting

java.lang.UnsupportedClassVersionError: com/adum/go/GoApplet (Unsupported major/minor version 48.0)

on the actual applet (obviously) on my browser of choice (Opera v 8.54 on OS X).

Safari seems to work fine though...

{Posted by postpostglock}
Post Reply