Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Faq not showing

I can enter faq's - no problem,
admin faq shows all faq'a and categories - no problem

sql table named faqcategories and faqanswer

admin/module/adminfaq.php and
modules/FAQ/index.php

show _faqanswer, _faqcategories - no problem.

So wy won't FAQ page display FAQ's?

[ Register or login to view links on this board.]

Ok run this sql query then open the modules/FAQ/index.php and the admin/modules/adminfaq.php and change all the faqanswer and faqcatgories to faqAnswers and faqCategories (just the one capital letter)

#
# Table structure for table `nuke_faqAnswer`
#

DROP TABLE IF EXISTS `nuke_faqAnswer`;
CREATE TABLE `nuke_faqAnswer` (
`id` tinyint(4) NOT NULL auto_increment,
`id_cat` tinyint(4) NOT NULL default '0',
`question` varchar(255) default '',
`answer` text,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `id_cat` (`id_cat`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `nuke_faqCategories`
#

DROP TABLE IF EXISTS `nuke_faqCategories`;
CREATE TABLE `nuke_faqCategories` (
`id_cat` tinyint(3) NOT NULL auto_increment,
`categories` varchar(255) default NULL,
`flanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`id_cat`),
KEY `id_cat` (`id_cat`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

That didn't work, I have tried every combination possible.

adminfaq works fine,

it's just modules/FAQ/index.php that is the probelem.

Dennis

I found the aswer to this problem, maybe somebody can reproduce it and come up with a fix.

It seems that if you activate multilingual features in the preferences, in the admin, then the FAQ page will not display.

Turn it off and FAQ's will dispaly.

The problem area is line 76 -> 105
primarily 78-> 82 of modules/FAQ/index.php

if ($multilingual == 1) {
$querylang = "WHERE flanguage='$currentlang'";
} else {
$querylang = "";
}

If you have the tables named nuke_faqAnswers and nuke_faqCategories use fix #1
(capital letters)
If you have the tables named nuke_faqanswers and nuke_faqcategories use fix #2
(small letters)

That is not the problem, the capitalization problem was fixed along time ago.

This is a new problem, read my last post, it has to do with multilingual option in admin.

Dennis

You can contact me on YIM for the next hour

Yes and READ my post that is the fix for it!

I hate to continue to disagree with you, but I did not have a problem with

_faqAnswer _faqCategories

or

_faqanswer _faqcategories

This is a different problem, I could not show FAQ's untill I disabled multilingual features in the admin.

If I turn multilingual features on, FAQ disappears
If I turn multilingual features off FAQ appears

Dennis

Ok i will explain it better...

Fix#1 use if your tables have the capital letters.

Fix#2 use if your tables have the small letters.

This is the fix for the FAQ's not showing when multilanguage is selected under admin preferances.

Let me explain myself better, there is a deeper issue.

I did fix#1 with multilingual activated - Result NO FAQ!

I did fix#2 with multilingual activated - Result NO FAQ!

Turned off multilingual, all is well!

You seem to think that is the only problem, when someone tries both fixes, with no results, then there may be another problem.

Maybe it dosen't show up on every system. I do understand a little about PHP.

Maybe you can explain why fix#1 and fix#2 did not work untill multilingual was de-activated?

Dennis