Special characters bug misinterpreted (4.0.5)

[Virgile]

Hello,

When creating a FAQ, some special characters are not correctly displayed:

Example string:
&é"'(-è_çà)=#

Result displayed:
&é"'(-è_çà)=#

Bye,
Virgile.

[Thorsten]

Hi,

I will check this.

bye
Thorsten

[Virgile]

Hello,

Have you had a chance to have a look?

Bye,
Virgile.

[Thorsten]

Hi,

yes and I couldn't reproduce this issue. Is that a new FAQ from 4.0 or an old one from the 3.2 era?

bye
Thorsten

[Virgile]

Hello,

When creating a FAQ in 4.0, whether I'm logged in or not, when we put in certain special characters we have this problem.

I checked the collation of our database and we have the following: DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

Bye,
Virgile.

[Thorsten]

Hi,

where is the wrong character visible? Backend? Frontend?

bye
Thorsten

[Virgile]

Hello,

The wrong characters are visible on the frontend but are also present in the database.

The characters é , . and ? are recorded as such in the database.

Problem: Comment peut-on vérifier le bon fonctionnement avec la version 3.2.3 ?
Sentence to think about : Comment peut-on vérifier le bon fonctionnement avec la version 3.2.3 ?

bye,
Virgile.

[Thorsten]

Hi,

can you please paste your template faq.twig file here?

It's in assets/templates/default

Thanks in advance!

bye
Thorsten

[Virgile]

Hello,

I can't upload the file because the extension is not allowed.

I copy you the content :

{% extends 'index.twig' %}

{% block richSnippets %}
<script type="application/ld+json">
{
"@context": "https://schema.org",
"@type": "FAQPage",
"mainEntity": [
{
"@type": "Question",
"name": "{{ question }}",
"acceptedAnswer": {
"@type": "Answer",
"text": "{{ answer | striptags }}"
}
}
]
}
</script>
{% endblock %}

{% block content %}
<div class="row g-5">
<div class="col-md-8">
<h2 class="mb-4 border-bottom">{{ question | raw }}</h2>

<article class="pmf-faq-body pb-4 mb-4 border-bottom">{{ answer|raw }}</article>

<p class="d-print-none">{{ writeCommentMsg|raw }}</p>
<div id="pmf-comment-add-success"></div>
<div class="d-print-none" id="comments">{{ renderComments|raw }}</div>
</div>

<div class="col-md-4">
<div class="position-sticky" style="top: 2rem">
<div class="p-4 mb-3 bg-light-subtle border rounded">
<ul class="list-group list-group-flush bg-transparent">
<li class="list-group-item d-flex justify-content-between align-items-center bg-transparent">
<div>
<i aria-hidden="true" class="bi bi-clock"></i>
<span class="data" id="pmf-reading-time-minutes">~ 0 min</span>
</div>
<a class="badge text-bg-secondary rounded-pill text-decoration-none" href="{{ solutionIdLink }}">
ID #{{ solutionId }}
</a>
</li>
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-person"></i>
<span class="data" rel="author">{{ faqAuthor }}</span>
</li>
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-calendar-date"></i>
<span class="data">{{ faqDate }}</span>
</li>
{% if numberOfComments is defined %}
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-chat-left-quote"></i>
{{ numberOfComments }}
</li>
{% endif %}
{% if userId != -1 %}
<li class="list-group-item bg-transparent">
<i aria-hidden="true" id="pmf-bookmark-icon" class="{{ bookmarkIcon }}"></i>
<a id="pmf-bookmark-toggle" href="#" rel="noopener" class="text-decoration-none"
data-pmf-action="{% if isFaqBookmark == true %}remove{% else %}add{% endif %}" data-pmf-id="{{ id }}"
data-pmf-csrf="{% if isFaqBookmark == true %}{{ csrfTokenRemoveBookmark }}{% else %}{{ csrfTokenAddBookmark }}{% endif %}">
{{ msgAddBookmark }}
</a>
</li>
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-file-pdf"></i>
<a target="_blank" href="{{ linkToPdf }}" rel="noopener" class="text-decoration-none">
{{ msgPdf }}
</a>
</li>
{% endif %}
{% if enableSendToFriend == true %}
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-share"></i>
<a rel="nofollow" href="#" class="text-decoration-none" data-bs-toggle="modal"
data-bs-target="#shareModel"
id="shareButton" data-bs-placement="top"> {{ msgSend2Friend }}</a>
</li>
{% endif %}
{% if msgChangeLanguage is defined %}
<li class="list-group-item bg-transparent">{{ switchLanguage|raw }}</li>
{% endif %}
{% if permissionEditFaq == true %}
<li class="list-group-item bg-transparent">
<i aria-hidden="true" class="bi bi-pencil"></i>
<a class="text-decoration-none" href="./admin/index.php?action=editentry&id={{ id }}&lang={{ lang }}">
{{ ad_entry_edit_1 }} {{ ad_entry_edit_2 }}
</a>
</li>
{% endif %}
</ul>
</div>

