PAYPAL NOT WORKING CORRECTLY

[hahygiene]

Hi guys

 

Please can I get some assistance into why Paypal will not redirect back to my prestashop site.. It lets users log in via the external page, processes payment fine and then nothing.. just a loading white screen.. Money shows in our paypal balance fine but our site won't recognise payment or the order and without checking paypal we have no clue that a sale has taken place.

 

I turned on IPN in paypal to see if it was working and was getting http 200 in the paypal logs so that looked good but after reading into the module was told that IPN was not needed so turned it off again.

 

Checking logs in PS. I am getting PaymentModule::validateOrder - Order Status cannot be loaded

 

Using PS 1.6.1.0 and PP 3.10.1 european

 

Please can somebody help 

[hahygiene]

Just done a debug and getting the following error

 

Fatal error: Uncaught Key 'id_product_2' doesn't exist in table 'ps_specific_price'

            SELECT *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 0, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 453, 32, 0)) AS `score`
                FROM `ps_specific_price` USE INDEX (id_product_2)
                WHERE `id_product` IN (0, 49)
                AND `id_product_attribute` IN (0, 0)
                AND `id_shop` IN (0, 1)
                AND `id_currency` IN (0, 1)
                AND `id_country` IN (0, 0)
                AND `id_group` IN (0, 1)
                AND `id_customer` IN (0, 453)
                AND
                (
                    (`from` = '0000-00-00 00:00:00' OR '2015-08-06 10:49:00' >= `from`)
                    AND
                    (`to` = '0000-00-00 00:00:00' OR '2015-08-06 10:49:00' <= `to`)
                )
                AND id_cart IN (0, 918)
                AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1thrown in /home/sites/hahygienesupplies.co.uk/public_html/classes/db/Db.php on line 765