Mysql Error Number: HY000/1021
This Page has produced an error
Please notify us of this error and provide as much information about the error as possible including what steps you performed to create the error.

SELECT contentgroup.Id, contentgroup.AppearDate, contentgroup.ExpireDate, contentgroup.StoreDate, contentgroup.DaysVis, contentgroup.Title, contentgroup.Description, contentgroup.Directory, contentgroup.SEOname, contentgroup.SEOdesc, contentgroup.SEOkey, contentgroup.extrafields_PH2, contentgroup.info , contentgroup.AppearDate as DTE , IF(contentgroup.ExpireDate IS NULL, '2025-04-25', contentgroup.ExpireDate) as EXP , plg_tour_contentgroup.trailer_url , plg_tour_contentgroup.trailer_url_mobile , contentgroup.PointsRank as plg_ratings_rank , contentgroup.PointsTot as plg_ratings_total , contentgroup.PointsRank , contentgroup.PointsTot , contentgroup.AverageScore , contentgroup.WeightedScore , contentgroup.NumVotes
 FROM (contentgroup)
 INNER JOIN plg_tour_contentgroup ON contentgroup.Id = plg_tour_contentgroup.contentgroup AND plg_tour_contentgroup.TourId='1' 
 WHERE (
  EXISTS ( SELECT 1 from category_contentgroup WHERE contentgroup.Id = category_contentgroup.contentgroup  AND Category IN (7))
  AND contentgroup.AppearDate <= '2025-04-23'
  AND IF(contentgroup.ExpireDate IS NULL, '2025-04-25', contentgroup.ExpireDate) >= '2025-04-23'
  AND EXISTS(select 1 from sites_contentgroup WHERE contentgroup.Id = sites_contentgroup.contentgroup AND sites_contentgroup.siteid = '1')
  AND contentgroup.AppearDate <= '2025-04-23'
 )
 ORDER BY DTE DESC LIMIT 0,1

Disk full (/tmp/#sql_28bc_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Array
(
    [:siteid] => 1
    [:tourid] => 1
    [:olderthan] => 2025-04-23
)

Array
(
    [0] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/membersMain.class.php
            [line] => 10234
            [function] => DoQuery
            [class] => Query
            [type] => ->
        )

    [1] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/phptemplate/classic_lhfilms/functions/custom.tpl
            [line] => 1211
            [function] => getSets
            [class] => ElevatedXApi
            [type] => ->
        )

    [2] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/phptemplate/classic_lhfilms/tour/header.tpl
            [line] => 282
            [function] => get_from_scheduled_updates
        )

    [3] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/phptemplate/classic_lhfilms/functions/standard.tpl
            [line] => 34
            [function] => include
        )

    [4] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/phptemplate/classic_lhfilms/gallery_outside.tpl
            [line] => 57
            [function] => LoadTemplate
        )

    [5] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/alwaysexec.php
            [line] => 606
            [function] => unknown
        )

    [6] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/membersMain.class.php
            [line] => 5338
            [function] => php_templateload
        )

    [7] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/pages/load_gallery.php
            [line] => 218
            [function] => xsl_output
            [class] => MembersMain
            [type] => ->
        )

    [8] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/pages/load_gallery.php
            [line] => 54
            [function] => gen_gallery
        )

    [9] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/pages/load_servepage.php
            [line] => 117
            [function] => LoadPage_gallery
        )

    [10] => Array
        (
            [file] => /home/httpd/html/loveherfeet.com/public_html/cms_admin/includes/alwaysexec.php
            [line] => 2156
            [function] => LoadPage_servepage
        )

    [11] => Array
        (
            [file] => /home/httpd/html/loveherfilms.com/public_html/tour/servepage.php
            [line] => 41
            [function] => LoadPageFile
        )

)