randomtheme error

Posted: Thu Apr 05, 2007 2:32 pm

Hi!

When trying to work out this module, i find that i've an error which reads:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/doingmything/includes/sql_layer.php on line 286
Access Denied

ummm...what have i done incorrectly?

TIA

Posted: Thu Apr 05, 2007 2:45 pm

sanpaku wrote:

Hi!

When trying to work out this module, i find that i've an error which reads:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/doingmything/includes/sql_layer.php on line 286
Access Denied

ummm...what have i done incorrectly?

TIA

This is a very "general" type error . Can you turn error reporting on as well? Also, the title of your post,

Quote:

randomtheme error

can you be more descriptive? Is this a module, block , what ? What version of nuke?

Posted: Thu Apr 05, 2007 3:07 pm

[quote="hue"]

sanpaku wrote:

Hi!

When trying to work out this module, i find that i've an error which reads:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/doingmything/includes/sql_layer.php on line 286
Access Denied

ummm...what have i done incorrectly?

TIA

This is a very "general" type error . Can you turn error reporting on as well?

Not sure exactly what that is Sad

Sorry...still muddling thru learning in/outs of nuke

This is a block: nuke vs is 76; nothing in block details that specifies particular vs capable of working on:

install directions pretty basic - only outta sorts is that of the english lang file but doable.

add'l details if helpful:
# Block - Random Theme
http://www.kissoftware.co.uk

Appears site no longer active/avail nor can i scour any info on author - lippylion.

bunch of tia!

Posted: Thu Apr 05, 2007 3:24 pm

[quote="sanpaku"]

hue wrote:

sanpaku wrote:

Hi!

When trying to work out this module, i find that i've an error which reads:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/doingmything/includes/sql_layer.php on line 286
Access Denied

ummm...what have i done incorrectly?

TIA

This is a very "general" type error . Can you turn error reporting on as well?

Not sure exactly what that is Sad

Sorry...still muddling thru learning in/outs of nuke

This is a block: nuke vs is 76; nothing in block details that specifies particular vs capable of working on:

install directions pretty basic - only outta sorts is that of the english lang file but doable.

add'l details if helpful:
# Block - Random Theme
http://www.kissoftware.co.uk

Appears site no longer active/avail nor can i scour any info on author - lippylion.

bunch of tia!

Please post line 286 .

Posted: Thu Apr 05, 2007 9:11 pm

[quote="hue"]

sanpaku wrote:

hue wrote:

sanpaku wrote:

Hi!

When trying to work out this module, i find that i've an error which reads:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/doingmything/includes/sql_layer.php on line 286
Access Denied

ummm...what have i done incorrectly?

TIA

This is a very "general" type error . Can you turn error reporting on as well?

Not sure exactly what that is Sad

Sorry...still muddling thru learning in/outs of nuke

This is a block: nuke vs is 76; nothing in block details that specifies particular vs capable of working on:

install directions pretty basic - only outta sorts is that of the english lang file but doable.

add'l details if helpful:
# Block - Random Theme
http://www.kissoftware.co.uk

Appears site no longer active/avail nor can i scour any info on author - lippylion.

bunch of tia!

Please post line 286 .

Lines 280-290

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

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

case "mSQL":

Posted: Fri Apr 06, 2007 4:11 am

Here's a little trick that I found at www.karakas-online.de .
Find this code below

Code:

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

and replace it with something like this

Code:

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

Once that's done, overwrite your file and check the error now ! Note, this is not a fix . What this will do is give you more of a descriptive error so that it can be fixed Smile

As always, make backups of your files before doing any edits.

Posted: Thu Apr 12, 2007 2:23 pm

Ok - here we go!

Parse error: syntax error, unexpected ')' in /home/www/dreamwur/includes/sql_layer.php on line

And now, wouldnt you know that i've gotten the same error(s) on my recipe module.

Parse error: syntax error, unexpected ')' in /home/www/dreamwur/includes/sql_layer.php on line 339

Is this amiss on my end? Last year, running same version of the recipe module, i had abs no issues. Cant say same of the randomtheme module.

I'm pulling my hair out reading the PHP-How-to...its a great little write up PROVIDED that you've a clue what you're looking at/for Smile

(shez, i need to learn more PHP!)

tia!

Posted: Thu Apr 12, 2007 4:19 pm

sanpaku wrote:

Ok - here we go!

Parse error: syntax error, unexpected ')' in /home/www/dreamwur/includes/sql_layer.php on line

And now, wouldnt you know that i've gotten the same error(s) on my recipe module.

Parse error: syntax error, unexpected ')' in /home/www/dreamwur/includes/sql_layer.php on line 339

Is this amiss on my end? Last year, running same version of the recipe module, i had abs no issues. Cant say same of the randomtheme module.

I'm pulling my hair out reading the PHP-How-to...its a great little write up PROVIDED that you've a clue what you're looking at/for Smile

(shez, i need to learn more PHP!)

tia!

It looks at though you pasted the code in the wrong place (the code I suggested) . Getting back to your random theme block , I am sure if it's random then it has to pull the loaded themes from the database . That said, did you run any sql queries for this block >?