questions not appearing in main FAQ page

Using dev versions is usually not recommended, especially for live / production sites.

Anyway, it looks like the cause of your problem is that you did not run update.php after upgrading the module. There is a new 'faq_questions' table which (a) needs to be created and (b) populated with the existing questions, which should be done when you run update.php.

Cheers,
Stella

It really depends on the module. Usually the dev versions of my modules are fine to use, but when they create new tables, etc, upgrading may be finicky.

Out of interest, can you tell me whether the 'faq_questions' table was created in your database and if so, if there's anything in it? Also, if you could get the schema_version for me too, that would be great. To get the schema_version just run the sql query:

select schema_version from system where name='faq';

Cheers,
Stella

well exact same problem here. I am using the official release. Secondly,the questions are being shown on faq_questions tables, it is just that they are NOT being shown on /faq page.

I am also using drupal 5.7 on localhost. The content is not visible in any of the browser.

I am having schema version 2.

I am using php4 though I don't think its the issue here :)

Can you give me a link to your site, please?

hi nancy, I am using it on localhost :) anything else which I can do ?

Hmm... grasping at straws here before asking for something bigger. Have you checked Watchdog and your Apache error logs? I assume you have verified that the nodes are marked published. Get a term number for the faq's and do a "taxonomy/term/xxx" on that; do the nodes show up?

Assuming those things don't show something, let's try using something like phpMyAdmin and emptying (TRUNCATE) all of the cache tables and Watchdog. And also tell me which version of MySql you're using.

BTW, just an aside: Drupal 7 is going to require PHP 5.2+, so you might want to think about upgrading in the next few months. It's also going to require MySql 5+.

Having the same problem after upgrade from 5.5 to 5.7 ... Ive notice that no faq's appear on mysite.com/faq I just get the standard page as if no faqs exist.

They are still in the db and are published.

However they do show if I go to mysite.com/faq/267 which is a taxonomy term.

I can also still view them individually ... i.e. mysite.com/node/316

I also noticed that there is no way to select or add a taxonomy in the edit/add form of a FAQ, for some reason this is now gone. I also tried to add a taxonomy cck field but it doesn't work or fix the problem. This in effect makes it impossible to add any new faqs.

Its strange that its different now. I made no changes in the faqs, or in the faqs module... only upgrading from 5.5 to 5.7, (exactly) as the instructions describe in the UPGRADE.txt.

I hope these points help you in your digging! Something got jumbled somehow.

For another user having a similar problem, the problem turned out to be that "FAQ" got lost from the list of content types to which the vocabulary applied. Once that was set back, everything was normal. Please check that.

Perfect ... I cant believe I didnt check that! I thought I checked everything. I was all up in that and didn't even think to look at that section!

Thanks for the tip!

I wonder if it had something to do with step #4 in the drupal UPGRADE.txt? Turning off all the contrib modules, not only is it painful to go through but apparently it can screw with some things? Or I suppose it could have been something to do with the taxonomy module's update. Although this only happened to the Faqs so it could be some particular bit in the faq module.

Cheers ^_^

Great. Glad it was something simple. You're not the first this has happened to, so it may be something in the upgrade process.

I added a note on the project page about this.

