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.SFW, contentgroup.extrafields_PH2, contentgroup.info , '1536' as ModelId , contentgroup.AppearDate as DTE , '2024-11-03' as EXP , contentgroup.PointsRank as plg_ratings_rank , contentgroup.PointsTot as plg_ratings_total , contentgroup.PointsRank , contentgroup.PointsTot , contentgroup.AverageScore , contentgroup.WeightedScore , contentgroup.NumVotes , IF(contentgroup.AverageScore IS NOT NULL,contentgroup.AverageScore, '0.8') as score , plg_tour_contentgroup.trailer_url , plg_tour_contentgroup.trailer_url_mobile , plg_tour_contentgroup.tourinfo , plg_tour_contentgroup.trailer_url as trailer_url_detect
 FROM (contentgroup)
 INNER JOIN plg_tour_contentgroup ON contentgroup.Id = plg_tour_contentgroup.contentgroup AND plg_tour_contentgroup.TourId='42' 
 WHERE (
  contentgroup.AppearDate <= '2024-11-02'
  AND '2024-11-03' >= '2024-11-02'
  AND EXISTS (select 1 from plg_contentascasc WHERE contentgroup.Id = plg_contentascasc.ContentId AND ModelId='1536')
  AND EXISTS (SELECT 1 from sites_contentgroup WHERE contentgroup.Id = sites_contentgroup.contentgroup AND siteid IN (25))
 )
 ORDER BY DTE desc LIMIT 0,8

Disk full (/mysqltmp/#sql-temptable-ef71-601ff8-4b7f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Array
(
    [:modelid] => 1536
    [:defaultscore] => 0.8
    [:tourid] => 42
)

Array
(
    [0] => Array
        (
            [file] => /home/httpd/html/metvly.com/public_html/cms_admin/plugins/contentasc/contentasc.class.php
            [line] => 727
            [function] => DoQuery
            [class] => Query
            [type] => ->
        )

    [1] => Array
        (
            [file] => /home/httpd/html/metvly.com/public_html/cms_admin/includes/pages/load_sets.php
            [line] => 95
            [function] => gen_sets
            [class] => plugin_contentasc
            [type] => ->
        )

    [2] => Array
        (
            [file] => /home/httpd/html/metvly.com/public_html/cms_admin/includes/pages/load_servepage.php
            [line] => 117
            [function] => LoadPage_sets
        )

    [3] => Array
        (
            [file] => /home/httpd/html/metvly.com/public_html/cms_admin/includes/alwaysexec.php
            [line] => 2207
            [function] => LoadPage_servepage
        )

    [4] => Array
        (
            [file] => /home/httpd/html/metvly.com/public_html/shefucksonthefirstdate/servepage.php
            [line] => 41
            [function] => LoadPageFile
        )

)