Gallery+MySQL erro

Sergeant Joined: Mar 26, 2003 Posts: 89

hello once agine
last night i have installed Gallery.
now it works fine and everything is good except one errror.
on top of my nuke pages i have got this line of error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/nuke/www/www/english/modules/Gallery/classes/database/mysql/Database.php on line 35
and everytime i click on Gallery link this error appears on the verey top of the theme or page.
when i am trying to post a comment for a page, the winwod opens and it posts the comment and everything but it has that error on it
any ideas?
plz help

Joined: Jan 31, 2004 Posts: -88

find that line in that file, and change sql_fetch_row to sql_fetchrow

AI

Sergeant Joined: Mar 26, 2003 Posts: 89

thank you
works

Posted: Fri May 02, 2003 10:00 am

ArtificialIntel wrote:

find that line in that file, and change sql_fetch_row to sql_fetchrow
AI

If I do that I get another errormessage:
Error: fetch_row() should be overridden by a subclass!

My Database.php code (without the correction)

Code:

?>
<?php
class MySQL_Database extends Abstract_Database {
var $link;

function MySQL_Database($host, $uname, $pass, $dbname) {
   $this->link = mysql_connect($host, $uname, $pass);
   mysql_select_db($dbname, $this->link);
}

function query($sql) {
   return mysql_query($sql, $this->link);
}

function fetch_row($results) {
   $row = mysql_fetch_row($results);
   return $row;
}
}
?>

Joined: Jan 31, 2004 Posts: -88

wrong file. Turn on SQL debug mode, and see what page / file is actually causing the error. that message itself is just where the errors being noticed.

AI

Posted: Fri May 02, 2003 10:59 am

I upgraded to 1.3.4 and it solved the problem. Thx.
FYI: http://gallery.menalto.com/modules.php?op=modload&name=phpBB_14&file=index&action=viewtopic&topic=5719&24631

Thanx!