Number of entries doesn't work?

[jmao]

I just installed phpmyfaq, and it appears fine and happy except that when I click Show All Categories, it lists the three categories I've entered. Next to the only one with any entries (there are 2), it lists that there are144115188075855872 entries. I'm not that prolific!

MySQL v4.0.16
php v4.3.2
Mac OS X v10.2.3 server

Thanks!
Jeff Mao

[Thorsten]

Hi Jeff,

this is strange. The number of entries that are displayed are from the database. Could you please post a screenshot?

bye
Thorsten

[jmao]

Here's a screen shot displaying all my "numerous" entires. You can visit it at www.jeffmao.com.

[Thorsten]

Hi,

thanks for the screenshot. Do you have installed phpMyAdmin? If yes, could you please test this SQL query in the SQL console of phpMyAdmin:

Code: Select all

SELECT count(faqdata.rubrik) AS number FROM faqrubrik LEFT JOIN faqdata ON faqdata.rubrik = faqrubrik.rubrik AND faqdata.active = 'yes' GROUP BY faqrubrik.rubrik ORDER BY faqrubrik.rubrik

Thanks!

bye
Thorsten

[jmao]

Here's what I get,...

mysql> SELECT count(phpmyfaqfaqdata.rubrik) AS number FROM phpmyfaqfaqrubrik LEFT JOIN phpmyfaqfaqdata ON phpmyfaqfaqdata.rubrik = phpmyfaqfaqrubrik.rubrik AND phpmyfaqfaqdata.active = 'yes' GROUP BY phpmyfaqfaqrubrik.rubrik ORDER BY phpmyfaqfaqrubrik.rubrik;
+--------------------+
| number |
+--------------------+
| 144115188075855872 |
| 0 |
| 0 |
+--------------------+
3 rows in set (1.39 sec)

mysql>

Jeff

[Thorsten]

Hi Jeff,

is it possible to send me a sql dump of your database with your phpMyFAQ data?

bye
Thorsten