JK11
Members-
Posts
14 -
Joined
-
Last visited
JK11's Achievements
-
I have similar problem like m2net, but with column advanced_stock_management. I know cause of this problem. But I dont know how can I add alias like a.advanced_stock_management into sql query. Code: $this->fields_list['advanced_stock_management'] = array( 'title' => $this->l('Advanced stock'), 'align' => 'text-center', 'filter_key' => $alias.'!advanced_stock_management', 'class' => 'fixed-width-sm' ); Error: Column 'advanced_stock_management' in where clause is ambiguous Sql query: SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active , shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, sa.`active`, sa.`advanced_stock_management`, IF(sav.`quantity`<=0, 1, 0) badge_danger FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 2 AND b.`id_shop` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default) LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default) LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default) LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) WHERE 1 AND `advanced_stock_management` = 1 GROUP BY sa.id_product
- 125 replies
-
- admin
- backoffice
-
(and 2 more)
Tagged with:
-
Hello, I want create multistore in my Prestashop 1.6.0.12. But when I try to create shop, there are no categories loaded, see attached screenshot. So I`m not able create new shop without selected root category. After turn on debug mode, this errors appears: Notice in line 444 in file /PATH/web/controllers/admin/AdminShopController.php [8] Undefined offset: 0 Notice in line 457 in file /PATH/web/controllers/admin/AdminShopController.php [8] Undefined offset: 0 Notice in line 459 in file /PATH/web/controllers/admin/AdminShopController.php [8] Undefined offset: 0 Thank you for any help.
-
Add image field to INSTANT STOCK STATUS list
JK11 posted a topic in Configuring and using PrestaShop
Hi all, I need add image(product image) field into INSTANT STOCK STATUS list in administration. See attached screenshot. I added this code to fields list in file /controllers/admin/AdminStockInstantStateController.php: 'image' => array( 'title' => $this->l('Image'), 'align' => 'center', 'image' => 'p', 'orderby' => false, 'filter' => false, 'search' => false ), But that's all, what I was able to do. Prestashop version: 1.6.0.12 Thank you for any help. King regards, Juraj. -
Cash on delivery module problem
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
Thanks for reply. It is exactly Cash on delivery plus 1.5.3 -
Hi all. I have PrestaShop™ 1.5.6.1. I have problem problem with COD module. This module sets total_paid_real double price. For example, in database in table orders in column total_paid is 100 and in the column total_paid_real is 200. And this mistake is also appear in dashboard montly stats. Any idea? Thank you.
-
Import from xml products with variants
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
No idea? -
Import from xml products with variants
JK11 posted a topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
Hi all. I have question about import from xml file products with variants. In xml file I have e.g. these three products: Amstaff Abaro Sweater Black - M Amstaff Abaro Sweater Black - L Amstaff Abaro Sweater Black - XL Every product have unique id. Is there way, how can I show this products as one product with dropdown variants M, L, XL? Thank you for any help. -
Hi all! It is possible to do import from xml file products with attributes in that way? The xml file contains e.g. this two products: Amstaff Abaro Sweater Black - M Amstaff Abaro Sweater Black - L I dont want in list of products in the Prestashop this two products, but only one product with two attributes, in this case sizes M and L. It is possible do something like this? Thank you for any help.
-
Fatal error: Class 'Image' not found in...
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
Thank you for your time. I solved the problem by deleting all cache files. -
Fatal error: Class 'Image' not found in...
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
Thanks for reply. I think, that import file is flawless, because the same file works very well on the other website, where PrestaShop™ 1.5.6.0 is running too. In my opinion the problem can be only on server side (but the web provider told me, that everything is setup correctly, the problem must be on the application side) or application side. I have compared prestashop classes in /classes folder, but classes are same like on the website, where import works well. Do you know, where could be the problem? Really thank you for your time. -
Fatal error: Class 'Image' not found in...
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
Yes, but this code work well on the other server. Here is the code: Function: function addImages($images,$product_id,$product_name=""){ - $images - array of images urls echo "adding "; $image_ids=array(); foreach($images as $url){ $productHasImages = (bool)Image::getImages(1, (int)($product_id)); - on this line is the problem $image = new Image(); $image->id_product = (int)($product_id); $image->position = Image::getHighestPosition($product_id) + 1; $image->cover = (!$productHasImages) ? true : false; $image->legend = createMultiLangField($product_name); $image->add(); if(!cpimage($product_id,$image->id,"tmp_img.jpg",$image->cover,$image->position)) echo "FAILED COPY<br>"; $image->associateTo(1); echo "image added"; $image_ids[]=$image->id; } return $image_ids[0]; } Is this enough information for you? Do you want whole file? Thanks for your help. -
Fatal error: Class 'Image' not found in...
JK11 replied to JK11's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
No. It's my own import file. -
Hi all, I use: PrestaShop™ 1.5.6.0 I have problem with my XML import: Fatal error: Class 'Image' not found in /www/path/import.php on line 212 line 212: $productHasImages = (bool)Image::getImages(1, (int)($product_id)); This import work fine on this server: http://fitness-sport.sk/info.php But problem is with this server: http://hiphop-oblecenie.sk/info.php Image classes are the same in the prestashop /classes Any idea? Thanks for any help.
-
Watermark not working in 1.5.2
JK11 replied to projectpb's topic in Configuring and using PrestaShop
I have tried mentioned module, but the problem still persists.