Jump to content
  • 0

Header.tpl


masternoob154

Question

8 answers to this question

Recommended Posts

  • 0

no oki, proszę o podpowiedz co zrobić 


Notice: Use of undefined constant _RIJNDAEL_KEY_ - assumed '_RIJNDAEL_KEY_' in /home/u462322442/public_html/classes/Cookie.php on line 80

Notice: Use of undefined constant _RIJNDAEL_IV_ - assumed '_RIJNDAEL_IV_' in /home/u462322442/public_html/classes/Cookie.php on line 80
[PrestaShopDatabaseException]

Disk full (/dev/shm/#sql_79b6_11.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")


SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
						pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
						p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
						product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, 
						stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
						p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
						CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
						product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, IFNULL(sp.`reduction_type`, 0) AS reduction_type,
NULL AS customization_quantity, NULL AS id_customization,

				product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
				IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
				(p.`weight`+ pa.`weight`) weight_attribute,
				IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
				IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
				pai.`id_image` as pai_id_image, il.`legend` as pai_legend,
				IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity
			
FROM `m59p_cart_product` cp
LEFT JOIN `m59p_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `m59p_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `m59p_product_lang` `pl` ON 
			p.`id_product` = pl.`id_product`
			AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop 
LEFT JOIN `m59p_category_lang` `cl` ON 
			product_shop.`id_category_default` = cl.`id_category`
			AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop 
LEFT JOIN `m59p_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN `m59p_specific_price` `sp` ON sp.`id_product` = cp.`id_product`
 LEFT 
			JOIN m59p_stock_available stock
			ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `m59p_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `m59p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `m59p_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `m59p_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 2
WHERE (cp.`id_cart` = 16) AND (p.`id_product` IS NOT NULL)
GROUP BY unique_id
ORDER BY cp.`date_add`, p.`id_product`, cp.`id_product_attribute` ASC

at line 635 in file classes/db/Db.php
629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**
DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 510 - classes/Cart.php] - [1 Arguments]
CartCore->getProducts - [line 62 - modules/blockcart/blockcart.php] - [1 Arguments]
BlockCart->assignContentVars - [line 212 - modules/blockcart/blockcart.php] - [1 Arguments]
BlockCart->hookRightColumn - [line 265 - modules/blockcart/blockcart.php] - [1 Arguments]
BlockCart->hookTop - [line 509 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 448 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]
Edited by masternoob154 (see edit history)
Link to comment
Share on other sites

  • 0

A nie przekroczyłeś limitu bazy danych?

Bo wywala się na zapytaniach sql i komunikat jest jak wół "Disk full (/dev/shm/#sql_79b6_11.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")".

A klucze powinny być w /config/settings.inc.php i presta generuje je automatycznie w czasie instalacji.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...