phpMyFAQ

Hi,

I think you don't need the Option FollowSymlinks, I will remove it.

Is "faqcategory_order" missing for 3.0 or 3.2? I think we introduced this table with 3.1.

bye
Thorsten

Hi,

is it working now?

bye
Thorsten

Hi,

do you know the current version and the version before?

bye
Thorsten

Hi,

did you changed anything on your server? I checked the code various times now and I don't find the issue that happens on your side.

bye
Thorsten

Hi,

thanks for the feedback, I added some documentation about SSO and nginx. I also added that for Apache.

https://phpmyfaq.readthedocs.io/en/main ... on-support

bye
Thorsten

Hi,

did you change the base URL in the .htaccess file provided by phpMyFAQ?

bye
Thorsten

Hi,

thanks for the great suggestions but one thing should be already possible: if you enable SSO, local logins should still work.

bye
Thorsten

Hi Ralph,

was it really missing?

bye
Thorsten

Hi Ralph, this is how the CREATE TABLE looks like for 3.0.x: CREATE TABLE faquser ( user_id INT(11) NOT NULL, login VARCHAR(128) NOT NULL, session_id VARCHAR(150) NULL, session_timestamp INT(11) NULL, ip VARCHAR(15) NULL, account_status VARCHAR(50) NULL, last_login VARCHAR(14) NULL, auth_source VARC...

Hi Ralph,

did you upgrade from a previous version?

bye
Thorsten

Hi,

I'm still debugging to reproduce this. I'm still confused why it stopped working on your installation.

bye
Thorsten

Hi,

when run this query in the SQL mode:
bye
Thorsten

Hi,

no, do you have access to your database with phpMyAdmin for example?

bye
Thorsten

Hi,

you can migrate the table to "utf8mb4" to use emojis directly:
It worked for me.

bye
Thorsten

Hi,

I found the issue, the emojis break the query if you use the "utf8mb4" encoding in MySQL. Which encoding do you use?

You can find it out using a tool like phpMyAdmin.

bye
Thorsten