hi acymailing team, we use you software since 12 year, and since 2 week we have server crash at precise time, i'm a this time not 100% sure its linked to acymail but our host have isolated this query 🇦
sql database as a lot of query and run out of space and crash...
| 106661 | danisegi_folamo | p18.server.hostpoint.internal:45734 |
danisegi_crashdebugfr | Execute | 345 | Sending data |
SELECT
a.id,a.title,a.alias,a.introtext,a.fulltext,a.checked_out,a.checked_out_time,a.catid,a.created,a.created_by,a.created_by_alias,a.modified,a.modified_by,CASE
WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END AS
publish_up,a.publish_down,a.images,a.urls,a.attribs,a.metadata,a.metakey,a.metadesc,a.access,a.hits,a.featured,a.language,LENGTH(a.fulltext)
AS readmore,a.ordering,fp.featured_up,fp.featured_down,CASE WHEN
c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN
0 ELSE a.state END AS state,c.title AS category_title,c.path
AS category_route,c.access AS category_access,c.alias AS
category_alias,c.language AS
category_language,c.published,c.published AS
parents_published,c.lft,CASE WHEN a.created_by_alias > ' ' THEN
a.created_by_alias ELSE ua.name END AS author,ua.email AS
author_email,uam.name AS modified_by_name,parent.title AS
parent_title,parent.id AS parent_id,parent.path AS
parent_route,parent.alias AS parent_alias,parent.language AS
parent_language
FROM s8c9k_content AS a
LEFT JOIN s8c9k_categories AS c ON c.id = a.catid
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_by
LEFT JOIN s8c9k_users AS uam ON uam.id = a.modified_by
LEFT JOIN s8c9k_categories AS parent ON parent.id = c.parent_id
LEFT JOIN s8c9k_content_frontpage AS fp ON fp.content_id = a.id
WHERE a.access IN (1,5,7) AND c.access IN (1,5,7) AND c.published
= 1 AND a.state = 1 AND a.catid IN
(103,211,90,91,92,93,94,95,96,98,101) AND (a.publish_up IS NULL OR
a.publish_up <= '2023-03-22 02:51:35') AND (a.publish_down IS NULL OR
a.publish_down >= '2023-03-22 02:51:35')
ORDER BY a.created DESC LIMIT 3 | 0.000 |
We use Joomla 4.2.9 and acymailing 5.11.06 (just upgraded)
Does this is your code ?
thanks,
f.
