First of all I'd like to say thank you for developing such great software.
I recently inherited management of an existing phpMyFAQ installation that is quite out of date (version 2.6.15) at http://www.faxtalk.com/support/kb/index.php. I wanted to bring this installation up to date, so I had planned to perform a series of step updates to get to version 3.0.4 (2.6.15 > 2.8.29 > 3.04). I followed the documented process to update from version 2.6.15 to version 2.8.29 as the first step and after performing the update I seem to be encountering some odd issues that I'm hoping you might be able to help (I attached some screenshots too if they help at all).
- After the update when visitors access phpMyFAQ they get a home page that does not display any topics available (tested with Chrome and the new MS Edge). I can manually enter in a document number in the search field and it will actually display without issue but if I go to the "Home" page the "News", "Most popular FAQs" and "Latest FAQs" sections all report that there are no FAQs. The page also reports that there are "No categories found" on the menu on the left.
I noticed that the language defaulted to "American English" for the page and I thought that might be related as I don't remember seeing "American English" as an option with version 2.6.15. However, if I change the language selector to just "English" I'm presented with a blank white screen. In further testing found that if I modify the Chrome settings and change the order so "English (United States)" is after "English" in the languages list I do see all of the topics when I visit the phpMyFAQ URL. This leads me to believe that I need to update the FAQ documents to include support for both "English" and "American English" to cover both possible use cases but I run into significant issues in trying to do that.
- If I try to add an additional language to a category (as an attempt to solve the languages issue highlighted in #1) by selecting the Translate option and then take a FAQ category that is currently in "English" and translate it to "American English" I encounter an error "You are not authorized" - I am logged in as the administrator at the time.
- If I try to edit a "News" FAQ I'm given the ability to edit the record and after clicking "Save" it reports that the record has been updated but when I display the news page as a user it does not show any updates.
Given the number of separate issues that I'm experiencing I starting to wonder if it would be better to start with a separate, clean installation of 3.0.4 but I'm unsure if I can just simply point a clean 3.0.4 installation to the existing MySQL database and have the existing documents automatically appear in the new installation. Is this possible? Should I attempt to upgrade from the existing 2.8.29 installation to the current 3.0.4 version regardless of the issues I'm encountering and then see if the issues remain or what new issues appear? I'm especially concerned of the "You are not authorized" error I'm seeing.
If starting with a fresh installation of phpMyFAQ while somehow being able to incorporate the existing MySQL database is the best option I'm happy to do that but I would very much appreciate any guidance as to what process to follow to best attempt to keep the existing SQL data.