Re: mySQL Error 28

[Rick James]

> perror 28
OS error code 28: No space left on device

Probably the query is too complex for the limited space in your tmpdir.

Are there suitable indexes for the JOINs?

    select  distinct category_name, category_desc, c.category_id
        from  trt_category AS c
        JOIN  trt_article AS a   ON a.category_id = c.category_id
        JOIN  bsjoin AS b        ON a.story_id = b.story_id
        WHERE  a.category_id != '1'
          AND  c.category_name != 'Upcoming Meeting'
          AND  b.board_id = ".$_GET['board_id']

Please use this format for doing JOINs.