phpMyFAQ

There's an error in the Danish language file in version 2.6.17: in line 473, defining ad_categ_paste_error, the string is terminated in mid-sentence with an apostrophe, and it causes phpMyFAQ to fail with an Apache 500 error. The quick fix is to change "isn't" to "is not".

Thorsten wrote:I'll take a löok at it.

It looks like it's still present in 2.0.7. Are you deferring it to 2.5?

just disable the automatic language detection in the configuration.
I suddenly got the same problem as the Spanish poster after upgrading from 2.0.1 to 2.0.6.

My FAQ is entirely in Danish, but after the upgrade only the English version (with no FAQ contents) is displayed. When I select the Danish ...

pesthoernchen wrote:I have restore a full backup (database and files) before I make the update.

You're right. It looks like you also need to add a "$query = array( );" statement after line 1420 as well.

pesthoernchen wrote:Liefert nun folgendes:

Did you restore the database before you attempted to re-run the update with the fix? Otherwise, the update will already have made some of the modifications to the tables in the first (failed) attempt.

Do you think there is any other way except loading db- and file-backup and try your solution?
If you want to roll back to 1.6.12, then you'll have to restore both the files and the database.

Otherwise, if you want to just try upgrading again with my solution, let the code stay in place and just ...

Looks like upgrading from 1.6.12 doesn't work at the moment. Then I'll switch back to to 1.6.12. Getting the files isn't a problem for me but, do I have to load the db backup back too?
I can't imagine the code for 1.6.12 will work with a database that has been (partially) upgraded to 2.0.0. You'll ...

Dawn,

Dawn wrote:Do you have any idea?

Have a look here.

I had to try it instead of just suggesting it. To fix the bug, add the following statement after line 1232 so that the lines after the curly bracket look like this:
It seems to make things work in my installation.

I think I may have an explanation for why it fails.

In step 10/13 of the 1.6 upgrade, line 1216 and forward, you start executing the queries in $query[], including the rename query that seems to create problems.

Then in step 1/4 of the 2.0-beta upgrade, line 1264 and forward, you add new queries ...

I've gotten a little close to what the error might be. I decided to alter the "update.php" script a tiny bit, changing the syntax in the query for renaming the table from "ALTER" to "RENAME". This caused a new error to appear in the update script that may help clarify the problem:

DB error: Table ...

I'm afraid renaming the faqfragen table fails on my system, too, upgrading from 1.6.10:

DB error: Table 'phpmyfaq.sat_faqfragen' doesn't exist

Query:

ALTER TABLE sat_faqfragen RENAME TO sat_faqquestions
Before the upgrade, the faqfragen table was created as follows, according to the MySQL ...

hhtmp88 wrote:Do you have a schedule on when the wrapper will be released?

In the Joomla world, a "wrapper" is a Joomla feature that enables the inclusion of another web page within a frame that is shown inside of the Joomla content. It's not something I came up with.

I'm including phpMyFaq via a "wrapper" in Joomla.

I'm not sure what you mean by integration with Joomla, though. What goals, specifically, should an integration with Joomla meet?

It picks up every single FAQ and indexes them all.
I'm sure it does. However, it's one of those "yet another thing to do" situations; I'd prefer to have phpMyFaq automatically generate the sitemap when a FAQ entry is added or updated rather than have to perform an additional manual task.

- wolf -