Discuss Joomla! 3.8.0

A place to discuss recent announcements made by the Joomla! Core Team. Let's hear what you have to say.
itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4025
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:

Re: Discuss Joomla! 3.8.0

Post by itoctopus » Mon Sep 25, 2017 8:41 am

There are now quite a few complaints that Joomla 3.8 is (much) slower than Joomla 3.7.5. Not sure if this caused by a possible increased number of requests that Joomla 3.8 makes to the web server causing a firewall throttling, or if this is caused by some slow queries. After reading the last forum post on this subject, I am inclined to think it is probably the former.
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter

itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4025
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:

Re: Discuss Joomla! 3.8.0

Post by itoctopus » Mon Sep 25, 2017 9:12 pm

Ole Bang Ottosen just replied through twitter about the performance issue here: https://twitter.com/ot2sen/status/912402329336451073 - it seems that the "onContentPrepare" event is fired twice. See: https://github.com/joomla/joomla-cms/pull/18066 . Thank you for the Joomla team for immediately investigating and confirming the issue.
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter

trusting
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 134
Joined: Tue Feb 10, 2009 4:49 am

Re: Discuss Joomla! 3.8.0

Post by trusting » Sun Oct 01, 2017 2:05 am

Just want to say "THANK YOU!!!" to preceptm for the SQL solution. I tried the various "turn off extensions via phpAdmin" fixes and still had a white screen admin. :( However, after running the SQL commands you provided, my backend is back! Thank you so much!

scottst
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Feb 05, 2010 2:21 am

Re: Discuss Joomla! 3.8.0

Post by scottst » Wed Mar 07, 2018 10:56 pm

That worked!

Thank you so much. My xxxxx=Jos and this code worked perfectly.

Bowing... :D

ALTER TABLE `xxxxx_menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;
UPDATE `xxxxx_menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';
UPDATE `xxxxx_menu`
SET `menutype` = 'main_is_reserved_133C585'
WHERE `client_id` = 0
AND `menutype` = 'main'
AND (SELECT COUNT(`id`) FROM `xxxxx_menu_types` WHERE `client_id` = 0 AND `menutype` = 'main') > 0;

UPDATE `xxxxx_modules`
SET `params` = REPLACE(`params`,'"menutype":"main"','"menutype":"main_is_reserved_133C585"')
WHERE `client_id` = 0
AND (SELECT COUNT(`id`) FROM `xxxxx_menu_types` WHERE `client_id` = 0 AND `menutype` = 'main') > 0;

UPDATE `xxxxx_menu_types`
SET `menutype` = 'main_is_reserved_133C585'
WHERE `client_id` = 0
AND `menutype` = 'main';
UPDATE `xxxxx_menu`
SET `client_id` = 1
WHERE `menutype` = 'main';
UPDATE `xxxxx_menu`
SET `menutype` = 'main'
WHERE `client_id` = 1
AND `menutype` = 'menu';
UPDATE `xxxxx_menu`
SET `menutype` = 'main',
`client_id` = 1
WHERE `menutype` = 'menu'
AND (SELECT COUNT(`id`) FROM `xxxxx_menu_types` WHERE `client_id` = 0 AND `menutype` = 'menu') = 0;
DELETE FROM `xxxxx_menu_types`
WHERE `client_id` = 1
AND `menutype` IN ('main', 'menu');


Locked

Return to “Announcements Discussions”