<div class="p-4 mb-3 bg-light-subtle border rounded">
<h4 class="fst-italic">{{ 'msgVoteUsability' | translate }}</h4>
<form action="#" method="post" class="form-inline pmf-voting-form">
<input type="hidden" name="voting-id" id="voting-id" value="{{ id }}">
<input type="hidden" name="voting-language" id="voting-language" value="{{ lang }}">
<div class="pmf-stars text-center">
<button type="submit" class="pmf-voting-star" data-star="1">
&#9733;
<span class="pmf-stars-screen-reader">1 Star</span>
</button>
<button type="submit" class="pmf-voting-star" data-star="2">
&#9733;
<span class="pmf-stars-screen-reader">2 Stars</span>
</button>
<button type="submit" class="pmf-voting-star" data-star="3">
&#9733;
<span class="pmf-stars-screen-reader">3 Stars</span>
</button>
<button type="submit" class="pmf-voting-star" data-star="4">
&#9733;
<span class="pmf-stars-screen-reader">4 Stars</span>
</button>
<button type="submit" class="pmf-voting-star" data-star="5">
&#9733;
<span class="pmf-stars-screen-reader">5 Stars</span>
</button>
</div>
<div class="text-end bold">&empty; <span id="rating">{{ renderVotingResult|raw }}</span></div>
</form>
<div id="pmf-voting-result"></div>
</div>

{% if renderTags is defined %}
<div class="p-4 mb-3 bg-light-subtle border rounded">
<h4 class="fst-italic">{{ renderTagsHeader }}</h4>
<div>{{ renderTags | raw }}</div>
</div>
{% endif %}
{% if renderRelatedArticles is defined %}
<div class="p-4 mb-3 bg-light-subtle border rounded">
<h4 class="fst-italic">{{ renderRelatedArticlesHeader }}</h4>
{{ renderRelatedArticles | raw }}
</div>
{% endif %}
{% if renderRelatedCategories is defined %}
<div class="p-4 mb-3 bg-light-subtle border rounded">
<h4 class="fst-italic">{{ renderRelatedCategoriesHeader }}</h4>
{{ renderRelatedCategories | raw }}
</div>
{% endif %}
{% if notes is defined %}
<div class="p-4 mb-3 bg-light-subtle border rounded">
<h4>{{ notesHeader }}</h4>
<p>{{ notes | raw }}</p>
</div>
{% endif %}
</div>
</div>
</div>

<div class="modal fade" id="pmf-modal-add-comment" tabindex="-1" aria-labelledby="commentModalLabel"
aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="commentModalLabel">{{ msgCommentHeader }}</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="{{ msgCancel }}"></button>
</div>
<div class="modal-body">
<div id="pmf-add-comment-error"></div>

<form id="pmf-add-comment-form" action="#" method="post" class="needs-validation" novalidate>
<input type="hidden" name="id" id="id" value="{{ id }}" />
<input type="hidden" name="lang" id="lang" value="{{ lang }}" />
<input type="hidden" name="type" id="type" value="faq" />
<input type="hidden" id="pmf-csrf-token" name="pmf-csrf-token" value="{{ csrfTokenAddComment }}">

<div class="row mb-2">
<div class="col">
<label class="sr-only" for="user">{{ msgNewContentName }}</label>
<input
type="text"
name="user"
id="user"
class="form-control"
required
placeholder="{{ msgNewContentName }}"
value="{{ defaultContentName }}"
/>
</div>
</div>
<div class="row mb-2">
<div class="col">
<label class="sr-only" for="mail">{{ msgNewContentMail }}</label>
<input
type="email"
name="mail"
id="mail"
class="form-control"
required
placeholder="{{ msgNewContentMail }}"
value="{{ defaultContentMail }}"
/>
</div>
</div>
<div class="row mb-2">
<div class="col">
<textarea
rows="10"
name="comment_text"
id="comment_text"
class="form-control"
required
placeholder="{{ msgYourComment }}"
></textarea>
</div>
</div>

{{ captchaFieldset|raw }}
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">{{ msgCancel }}</button>
<button type="button" class="btn btn-primary" id="pmf-button-save-comment">{{ msgNewContentSubmit }}</button>
</div>
</div>
</div>
</div>

