1. ligi
  2. General
  3. Wednesday, August 02 2017, 03:51 PM
when trying to install easyprofile i get the following error on a specific host. Index column size too large ..The max column size is 767 bytes.. Do you have any idea how to solve this?
Tnx in advance
admin Accepted Answer
Admin
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.
  1. more than a month ago
  2. General
  3. # 1
ligi Accepted Answer
tnx for your reply, we'll get in touch with the hosting provider about the sql server
  1. more than a month ago
  2. General
  3. # 2
ligi Accepted Answer
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.
  1. more than a month ago
  2. General
  3. # 3
admin Accepted Answer
Admin
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.
  1. more than a month ago
  2. General
  3. # 4
ligi Accepted Answer
I really appreciate your help.
Info are in the side details tab.

Thank you so much!
  1. more than a month ago
  2. General
  3. # 5
admin Accepted Answer
Admin
Done :D

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.
  1. more than a month ago
  2. General
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.