Faq error in PHP-Nuke 7

porcupinepc · 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

porcupinepc · 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

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Wed Dec 10, 2003 11:17 pm

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

Agent001Fox · Posted: Wed Jan 14, 2004 6:35 am

How can I change the table name through PhpMyAdmin?

Raven · 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`