phpMyFAQ

I fixed it.

I had to add rows to 2 tables.

I had to add a row to the faqdata_group table for each faqdata ID, along with a dummy -1 group ID.

Then, I had to add a row to the faqdata_user table for each faqdata ID and a dummy -1 user ID.

The faqdata_group table exists, but there is no data in it.

Here is my debug information when I run a search for the word "linux". The last line is querying faqdata, but it doesn't contain the search text and I confirmed that the query returns no rows:

DEBUG INFORMATION:

C:\phpmyfaq\inc\Init.php:
PMF_Configuration->getAll() in line 106: SELECT config_name ...

Unfortunately, I can't do a db export because the company that I work at uses phpMyFAQ for data that we keep internally. I double checked the db export and confirmed that there was nothing that needed to be imported into faqdata_group, so I don't think any data is missing from the migration.

Are ...

faqcategoryrelations has 914 records which sounds good
faqdata_user has the 3 users that I created in the original db
faqdata_group is completely empty, but I don't know if I even had any groups in the original db... Will that matter?

I migrated my FAQ from a server running on MS SQL Server to a server running MySQL 5.5.8. I used the FAQ export from the admin page. Everything seemed to go alright. Some of my FAQs had newlines in the text, but I just had to manually import those using phpMyAdmin, so that wasn't a very big deal ...