phpMyFAQ

(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?

Just curious, am I missing permissions/rights from the configuration?

Unless I'm reading that incorrectly, it alludes to 37 and higher, while my installation stops at 36 (as per the attached image from phpmyadmin).

2.8. I managed to get it working by some combination of restoring the database, restarting apache/PHP, clearing caches, etc. I'm not sure which, exactly, did the trick.

Is there a way to raise the limit for unsuccessful logins? As it is, it seems like I am (or was) getting just one.

2.8[.something]. I'm not sure where to find the point version number. I want to say 2.8.7.

I don't know if this is pertinent or not, but I notice the line in 2.9.9:

$minRights = ['37', '39', '40', '41']

but when I look directly at the faquser_right table, user_id 1 (admin) only has right_id 1 through 36. Although in the user management interface, all permission checkboxes are checked ...