Message
- Error
-
- Disk full (/tmp/#sql_486_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT
c.title as title,
s.title as section,
cat.title as category,
CONCAT('index.php?option=com_content&view=article&catid=', cat.id, '&id=', c.id) as link
FROM
jos_content as c,
jos_sections as s,
jos_categories as cat
WHERE
c.sectionid = s.id
AND c.catid = cat.id
AND c.state = '1'
AND s.published = '1'
AND cat.published = '1'
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2022-05-28 12:39:54' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2022-05-28 12:39:54' )
AND c.access <= '0'
ORDER BY s.title, cat.title,c.title
This was your SQL:
SELECT c.title as title, s.title as section, cat.title as category, CONCAT('index.php?option=com_content&view=article&catid=', cat.id, '&id=', c.id) as link FROM jos_content as c, jos_sections as s, jos_categories as cat WHERE c.sectionid = s.id AND c.catid = cat.id AND c.state = '1' AND s.published = '1' AND cat.published = '1' AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2022-05-28 12:39:54' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2022-05-28 12:39:54' ) AND c.access <= '0' ORDER BY s.title, cat.title,c.title
End of SQL - Disk full (/tmp/#sql_486_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT
cat.title as title,
s.title as section,
'' as category,
concat('index.php?option=com_content&view=category&layout=blog&id=',cat.id) as link
FROM
jos_sections as s,
jos_categories as cat
WHERE
cat.section = s.id
AND s.published = '1'
AND cat.published = '1'
AND cat.access <= '0'
AND s.access <= '0'
ORDER BY s.title, cat.title
This was your SQL:
SELECT cat.title as title, s.title as section, '' as category, concat('index.php?option=com_content&view=category&layout=blog&id=',cat.id) as link FROM jos_sections as s, jos_categories as cat WHERE cat.section = s.id AND s.published = '1' AND cat.published = '1' AND cat.access <= '0' AND s.access <= '0' ORDER BY s.title, cat.title
End of SQL
- Disk full (/tmp/#sql_486_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT
c.title as title,
s.title as section,
cat.title as category,
CONCAT('index.php?option=com_content&view=article&catid=', cat.id, '&id=', c.id) as link
FROM
jos_content as c,
jos_sections as s,
jos_categories as cat
WHERE
c.sectionid = s.id
AND c.catid = cat.id
AND c.state = '1'
AND s.published = '1'
AND cat.published = '1'
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2022-05-28 12:39:54' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2022-05-28 12:39:54' )
AND c.access <= '0'
ORDER BY s.title, cat.title,c.title