Post by cuppyz » Mon Jul 14, 2014 2:55 am

I just installed VQMOD 2.4.1 in my open cart 1.5.6.4.... then got error like this :

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/80/9172680/html/szdreamaker/vqmod/vqcache/vq2-catalog_controller_common_footer.php on line 25Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/80/9172680/html/szdreamaker/vqmod/vqcache/vq2-catalog_controller_common_footer.php on line 25Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/content/80/9172680/html/szdreamaker/vqmod/vqcache/vq2-catalog_controller_common_footer.php on line 25

Anybody can help show the way to fix it

Newbie

Posts

Joined
Mon Jul 14, 2014 2:39 am

Post by Cue4cheap » Mon Jul 14, 2014 4:26 am

cuppyz wrote:I just installed VQMOD 2.4.1 in my open cart 1.5.6.4.... then got error like this :

Anybody can help show the way to fix it
This is not a bug in 1.5.6.4..... Wrong place to post.

Here is the answer in the other post you made: http://forum.opencart.com/viewtopic.php?f=161&t=128085

Mike

cue4cheap not cheap quality


Active Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by r357 » Mon Jul 14, 2014 5:23 pm

I use a clear version opencart 1.5.6.4 and a paypal sandbox.

My test product has 200 USD value and 10 mounts x 20USD profile
When I test it... In my opencart dashboard I see an order with status : Complete
When I go to Sales>Recurring profiles I see a status: Pending
When I go to my sandbox merchant acc I see - PayPal balance 200USD
When I go to the payer sandbox acc I see missing 200USD

Here is a paypal debug from opencart error log

Code: Select all

