OllyL

When you uninstalled the Module did you also check to remove all settings and data? I'm pretty sure this was important too and it only takes 5 seconds to put your PayPal login details back in. I have checked my IPN.php file and I'm pretty sure that I didn't make any modifications to it (or if I did these were overwritten by the newer versions). We are running version 3.8.0 of the PayPal module without errors so you could try rolling back to this version and see if it works better. You could also check your PayPal IPN settings and make sure you've not got anything weird configured in there. Potentially you could also try setting the IPN url in PayPal directly to your ipn.php file to ensure that it's calling the right address after each transaction but this should be handled automatically in the module. Sorry I can't be more help, if I don't write the answer in a forum thread then it usually means that I was doing something stupid so I don't think the solution is something complicated! Cheers

Hi Angela, From what I can remember the upgrade did in fact fix it but I had to do a bit of purging before it took hold: Make sure to clear your smarty cache under the performance options Make sure to un-install the old module in the Modules dashboard, don't just copy the files Once uninstalled trash out the old module directory completely and do a fresh install of the updated module Ensure that you have the PayPal Europe version of the module not the US one Potentially I did have to make a change to the module script but I'm pretty sure if I had then I would've posted about it here, If you're having no luck with install then I'll check my copy of ipn.php and see if I made a hack fix.

No, I think you would get a different error if it was data types, you error very specifically says there is a column mismatch

Hi Coniglio, I would guess that the Prestashop version you are migrating to/from has a different table schema on one or more of the tables. I would recommend upgrading the old deployment of Prestashop (in a test environment) to match your target version and then try the query again.

I upgraded the PayPal module to 3.8.0 and the problem has been fixed EDIT - No I was wrong, this has not fixed the problem, still getting errors

Hi There, The PayPal module appears to be working correctly but we are getting these errors appearing in Apache whenever a payment is made: PHP Fatal error: Call to a member function getSummaryDetails() on a non-object in /var/www/prestashop/modules/paypal/ipn.php on line 156 Anyone else experiencing this and/or know of a solution? Many thnaks in advance, Olly

