Faq not showing

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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.]



Back to top Reply with quote
#2   re: Faq not showing
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
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 ;




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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



Back to top Reply with quote
#4   re: Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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 = "";
    }



Dennis


Back to top Reply with quote
#5   re: Faq not showing
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
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)



Attached Files
FAQ_fix2.zip (1.62 KB, Downloaded: 5248 Time(s))
Attached Files
FAQ_fix1.zip (1.62 KB, Downloaded: 5252 Time(s))



_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#6   re: Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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



Back to top Reply with quote
#7   re: Faq not showing
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
Yes and READ my post that is the fix for it!




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#8   re: Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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



Back to top Reply with quote
#9   re: Faq not showing
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
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.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#10   re: Faq not showing
UMF
CZ Newbie
Status: Offline
Joined: Oct 23, 2003
0.00 posts per day
Posts: 12
Points: 845
 Yahoo Messenger  
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



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum