PPSA

Thank you, this solved my problem as well while installing 1.7.8.9

Im also battling with this issue with a new install of 1.7.8.9 Did anyone perhaps figure out the how to circumvent this? The code in this GITHUB fix does not fix the issue, it actually breaks the site from loading even if I insert "8.0" as the SQL version https://stackoverflow.com/questions/67934455/an-exception-occured-while-establishing-a-connection-to-figure-out-your-platform

My mails were working perfectly and an update must have disabled them

Funnily enough I am battling with the exact same error with similar PHP settings. I've never had issues before installing Prestashop on my server but now this specific error keeps popping up I wonder if its related to the dependencies it downloads from Prestashop when it is installing the add on modules?

So from what I have experienced, is that the entire orders list is queried even though it only displays 20,30,50,100 of your choosing. So you need to go back to the tables ps_orders and ps_order_payment and sort by the id_currency column/field to make sure there is no other values there besides the value "2" If there is just one pre-existing order with another value that does not tie up to the ps_currency table "2" then it will throw the error you are experiencing.

Have you checked what data is in the Database in tables ps_orders and ps_order_payment under the id_currency column/field

Yeah this was the same issue I had with the Migration Pro Module for past orders which seemed to not align with payment id's The tables that need fixing is ps_cart, ps_orders and ps_order_payment under the id_currency column From what I have found is that the PS1.7 and lower have the currency ID's starting from 0 and PS8 onwards the currency begins with ID 1 So to move the data forwards start from the highest number and work backwards to prevent an overlap in the instruction Change Currency ID 2 to 3, then 1 to 2, then 0 to 1 SQL you can run to change the data is: Update ps_orders SET id_currency = '2' Where id_currency = '1'; Update ps_order_payment SET id_currency = '2' Where id_currency = '1'; Update ps_cart SET id_currency = '2' Where id_currency = '1';

The error is related to the controller not finding the currency in past orders placed You need to go to the ps_orders and ps_order_payment tables and make sure that the id_currency value points to a actual existing currency in ps_currency table If it doesnt, you will need to add those currency's back or reassign them manually to another currency so that the store can tie up

Hi everyone I hope someone smarter than myself can give me guidance on how to ready the site for the upgrade due to the failure I have. The error and activity log is attached during the upgrade process from 1.7.6.7 to 1.7.8.5 (latest) Looks like everything went pear shaped once the TacticianBundle.php was not found Prestashop 1-Click Upgrade Log.xlsx I also would like to know if using the Atrribute Wizard Pro module that overrides and overwrites many of the original Prestashop files would be an ongoing problem after the upgrade. I would like to have a clean installation and retain my orders, customers, products, theme and images without any gremlins transferring over from the current version. Any assistance would be greatly appreciated. https://1drv.ms/x/s!AtlzmbYDoDXBgclEFY4Ljt4widVq1Q?e=cPlddk FYI - Using One Drive as the Prestashop Forum wont upload the XLS doc for some reason

I agree with this as I experienced the same

Same issue here, log in screen keeps on returning and cant disable the cookie check

Use this method, its much better than the first link https://mypresta.eu/prestashop-17/display-available-subcategories.html

Same issue here, did you find a solution to this?

With a bit of investigating it was found that the module we had newly installed to address the hacking caused this issue with TinyMCE If you have Active Design's Antivirus Pro v1.1.2 installed on PS 1.6.1.23 then its either not compatible or has a bug in it Studying the load of the files the AntiVirus Pro calls a js function before loading jquery-1.11.0.min.js which causes the error and everything to break

