<![CDATA[Esvon LTD]]> <![CDATA[UTF-8 issue after MySQL server update 5.x to 8.x]]> Sometimes after MySQL server update to 8.x some things are not displaying as they should.

For example, the bullets are • iv,  characters appear on empty lines or in other whitespace, and apostrophes are replaced by ’ , and many other things that look weird and seem encoding-related.

Newly added data doesn't display this behaviour.

This problem is encoding related and usually is result of your export/import strategy.

The weird chars come from UTF-8 data that was originally stored as Latin-1 and then not converted correctly to UTF-8.

If you still have access to the old database, you can try exporting it using command like this:

mysqldump -uDBUSER -pDBPASS -r db.sql --default-character-set=latin1 --skip-set-charset --no-tablespaces DBNAME

If the old database is not available or not up to date, the data is probably still recoverable; you'll need a MySQL function like

convert(cast(convert(v_descr using latin1) as binary) using utf8)

Here is how you can test it on one record initially:

update ec5_ad set v_descr = convert(cast(convert(v_descr using latin1) as binary) using utf8) where link_id=1

]]> <![CDATA[All email messages go to junk mail, is there a solution?]]> You can try to enable PHP mailer authenticating through SMTP at the bottom of this page:

Admin Area -> Application Setup -> Advanced Setup

Here are the steps required:

1/ Change  "Method  to  send  mail"  to "SMTP Server"
2/ Specify SMTP Host/Port
3/ Enable SMTP authentication
4/ Specify SMTP Username/Password
5/ Click "Update"

If your script version has "No-Reply Email" option in Application Setup (since 4.0.14), it may be necesary to match SMTP Username with "No-Reply Email"(make sure they are the same)

]]> <![CDATA[How can fields of textarea type be displayed with line breaks in the frontend / ...]]> You can use "|nl2br" modificator in the proper template (details.htm for ad details page).

For example:##f_descr|nl2br##

]]> <![CDATA[How can I force secure browsing through HTTPS in Admin Area for all pages?]]> If you have Apache server you can place .htaccess file into /admin/ directory (or its renamed equivalent) with the following lines (use your directory name instead of /admin/ if you renamed it).

If .htaccess file already exists you can add these lines to it unless some of them are already there:

RewriteEngine On
RewriteBase /admin/

RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{SERVER_NAME}/admin/$1 [R=301,L]

]]> <![CDATA[Why installed client software for Member Websites module does not display conten...]]> <![CDATA[Why my website is showing message "Please access site through domain mydomain.co...]]> In Admin Area -> Application Setup you have Site URL defined as starting with

http://mydomain.com/ (by mydomain.com we mean your actual domain)

You can change it to begin with http://www.mydomain.com/

If you want both "www" and "non-www" URLs to work as mirrors (not best idea for SEO, the website may suffer from duplicate content penalty), just comment out the related PHP code in inc/app_init.php (search for string "Please access site through domain")]]> <![CDATA[Why some of the expired listings become active again with a new expiration date ...]]> If a price plan is configured to expire into another price plan then a new plan is activated automatically when previous plan expires. So a new expiration date is set according to a new plan settings.

You can avoid this by making sure "Price plan to expire this price plan into" is set to nothing. This option can be be seen when you click "modify" next to any price plan in Admin Area -> Price Plans.

]]>