R Santos

[Solved this way] Hello guys... This was hard but it is now solved. On filezilla ftp you look for: /public_html/classes/db/DbPDO.php Inside DbPDO.php Edit and add the follow: // disable ONLY_FULL_GROUP_BY if ($this->link->exec('set session sql_mode=\'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\'') === false) die(Tools::displayError('PrestaShop Fatal error')); Now... Make sure to add the comand before this → return $this->link; Which is around line 72-77 (this may vary) P.S. See attached image Thank you guys!!! You saved my shop :)

Hi Everyone, HERE IS THE JOB I NEED AS SOON AS POSSIBLE: I need to have the the payments automatically converted for my shop default currency just to convert on the time that client see payment page from paypal (I use many currencies). I on PS 1.6.0.9 and the paypal modules is V 3.8.2. There are 2 options: 1-Choose Website Payments Standard 2-Choose Website Payments Pro Hosted On website payment standard (Option 1) is not converting automatically just at the time it redirect to paypal payment page. I'm using the (Option 2) and it does not do that convention, and I end up on bad currency conversion from paypal and messing up my stock system which does not accept other currencies. So basically that is the job, make the option 1 and 2 convert automatically to shop default currency ... Should be a easy fix... I have a small budget of 50 euros on this job, please inbox if you are interested. NO TIME WASTERS!!!! IF YOU CANT DO IT, DONT EMAIL. Thank you. Ricardo Ricardo

Hi Curt Donohue, Did you had luck on this integration with aweber? I`m looking for the same sort of autoresponder. Thank you.

Hi Jordiob, Thank you so much... This is great stuff.

Hi Everyone, I need to have the currency automatically converted for my shop default currency (I use many currencies). I on PS 1.6.0.9 (but upgrading to latest version) and the paypal modules is V 3.8.1. There are 2 options: 1-Choose Website Payments Standard 2-Choose Website Payments Pro Hosted On website payment standard (Option 1) is converting automatically just at the time it redirect to paypal payment page. But I'm using the (Option 2) and it does not do that convention, and I end up on bad currency conversion from paypal. So basically that is the job, make the option 2 convert automatically to shop default currency ... Should be a easy fix... I have a small budget on this job, please inbox if you are interested. Thank you. Ricardo

Just to help out: If is a product you add this to link product.php?id_product=16 or if is a category you add thisproduct.php?id_product=13 or if is a CMS you add this cms.php?id_cms=5 Remember the number is the actual id for a product, category or CMS Hope this helps

I did manage to sort the products on sub-category however on category still a mess. Try to advanced parameters > performance > force compile and all clean cache. Clear cache on web browser too. I did purchase this module from addons (Sorting Products by Category v1.1 - by Lineagrafica.es) but did not work on category but works on subcategory, I guess I definitely may be a bug, I did change product category, sequence, etc... I did upgrade from V 1.4 to new V 1.6. If any of you sort this out please let me know, really frustrating

Hi there, Got the same problem here, did you find the solution? thank you.

Hello guys, Same problem here... Any luck on sorting this issue? or perhaps a module that sort products sequence? Thank you. Ricardo

Thank you for sharing this, worked like a charm!!!

Hi There, Here is the job. I have my web store in V1.4.8.2 and it is a very customised store in almost every page and modules, this is not a one click upgrade to V1.6 Will require a expert to do so, only doing because in need of new features from V1.6. *Upgrade from V1.4 to V1.6 *New template to be installed *upgrade the modules with may not work on V1.6 *Test and run to make sure the same feature and modules from V1.4 will be fully working on V1.6 Basically this is a full migration from V1.4 to V1.6 If any one with the right expertise interested, please pm me. Thank you.

<p>Hi Guys,</p> <p> </p> <p>I did same as described, follow code from tmcategories.tpl I`m using prestashop V1.4.8.2</p> <p> </p> <div><!-- TM Categories --></div> <div><script type="text/javascript" src="{$module_dir}superfish.js"></script></div> <div>{literal}</div> <div><script type="text/javascript"></div> <div>$(document).ready(function() {</div> <div>$('ul.sf-menu').superfish({</div> <div>delay: 1000,</div> <div>animation: {opacity:'show',height:'show'},</div> <div>speed: 'fast',</div> <div>autoArrows: false,</div> <div>dropShadows: false</div> <div>});</div> <div>});</div> <div></script></div> <div>{/literal}</div> <div><div class="clearblock"></div></div> <div><div id="tmcategories"></div> <div><ul id="cat" class="sf-menu"></div> <div>{foreach from=$blockCategTree.children item=child name=blockCategTree}</div> <div>{if $smarty.foreach.blockCategTree.last}</div> <div>{include file="$branche_tpl_path" node=$child last='true'}</div> <div>{else}</div> <div>{include file="$branche_tpl_path" node=$child}</div> <div>{/if}</div> <div>{/foreach}</div> <div><strong> <li class="sub"></strong></div> <div><strong> <a href="{$link->getPageLink('cms.php?id_cms=11')}">{l s='Make-up' mod='tmcategories'}</a></strong></div> <div><strong> </li></strong></div> <div></ul></div> <div></div></div> <div><!-- /TM Categories --></div> <div> </div> <div>After save and refresh the page, nothing happens???</div> <div>Any Ideas what is wrong?</div> <div> </div> <div>Thank you.</div>

Hi Blank, Did you managed to edit the TM Categories and been able to add a CMS page? If so, could you send the way to do it? Thank you. Ricardo

Hi Mike, Did you had any luck on this search? I`m looking for the same thing, need CMS page to be used on menu bar. Please if you found the solution let me know. Regards, Ricado

Hello there, Is this calculation came ok for you? On mine is 2 pences difference? using V 1.4.8.2 Let me know if you got the solution? Thank you