Hi everyone I am really stumped My site got hacked and some ransomware was installed that demanded x amount of USD to be paid to get my site back Anyways I decided to keep the DB but replace the files for a clean install of 1.6.1.23 and I did the usual manual copy of the img files, modules I use, pdf and mail templates and the config file. So the store is running perfectly and there is no hassles at all at this moment except for the loading of the TinyMCE in the product pages where all I see is the HTML of the short and long descriptions I have already checked in CMS and HomeSlider that TinyMCE works there and there is no problems with it loading. What I have done so far is copy the entire store again except for the config, mail, pdf, install, modules into the root and replace any altered or corrupt files I have also added Vekia's Extended tinyMCE editor code found below and that also did not resolve the issue https://www.prestashop.com/forums/topic/318425-tutorial-tinymce-rich-text-editor-extended-version/ The only module I can imagine would be causing this issue is Attribute Wizard Pro but I have already replaced all its overrides with the original files I have these errors in Google Chrome Console but I do not know how to diagnose what is the cause of the issue based on what it is giving errors about Unfortunately this goes beyond my capabilities in fault finding This is the errors it is throwing on the Google Chrome Console jquery.autocomplete.js:758 Uncaught ReferenceError: jQuery is not defined at jquery.autocomplete.js:758 (anonymous) @ jquery.autocomplete.js:758 products.js:1028 Uncaught TypeError: $(...).autocomplete is not a function at Object.bindAvailableForOrder (products.js:1028) at onReady (products.js:1183) at ProductTabsManager.onLoad (products.js:87) at ProductTabsManager.init (products.js:53) at HTMLDocument.<anonymous> (products.js:1888) at j (jquery-1.11.0.min.js:2) at Object.fireWith [as resolveWith] (jquery-1.11.0.min.js:2) at Function.ready (jquery-1.11.0.min.js:2) at HTMLDocument.K (jquery-1.11.0.min.js:2) bindAvailableForOrder @ products.js:1028 onReady @ products.js:1183 ProductTabsManager.onLoad @ products.js:87 ProductTabsManager.init @ products.js:53 (anonymous) @ products.js:1888 j @ jquery-1.11.0.min.js:2 fireWith @ jquery-1.11.0.min.js:2 ready @ jquery-1.11.0.min.js:2 K @ jquery-1.11.0.min.js:2 index.php?controller=AdminProducts&id_product=40&updateproduct&token=4d674e289f80bdc81a6e35d1b139da8d:1 [DOM] Found 4 elements with non-unique id #product_form_submit_btn: (More info: https://goo.gl/9p2vKq) <button id="product_form_submit_btn" type="submit" name="submitAddproduct" class="btn btn-default pull-right" disabled="disabled">…</button> <button id="product_form_submit_btn" type="submit" name="submitAddproductAndStay" class="btn btn-default pull-right" disabled="disabled">…</button> <button id="product_form_submit_btn" type="submit" name="submitAddproduct" class="btn btn-default pull-right" disabled="disabled">…</button> <button id="product_form_submit_btn" type="submit" name="submitAddproductAndStay" class="btn btn-default pull-right" disabled="disabled">…</button> en-default-small_default.jpg:1 GET https://www.performanceproducts.co.za/img/p/en-default-small_default.jpg 404 Image (async) buildFragment @ jquery-1.11.0.min.js:3 domManip @ jquery-1.11.0.min.js:3 append @ jquery-1.11.0.min.js:3 (anonymous) @ jquery-1.11.0.min.js:3 n.access @ jquery-1.11.0.min.js:3 html @ jquery-1.11.0.min.js:3 success @ products.js:127 j @ jquery-1.11.0.min.js:2 fireWith @ jquery-1.11.0.min.js:2 x @ jquery-1.11.0.min.js:4 b @ jquery-1.11.0.min.js:4 XMLHttpRequest.send (async) send @ jquery-1.11.0.min.js:4 ajax @ jquery-1.11.0.min.js:4 ProductTabsManager.display @ products.js:117 ProductTabsManager.displayBulk @ products.js:166 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ index.php?controller=AdminProducts&id_product=40&updateproduct&token=4d674e289f80bdc81a6e35d1b139da8d:1105 dispatch @ jquery-1.11.0.min.js:3 r.handle @ jquery-1.11.0.min.js:3 load (async) add @ jquery-1.11.0.min.js:3 e.event.add @ jquery-migrate-1.2.1.min.js:2 (anonymous) @ jquery-1.11.0.min.js:3 each @ jquery-1.11.0.min.js:2 each @ jquery-1.11.0.min.js:2 on @ jquery-1.11.0.min.js:3 (anonymous) @ bootstrap.min.js:6 (anonymous) @ bootstrap.min.js:6 products.js:794 Uncaught TypeError: $(...).autocomplete is not a function at Object.initAccessoriesAutocomplete (products.js:794) at HTMLDivElement.onReady (products.js:913) at HTMLDivElement.dispatch (jquery-1.11.0.min.js:3) at HTMLDivElement.r.handle (jquery-1.11.0.min.js:3) at Object.trigger (jquery-1.11.0.min.js:3) at Object.e.event.trigger (jquery-migrate-1.2.1.min.js:2) at HTMLDivElement.<anonymous> (jquery-1.11.0.min.js:3) at Function.each (jquery-1.11.0.min.js:2) at e.fn.init.each (jquery-1.11.0.min.js:2) at e.fn.init.trigger (jquery-1.11.0.min.js:3) initAccessoriesAutocomplete @ products.js:794 onReady @ products.js:913 dispatch @ jquery-1.11.0.min.js:3 r.handle @ jquery-1.11.0.min.js:3 trigger @ jquery-1.11.0.min.js:3 e.event.trigger @ jquery-migrate-1.2.1.min.js:2 (anonymous) @ jquery-1.11.0.min.js:3 each @ jquery-1.11.0.min.js:2 each @ jquery-1.11.0.min.js:2 trigger @ jquery-1.11.0.min.js:3 success @ products.js:137 j @ jquery-1.11.0.min.js:2 fireWith @ jquery-1.11.0.min.js:2 x @ jquery-1.11.0.min.js:4 b @ jquery-1.11.0.min.js:4 XMLHttpRequest.send (async) send @ jquery-1.11.0.min.js:4 ajax @ jquery-1.11.0.min.js:4 ProductTabsManager.display @ products.js:117 ProductTabsManager.displayBulk @ products.js:166 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ products.js:208 setTimeout (async) ProductTabsManager.displayBulk @ products.js:205 (anonymous) @ index.php?controller=AdminProducts&id_product=40&updateproduct&token=4d674e289f80bdc81a6e35d1b139da8d:1105 dispatch @ jquery-1.11.0.min.js:3 r.handle @ jquery-1.11.0.min.js:3 load (async) add @ jquery-1.11.0.min.js:3 e.event.add @ jquery-migrate-1.2.1.min.js:2 (anonymous) @ jquery-1.11.0.min.js:3 each @ jquery-1.11.0.min.js:2 each @ jquery-1.11.0.min.js:2 on @ jquery-1.11.0.min.js:3 (anonymous) @ bootstrap.min.js:6 (anonymous) @ bootstrap.min.js:6

You are 1000% correct in saying this I battled for days thinking its something on my server I disabled Mail Chimp module and boom, its working like normal, imports within 10-15 seconds

Has anyone found a solution for this in Prestashop 1.7?

I have also been searching everywhere for an answer for this The same thing you have done is what I have done on 1.7.4.2 and no change even with clearing the cache.

The solution proposed by "zmacedoni" solved the same issue I was experiencing with "cancelling" an order in Prestashop 1.6.1.3! Thank you for the support!