Mysql errors [when pulling info from the video database.]

Corran · Post by **Corran** » Wed May 25, 2005 2:47 am

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/_includes/v3/videolist.php on line 11

I haven't seen anything committed to the svn recently so I'm not sure what introduced this bug. It shows up on all of the member pages I go to instead of the list of videos that user has created.

Kerydwenn · Post by **Kerydwenn** » Wed May 25, 2005 3:09 am

Add-on:

- There's also a problem when wanting to reach a vid using a link to its page (I tested with some of my vids, as well as with). The page displays:

Does not exist: This video does not (yet) exist. That can mean one of two things: Either you have followed a bad link or the video's creator has marked this video to premiere in the future. In the latter case, the video info will show up here once it premieres.

With the following error at the top of the page:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/members/members_videoinfo.php on line 71

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/members/members_videoinfo.php on line 72

- Problem with the SuperSearch as well (I tested the query with super-known anime and artists that are in the DB, not with unknown stuff):

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/search/supersearch.php on line 713

query time: 0.000185966491699
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/search/supersearch.php on line 735

We're sorry, but no results for your query.

These are what I've located so far, I haven't been hunting errors throughout the whole site though. I hope this can help in locating the problem more easily. If I've looked stupid by posting these, please pardon me.

Corran · Post by **Corran** » Wed May 25, 2005 3:53 am

Errors happens wherever video information is pulled.

C_Leckie · Post by **C_Leckie** » Wed May 25, 2005 7:23 am

yeah im getting it to looks like the database upgrade has went wrong in some way.

badmartialarts · Post by **badmartialarts** » Wed May 25, 2005 7:54 am

Maybe someone renamed the database file or something? Or it got deleted

Infinity Squared · Post by **Infinity Squared** » Wed May 25, 2005 9:03 am

Anyone suspecting an attack?

Oh gosh, I don't know how I'd live without the org

JaddziaDax · Post by **JaddziaDax** » Wed May 25, 2005 10:27 am

having this problem as well, i checked it out with several ways of looking at pages, i am guessing its something to do with the server... but i am patient, hope it comes back soon!

Moonlight Soldier · Post by **Moonlight Soldier** » Wed May 25, 2005 10:58 am

In addition, I get this when I try and look at my opinions received:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/members/opinions/received_ops.php on line 62

megaman917 · Post by **megaman917** » Wed May 25, 2005 11:06 am

I almost thought that I was the only one. Glad I'm not.

YouTube · Post by **derobert** » Wed May 25, 2005 11:12 am

It appears mysql managed to corrupt the videos_stats table. "repair table" seems to have made it work again.