phpMyFAQ

I added 'twofactor_enabled' to faquserdata and tried again. This time I got:

Update database failed: Duplicate entry 'layout.enableCookieConsent' for key 'faqconfig.PRIMARY'

I added 'twofactor_enabled' to faquserdata and tried again. This time I got:

Update database failed: Duplicate entry 'layout.enableCookieConsent' for key 'faqconfig.PRIMARY'

Actually, when I click on the "check" error in Chrome's Network tab I get:

An error occurred: Unknown column 'twofactor_enabled' in 'field list' at line 311 at /[myserver.com]/kb/src/phpMyFAQ/Database/Mysqli.php

So I guess something is looking for a nonexistent column?

I've been using phpMyFAQ for many years, and try to upgrade regularly. Usually it goes (relatively) smoothly, aside of a few tweaks and bit of debugging here and there. But today I'm running into difficulty updating from 3.1.7 to 4.0.10.

I'm getting an error in update.js, at: await fetch("../api ...

(I mean, it looks like it could be as simple as somehow[?] a column got deleted from faquser. I could try re-adding it, but I'm not sure what type it's supposed to be, etc.)

The server host (DreamHost) has upgraded PHP 7.x to 8.2. Now our phpMyFaq installation throws an error when attempting to search:

mod_fcgid: stderr: phpMyFAQ mysqli_sql_exception: Unknown column 'remember_me' in 'where clause' in /<path-to-phpmyfaq>/src/phpMyFAQ/Database/Mysqli.php on line 357
mod ...

To follow up further, it seems like this change to api.php:154 fixes it:
I assume something about default language handling has changed somewhere?

Actually a correction: that wget line gives me a 500 internal server error.

But if I try either the Perl script or the wget line with kb-old/api.php instead of kb/api.php (to use my old 2.9 phpMyFaq installation) both work just fine.

I used to (on a 2.9 installation) be able to get a JSON response of search results using the Perl code:

my $query = $cgi->param('q');
my $query_decoded = uri_decode($query);
my $ua = LWP::UserAgent->new;
my $response = $ua->get("https://mysite.com/kb/api.php?action=search&lang=en&q=$query");
my ...

Thanks so much!

It would be handy for someone in my situation: i.e., the sole maintainer of the FAQ. When I add a question via the admin/content panel, I don't need an email reminding me I just did it.

I've updated to the latest 3.1.x and am ironing out the kinks in my installation. One thing that's new (and that I have no need for) is the "There's a new entry in the FAQ!" email that appears to now(?) get sent when adding a new FAQ via the admin panel.

Is there a way to disable this?

Version 67.0.3396.99 (Official Build) (64-bit)

I believe this is due to phpMyFaq's URL-checking and (relatively) recent changes to Chrome to guard against cross-site scripting.

As soon as I click to create a new FAQ that contains links/URLs, I get a cross-site scripting error from Chrome.

Checking afterward, however, the FAQ has been created ...

I believe I did.

(Most) other things seem to be working properly.

Is the update script something that can be re-run to fix anything that wasn't properly configured the first time?