Strange error in the bottom of the site.

DJ-Loki · **Strange error in the bottom of the site. -** 03-13-2003, 04:14 PM

Hi,

I have a strange error at the very bottom of my site.

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/dj-loki.com/httpdocs/includes/sql_layer.php on line 301

I only saw it today, but maybe it was already there for weeks! What could it be? It only occurs at the begin page. Strange!

Martin · 03-13-2003, 06:09 PM

That error is usually caused by a mysql table missing from the database. Have you recently made changes and added anything to the site?

chatserv · 03-13-2003, 09:24 PM

To get a more descriptive error message, you can edit the "case" lines in the sql_layer.php.
For example, this is the "case" that starts at line 300 in the nuke 6.0 sql_layer.php

change:

Code:

case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;

to:

Code:

case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;

You will still get the errors but they should now have extra info, like table nuke_somename does not exist, this will make it easier to track down the problem.

DJ-Loki · 03-14-2003, 04:01 AM

Hmm, ok i will try that. And yes i have made some changes. I have upgraded MS-Analysis fom RC2 to RC3 and i have made some changes to the theme.

DJ-Loki · 03-14-2003, 04:09 AM

Ok done it! This is what i get:

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/dj-loki.com/httpdocs/includes/sql_layer.php on line 301
Table 'forum._users' doesn't exist

Table "forum_users" doesn't exist!!!??? 8O :?: 8O

DJ-Loki · 03-14-2003, 02:51 PM

Is there anyboy who can help me??

mikem · 03-14-2003, 03:08 PM

Do all your tables in your MySQL database start with forum_ ?
Ususally on a nuke install, the tables are prefixed with nuke_
nuke_users
not
forum_users, unless you changed that for the install, which is ok.
However, some script you have running is looking for the forum_users table it appears... :?

mikem

mikem · 03-14-2003, 03:12 PM

Hey can you give us a link to your site?

mikem

DJ-Loki · 03-14-2003, 03:15 PM

No, all my nuke tables start with nuke_. I was thinking: i have removed the last footer line. It said theme smartDark by (you) Mikem. I had changed the theme drastic so.....

ops: But could that be the problem?

http://www.dj-loki.com

DJ-Loki · 03-14-2003, 03:19 PM

But my database name is forum.