OpenCart 1.5.6.4 BUG topic - Read first post first!

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

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

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
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.

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!

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.

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

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

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.

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

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;
I have looked up the corresponding file and got this 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

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.

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

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.