<div class="modal fade" id="shareModel" tabindex="-1" aria-labelledby="ShareLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="ShareLabel">{{ 'msgSend2Friend' | translate }}</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body share-modal-body">
<p>{{ 'msgShareLinkVia' | translate }}</p>
<div class="d-flex align-items-center icons">
<a class="fs-5 d-flex align-items-center justify-content-center" target="_blank"
href="https://www.linkedin.com/sharing/share-offsite/?url={{ currentPageUrl | url_encode }}">
<span class="bi bi-linkedin"></span>
</a>
<a class="fs-5 d-flex align-items-center justify-content-center" target="_blank"
href="https://reddit.com/submit?url={{ currentPageUrl | url_encode }}&title={{ msgShareText | url_encode }}">
<span class="bi bi-reddit"></span>
</a>
<a class="fs-5 d-flex align-items-center justify-content-center" target="_blank"
title="{{ msgShareViaWhatsapp }}"
href="https://wa.me/?text={{ msgShareText | url_encode }}+{{ currentPageUrl | url_encode }}">
<span class="bi bi-whatsapp"></span>
</a>
<a class="fs-5 d-flex align-items-center justify-content-center" target="_blank"
href="https://telegram.me/share/url?url={{ currentPageUrl | url_encode }}>&text={{ msgShareText | url_encode }}">
<span class="bi bi-telegram"></span>
</a>
</div>
<p>{{ 'msgCopyLink' | translate }}</p>
<div class="field d-flex align-items-center justify-content-between">
<span class="bi bi-link text-center"></span>
<input type="text" class="form-control" id="pmf-share-link" value="{{ currentPageUrl }}" readonly>
<button class="btn btn-primary" id="pmf-share-link-copy-button"
data-pmf-message="{{ 'msgLinkCopied' | translate }}">
{{ 'msgCopy' | translate }}
</button>
</div>
</div>
</div>
</div>
</div>

{% endblock %}


Bye,
Virgile.

[Thorsten]

Hi,

okay, everything is correct in that file.

I'll check the code again.

bye
Thorsten

[Virgile]

Hello,

Did you have time to look at the character problem?

I also found 3 bugs on version 4.0.6.

The first is in the dashboard part of the administration. When we click on “Comments” or “Open questions”, we get the following error:

phpMyFAQ Fatal error
Uncaught exception: 'Error'

Message: 'Class “IntlDateFormatter” not found'

Stack trace:

#0 /var/www/html/phpmyfaq/admin/comments.php(40): [constant expression]()
#1 /var/www/html/phpmyfaq/admin/index.php(282): require()
#2 {main}
Thrown in '/var/www/html/phpmyfaq/src/libs/twig/intl-extra/IntlExtension.php' on line 60

The second is present when viewing a FAQ, the user is not correctly entered: n&sol;a

The third is for FAQ creation via the “Add a FAQ” interface in “Administration”. When we want to create an FAQ and click on “Save”, nothing happens. The FAQ is not created.

PS: There is also the empty right in the list of rights that I had indicated to you.

Bye,
Virgile.

[Thorsten]

Hi,

phpMyFAQ Fatal error
Uncaught exception: 'Error'

Message: 'Class “IntlDateFormatter” not found'

Stack trace:

#0 /var/www/html/phpmyfaq/admin/comments.php(40): [constant expression]()
#1 /var/www/html/phpmyfaq/admin/index.php(282): require()
#2 {main}
Thrown in '/var/www/html/phpmyfaq/src/libs/twig/intl-extra/IntlExtension.php' on line 60

The PHP Intl extension is missing. It's strange that you could update as we check that this extension is available.

The second is present when viewing a FAQ, the user is not correctly entered: n&sol;a

Fixed the wrong entity for 4.0.7, if you want to see the real username, this user has to enable that in the user preferences.

The third is for FAQ creation via the “Add a FAQ” interface in “Administration”. When we want to create an FAQ and click on “Save”, nothing happens. The FAQ is not created.

Is there any error?

PS: There is also the empty right in the list of rights that I had indicated to you.

Do you have a screenshot for me?

bye
Thorsten

[Virgile]

Hello,

The intl extension was not installed. I guess the check is not working properly for this extension.

To access the preference of an LDAP user, the menu is not practical. As you told me, being LDAP accounts, password modification should not be displayed. However, other settings are no longer easily accessible (such as enabling username visibility). Wouldn't it be a good idea to make the fields and buttons for password modification invisible to LDAP users, instead of making access to preferences inaccessible?

1.PNG

I get no errors on the web interface when I try to create a FAQ via the web interface.

Here's the right that isn't displayed :

2.PNG

Bye,
Virgile.

[Thorsten]

Hi,

To access the preference of an LDAP user, the menu is not practical. As you told me, being LDAP accounts, password modification should not be displayed. However, other settings are no longer easily accessible (such as enabling username visibility). Wouldn't it be a good idea to make the fields and buttons for password modification invisible to LDAP users, instead of making access to preferences inaccessible?

that's a better solution, you are right.

For the permissions, I think it's an old permission we removed for 4.0. I'll work on a cleanup job. Do you see the value of the checkbox?

bye
Thorsten

[Virgile]

Hello,

Here is the information on the empty right :

1.PNG

For the FAQ creation problem, here is the error returned by our browser:

2.PNG

Bye,
Virgile.