Hi All, I have managed to fix this. I was on the phone with our hosting company yesterday working on another issue and stumbled upon a solution. Basically the code block above is along the right lines but is not completely right. Putting this code block at the top of settings.php seems to work: /* RACKSPACE SSL FIX */ if ( isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && ($_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https' || $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'HTTPS' )) { $_SERVER['SSL'] = 'on'; $_SERVER['SERVER_PORT'] = 443; } else { $_SERVER['SSL'] = 'off'; $_SERVER['SERVER_PORT'] = 80; } The basic principal is that the load balancer receives HTTPS traffic on port 443 but then forwards it as regular HTTP traffic to the server on port 80. Obviously this port redirection plays havoc with Prestashop as all attempts it makes to redirect to port 443/Https keep coming back on port 80 and you get redirection loops occuring. The code above simply picks up a header flag from the load balancer (X-Forwarded-Proto) and if enabled with switches on all the usual flags for SSL so Presta is tricked into thinking a regular HTTPS request has occured. I have tested on 1.6 and is working correctly

[Edit: sorry this forum keeps losing half of what I type, have edited back in missing bits as best I can!] Hi There, We've got a Prestashop hosted on Rackspace with two front-end web servers sat behind a load balancer. The shop is here: http://ratchetclothing.co.uk/ My clients want to use HTTPS / SSL for the checkout so we can have the padlock in the browser and to boost our customer's confidence in us, help secure sales etc. I purchased an SSL Certificate and set this up on our load balancer and It's working correctly I think. However when I go into admin to enable the SSL instead of the checkbox I get a link popping up which says: "Please click here to enable SSL before continuing" Even when viewing admin via https/ssl I could not remove the link but after some Googling I discovered one hack which got around it by adding some code to the top of config/settings.inc: if( isset($_SERVER['HTTP_X_FORWARDED_PROTO']) ) { $_SERVER['SSL'] = 'on'; $_SERVER['SERVER_PORT'] = 443; } This allows me to enable SSL in back office but once enabled my homepage gets stuck in a redirect loop permanently linking back to the HTTP site which kills the browser. I can fix the loop by switching on "Enable SSL on all pages" but once I do this I get other weird bugs appearing and the site doesn't seem 100% stable. Has anyone managed to get Prestashop working with SSL on Rackspace or when behind a load balancer and if so could you help me out? Thanks very much in advance, Olly

Hi There, We've just upgraded our shop to 1.6 and we're having problems with statistics. When you click the link on admin it just sits forever and won't load the page. I'm not sure if it's a particular query in there (cross join or something) but it means the page just times out before we can see anything. I download the database optimizer module to clean up some other tables in case this was the problem (it cleaned about 20 million connections) but it doesn't seem to have helped. Anyone got any ideas? Does anyone know the default report which is loaded when you first click stats? Thanks, Olly

Okay I understand. Thanks I will try this and reply later

The problem isn't accessing the site, it's the redirection. I am being redirected constantly to the shop Url instead of our admin Url. Can I disable this redirection? Also I am struggling to access admin through HTTP instead of HTTPS when we have SSL enabled for our store. Can this be disabled for admin? Thanks

Hi There, We have a Prestashop deployment running across 4 cloud servers (1xDB, 2xWeb, 1xLoad Balancer). The shop is on the root domain (e.g. http://myprestashop.com) but the admin site is accessed through a sub domain (e.g. http://admin.myprestashop.com). The reason for this being that we had an issue with big requests (like generating a lot of invoices) timing out when accessing the admin are through the load balancer so the sub domain points directly at one of the web server instances (i.e. it goes around the load balancer). As a further complication we also have SSL running on the load balancer with requests then being forwarded via port 80 to the front-end web servers. SSL mode is enabled on the back-end despite requests being forwarded via port 80 as this was the only way I could get the site to work. "Use SSL for all requests" is also enabled for the same reason. With me so far? What is a problem is accessing the admin site. First off, Prestashop doesn't like this being on a different (sub)domain from the shop, so immediately it is trying to redirect me back to http://myprestashop.com So to break it down: http://admin.myprestashop.com/admin1234 - is the url I want to be able to use http://myprestashop.com/admin1234 - it sometimes tries to forward me to which is no use because long requests don't work through this url https://myprestashop.com/admin1234 https://admin.myprestashop.com/admin1234 - Even if I hack the correct domain back into the address bar it still tries to send me here a lot which is no good because SSL is not enabled on the web servers themselves Can anyone help me out of this quandary? Is there anything I can do with my .htaccess file to ensure that all attempts to access admin are forwarded to the correct URL? Thanks very very much in advance!! Cheers, Olly

Has anyone found a fix? Just updating our shop to 1.6 and this problem has appeared. Thanks!

FYI Not sure if this is the best way but have come up with a database query for doing this. Note that this is ONLY RECOMMENDED if you are migrating and old->new database as my post above and not recommended for copying data between two different shops or different platforms (it relies on the unique identifiers being the same). Also this script does not include the customer_messages table(s) as these have been modified in version 1.6 and since they are not so important for us I decided to leave them out. I should add that "live" is the new, target database. "backup_211014" is the existing database containing the new records. @startid and @endid should be amended to include the start/end record that you wish to import in each case (either id_order, id_customer, or newsletter sub id). Hope this helps someone, or if a [spam-filter] sees this post please let me know of problems or better solutions to this problem as I've not performed the migration yet (still exploring alternate options), Cheers, ------------------------------ /*CUSTOMER MIGRATION SCRIPT */ BEGIN; SET @startID = 38535; SET @endID = 38536; INSERT INTO live.`ps_customer` SELECT * FROM backup_211014.`ps_customer` WHERE id_customer >= @startID AND id_customer <= @endID AND id_customer NOT IN (SELECT id_customer FROM live.`ps_customer` WHERE id_customer >= @startID AND id_customer <= @endID) ORDER BY id_customer ASC; INSERT INTO live.`ps_address` SELECT * FROM backup_211014.`ps_address` WHERE id_customer >= @startID AND id_customer <= @endID AND id_customer NOT IN (SELECT id_customer FROM live.`ps_address` WHERE id_customer >= @startID AND id_customer <= @endID) ORDER BY id_customer ASC; INSERT INTO live.`ps_paypal_customer` SELECT * FROM backup_211014.`ps_paypal_customer` WHERE id_customer >= @startID AND id_customer <= @endID AND id_customer NOT IN (SELECT id_customer FROM live.`ps_paypal_customer` WHERE id_customer >= @startID AND id_customer <= @endID) ORDER BY id_customer ASC; COMMIT; /*ORDER MIGRATION SCRIPT */ BEGIN; SET @startID = 36892; SET @endID = 36892; INSERT INTO live.`ps_order_slip_detail` SELECT backup_211014.`ps_order_slip_detail`.* FROM backup_211014.`ps_order_slip_detail` INNER JOIN backup_211014.`ps_order_slip` ON backup_211014.`ps_order_slip_detail`.id_order_slip = backup_211014.`ps_order_slip`.`id_order_slip` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_slip` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY backup_211014.`ps_order_slip_detail`.`id_order_detail` ASC; INSERT INTO live.`ps_order_detail_tax` SELECT backup_211014.`ps_order_detail_tax`.* FROM backup_211014.`ps_order_detail_tax` INNER JOIN backup_211014.`ps_order_detail` ON backup_211014.`ps_order_detail_tax`.`id_order_detail` = backup_211014.`ps_order_detail`.`id_order_detail` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_detail` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY backup_211014.`ps_order_detail`.`id_order_detail` ASC; INSERT INTO live.`ps_order_payment` SELECT backup_211014.`ps_order_payment`.* FROM backup_211014.`ps_order_payment` INNER JOIN backup_211014.`ps_order_invoice_payment` ON backup_211014.`ps_order_invoice_payment`.`id_order_payment` = backup_211014.`ps_order_payment`.`id_order_payment` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_invoice_payment` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY backup_211014.`ps_order_payment`.`id_order_payment` ASC; INSERT INTO live.`ps_order_return_detail` SELECT backup_211014.`ps_order_return_detail`.* FROM backup_211014.`ps_order_return_detail` INNER JOIN backup_211014.`ps_order_return` ON backup_211014.`ps_order_return_detail`.`id_order_return` = backup_211014.`ps_order_return`.`id_order_return` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_return` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY backup_211014.`ps_order_return_detail`.`id_order_return` ASC; INSERT INTO live.`ps_orders` SELECT * FROM backup_211014.`ps_orders` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_orders` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_carrier` SELECT * FROM backup_211014.`ps_order_carrier` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_carrier` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_cart_rule` SELECT * FROM backup_211014.`ps_order_cart_rule` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_cart_rule` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_detail` SELECT * FROM backup_211014.`ps_order_detail` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_detail` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_history` SELECT * FROM backup_211014.`ps_order_history` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_history` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_invoice` SELECT * FROM backup_211014.`ps_order_invoice` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_invoice` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_invoice_payment` SELECT * FROM backup_211014.`ps_order_invoice_payment` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_invoice_payment` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_return` SELECT * FROM backup_211014.`ps_order_return` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_return` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_order_slip` SELECT * FROM backup_211014.`ps_order_slip` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_order_slip` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; INSERT INTO live.`ps_paypal_order` SELECT * FROM backup_211014.`ps_paypal_order` WHERE id_order >= @startID AND id_order <= @endID AND id_order NOT IN (SELECT id_order FROM live.`ps_paypal_order` WHERE id_order >= @startID AND id_order <= @endID) ORDER BY id_order ASC; COMMIT; /* MIGRATE NEWS LETTER SUBS */ BEGIN; SET @startID = 793; SET @endID = 793; INSERT INTO live.`ps_newsletter` SELECT * FROM backup_211014.`ps_newsletter` WHERE id >= @startID AND id <= @endID AND id NOT IN (SELECT id FROM live.`ps_newsletter` WHERE id >= @startID AND id <= @endID) ORDER BY id ASC; COMMIT;

Hi There, We're in the process of building an snazzy new version of our store using the latest 1.6 Prestashop platform which will soon be replacing our existing store running on 1.5. The new version of the store was built using a system image of the live site (which was then upgraded and modified) and so most of our data is already correct however we will need to migrate all new customers and orders over from the current site which have come in since the work began. What is the best way to do this? I have taken a look through the modules catalogue but I could not see anything for migrating orders, only customers and products. We don't use stock management or any custom plug-ins for products/suppliers etc.so it literally is just the order and customer information we need and nothing more. Does anyone know of a way to do this? Thanks very much, Olly