Jump to content

Arpels

Members
  • Posts

    36
  • Joined

  • Last visited

Profile Information

  • First Name
    Kevin
  • Last Name
    Barnoin

Recent Profile Visitors

189 profile views

Arpels's Achievements

Newbie

Newbie (1/14)

1

Reputation

5

Community Answers

  1. Actually it's following a migration. I was on 1&1 mutualized server, now i'm on Amazon EC2 instance with a Load balancer in front. I've made some perf. test and it seems my .htaccess is not taken into account. I've setup compression, deflate and expires instruction but perf test shows that it's not enable... I really feel it's related to missing configuration on my apache server. I'm still investigating
  2. Saddly no, same result on Safari & Firefox. each time I change menus, the token changes... Any thought on server configuration ? Regards,
  3. Hi, I'm facing intempestive timeout on my back office. Everytime I change menus, the URL token changes (I feel it should not?!). I feel the its a configuration issue in my php.ini/.htaccess or httpd.conf. Thanks for your help ! Background : Prestashop 1.6.1.3 Private server (root access) Admin -> Pref -> cookies BO setup to 72 hours (even ticking the "Stay logged" doesn't work)
  4. Hello, Latest post is a bit old but, did anyone find out how to manage that ? The issue here is just about changing the URL of the first step OR the shipping step, as both has the same URLs in Prestashop 1.6 Best, K
  5. Hello, I don't understand why <p> balise are added automatically to the description_short when a product page is saved. I praticaly only use the import for my product, but upon small modification, saving the product add those <p></p> balise everytime. If anyone has encountered the problem, i'd be glad to get red of it. Thanks !
  6. Hello, I've manage to change the control that has prestashop over the field to enable chars input : For the ean13, as exemple, in /classes/order/OrderDetail.php I've changed isEan13 with isGenericName in the definition array.
  7. Hello, I want to change the type of ean13 field to alloxw chars in it. I've updated the table structure, the field itself to allow more than 13 INT but when I put chars in it, it says it's not valid. How do I change/remove the control on the datatype of the field at save event AND in the import function for CSV upload ? Thanks !
  8. Hello ! I found the solution ! topic closed Thanks
  9. Hello, Thanks, the error is gone, but the datatable fields don't get updated. I think it's because the insertion of the ps_order rows is made after my UPDATE query. How can I make achieve my update afterward ?
  10. I got it worked with the following : Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'orders` SET `delivery_date`='.$planning_delivery->date_delivery.' WHERE `id_order` = '.$params['order']->id); But I have this message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 WHERE `id_order` = 141' at line 1 query fired : UPDATE `ps_orders` SET `delivery_date`=2017-03-22 00:00:00 WHERE `id_order` = 141
  11. Hello Vekia, thanks for you feedback. You're right it's a custom module and my support is out of date. I just want to update the delivery date in ps_orders when it's inserted in the related table of the module. I checked the code and think found the right place to do so as below, and the variable does exist, but maybe not where I put my query. Here is the sample of code above : code removed
  12. Hello, I don't understand why the second line starts at the end and not a the full left :
  13. What i'm I doing wrong ? $result = Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'orders` SET `delivery_date` = '.$planning_delivery->date_delivery); Notice: Undefined variable: planning_delivery in /homepages/39/d606972938/htdocs/prestashop-uat/modules/planningdeliverybycarrier/planningdeliverybycarrier.php on line 557 Notice: Trying to get property of non-object in /homepages/39/d606972938/htdocs/prestashop-uat/modules/planningdeliverybycarrier/planningdeliverybycarrier.php on line 557 [PrestaShopDatabaseException] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 UPDATE `ps_orders` SET `delivery_date` = at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } Thanks for your help...
  14. Hello, last week one of my client succeeded to order beyond the limit of time setup. I've made sure that clients can only choose a delivery slot 2 hours after the current time. example : it's 12:25, the first delivery slot available is 2:30 However, if the client choose the delivery slot, but don't continue the purchase and remain on the page, if he validates 2 hours later (for the example above, lets say it's now 2:25), the command will be validated. I believe I can check the cookie with the last update date of the whole basket and the current time (if the user is in the order process pages) to avoid such behavior. If someone as an idea, it would be really helpfull. I'm using prestashop 1.6.1.3
  15. Ok so I found my issue, I had another JS that bypassed the function. I made it worked. For info, Vekia's tutorial does work.
×
×
  • Create New...