Faq error in PHP-Nuke 7

Posted: Wed Dec 10, 2003 9:54 pm

I was just in the process of adding a FAQ in the admin screen (Nuke 7) and the following showed:

Active FAQs

ID Categories Language Functions

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/includes/sql_layer.php on line 286

Line #286 insql_layer.php is:

$row = mysql_fetch_row($res);

Any idea?

Joe

Posted: Wed Dec 10, 2003 10:34 pm

Well i found some additional help on another site and thought i would pass it along to the users here:

To start, edit the file sql_layer.php

Go to line 300 and look for the following:

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

Now, change the code to the following:

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

This will show in detail what the problem code is.

Now, here is the solution to the bug:

The problem is with capitalization in the database, find the 2 FAQ tables in the nuke database (nuke_faqanswer and nuke_faqcategories) and make sure the "C" in categories and the "A" in answers are capitalized. Problem solved.

Regards

Joe Robertson
System Admin

www.porcupinepc.com/forums

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

This has been there since v6.5. As with the avatar issue, FB continues to not address the known bugs. Too bad.

Posted: Wed Jan 14, 2004 6:35 am

How can I change the table name through PhpMyAdmin?

Posted: Wed Jan 14, 2004 6:42 am

Depends on your version of phpmyadmin. You need to see a tab called Operations. If there is a Properties icon on the line that has the table name then click on that. Or, just clicking the table name in the left frame should do the same thing. That should bring up that tab. Or, just run this query in the SQL window

Code:

ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`

Posted: Wed Jan 14, 2004 6:46 am

That did it! Thanx for your quik reply and good help! Wink

You are the king... Razz

Posted: Wed Jan 14, 2004 6:51 am

Make sure you do the same for faqcategories.

Posted: Wed Jan 14, 2004 6:57 am

Already done that.... Very Happy

Worker Joined: May 27, 2006 Posts: 157

I renamed the faq_answer and faq_categories and i still get same message with the sql_layer.php thing!

Posted: Tue May 30, 2006 5:37 am

What version of nuke and fix pack are you using?

Posted: Fri Jun 09, 2006 12:32 pm

version 7.6 and i dont know what the fix pack is let alone using it.