Paypal Image and URLs Not Working

  • Posts: 79
  • Thank you received: 9
  • Hikaserial Standard Hikashop Business Hikashop Essential
7 years 9 months ago #262669

-- url of the page with the problem -- : hatsukoi.co.uk/
-- HikaShop version -- : 3.0.0
-- Joomla version -- : 3.6.5

Hi there,

I have just updated to the latest version of Hikashop and now I have a couple of problems on the payment:

The Paypal header image no longer shows up on the paypal payment page.
The Return URL and Cancel URL no longer seem to work - instead I get this error:
1690 - BIGINT UNSIGNED value is out of range in '(`cristynw_hats`.`jos_hikashop_product`.`product_sales` + -(1))' SQL=UPDATE jos_hikashop_product SET product_sales = product_sales + -1 WHERE product_id IN (82,81)

I have checked that all the page URLs exist:
Cancel URL: hatsukoi.co.uk/empty-basket
Return URL: hatsukoi.co.uk
Paypal Header Image URL: hatsukoi.co.uk/images/hatsukoi-paypal-logo.png

Does anyone have any ideas or can tell me what I'm doing wrong?

Many thanks
Leila

Please Log in or Create an account to join the conversation.

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 9 months ago #262677

Hi,

1. Regarding the PayPal image, HikaShop still properly sends it to PayPal, even on your website:
monosnap.com/file/1ZA3sxtzgwp3X1JgPVkTMr98gzcFrU
If PayPal doesn't use it on its payment gateway, it must have something to do with the settings of your PayPal merchant account. I would recommend contact the PayPal support along with that screenshot link to ask them what to do.

2. Thank you for that feedback. We've added a patch for that on our end. Download again the install package you can get on our website and install it on yours and that will add the fix for that.

Please Log in or Create an account to join the conversation.

  • Posts: 79
  • Thank you received: 9
  • Hikaserial Standard Hikashop Business Hikashop Essential
7 years 9 months ago #263041

Hi there,

Many thanks for your help. I installed the new version but I'm still having some problems.

- My logo is still not being displayed, even though I have made some changes to my Paypal settings. I realise this may not be a Hikashop issue but I have searched for other people with the same problem but can't find anyone complaining of the same thing.

- When you do a full transaction, the return page is fine but

- When you cancel the transaction (before logging into Paypal - the tiny link at the bottom of the payment page), my site still returns a page error. If you refesh the page it loads the correct page but I don't think most people will think to do that.

I do appreciate your hard work and Hikashop is a great application!

Best regards
Leila

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 9 months ago #263043

Hi,

1 - I'm afraid that's not related to our plugin or to our support.

2 - In the file "administrator/components/com_hikashop/classes/order_product.php", please replace

$query = 'UPDATE '.hikashop_table('product').' SET product_sales = GREATEST(0, product_sales - '.(int)$k.') WHERE product_id IN ('.implode(',',$update).')';
By
$query = 'UPDATE '.hikashop_table('product').' SET product_sales = GREATEST(0, CAST(product_sales AS SIGNED) - '.(int)$k.') WHERE product_id IN ('.implode(',',$update).')';
It should avoid the mysql bug regarding the operation made on an unsigned even if the greatest should avoid it.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.078 seconds
Powered by Kunena Forum