Jump to content

DavidK

Member
  • Content Count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. DavidK

    2checkout gateway not working anymore

    Thank you for all help and advices,I will try to check and fix other things as you recommend.David
  2. DavidK

    2checkout gateway not working anymore

    I believed there is no plugin or code change that could cause this problem,but after checking all active plugins,I realized there is zendesk plugin that I installed some time ago.This plugin is enhanced that allow to see,if buyer is registered customer and show cart content...so I realized this could be the problem.I deactivated it and I can now log in with test accounts.You are really great helper,I would never think this way...This is official plugin from cubecart marketplace.Many many thanks ! Regarding those other errors,especialy with catalog class,do you think this could be also fixed some way ? Once again thanks for your time and help.David
  3. DavidK

    2checkout gateway not working anymore

    Hi,this is some of latest error logs,last line (from 17:17:39) is when I made test login to store front. [18-Sep-2018 18:43:14 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [18-Sep-2018 16:43:17 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [18-Sep-2018 18:43:18 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [18-Sep-2018 16:43:21 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [18-Sep-2018 18:43:21 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [18-Sep-2018 16:43:30 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [18-Sep-2018 18:43:30 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [18-Sep-2018 18:43:34 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [18-Sep-2018 17:17:39 UTC] PHP Fatal error: Call to a member function setError() on null in /home2/minerals/public_html/store/classes/user.class.php on line 244 And this is part of latest error logs from store admin (system error logs): Today, 18:43File: [catalogue.class.php] Line: [1819] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE)) >= 0.5 ORDER BY `IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))` DESC LIMIT 100 " - Unknown column 'IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))' in 'order clause' Today, 18:43File: [catalogue.class.php] Line: [1821] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE)) >= 0.5 GROUP BY I.product_id ORDER BY `IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))` DESC " - Unknown column 'IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))' in 'order clause' Today, 18:43File: [catalogue.class.php] Line: [1819] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('tourmaline' IN BOOLEAN MODE)) >= 0.5 ORDER BY `IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))` DESC LIMIT 100 " - Unknown column 'IF (G.product_id IS NULL, IF (I.sale_price IS NULL OR I.sale_price = 0, I.price, I.sale_price), IF (G.sale_price IS NULL OR G.sale_price = 0, G.price, G.sale_price))' in 'order clause'
  4. DavidK

    2checkout gateway not working anymore

    Hello,I use 6.1.15,it was upgraded from modified v5 with fairly many mods.Upgrade was made by semperfiwebservices and I installed also couple of their plugins and store has also some code change.I am confused about login issues,because as far I can not see in admin access logs some numerous failed login attempts by customers.There is also some continuous errors caused by catalogue.class.php file.What would you recommend to do ?
  5. DavidK

    2checkout gateway not working anymore

    Hi Brian,thank you for your fix,just want to confirm,that it works now with original url in action statement and adding code as adviced in your second post.Thank you a lot for your help,you already help me few times in past,I really appreciate it very much. I would have one more problem to fix,I have some issues with login,I was doing some test orders and found,that when I try to login to front store as buyer with some test accounts,instead of being logged,it returns blank page with just "1" as page source,so probably some issue with ip blocker.I am not sure,if this happens also to buyers,some buyers use express paypal checkout without having to login or register,some register accounts,but strange is,that I tried my test with 3 different test accounts and with any I am not able to login.From admin I can log using Login as... but not from store front.Would you be willing to look in to my problem ? This problem started after my upgrade from v5 to my current 6.1.15 and since upgrade our sales went down,so I am afraid more potential buyers may have same issue.Thank you advance for your advice or help.David
  6. DavidK

    2checkout gateway not working anymore

    Thank you for your advice,I try it and let know if it helps or not.
  7. DavidK

    2checkout gateway not working anymore

    Hello,I have my account active,I have discussed with their support,they say,that conflict is due to sending parameter token and it should be excluded.... ------------ Hello David, From our early investigations regarding this issue it seems that the parameter "token" which you pass-by conflict with some other parameters. Can you please re-check your integration and stop sending the token parameter to see if the issue still persists? Hope to hear from you soon. Thank you, Mihai D. Merchant Support Specialist https://www.2checkout.com
  8. Hi,2checkout gateway plugin I think should be updated,after recent upgrades provided by 2checkout gateway is causing error and customer is not forwarding to payment page.Could anybody look on it and try to fix this plugin that it works ???
  9. DavidK

    2checkout gateway error

    Hi,thanks for answer,maybe it would be good to forward it as error/issue as it is standard gateway of cubecart.
  10. Hi,I noticed we have recently unfinished orders of buyers using 2checkout gateway and i found,that after pushing final button and transfering to 2checkout gateway,there is 500 internal error on 2checkout server.They provided recently some upgrades of their administration panels,but as I was informed,it should not affect anyhow payments and configurations or carts,etc. I received this answer from them and enclose it here,is anybody else also having same issue ? I use standard 2checkout gateway with no code changing.Could anybody help ? David ------- Hello David, From our early investigations regarding this issue it seems that the parameter "token" which you pass-by conflict with some other parameters. Can you please re-check your integration and stop sending the token parameter to see if the issue still persists? Hope to hear from you soon. Thank you, Mihai D. Merchant Support Specialist https://www.2checkout.com
  11. Thank you for looking in to it and explaining.I think I can live without Shippo plugin,I just rather set all in one shipping and it works,for what I need.But what would you recommend with those other errors ? Is there some way to fix it or find,what is doing those errors ? My old v5 was fairly much modified,there were some mods I do not use anymore,as it was upgraded manually by semperfiwebservices,I believe they did their job well,maybe some old modified coding which was kept is not good.What would you recommend to do ? How it can impact my shop to keep it as it is ? Thank you for your time and help.
  12. Well,I tried again to turn on Shippo on and when I go to basket or checkout,there is blank page and as source it display just number 1.I checked error log and there are other errors,but I think not any of shippo addon.There are few errors that are continuosly repeating every day.I recently upgraded from v5 to 6.1.15.It was manual upgrade.Same problems I am getting when trying to log as some test user myself.Again blank page.So a bit strange things.Any advise what can be wrong ? Thank you advance for any help or advise. I checked now also system error log in store admin and there is error of shippo plugin as: Today, 19:36 [Exception] /home2/minerals/public_html/store/modules/shipping/goShippo/shippo-php-client-1.4.2/lib/Shippo/ApiRequestor.php:100 - {"parcels": [{"__all__": ["Parcel template or dimensions must be given."]}]} Lot of other every day repeating errors in my log. [26-Jun-2018 02:46:36 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 02:46:54 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 07:17:52 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 05:26:14 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 05:26:22 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 05:26:26 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 05:26:31 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 08:08:26 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 09:09:07 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 09:33:09 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 10:33:09 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 08:45:29 UTC] PHP Fatal error: Call to a member function setError() on null in /home2/minerals/public_html/store/classes/user.class.php on line 244 [26-Jun-2018 08:45:43 UTC] PHP Fatal error: Call to a member function setError() on null in /home2/minerals/public_html/store/classes/user.class.php on line 244 [26-Jun-2018 09:28:04 UTC] PHP Warning: Invalid Security Token in /home2/minerals/public_html/store/classes/sanitize.class.php on line 150 [26-Jun-2018 10:00:47 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 10:00:49 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 12:32:47 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 12:46:19 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/modules/shipping/All_In_One_Shipping/admin/index.inc.php on line 128 [26-Jun-2018 12:48:08 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 13:11:53 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/modules/shipping/All_In_One_Shipping/admin/index.inc.php on line 128 [26-Jun-2018 14:31:23 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 15:46:55 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 16:10:35 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 18:30:52 Europe/Prague] PHP Warning: Invalid argument supplied for foreach() in /home2/minerals/public_html/store/classes/catalogue.class.php on line 258 [26-Jun-2018 16:55:57 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111 [26-Jun-2018 16:56:02 UTC] PHP Warning: Security Warning: Illegal array key "#39;A" was detected and was removed. in /home2/minerals/public_html/store/classes/sanitize.class.php on line 111
  13. Thank you,I will do it later.I have simillar problem when trying to log with certain test accounts to my shop,it is somehow always blocked by blocker.Strange,when I try to create new account,it does not make problems.....strange.Thank you for your advise,as soon as I get chance,I show the error result.
  14. Is this plugin working correct ? I installed it,created Shippo account and got testing api token,but when I activate this plugin,instead of cart page or checkout page I get blank page.....If anybody is using this plugin,please let me know,if it works and what I did wrong.Thanks
  15. Hi,is anybody using this plugin and this service ?
×