I am soooo very sorry if this question has been answered a gazillion times but I simply dont understand how to get FAQs to work. I am a certified beginner. The site I am trying to get FAQs to work on is www.thinkwest.org I have managed to get a menu item set up but it only displays one question despite the fact that i have written three so far. Is there a video tutorial I can watch that shows me the steps I need to take to get it to work properly. I can find nothing that gives me a step by step explanation of what I need to do (I'm sure it exists, I simply cant find anything). I thankyou...

toula: Check out #129209 for more details on how to configure the FAQ module. There is no step-by-step guide at present. However, if you're not using categorized faq pages, you should have to

1. Create some FAQ nodes at "Create content >> FAQ" and ensure they are published.
2. Ensure users have the correct permissions to see FAQ nodes at "Administration >> Users >> Permissions"
3. The FAQs should appear on the FAQ page "/faq"
4. You can change the layout of the FAQ page at admin/settings/faq/questions

If you're using categorized faq nodes, then it's slightly more complicated. In addition to the steps above you must:

1. Create a new taxonomy vocabulary at "Administration >> Content Management >> Taxonomy" and ensure it is enabled for FAQ node types.
2. For each FAQ node, you must associate it with at least one term from your new vocabulary. You can do this on each edit node page.
3. Enable categorization of the FAQ nodes and chose a layout at admin/settings/faq/categories

If you're using additional access control modules, such as Taxonomy Access Control or Node Access, then there may be additional permissions you need to assign to the various nodes.

Hope this helps.

Cheers,
Stella

I've created a simple step-by-step guide using the text above at #244486.

Cheers,
Stella

dear stella
thank you! you are a gem...i am very touched at the speed of your response...the kindness of strangers still moves me...thankyou...i will do as you have advised and let you know how i go...
have a stellar day!!!
toul@

dear stella
i have followed your instructions and im still not able to crack getting questions on the faq page...i am able to get the introduction to the page (http://www.thinkwest.org/faq) but i cant seem to get the questions to appear underneath it...i have attached a pdf with the settings i have for an faq (sample) question (assuming the problem is on this page!!)...

thanking you
toul@

toula: you need to send me your faq settings from admin/settings/faq, etc. In particular I'm interested in the "questions" and "categories" settings. Have you enabled categorization of the faqs for example? What layouts are you using? etc, etc

Cheers,
Stella

hi again
thankyou so much for your prompt reply...i have attached 3 pdfs with my faqs setting

You're not using the latest version of the module. Please upgrade to the latest version. That is 6.x-1.5 for Drupal 6.x installations and 5.x-2.9 for Drupal 5.x installations.

Cheers,
Stella

thankyou stella...i have done that but i think i am having more general problems around drupal versions and module comparabilities...i am getting a whole lot of error messages like

"user warning: Table 'thinkwest.faq_questions' doesn't exist query: SELECT question FROM faq_questions WHERE nid = 104 AND vid = 113 in /var/www/vhosts/thinkwest.org/httpdocs/includes/database.mysql.inc on line 172."

the site was developed in drupal 5.1 and i suspect i will need to upgrade in order to eliminate these errors...i will now talk to my hosting provider to see what can be done and then give faqs another go (i have also added the upload module and i am getting a range of errors as well)...

i really thankyou for getting me to this point...
toul@

It looks like you haven't run update.php. Check you status report and I bet it will say your schema is out of date and point you to run an update.

thanks for you kind persistence with my ignorance...i clicked the "database update script" and it says "page not found" so not sure what to do now...

Looks like you haven't upgraded your site correctly. I've just double-checked and you're right http://www.thinkwest.org/update.php gives a 404 error. Looks like something went wrong in your site upgrade from Drupal 5.x to Drupal 6.x.

As for the faq_questions table - yes, you need to run update.php in order to get this table as Nancy said. It probably explains why the questions aren't appearing. You need to sort out your more general problems with your site first.

Cheers,
Stella

You installed with Fantastico I bet. Fantastico's developers really screwed that one up. For some reason, they don't include update.php in their installation. I don't know what they were smoking when they decided that.

If you have a test site on your local PC, you can FTP that code to your site. If you can't find it anywhere else, contact me and I'll send you a copy.

ah you are all gems to keep hammering away at this and quite frankly i could do with some strange substances at the moment to keep me from banging my aching head on the keyboard!!!...and i sheepishly now have to say that i havent upgraded to drupal six but will do that as soon as i can figure how to do it...i thought i could just keep working on this site in the drupal version initially downloaded but it is clear from all you say that that really should be my very next action...it's nearly greek easter (yep we're a recalcitrant lot) and i wish i could send you some easter goodies to say thanks!!!!

There's no need to upgrade to D6, I just thought since you specified the faq module version as 6.x-1.0 that you already had done so. If you're still on D5, then you should probably upgrade to D5.7 if you haven't already.

ok D5.7 it is then...ta!!!!!!!!!!!!!!!!!!!!!!!!

Well, Toula, some people have found that chocolate works well on me.

While I would recommend an upgrade, all you probably need is the proper update.php. I think I still have most versions handy.

thanks nancy...a truck load of virtual chocky is on its way...i will work towards an upgrade to 5.7 but if you think a proper update.php file will do it then that's what i'll do (so...er...um...what do i do now....derrr)

Use my contact page and let me know which version.