- Posts: 6218
COMMUNITY FORUM
Installation impossible sous Joomla 3.922
- JoomlaWorks
- Offline
- Admin
Less
More
4 years 3 weeks ago #177317
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Can you modify the server's my.cnf? Judging from the screenshots' URLs, you're using cPanel.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 weeks ago #177318
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
it's a shared server (using cpanel you're right) and I don't seem to have access to this "my.cnf" ... where should be this file? ... I didn't find any with this naame
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 3 weeks ago #177319
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Pass along the SQL error to your hosting company so they can adjust the server's my.cnf configuration accordingly (they probably need to enable innodb_large_prefix).
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 weeks ago #177323
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Thanks Fotis, I'll transmit to my hosting company. Usually they argue that it's a shared server son can't make any individual change ... but I hope they'll agree to do.
Have a nice day ... I'll inform if any progress for solution.
Have a nice day ... I'll inform if any progress for solution.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 3 weeks ago #177331
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
You'll probably have issues with other extensions as well, so it's good to be prepared :)
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
4 years 2 weeks ago #177357
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Hi Fotis,
The DB admin had a look and his answer is the following:
"The suggested variable is already ON:
mysql> show session variables like 'innodb_large_prefix';
+
+
+
| Variable_name | Value |
+
+
+
| innodb_large_prefix | ON |
+
+
+
1 row in set (0.00 sec)
Customer must create table with:
ROW_FORMAT=DYNAMIC
E.g.
CREATE TABLE <table_name> (
... field definitions ...
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
This is a common issues when importing from MariaDB or MySQL > 5.6"
SO WHAT CAN I DO AT THIS STAGE?
Really embarrassed not to be able to use K2
The DB admin had a look and his answer is the following:
"The suggested variable is already ON:
mysql> show session variables like 'innodb_large_prefix';
+
+
+
| Variable_name | Value |
+
+
+
| innodb_large_prefix | ON |
+
+
+
1 row in set (0.00 sec)
Customer must create table with:
ROW_FORMAT=DYNAMIC
E.g.
CREATE TABLE <table_name> (
... field definitions ...
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
This is a common issues when importing from MariaDB or MySQL > 5.6"
SO WHAT CAN I DO AT THIS STAGE?
Really embarrassed not to be able to use K2
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 2 weeks ago #177367
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
This is the first time I hear about this.
Digging around a bit I found this old post (MySQL 5.0 is mentioned!) at the MySQL worklog site: dev.mysql.com/worklog/task/?id=8307
So it's my guess that your webhost has a weird or outdated my.cnf config. And I'm afraid I can't modify K2 for everyone just to suit your webhost.
So grab K2, extract it and edit the SQL installation file to append ROW_FORMAT=DYNAMIC at the end of each CREATE TABLE... definition.
If I were you I would changes webhosts though...
Digging around a bit I found this old post (MySQL 5.0 is mentioned!) at the MySQL worklog site: dev.mysql.com/worklog/task/?id=8307
So it's my guess that your webhost has a weird or outdated my.cnf config. And I'm afraid I can't modify K2 for everyone just to suit your webhost.
So grab K2, extract it and edit the SQL installation file to append ROW_FORMAT=DYNAMIC at the end of each CREATE TABLE... definition.
If I were you I would changes webhosts though...
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
4 years 2 weeks ago #177374
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
OK thanks a lot!
I'll try to do so asap.
Hope it will work ...
Have a nice day.
Marc
I'll try to do so asap.
Hope it will work ...
Have a nice day.
Marc
Please Log in or Create an account to join the conversation.
- Marc
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
4 years 2 weeks ago #177375
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
done ... and works!
MANY THANKS FOTIS !!!!
MANY THANKS FOTIS !!!!
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 1 week ago #177386
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Do consider the option of changing webhosts in the near future though. :)
You never know when things will break again...
You never know when things will break again...
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.