Keyword

Installation impossible sous Joomla 3.922

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
4 weeks 2 days ago #177317 by Fotis
Replied by Fotis 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.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177318 by Marc
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.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
4 weeks 2 days ago #177319 by Fotis
Replied by Fotis 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).

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177323 by Marc
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.

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
4 weeks 1 day ago #177331 by Fotis
Replied by Fotis 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 :)

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

More
3 weeks 2 days ago #177357 by Marc
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

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
2 weeks 6 days ago #177367 by Fotis
Replied by Fotis 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...

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

More
2 weeks 6 days ago #177374 by Marc
OK thanks a lot!
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.

More
2 weeks 6 days ago #177375 by Marc
done ... and works!

MANY THANKS FOTIS !!!!

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
2 weeks 2 days ago #177386 by Fotis
Replied by Fotis 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...

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum