Jump to content

koyocik

Members
  • Posts

    43
  • Joined

  • Last visited

Posts posted by koyocik

  1. Hi, after update from 1.7.2 to 1.7.6.4 I got an error in backoffice, when I try to get to Design->Pages.

    An exception occurred while executing 'SELECT c.`id_cms`, cl.`link_rewrite`, c.`active`, c.`position`, cl.`meta_title`, cl.`head_seo_title`, c.`id_cms_category` FROM ps_cms c LEFT JOIN ps_cms_lang cl ON cl.`id_cms` = c.`id_cms` INNER JOIN ps_cms_shop cs ON cs.`id_cms` = c.`id_cms` WHERE (cl.`id_lang` = ?) AND (cl.`id_shop` IN (?)) AND (cs.`id_shop` IN (?)) AND (c.`id_cms_category` = ?) GROUP BY c.`id_cms` ORDER BY date_add DESC LIMIT 50 OFFSET 0' with params [1, 1, 1, 1]:
    
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_add' in 'order clause'

    I compared ps_cms table to fresh installed prestashop 1.7.6.4 and has the same columns, no "date_add".

     

    Any help? 

  2. Hi. 

    I faced problem I cannot solve myself.

    I have a product: T-shirt with regular retail price: $10

    now I added 3 combinations:

    BLUE -> add $2 (final price is $12)

    WHITE -> add $1 (final price is $11)

    WHITE -> subtract $1 (final price is $9)

    How to show regular retail price ($10) on product page? All variables I've found by $product|@print_r are combination dependent...

     

    Thanks for any help!

     

     

  3. Nope still the same. Only thing I achieved by changing locales was mails stopped working (wrong path to mail files - gb instead of GB) ;)

     

    Payments looks ok, I receive money, but order statuses are blank and customer gets white page with "Error processing payment" text. 

     

    Something with redirects? But I did literally nothing on shop, and since January 1st it simply stopped working...

  4. Zakładam, że używasz standardowego szablonu i modułu górne menu poziome. W grę wchodzą 3 (lub 4) pliki. 

     

    themes/default-bootstrap/css/modules/blocktopmenu/css/blocktopmenu.css

     

    themes/default-bootstrap/css/modules/blocktopmenu/css/superfish-modified.css

     

    themes/default-bootstrap/modules/blocktopmenu/blocktopmenu.tpl

     

    i ewentualnie themes/default-bootstrap/css/global.css

     

    Miłej zabawy ;)

  5. Trochę nie rozumiem o co Ci chodzi. Nikt tu nie twierdzi, że advancedeucompliance jest złym modułem. Ale może ktoś po prostu będzie chciał coś jednak załączyć do maila. I ma rozwiązanie. Dlaczego nie ulatwić, skoro jest taka możliwość?

     

    Poza tym, współpracowałeś kiedyś przy tworzeniu sklepu z kancelarią prawną? Przysłali Ci formularz zwrotu albo regulamin w htmlu? Mnie nigdy. A pdf niejednokrotnie. 

  6. W 1.6.1.5 trzeba zmienić Swift_Message_Attachment na Swift_Attachment, inaczej się wywala.

     

    A więc, dla 1.6.1.5:

    /* Attach a file to order confirmation mail */
        if ($template == 'order_conf') {
        	$file = _PS_ROOT_DIR_ . '/pliki/regulamin.pdf';
        	$message->attach(new Swift_Attachment(file_get_contents($file), 'Regulamin', 'application/pdf'));
         
        /* Send mail */
        $send = $swift->send($message, $to, new Swift_Address($from, $from_name));
        $swift->disconnect();
    
  7. Hi.

     

    What I'm trying to achieve, is display basic unit price (tax excl.) on product page and product list.

     

    I got products with quantity combinations - 100pcs, 1000pcs etc, and unit price on product page is shown by combination, not by piece. Is there a way to display basic unit price, as one declared in BO - unit price?

     

    I tried 

    1. 

    {$product->unit_price}

    2. 

    {assign var='kproductPrice' value=$product->getPrice(true, $smarty.const.NULL, 6)}
    {$kproductPrice}

    But none of these is working...

  8. Hi guys, I wanted to display features and features values in backoffice, but stuck with it... maybe somebody?

     

    $this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'feature_product` fp ON (fp.`id_product` = a.`id_product` AND fp.`id_feature` = '.ID_FEATURE.') ';
    $this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'feature_value_lang` fl ON (fp.`id_feature_value` = fl.`id_feature_value` AND b.`id_lang` = fl.`id_lang`) ';
    $this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'feature_lang` fgf ON (fp.`id_feature` = fgf.`name` AND b.`id_lang` = fgf.`id_lang`) ';
    
    
    
    
    $this->fields_list['fgfname'] = array(
    'title' => $this->l('WarCecha'),
    'width' => 100,
    'filter_key' => 'fgf!name',
    );
    $this->fields_list['feature'] = array(
    'title' => $this->l('Cecha'),
    'width' => 100,
    'filter_key' => 'fl!value',
    );
  9. Cześć.

     

    Usiłuję napisać moduł, który będzie wyświetlał wszystkie produkty, które mają parametr xdelivery 1 w bazie danych.

     

     

     

     

     

    w kontolerze mam tak:

    
    
    $products_partial = Product::getProducts($this->context->language->id, , 1000, 'name', 'asc'); 
    $products = Product::getProductsProperties($this->context->language->id, $products_partial);
    

    a w pliku tpl tak:

     

    {foreach from=$products item=product name=products}
        {if $product.xdelivery==1}

    I działa, ale ładowanie trwa wieki. Pewnie dlatego, że najpierw sprawdza wszystkie a potem dopiero filtruje. 

     

     

    Jak zrobić, żeby do foreach były brane tylko produkty, dla których xdelivery==1

     

    Będę wdzięczny za pomoc

     

    Pozdrawiam.

  10. Hi!

     

    I'm trying to force socialsharing module, to use second, not first product image.

     

    I've found here, thanks to Vekia some code to change in class Product.php:

     public static function geImagesByID($id_product, $limit = 2){
            $id_image = Db::getInstance()->ExecuteS('SELECT `id_image` FROM `'._DB_PREFIX_.'image` WHERE `id_product` = '.(int)($id_product) . ' ORDER BY position ASC LIMIT 1, ' . $limit);
            $toReturn = array();
            if(!$id_image)
               return;
            else
               foreach($id_image as $image)
                  $toReturn[] = $id_product . '-' . $image['id_image'];
            return $toReturn;
        } 
    

    but, have no idea what do next in socialsharing_header.tpl, I know it is here:

    {if isset($link_rewrite) && isset($cover) && isset($cover.id_image)}
    <meta property="og:image" content="{$link->getImageLink($link_rewrite, $cover.id_image, large_default)}" />
    {/if}
    

    Thanks.

     

     

  11. Hi Gurus!

     

    I'm trying to display all the specific prices to all groups (visitors mostly).

     

    My point is, to encourage customers to create account:

    In example:

    - Regular product price is $100

    - Product price for members is $95

     

    On product page  I would like to display something like:

    Price for members: $95

    Price: $100

     

    The problem is, that this specific members price is set individually for each product, so I cannot simply add $product-price and recalculate it. 

     

    I need to display  specific price for product directly, and don't know how. 

  12. Hi Gurus :)

     

    I'd like to modify alittle my product.tpl in template.

     

    I have 3 features, and want each of them to have pictures (on/off). But, want to display "highlighted" pictures if feature is set to "Yes" and no highlighted when feature is set to "NO" or not set at all.

     

    I creatd correct css, but have a problem with product.tpl

     

    Done something like this, but I'm sure is wrong somewhere:

     

    {if $feature.id ==14 && $feature.value != 0}
    <img class="icon highlighted" src="../../img/terrain/Carve.png" />
    {else}
    <img class="sp_icon" src="../../img/terrain/Carve.png" />
    {/if}
     
    Grateful for any help.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More