B-Ware

Heute-Wohnen - 

tep_db_query Error 1: 
Can't create/write to file '/tmp/MYW7L5W6' (Errcode: 28 - No space left on device)

In file '/includes/modules/product_listing.php' on line 165

===================== Query =====================

select
	 p.products_master, pd.products_name, p.products_user2, p.products_image, p.products_weight, p.products_versand_nachnahme, p.products_quantity, p.products_model, p.products_rating, p.products_rating_count, pd.products_bullets_parent, 
            p.products_id,  p2c.categories_id, 
            pd.products_description,
            pd.products_name,
            p.manufacturers_id,
            p.products_quantity,
            
            p.products_price,
            p.products_price_ca,
            p.products_date_added,
            p.products_google_cpc,
            p.products_priority,
            pp.price,
            p.products_tax_class_id,
            max(IF(s.status, s.specials_new_products_price, p.products_price )) as max_price,
            IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
            IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0)) as final_price,
            IF(s.status, s.specials_new_products_price/p.products_price_ca, (p.products_price + IF(pp.price, pp.price, 0))/p.products_price_ca) as factor,
            (p.products_price_ca-IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0))) as discount,
            IF(p.products_abware='Nein',p.products_priority_
from
	_cpc-0.5,p.products_priority_
from
	_cpc) as CPC
                
                
            
from
	 (products p, products_description pd, products_to_categories p2c, categories c ) 
left join
	 specials s on (p.products_id = s.products_id)  
left join
	 products_prices pp on (p.products_id=pp.products_id and pp.anbieter=9999)  
where
	
            
            p.products_status = '1'
            and pd.products_id = p.products_id
            and pd.language_id = '2'
            and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  AND p2c.categories_id = '1075'  
group by
	 p.products_id  
order by
	  CPC desc, pd.products_name limit 0, 120


===================== Client =====================

SERVER_ADDR:
77.75.251.50

HTTP_X_FORWARDED_FOR:
-

REMOTE_ADDR:
18.118.126.11

HTTP_REFERER:
http://www.heute-wohnen.de/B-Ware_c1075_sid9e4c19d143e25b622caa5509ae74a822_x1.htm

HTTP_USER_AGENT:
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

REQUEST_URI:
/B-Ware_c1075_sid9e4c19d143e25b622caa5509ae74a822_x1.htm



===================== Backtrace =====================

2.
'tep_db_query' called at:
/includes/modules/product_listing.php : 165


1.
'include' called at:
/index.php : 514


===================== Full Backtrace =====================

#0  tep_db_tm_error(select p.products_master, pd.products_name, p.products_user2, p.products_image, p.products_weight, p.products_versand_nachnahme, p.products_quantity, p.products_model, p.products_rating, p.products_rating_count, pd.products_bullets_parent, 

            p.products_id,  p2c.categories_id, 

            pd.products_description,

            pd.products_name,

            p.manufacturers_id,

            p.products_quantity,

            

            p.products_price,

            p.products_price_ca,

            p.products_date_added,

            p.products_google_cpc,

            p.products_priority,

            pp.price,

            p.products_tax_class_id,

            max(IF(s.status, s.specials_new_products_price, p.products_price )) as max_price,

            IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,

            IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0)) as final_price,

            IF(s.status, s.specials_new_products_price/p.products_price_ca, (p.products_price + IF(pp.price, pp.price, 0))/p.products_price_ca) as factor,

            (p.products_price_ca-IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0))) as discount,

            IF(p.products_abware='Nein',p.products_priority_from_cpc-0.5,p.products_priority_from_cpc) as CPC

                

                

            from (products p, products_description pd, products_to_categories p2c, categories c ) left join specials s on (p.products_id = s.products_id)  left join products_prices pp on (p.products_id=pp.products_id and pp.anbieter=9999)  where

            

            p.products_status = '1'

            and pd.products_id = p.products_id

            and pd.language_id = '2'

            and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  AND p2c.categories_id = '1075'  group by p.products_id  order by  CPC desc, pd.products_name limit 0, 120, 1, Can't create/write to file '/tmp/MYW7L5W6' (Errcode: 28 - No space left on device)) called at [/home/heuqvrlg/www.heute-wohnen.de/includes/functions/database.php:133]

#1  tep_db_query(select p.products_master, pd.products_name, p.products_user2, p.products_image, p.products_weight, p.products_versand_nachnahme, p.products_quantity, p.products_model, p.products_rating, p.products_rating_count, pd.products_bullets_parent, 

            p.products_id,  p2c.categories_id, 

            pd.products_description,

            pd.products_name,

            p.manufacturers_id,

            p.products_quantity,

            

            p.products_price,

            p.products_price_ca,

            p.products_date_added,

            p.products_google_cpc,

            p.products_priority,

            pp.price,

            p.products_tax_class_id,

            max(IF(s.status, s.specials_new_products_price, p.products_price )) as max_price,

            IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,

            IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0)) as final_price,

            IF(s.status, s.specials_new_products_price/p.products_price_ca, (p.products_price + IF(pp.price, pp.price, 0))/p.products_price_ca) as factor,

            (p.products_price_ca-IF(s.status, s.specials_new_products_price, p.products_price + IF(pp.price, pp.price, 0))) as discount,

            IF(p.products_abware='Nein',p.products_priority_from_cpc-0.5,p.products_priority_from_cpc) as CPC

                

                

            from (products p, products_description pd, products_to_categories p2c, categories c ) left join specials s on (p.products_id = s.products_id)  left join products_prices pp on (p.products_id=pp.products_id and pp.anbieter=9999)  where

            

            p.products_status = '1'

            and pd.products_id = p.products_id

            and pd.language_id = '2'

            and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  AND p2c.categories_id = '1075'  group by p.products_id  order by  CPC desc, pd.products_name limit 0, 120) called at [/home/heuqvrlg/www.heute-wohnen.de/includes/modules/product_listing.php:165]

#2  include(/home/heuqvrlg/www.heute-wohnen.de/includes/modules/product_listing.php) called at [/home/heuqvrlg/www.heute-wohnen.de/index.php:514]



===================== Dev Mode =====================

Keine Mails und direkte Fehlerausgabe: "define('NO_SQL_MAILS', '1');"