hi folks sorry to disturb you but since the 4 july we face this random error when activating Ja Good template

Can't create/write to file '/var/tmp/mysql/#sql-temptable-fa1f-66f2-b.MAD' (Errcode: 28 "No space left on device")

(no problem with cassiopea)

our host said its this SQL query who crash the server

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-07-06 13:49:41') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-06 13:49:41')
ORDER BY a.created DESC LIMIT 3

So as there is category filter IN (103,211,90,91,92,93,94,95,96,98,101)

i guess its bricks or slideshow module,

site is, of course.... down....,

all the best

f.

all the best

Hi saguaros i think i have found the bad module )))))

as the request as a category filter IN (103,211,90,91,92,93,94,95,96,98,101)

who is :

103 = Twiligth Zone
211 = Loisirs
90 = Actualités internationales
91 = Actualités Françaises
92 = Brèves
93 = Sécurité
94 = Jeux Vidéo
95 = Actualités scientifiques
96 = Divers
98 = Actualités High Tech
101 = News flash

I haved checked the category selection of brick module and so on, and the only module with that category selection is 'last articles' aka 'derniers articles' screen shot attached

I have disabled the module, but we will have more clue tomorrow or monday as the nigth the site is not publicaly accessible.

All the best, hope you can fix that asap.

nb. you have to know that we have 15K articles......... the blog as 15 year....

Kind regards,

f.

hi folks you need to fix this module on your side, so we can update the site,

thanks

Hi folks we desactivated the fautly module that worked a bit, but we get another crash this nigth, with other modules with category selection, i will determine them exactly)

it seem that your code as issue with large number or article and make crash the server

we need fix urgently

Here is the other fautly modules and the SQL request :

Briks Module

Time: 230712 2:06:44

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 (263,72,73,102,90,91,75,76,92,93,94,95,96,98,99,101,103) AND a.created_by IN (62,724) AND (a.publish_up IS NULL OR a.publish_up <= '2023-07-11 23:56:35') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-11 23:56:35')
ORDER BY a.created DESC LIMIT 4;

Category 263,72,73,102,90,91,75,76,92,93,94,95,96,98,99,101,103

263 = Cuisine
72 = Cinéma
73 = Livres
102 = Musiques
90 = Actualités internationale
91 = Actualités Française
75 = Tutorial
76 = Astuces Logiciels
92 = Brèves
93 = Sécurité
94 = Jeux vidéo
95 = Actualités scientifiques
96 = Divers
98 = Actualités Higth Tech
99 = Dossiers
101 = NewsFlash
103 = Twilligth Zone

Slide midle Modules

SET timestamp=1689120524;
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 (90,91,95,96,98,99) AND (a.publish_up IS NULL OR a.publish_up <= '2023-07-11 23:56:37') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-11 23:56:37')
ORDER BY a.hits DESC LIMIT 50;

90 = Actualités internationale
91 = Actualités Française
95 = Actualités scientifiques
96 = Divers
98 = Actualités Higth Tech
99 = Dossiers

who CRASH, and the team support are woke up in the middle of the nigth because the SQL server as crashed and that as crashed server of OTHER customer TOO !

We need a FIX !

Thanks,

ok, i've a meeting in 30mn will be back in 1hour will give you the admin and the backdoor,

thanks a lot, the host want to fire us because of these crash

kind regards,

f.

there is no Cpanel @ hostpoint

Also the issue is random we have archived 5K articles on the 15k to reduce the load of the query

thanks

manhta international restriction should be ok now