FAQ not showing on main page when selecting a category

[Jeppoz]

Hi,

I recently installed the latest version for phpMyFAQ on a linux redhat machine, and everything went fine. But for some reason when I add more than one FAQ to a category it doesn't show when I select the category in the frond-end. If I only have one category and one FAQ in that, it works, but as soon as I add one more, it only shows the category and not the FAQ article.

Please look here to see what I mean;

Removed website.

Anyone experience this and know why?

Kind regards,
Jesper

[Thorsten]

Hi,

are the new FAQs set to active?

bye
Thorsten

[Jeppoz]

Yes, they are..

I have now made some more testing and have found out that it might be caused by the infrastruction it runs on, because I just made a test installation on my home server and there it worked just fine.

The server it fails on runs the following:

System Information
phpMyFAQ Version - phpMyFAQ 2.6.17
Server Software - Apache/2.2.3 (Red Hat)
PHP Version - PHP 5.3.6
Register Globals - off
Safe Mode - off
Open Basedir - off
Database Server - Mysql
Database Client Version - 5.1.57
Database Server Version - 5.1.57
Webserver Interface - APACHE2HANDLERPHP
Extensions - Core, date, ereg, libxml, openssl, pcre, zlib, bz2, calendar, ctype, hash, filter, ftp, gettext, gmp, SPL, iconv, Reflection, session, standard, shmop, SimpleXML, sockets, exif, tokenizer, xml, apache2handler, curl, dom, fileinfo, gd, json, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, wddx, xmlreader, xmlwriter, xsl, zip

Server that it works on runs the following:

System Information
phpMyFAQ Version - phpMyFAQ 2.6.17
Server Software - Apache/2.2.14 (Ubuntu)
PHP Version - PHP 5.3.2-1ubuntu4.9
Register Globals - off
Safe Mode - off
Open Basedir - off
Database Server - Mysql
Database Client Version - 5.1.41
Database Server Version - 5.1.41-3ubuntu12.10
Webserver Interface - APACHE2HANDLER
PHP Extensions - Core, date, ereg, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, dba, dom, hash, fileinfo, filter, ftp, gettext, session, iconv, json, mbstring, SPL, standard, posix, Reflection, Phar, shmop, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, apache2handler, gd, mysql, mysqli, PDO, pdo_mysql, mhash

Am I missing something on the faulty server?

Kind regards,
Jesper

[Thorsten]

Hi,

looks good. Is it possible to get an FAQ account on your machine?

bye
Thorsten

[Jeppoz]

Yeah, sure.

I have sent you a PM with info.

//Jesper

[Thorsten]

Hi,

this is strange. I'll analyze it right now.

bye
Thorsten

[Thorsten]

Hi,

could you please check if your table faqdata has problems and have to be repaired?

I could download your FAQ data and import it normally in my test system.

bye
Thorsten

[Jeppoz]

Hi,

Sure I can, and I just tested to remove any special characters from the faqdata table, but no effect.I also run a repair command on it, still the same. I still believe that it has something to do with the infrastructure, either PHP or Apache or Mysql.

To make it more simplier, I have installed another faq on <removed website>. It only has 2 FAQ with 1 category. If you remove the second FAQ article, it will work, however, as soon as you add second, this problem occurs.

You can try it yourself, with the same credentials I send to you earlier.

How did you export the FAQ data and then imported in your test system?

Kind regards,
Jesper

[Thorsten]

Hi,

I couldn't see the entries in the FAQ administration... this is weird!

I downloaded your data from the backup/restore section in the administration and imported it the same way on my testsystem...

bye
Thorsten

[Thorsten]

Hi,

if I search for "test" in the admin backend, I'll get the 2 entries... this is really extremely strange...

bye
Thorsten

[Jeppoz]

Hi again,

Did you find out anything more about this?

Kind regards,
Jesper

[Thorsten]

Hi,

no, not yet... it's really strange because I don't understand why this is happening... Which linux distribution are you using?

bye
Thorsten

[Jeppoz]

Hi,

Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Linux version 2.6.18-194.26.1.el5 (mockbuild@x86-004.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Fri Oct 29 14:21:16 EDT 2010

Redards,
Jesper

[Jeppoz]

Hi again,

I have now made other tests and can see that the beta version 2.7 is doing exactly the same thing.

I think there must be something with either PHP/APACHE or MYSQL that is causing this.

Any ideas so far?

Is there any test we can do?

Kind regards,
Jesper

[Thorsten]

Hi,

can you reproduce the same like me?

Logging into administration, go to edit FAQs in the content section and you don't see the entries. If you search for "test", you'll get results. This is really strange...

bye
Thorsten