subBlack3d SQL error

Nuke Cadet Joined: Aug 15, 2003 Posts: 6

Hi and thanks for giving us this awsome theme Very Happy

Have a problem

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sueltate/public_html/includes/sql_layer.php on line 286

Nuke 6.8

Thanks

Vic

Guest

Yeah, i've got the same.

Tested on Nuke 6.5 and 6.7.

Btw. many thx for this awesome layout.
Nukemods ownz! Twisted Evil

Posted: Wed Aug 27, 2003 3:49 pm

I was afraid of little issues like this which is going to make it a little tricky to update the themes. However try this.

open your theme.php file for the subBlack3D theme pack

find this and remove it

Code:

$topics_list = "<select name=\"new_topic\" onChange='submit()'>\n";
$topics_list .= "<option value=\"\">All Topics</option>\n";
$toplist = sql_query("select topicid, topictext from ".$prefix."_topics order by topictext", $dbi);
while(list($topicid, $topics) = sql_fetch_row($toplist, $dbi)) {
if ($topicid==$topic) { $sel = "selected "; }
$topics_list .= "<option $sel value=\"$topicid\">$topics</option>\n";
$sel = "";
}

see if that does the trick.

mikem

Posted: Wed Aug 27, 2003 3:55 pm

HURRAY!

Thx mikem! U are the best!

Guest

HURRAY!

Many thx mike, u are the best Exclamation

Posted: Wed Aug 27, 2003 4:00 pm

Jagger wrote:

HURRAY!

Many thx mike, u are the best Exclamation

Cool! Great.

Ok if ANYONE downloads ANY of the nukemods theme packs and uses them on version 6.7 or higher of Nuke, then try the above fix if you have the same problem. I will update and check all theme packs for this ASAP.

Thanks guys for the heads-up Smile

mikem

Nuke Cadet Joined: Aug 15, 2003 Posts: 6

Ok mikem did your fix suggestion did not work for me, still get the same error.

2. On the home page story block it stretches to accommodate the article instead of accommodating the article to the block so if the article was written in a 600 wide format it will actually stretch the block that with.

3. I am changing the colors of the theme and I have found most of where to change settings but i can not change the color of the footer or the center blocks in the main page, can you please point me the right way.

4. Also my site is in spanish right now the whole forum whent english I went to forum admin and still says spanish but forums are in english since I am editing graphichs to change color have not time to figure it out, have an idea would be nice.

5. Since you have a fowarding page on your old page I can not get to the donation block would you be so kind to give me your paypal email to make my donatio.

Thanks
Vic
Very Happy

Posted: Wed Aug 27, 2003 7:15 pm

Okay Vifra Smile

1. Where's number 1? Wink

or was it the fix suggestion? If the latter, please turn on Nuke debugging.

2. can I see an example of what you mean?

3. ANY changes are not necessarily supported. However, when you say you are changing colors, that is a very vague statement. Colors of what? gaphics, tables? borders? umm...table cells, table rows, text, text links, hover?

4.any language support is mainly for the forums template. Unfortunately, I am not the developer of the Forums template as you can see in the Readme file and theme.php file.
I would recommend finding the source of the template developer to see if any language support is supported Rolling Eyes

The Nuke side of the theme "should" fully support the regular Nuke language changes. Does it? Or is it just the Forum tempalte side that is not coinciding with the Language?

5. donations@nukemods.com valid thru 09-14-03

mikem

Nuke Cadet Joined: Aug 15, 2003 Posts: 6

Hi Mike:

Ok I got everything taken care exept language wich I will follow your instruction and of course #1 he he the

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sueltate/public_html/includes/sql_layer.php on line 286

I did as per your instructions and removed

Code:

$topics_list = "<select name=\"new_topic\" onChange='submit()'>\n";
$topics_list .= "<option value=\"\">All Topics</option>\n";
$toplist = sql_query("select topicid, topictext from ".$prefix."_topics order by topictext", $dbi);
while(list($topicid, $topics) = sql_fetch_row($toplist, $dbi)) {
if ($topicid==$topic) { $sel = "selected "; }
$topics_list .= "<option $sel value=\"$topicid\">$topics</option>\n";
$sel = "";
}

But I am still getting the same error. As for :

Quote:

If the latter, please turn on Nuke debugging.

Oh lord here it comes I do not beleive I am going to ask this, How do I turn on Nuke Debugging? Embarassed

Thanks for the help.

Vic

Posted: Thu Aug 28, 2003 6:07 am

Quote:

Oh lord here it comes I do not beleive I am going to ask this, How do I turn on Nuke Debugging?

Check my signature Wink

Nuke Cadet Joined: Aug 28, 2003 Posts: 4

mmmh... for me the solution worked, but i've got a fresh install of 6.7 with new DB setup and empty tables and so far I don't have any probs.

Nuke Cadet Joined: Aug 15, 2003 Posts: 6

Ok mega neewbee mistake deleted wrong code line.

Everything is working great.

Hope to keep increasing knowledge and to help others like you guys help me.

If you ever need module or theme pack transaltions to spanish just le me know would like to contribute as much as I can.

Thanks
Vic

PS: Nuke debugging is a great help. Very Happy