2014-07-14 0:56:13 - PayPal Express debug (Call data): {"METHOD":"SetExpressCheckout","MAXAMT":"250.00","RETURNURL":"http:\/\/btc-bazaar.com\/index.php?route=payment\/pp_express\/checkoutReturn","CANCELURL":"http:\/\/btc-bazaar.com\/index.php?route=checkout\/checkout","REQCONFIRMSHIPPING":0,"NOSHIPPING":1,"LOCALECODE":"EN","LANDINGPAGE":"Login","HDRIMG":null,"HDRBORDERCOLOR":"","HDRBACKCOLOR":"","PAYFLOWCOLOR":"","CHANNELTYPE":"Merchant","ALLOWNOTE":"0","PAYMENTREQUEST_0_SHIPPINGAMT":"","PAYMENTREQUEST_0_CURRENCYCODE":"USD","PAYMENTREQUEST_0_PAYMENTACTION":"Sale","L_PAYMENTREQUEST_0_DESC0":false,"L_PAYMENTREQUEST_0_NAME0":"Apple Cinema 30"","L_PAYMENTREQUEST_0_NUMBER0":"Product 15","L_PAYMENTREQUEST_0_AMT0":"200.00","L_PAYMENTREQUEST_0_QTY0":1,"L_PAYMENTREQUEST_0_ITEMURL0":"http:\/\/btc-bazaar.com\/index.php?route=product\/product&product_id=42","L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0":"12.50","L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0":"kg","L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0":"1.00000000","L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0":"2.00000000","L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0":"3.00000000","L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0":"cm","PAYMENTREQUEST_0_ITEMAMT":"200.00","PAYMENTREQUEST_0_AMT":"200.00","L_BILLINGTYPE0":"RecurringPayments","L_BILLINGAGREEMENTDESCRIPTION0":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:15 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&TIMESTAMP=2014%2d07%2d14T00%3a56%3a13Z&CORRELATIONID=632c28deac7a5&ACK=Success&VERSION=65%2e2&BUILD=11843215"
2014-07-14 0:56:39 - PayPal Express debug (Call data): {"METHOD":"GetExpressCheckoutDetails","TOKEN":"EC-2NL13084ME6423432"}
2014-07-14 0:56:40 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&BILLINGAGREEMENTACCEPTEDSTATUS=1&CHECKOUTSTATUS=PaymentActionNotInitiated&TIMESTAMP=2014%2d07%2d14T00%3a56%3a39Z&CORRELATIONID=66e295ed29b36&ACK=Success&VERSION=65%2e2&BUILD=11843215&EMAIL=r357bg%40gmail%2ecom&PAYERID=GAFDYKGARZNEJ&PAYERSTATUS=verified&FIRSTNAME=Delene&LASTNAME=Sch%c3%a4tti&COUNTRYCODE=US&CURRENCYCODE=USD&AMT=200%2e00&ITEMAMT=200%2e00&SHIPPINGAMT=0%2e00&HANDLINGAMT=0%2e00&TAXAMT=0%2e00&INSURANCEAMT=0%2e00&SHIPDISCAMT=0%2e00&L_NAME0=Apple%20Cinema%2030%26quot%3b&L_NUMBER0=Product%2015&L_QTY0=1&L_TAXAMT0=0%2e00&L_AMT0=200%2e00&L_DESC0=0&L_ITEMWEIGHTVALUE0=%20%2012%2e50000&L_ITEMWEIGHTUNIT0=kg&L_ITEMLENGTHVALUE0=%20%20%201%2e00000&L_ITEMLENGTHUNIT0=cm&L_ITEMWIDTHVALUE0=%20%20%202%2e00000&L_ITEMWIDTHUNIT0=cm&L_ITEMHEIGHTVALUE0=%20%20%203%2e00000&L_ITEMHEIGHTUNIT0=cm&PAYMENTREQUEST_0_CURRENCYCODE=USD&PAYMENTREQUEST_0_AMT=200%2e00&PAYMENTREQUEST_0_ITEMAMT=200%2e00&PAYMENTREQUEST_0_SHIPPINGAMT=0%2e00&PAYMENTREQUEST_0_HANDLINGAMT=0%2e00&PAYMENTREQUEST_0_TAXAMT=0%2e00&PAYMENTREQUEST_0_INSURANCEAMT=0%2e00&PAYMENTREQUEST_0_SHIPDISCAMT=0%2e00&PAYMENTREQUEST_0_INSURANCEOPTIONOFFERED=false&L_PAYMENTREQUEST_0_NAME0=Apple%20Cinema%2030%26quot%3b&L_PAYMENTREQUEST_0_NUMBER0=Product%2015&L_PAYMENTREQUEST_0_QTY0=1&L_PAYMENTREQUEST_0_TAXAMT0=0%2e00&L_PAYMENTREQUEST_0_AMT0=200%2e00&L_PAYMENTREQUEST_0_DESC0=0&L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0=%20%2012%2e50000&L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0=kg&L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0=%20%20%201%2e00000&L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0=cm&L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0=%20%20%202%2e00000&L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0=cm&L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0=%20%20%203%2e00000&L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0=cm&PAYMENTREQUESTINFO_0_ERRORCODE=0"
2014-07-14 0:56:40 - PayPal Express debug (Call data): {"TOKEN":"EC-2NL13084ME6423432","PAYERID":"GAFDYKGARZNEJ","METHOD":"DoExpressCheckoutPayment","PAYMENTREQUEST_0_NOTIFYURL":"http:\/\/btc-bazaar.com\/index.php?route=payment\/pp_express\/ipn","RETURNFMFDETAILS":1,"PAYMENTREQUEST_0_SHIPPINGAMT":"","PAYMENTREQUEST_0_CURRENCYCODE":"USD","PAYMENTREQUEST_0_PAYMENTACTION":"Sale","L_PAYMENTREQUEST_0_DESC0":false,"L_PAYMENTREQUEST_0_NAME0":"Apple Cinema 30"","L_PAYMENTREQUEST_0_NUMBER0":"Product 15","L_PAYMENTREQUEST_0_AMT0":"200.00","L_PAYMENTREQUEST_0_QTY0":1,"L_PAYMENTREQUEST_0_ITEMURL0":"http:\/\/btc-bazaar.com\/index.php?route=product\/product&product_id=42","L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0":"12.50","L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0":"kg","L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0":"1.00000000","L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0":"2.00000000","L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0":"3.00000000","L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0":"cm","PAYMENTREQUEST_0_ITEMAMT":"200.00","PAYMENTREQUEST_0_AMT":"200.00","L_BILLINGTYPE0":"RecurringPayments","L_BILLINGAGREEMENTDESCRIPTION0":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:43 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&SUCCESSPAGEREDIRECTREQUESTED=false&TIMESTAMP=2014%2d07%2d14T00%3a56%3a42Z&CORRELATIONID=661bec006990b&ACK=Success&VERSION=65%2e2&BUILD=11843215&INSURANCEOPTIONSELECTED=false&SHIPPINGOPTIONISDEFAULT=false&PAYMENTINFO_0_TRANSACTIONID=9WM10836AJ2272512&PAYMENTINFO_0_TRANSACTIONTYPE=cart&PAYMENTINFO_0_PAYMENTTYPE=instant&PAYMENTINFO_0_ORDERTIME=2014%2d07%2d14T00%3a56%3a41Z&PAYMENTINFO_0_AMT=200%2e00&PAYMENTINFO_0_FEEAMT=6%2e10&PAYMENTINFO_0_TAXAMT=0%2e00&PAYMENTINFO_0_CURRENCYCODE=USD&PAYMENTINFO_0_PAYMENTSTATUS=Completed&PAYMENTINFO_0_PENDINGREASON=None&PAYMENTINFO_0_REASONCODE=None&PAYMENTINFO_0_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_0_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_0_ERRORCODE=0&PAYMENTINFO_0_ACK=Success"
2014-07-14 0:56:43 - PayPal Express debug (Call data): {"METHOD":"CreateRecurringPaymentsProfile","TOKEN":"EC-2NL13084ME6423432","PROFILESTARTDATE":"2014-07-14T01:01:43Z","BILLINGPERIOD":"Month","BILLINGFREQUENCY":"1","TOTALBILLINGCYCLES":"10","AMT":20,"CURRENCYCODE":"USD","PROFILEREFERENCE":3,"DESC":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:45 - PayPal Express debug (Result): "PROFILEID=I%2d8D8AUTMS8SUC&PROFILESTATUS=ActiveProfile&TIMESTAMP=2014%2d07%2d14T00%3a56%3a44Z&CORRELATIONID=c2103f7f961e6&ACK=Success&VERSION=65%2e2&BUILD=11843215"
2014-07-14 0:56:49 - PayPal Express debug (IPN data): {"request":"cmd=_notify-validate&mc_gross=200.00&protection_eligibility=Ineligible&item_number1=Product+15&payer_id=GAFDYKGARZNEJ&tax=0.00&payment_date=17%3A56%3A41+Jul+13%2C+2014+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=Delene&mc_fee=6.10¬ify_version=3.8&custom=&payer_status=verified&num_cart_items=1&mc_handling1=0.00&verify_sign=AOwxKIlnVFEAwVrLIuSb2g-xODWhAk1XW9KQWvekORa47tLs9HLaeyEf&payer_email=r357bg%40gmail.com&mc_shipping1=0.00&tax1=0.00&txn_id=9WM10836AJ2272512&payment_type=instant&last_name=&item_name1=Apple+Cinema+30%26amp%3Bquot%3B&receiver_email=paypal-facilitator%40vitalamin.ch&payment_fee=6.10&quantity1=1&receiver_id=YNK26S2GGRCPS&txn_type=cart&mc_gross_1=200.00&mc_currency=USD&residence_country=US&test_ipn=1&transaction_subject=20+USD+every+1+month+for+10+payments0&payment_gross=200.00&ipn_track_id=661bec006990b","response":"INVALID"}
2014-07-14 0:56:49 - PayPal Express debug (IPN fail): ["IPN was invalid"]
I cant find what is wrong here. Can someone give me a clue?

When I add the product to the shopping cart I see

Recurring item $20.00 every 1 month(s) for 10 payment(s)
Unit Price 200USD
Total 200USD

I thought it will charge the buyer 20USD now and 9 x 20USD later, not 200USD now.

Newbie

Posts

Joined
Tue Oct 02, 2012 12:36 am

Post by mcurtis » Thu Jul 17, 2014 2:58 am

Hi,

When trying to access the admin panel i am getting this. Any ideas?

Fatal error: print_r(): Cannot use output buffering in output buffering display handlers in /public_html/mywebsite/system/library/log.php on line 14

Thanks in advance!

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by Johanb » Wed Jul 30, 2014 9:45 pm

fickena wrote:I have a clean install of 1.5.6.4 and have experienced problems with adding anything to "information" pages. If you add media or links to an information page you get the "image properties" window up. You click URL to select the file and the old image manager comes up. Select the image. However this is as far as you can go and it all hangs.

Same thing happens when trying to add a link to info pages.

I am having to write everything in HTML and copy and paste instead.

Can someone else try and see if they have similar problems so I can work out where the issue lies.
There is a problem adding images and links in the rich-text box if you are using Windows Explorer 11, just switch to either Explorer 10 and Chrome and it should work fine.

Newbie

Posts

Joined
Fri Jul 25, 2014 2:07 pm

Post by swguy » Sun Aug 03, 2014 12:35 am

Just adding a link out to this post which reported and fixed a bug in Option value names in admin:

http://forum.opencart.com/viewtopic.php?f=161&t=128413

Better Together: Buy one product, get another at a discount.
Discount Chooser: Buy a group of products, get another group at a discount.


User avatar
New member

Posts

Joined
Mon Apr 15, 2013 4:13 am

Post by TAC » Thu Aug 14, 2014 4:57 pm

I cannot get 1.5.6.4 to install properly. No idea if it is a bug or not.

Details are in this post http://forum.opencart.com/viewtopic.php?f=19&t=129516

Thanks :)

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by snakehult » Sun Aug 24, 2014 6:47 pm

fresh install 1.5.6.4.

1. customer create account.
2. in admin I add $100 in transaction for store credit.
3 .customer buy 1 item and in checkout use his credit (no choice) and total is calculated with -$100

Customer mail/phone and want an extra product to his order.
4.I login in to admin go to order and add 1 product.
When save and order recalculated store credit is lost. and total is full price. no store credit.

But in customers transactionhistory the credit is withdrawn and connected to order id.

Storecredit lost.

Markus Edholm
ME fix IT AB
Facebook
mefixit.se


New member

Posts

Joined
Tue Jan 15, 2013 7:28 pm

Post by redhatusr » Thu Sep 11, 2014 6:13 pm

This is my first try to meet opencart and leave drupal commerce behind. I don't know what information to include about this problem so I include everything I can think

1. install clean Opencart 1.5.4.6
unzip opencart-1.5.6.4.zip
mysql -uroot -p -e 'create database opencart1;'
chown apache:apache opencart1 * -R
mv opencart1/config-dist.php opencart1/config.php
mv opencart1/admin/config-dist.php opencart1/admin/config.php
Database Driver: [MySQL] i also try with [MySQLi]
rm opencart1/install/ -rf

2. login with admin as normal

3. create 2 users for both groups 'Top Administrator' and 'Demonstration' with status [Enable]

4. Try to login with users account but i get the error

Warning: No match for E-Mail Address and/or Password.

my server configuration:

[root@centos www]# cat /etc/centos-release
CentOS release 6.5 (Final)

[root@centos www]# rpm -aq | grep http
httpd-2.2.15-31.el6.centos.x86_64
httpd-tools-2.2.15-31.el6.centos.x86_64
httpd-devel-2.2.15-31.el6.centos.x86_64

[root@centos www]# rpm -aq | grep mysql
php-mysql-5.3.3-27.el6_5.1.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.x86_64

[root@centos www]# rpm -aq | grep php
php-mysql-5.3.3-27.el6_5.1.x86_64
php-gd-5.3.3-27.el6_5.1.x86_64
php-pear-1.9.4-4.el6.noarch
php-pdo-5.3.3-27.el6_5.1.x86_64
php-cli-5.3.3-27.el6_5.1.x86_64
php-devel-5.3.3-27.el6_5.1.x86_64
php-common-5.3.3-27.el6_5.1.x86_64
php-mbstring-5.3.3-27.el6_5.1.x86_64
php-mcrypt-5.3.3-3.el6.x86_64
php-5.3.3-27.el6_5.1.x86_64
php-xml-5.3.3-27.el6_5.1.x86_64

Newbie

Posts

Joined
Thu Sep 11, 2014 5:37 pm

Post by ForgetfulGuru » Thu Sep 25, 2014 4:47 pm

Good morning, You wonderful and helpful people of OpenCart Forum World.
I have an error showing up in my install of OpenCart 1.5.6.4 and, having ignored it since install, would lkie to try and find an answer to it.
The error log reports this one and only error every time I access the Dashboard;

Code: Select all

2014-09-25 8:08:52 - PHP Notice:  Undefined index: play in /home/*******/public_html/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 144
I have looked up the corresponding file and got this

Code: Select all

<?php if($openbay_markets['play'] == 1){ ?>
While I appreciate that OpenBay is not OpenCart, it did come as part of the default instal this time around (I think)
Is anyone else getting this error? Is there a fix for it? Or should I be contacting OpenBay developers?

Thanks very much ( in advance ) for your input and help as I am sure you will be forthcoming in helping me resolve this issue

Life is for the taking. It's everything else you need to pay for.
Anne Makes Lovely Candles


User avatar
New member

Posts

Joined
Sun Jul 22, 2012 11:12 pm
Location - Left hand corner as you enter the room, better feng shui.

Post by rynbryn » Tue Sep 30, 2014 3:16 pm

When I try to add a product on SALES > ORDER > PRODUCT tab page, it says, "Order totals has been successfully re-calculated!" but no products are added. What seems to be the problem? I've tried to overwrite file related to this pages but nothing happens. :(

Attachments

manual-order.JPG

Opencart Manual Order - manual-order.JPG (64.72 KiB) Viewed 17824 times


Newbie

Posts

Joined
Thu May 15, 2014 11:21 am

Post by direct2ufootwear » Wed Oct 22, 2014 11:55 pm

Hello i recently upgraded opencart software to version 1.5.6.4 and also updated to the latest version of vqmod but the problem i have now is when a customer try to create an account you see a white page

Admin when i edit a customers account i also get a white page error logs below

2014-10-22 12:20:35 - PHP Notice: Undefined index: customer_taxgroup_id in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 103
2014-10-22 12:20:35 - PHP Notice: Undefined index: vat_checked in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 104
2014-10-22 12:20:35 - PHP Notice: Undefined index: taxid1 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 105
2014-10-22 12:20:35 - PHP Notice: Undefined index: taxid2 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 106
2014-10-22 12:40:45 - PHP Notice: Undefined variable: total_pending_order in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 66
2014-10-22 12:40:45 - PHP Notice: Undefined variable: link_to_sale in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 66
2014-10-22 12:40:45 - PHP Notice: Undefined variable: total_pending_order in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 66
2014-10-22 12:40:45 - PHP Notice: Undefined variable: link_to_customers in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 67
2014-10-22 12:45:03 - PHP Notice: Undefined index: customer_taxgroup_id in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 103
2014-10-22 12:45:03 - PHP Notice: Undefined index: vat_checked in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 104
2014-10-22 12:45:03 - PHP Notice: Undefined index: taxid1 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 105
2014-10-22 12:45:03 - PHP Notice: Undefined index: taxid2 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 106
2014-10-22 12:45:04 - PHP Notice: Undefined index: customer_taxgroup_id in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 168
2014-10-22 12:45:04 - PHP Notice: Undefined index: vat_checked in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 169
2014-10-22 12:45:04 - PHP Notice: Undefined index: taxid1 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 170
2014-10-22 12:45:04 - PHP Notice: Undefined index: taxid2 in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 171
2014-10-22 12:45:04 - PHP Notice: Undefined index: customer_taxgroup_id in /var/www/vhosts/wholesale-footwear.co.uk/httpdocs/vqmod/vqcache/vq2-catalog_model_account_address.php on line 168


Posts

Joined
Wed Oct 22, 2014 11:48 pm

Post by JeffroDH » Thu Feb 19, 2015 2:49 am

r357 wrote:I use a clear version opencart 1.5.6.4 and a paypal sandbox.

My test product has 200 USD value and 10 mounts x 20USD profile
When I test it... In my opencart dashboard I see an order with status : Complete
When I go to Sales>Recurring profiles I see a status: Pending
When I go to my sandbox merchant acc I see - PayPal balance 200USD
When I go to the payer sandbox acc I see missing 200USD

Here is a paypal debug from opencart error log

Code: Select all

2014-07-14 0:56:13 - PayPal Express debug (Call data): {"METHOD":"SetExpressCheckout","MAXAMT":"250.00","RETURNURL":"http:\/\/btc-bazaar.com\/index.php?route=payment\/pp_express\/checkoutReturn","CANCELURL":"http:\/\/btc-bazaar.com\/index.php?route=checkout\/checkout","REQCONFIRMSHIPPING":0,"NOSHIPPING":1,"LOCALECODE":"EN","LANDINGPAGE":"Login","HDRIMG":null,"HDRBORDERCOLOR":"","HDRBACKCOLOR":"","PAYFLOWCOLOR":"","CHANNELTYPE":"Merchant","ALLOWNOTE":"0","PAYMENTREQUEST_0_SHIPPINGAMT":"","PAYMENTREQUEST_0_CURRENCYCODE":"USD","PAYMENTREQUEST_0_PAYMENTACTION":"Sale","L_PAYMENTREQUEST_0_DESC0":false,"L_PAYMENTREQUEST_0_NAME0":"Apple Cinema 30"","L_PAYMENTREQUEST_0_NUMBER0":"Product 15","L_PAYMENTREQUEST_0_AMT0":"200.00","L_PAYMENTREQUEST_0_QTY0":1,"L_PAYMENTREQUEST_0_ITEMURL0":"http:\/\/btc-bazaar.com\/index.php?route=product\/product&product_id=42","L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0":"12.50","L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0":"kg","L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0":"1.00000000","L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0":"2.00000000","L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0":"3.00000000","L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0":"cm","PAYMENTREQUEST_0_ITEMAMT":"200.00","PAYMENTREQUEST_0_AMT":"200.00","L_BILLINGTYPE0":"RecurringPayments","L_BILLINGAGREEMENTDESCRIPTION0":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:15 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&TIMESTAMP=2014%2d07%2d14T00%3a56%3a13Z&CORRELATIONID=632c28deac7a5&ACK=Success&VERSION=65%2e2&BUILD=11843215"
2014-07-14 0:56:39 - PayPal Express debug (Call data): {"METHOD":"GetExpressCheckoutDetails","TOKEN":"EC-2NL13084ME6423432"}
2014-07-14 0:56:40 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&BILLINGAGREEMENTACCEPTEDSTATUS=1&CHECKOUTSTATUS=PaymentActionNotInitiated&TIMESTAMP=2014%2d07%2d14T00%3a56%3a39Z&CORRELATIONID=66e295ed29b36&ACK=Success&VERSION=65%2e2&BUILD=11843215&EMAIL=r357bg%40gmail%2ecom&PAYERID=GAFDYKGARZNEJ&PAYERSTATUS=verified&FIRSTNAME=Delene&LASTNAME=Sch%c3%a4tti&COUNTRYCODE=US&CURRENCYCODE=USD&AMT=200%2e00&ITEMAMT=200%2e00&SHIPPINGAMT=0%2e00&HANDLINGAMT=0%2e00&TAXAMT=0%2e00&INSURANCEAMT=0%2e00&SHIPDISCAMT=0%2e00&L_NAME0=Apple%20Cinema%2030%26quot%3b&L_NUMBER0=Product%2015&L_QTY0=1&L_TAXAMT0=0%2e00&L_AMT0=200%2e00&L_DESC0=0&L_ITEMWEIGHTVALUE0=%20%2012%2e50000&L_ITEMWEIGHTUNIT0=kg&L_ITEMLENGTHVALUE0=%20%20%201%2e00000&L_ITEMLENGTHUNIT0=cm&L_ITEMWIDTHVALUE0=%20%20%202%2e00000&L_ITEMWIDTHUNIT0=cm&L_ITEMHEIGHTVALUE0=%20%20%203%2e00000&L_ITEMHEIGHTUNIT0=cm&PAYMENTREQUEST_0_CURRENCYCODE=USD&PAYMENTREQUEST_0_AMT=200%2e00&PAYMENTREQUEST_0_ITEMAMT=200%2e00&PAYMENTREQUEST_0_SHIPPINGAMT=0%2e00&PAYMENTREQUEST_0_HANDLINGAMT=0%2e00&PAYMENTREQUEST_0_TAXAMT=0%2e00&PAYMENTREQUEST_0_INSURANCEAMT=0%2e00&PAYMENTREQUEST_0_SHIPDISCAMT=0%2e00&PAYMENTREQUEST_0_INSURANCEOPTIONOFFERED=false&L_PAYMENTREQUEST_0_NAME0=Apple%20Cinema%2030%26quot%3b&L_PAYMENTREQUEST_0_NUMBER0=Product%2015&L_PAYMENTREQUEST_0_QTY0=1&L_PAYMENTREQUEST_0_TAXAMT0=0%2e00&L_PAYMENTREQUEST_0_AMT0=200%2e00&L_PAYMENTREQUEST_0_DESC0=0&L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0=%20%2012%2e50000&L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0=kg&L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0=%20%20%201%2e00000&L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0=cm&L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0=%20%20%202%2e00000&L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0=cm&L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0=%20%20%203%2e00000&L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0=cm&PAYMENTREQUESTINFO_0_ERRORCODE=0"
2014-07-14 0:56:40 - PayPal Express debug (Call data): {"TOKEN":"EC-2NL13084ME6423432","PAYERID":"GAFDYKGARZNEJ","METHOD":"DoExpressCheckoutPayment","PAYMENTREQUEST_0_NOTIFYURL":"http:\/\/btc-bazaar.com\/index.php?route=payment\/pp_express\/ipn","RETURNFMFDETAILS":1,"PAYMENTREQUEST_0_SHIPPINGAMT":"","PAYMENTREQUEST_0_CURRENCYCODE":"USD","PAYMENTREQUEST_0_PAYMENTACTION":"Sale","L_PAYMENTREQUEST_0_DESC0":false,"L_PAYMENTREQUEST_0_NAME0":"Apple Cinema 30"","L_PAYMENTREQUEST_0_NUMBER0":"Product 15","L_PAYMENTREQUEST_0_AMT0":"200.00","L_PAYMENTREQUEST_0_QTY0":1,"L_PAYMENTREQUEST_0_ITEMURL0":"http:\/\/btc-bazaar.com\/index.php?route=product\/product&product_id=42","L_PAYMENTREQUEST_0_ITEMWEIGHTVALUE0":"12.50","L_PAYMENTREQUEST_0_ITEMWEIGHTUNIT0":"kg","L_PAYMENTREQUEST_0_ITEMLENGTHVALUE0":"1.00000000","L_PAYMENTREQUEST_0_ITEMLENGTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMWIDTHVALUE0":"2.00000000","L_PAYMENTREQUEST_0_ITEMWIDTHUNIT0":"cm","L_PAYMENTREQUEST_0_ITEMHEIGHTVALUE0":"3.00000000","L_PAYMENTREQUEST_0_ITEMHEIGHTUNIT0":"cm","PAYMENTREQUEST_0_ITEMAMT":"200.00","PAYMENTREQUEST_0_AMT":"200.00","L_BILLINGTYPE0":"RecurringPayments","L_BILLINGAGREEMENTDESCRIPTION0":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:43 - PayPal Express debug (Result): "TOKEN=EC%2d2NL13084ME6423432&SUCCESSPAGEREDIRECTREQUESTED=false&TIMESTAMP=2014%2d07%2d14T00%3a56%3a42Z&CORRELATIONID=661bec006990b&ACK=Success&VERSION=65%2e2&BUILD=11843215&INSURANCEOPTIONSELECTED=false&SHIPPINGOPTIONISDEFAULT=false&PAYMENTINFO_0_TRANSACTIONID=9WM10836AJ2272512&PAYMENTINFO_0_TRANSACTIONTYPE=cart&PAYMENTINFO_0_PAYMENTTYPE=instant&PAYMENTINFO_0_ORDERTIME=2014%2d07%2d14T00%3a56%3a41Z&PAYMENTINFO_0_AMT=200%2e00&PAYMENTINFO_0_FEEAMT=6%2e10&PAYMENTINFO_0_TAXAMT=0%2e00&PAYMENTINFO_0_CURRENCYCODE=USD&PAYMENTINFO_0_PAYMENTSTATUS=Completed&PAYMENTINFO_0_PENDINGREASON=None&PAYMENTINFO_0_REASONCODE=None&PAYMENTINFO_0_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_0_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_0_ERRORCODE=0&PAYMENTINFO_0_ACK=Success"
2014-07-14 0:56:43 - PayPal Express debug (Call data): {"METHOD":"CreateRecurringPaymentsProfile","TOKEN":"EC-2NL13084ME6423432","PROFILESTARTDATE":"2014-07-14T01:01:43Z","BILLINGPERIOD":"Month","BILLINGFREQUENCY":"1","TOTALBILLINGCYCLES":"10","AMT":20,"CURRENCYCODE":"USD","PROFILEREFERENCE":3,"DESC":"20 USD every 1 month for 10 payments"}
2014-07-14 0:56:45 - PayPal Express debug (Result): "PROFILEID=I%2d8D8AUTMS8SUC&PROFILESTATUS=ActiveProfile&TIMESTAMP=2014%2d07%2d14T00%3a56%3a44Z&CORRELATIONID=c2103f7f961e6&ACK=Success&VERSION=65%2e2&BUILD=11843215"
2014-07-14 0:56:49 - PayPal Express debug (IPN data): {"request":"cmd=_notify-validate&mc_gross=200.00&protection_eligibility=Ineligible&item_number1=Product+15&payer_id=GAFDYKGARZNEJ&tax=0.00&payment_date=17%3A56%3A41+Jul+13%2C+2014+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=Delene&mc_fee=6.10¬ify_version=3.8&custom=&payer_status=verified&num_cart_items=1&mc_handling1=0.00&verify_sign=AOwxKIlnVFEAwVrLIuSb2g-xODWhAk1XW9KQWvekORa47tLs9HLaeyEf&payer_email=r357bg%40gmail.com&mc_shipping1=0.00&tax1=0.00&txn_id=9WM10836AJ2272512&payment_type=instant&last_name=&item_name1=Apple+Cinema+30%26amp%3Bquot%3B&receiver_email=paypal-facilitator%40vitalamin.ch&payment_fee=6.10&quantity1=1&receiver_id=YNK26S2GGRCPS&txn_type=cart&mc_gross_1=200.00&mc_currency=USD&residence_country=US&test_ipn=1&transaction_subject=20+USD+every+1+month+for+10+payments0&payment_gross=200.00&ipn_track_id=661bec006990b","response":"INVALID"}
2014-07-14 0:56:49 - PayPal Express debug (IPN fail): ["IPN was invalid"]
I cant find what is wrong here. Can someone give me a clue?

When I add the product to the shopping cart I see

Recurring item $20.00 every 1 month(s) for 10 payment(s)
Unit Price 200USD
Total 200USD

I thought it will charge the buyer 20USD now and 9 x 20USD later, not 200USD now.

I'm seeing the same problem. The item's full price is displayed at checkout, and the customer is billed the full price of the item PLUS the first payment of the recurring profile. This bug persists in 2.0.

Active Member

Posts

Joined
Thu Jul 11, 2013 8:29 am
Who is online

Users browsing this forum: No registered users and 10 guests