Easy Profile - Joomla Extension

Hi,
this is not something that regards directly EasyProfile, this seems a MySQL server problem due to a old version, from Joomla 3.6 (I think) the new installations uses utf8mb4 charset, it is not well supported by old versions of mysql server.

Try to ask to your hosting provider to upgrade Mysql, you risks that the future Joomla releases will be not compatible with your server.

tnx for your reply, we'll get in touch with the hosting provider about the sql server

Byte, the server provider in the Netherlands where the website is hosted responded with this:

you could add extra argument at the end ROW_FORMAT=dynamic:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci ROW_FORMAT=dynamic;
and then a big part of the database server would be compatible.

Could you tell me how to do this?
Or is it possible that you could do this? thank you.

Hi,
probably with this solution it can works, but we are not able to add this in our package because we need to keep compatibility with different Database Server Providers (MariaDB, MongoDB,MySQL,.....).

Could you tell me how to do this?

you can create Easy Profile Tables before install it, to create these tables you can follow these steps:
- Unzip Easy Profile Package file
- Unzip "jsn" Zip File contained in previous package
- From extracted files open folder admin/sql
- Open file "install.mysql.utf8.sql"
- Copy SQL code,
- replace #__ with prefix of your DB
- add "ROW_FORMAT=dynamic" at the end of lines 52 and 69 (before ";" char like example from your provider)
- Open a DB panel, normally all hosting providers give you a panel to make this (in the most of cases something like phpMyAdmin)
- Use the code to launch the query into DB.

Or is it possible that you could do this? thank you.

Normally we does no do this for free members, but your subscription is just expired so we have decided to give you our help. To help you, we need your site details, you can use the form below the reply in "Site Details" tab.

I really appreciate your help.
Info are in the side details tab.

Thank you so much!

Done

very thanks for your availability, I found the incompatible part of query with your DB server and we will add this fix in next release.