Author Topic: db error  (Read 3302 times)

0 Members and 1 Guest are viewing this topic.

Offline carl

  • Pre-Newbie
  • Posts: 1
    • View Profile
db error
« on: September 12, 2002, 01:01:24 PM »
:cry:


Just installed it, looks very good!

After a few logins and outs got the following error:

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0) ORDER BY i.image_date DESC LIMIT 3
Lost connection to MySQL server during query

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/dooyewee/hilbert/album/includes/db_mysql.php on line 116


What is the problem here, how can i fix it and prevent it from happing again



Greetings Carl

Offline Nossie

  • Jr. Member
  • **
  • Posts: 67
    • View Profile
    • GothicWinter.Com
Re: db error
« Reply #1 on: September 16, 2002, 07:43:35 PM »
Quote from: carl
Code: [Select]

Lost connection to MySQL server during query

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/dooyewee/hilbert/album/includes/db_mysql.php on line 116


Hi Carl,
have you only seen this error once?
Its possible for this error to happen on a few occasions when the information transmitted gets interupted..  maybe your mysql database is on a different server?

If you've only seen this once then it shouldnt be a problem.. (the mysql termination would explain the other errors)..

but if you see it lots of times you might be overloading the mysql server with queries sent...

hope that helps
(\).
MOTD: LINUX IS LIKE A WIGWAM - NO WINDOWS, NO GATES, APACHE INSIDE !!!