[Skip to main content](#vessel-content) # Profile for earmaster ## [![earmaster's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35023-earmaster "View earmaster's Profile") **[ Offline](/forum/user/35023-earmaster)** - **User Type:** User - **Register Date:** 18 Nov 2014 - **Last login:** 23 hours 53 minutes ago - **Time Zone:** UTC +0:00 - **Local Time:** 08:03 - **Posts:** 136 - **Profile views:** 256 - **Thank you received:** 2 - **Gender:** Unknown - **Birthdate:** Unknown - **Medals:** Hikashop Business - Posts # earmaster's recent posts (136 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/25-install-update/100000093-error-with-geolocation-plugin#100000474) | [Error with Geolocation plugin](/forum/25-install-update/100000093-error-with-geolocation-plugin#100000474 "-- url of the page with the problem -- : www.earmaster.com -- HikaShop version -- : 6.6.0 -- Joomla version -- : 5.4.9 Stable -- PHP version -- : 8.5.12 -- Browser(s) name and version -- : Chrome 156.0 -- Error-message(debug-mod must be tuned on) -- : Lock wait timeout exceeded; try restarting transaction We regularly got this unhandled exception on ordinary front-end pages, often non-shop pages visited by new visitors: Each occurrence means a visitor waits about 50 seconds and then gets an error page. Cause Line 327 is the cleanup query at the end of getZone(): This runs for every visitor without an existing session: every new visitor, and every bot or client that doesn't keep cookies. The table only has an index on (geolocation_type, geolocation_ref_id). So the DELETE has to scan and lock every "visit" row, not just the expired ones. On our site that's about 1.87 million rows. The IP lookup in the same function has no index on geolocation_ip either. When several new visitors arrive at the same time, these queries queue behind each other until one times out. Workaround we applied Adding two indexes solved it for us: EXPLAIN confirms the DELETE now uses idx_type_created. Suggestions * Add these indexes (or equivalent ones) to the table definition and the update script, so they survive updates and other sites get them too. * Run the purge occasionally, for example once a day or through a scheduled task, instead of on every new visitor's first page view. * Rows with geolocation_type = 'bot' are never purged. We have about 245,000 of them after a year, and the number keeps growing. * Possible typo: a few lines above the DELETE in getZone(), if(empty($zones)) looks like it should be if(!empty($zones)). In practice the fallback query below it usually finds the zone anyway, but it's worth checking.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 1 day 20 hours ago, by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") [Last Post](/forum/25-install-update/100000093-error-with-geolocation-plugin#100000477 "-- url of the page with the problem -- : www.earmaster.com -- HikaShop version -- : 6.6.0 -- Joomla version -- : 5.4.9 Stable -- PHP version -- : 8.5.12 -- Browser(s) name and version -- : Chrome 156.0 -- Error-message(debug-mod must be tuned on) -- : Lock wait timeout exceeded; try restarting transaction We regularly got this unhandled exception on ordinary front-end pages, often non-shop pages visited by new visitors: Each occurrence means a visitor waits about 50 seconds and then gets an error page. Cause Line 327 is the cleanup query at the end of getZone(): This runs for every visitor without an existing session: every new visitor, and every bot or client that doesn't keep cookies. The table only has an index on (geolocation_type, geolocation_ref_id). So the DELETE has to scan and lock every "visit" row, not just the expired ones. On our site that's about 1.87 million rows. The IP lookup in the same function has no index on geolocation_ip either. When several new visitors arrive at the same time, these queries queue behind each other until one times out. Workaround we applied Adding two indexes solved it for us: EXPLAIN confirms the DELETE now uses idx_type_created. Suggestions * Add these indexes (or equivalent ones) to the table definition and the update script, so they survive updates and other sites get them too. * Run the purge occasionally, for example once a day or through a scheduled task, instead of on every new visitor's first page view. * Rows with geolocation_type = 'bot' are never purged. We have about 245,000 of them after a year, and the number keeps growing. * Possible typo: a few lines above the DELETE in getZone(), if(empty($zones)) looks like it should be if(!empty($zones)). In practice the fallback query below it usually finds the zone anyway, but it's worth checking.") 1 day 17 hours ago by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") | Replies:0 Views:26 | [Last Post](/forum/25-install-update/100000093-error-with-geolocation-plugin#100000477 "-- url of the page with the problem -- : www.earmaster.com -- HikaShop version -- : 6.6.0 -- Joomla version -- : 5.4.9 Stable -- PHP version -- : 8.5.12 -- Browser(s) name and version -- : Chrome 156.0 -- Error-message(debug-mod must be tuned on) -- : Lock wait timeout exceeded; try restarting transaction We regularly got this unhandled exception on ordinary front-end pages, often non-shop pages visited by new visitors: Each occurrence means a visitor waits about 50 seconds and then gets an error page. Cause Line 327 is the cleanup query at the end of getZone(): This runs for every visitor without an existing session: every new visitor, and every bot or client that doesn't keep cookies. The table only has an index on (geolocation_type, geolocation_ref_id). So the DELETE has to scan and lock every "visit" row, not just the expired ones. On our site that's about 1.87 million rows. The IP lookup in the same function has no index on geolocation_ip either. When several new visitors arrive at the same time, these queries queue behind each other until one times out. Workaround we applied Adding two indexes solved it for us: EXPLAIN confirms the DELETE now uses idx_type_created. Suggestions * Add these indexes (or equivalent ones) to the table definition and the update script, so they survive updates and other sites get them too. * Run the purge occasionally, for example once a day or through a scheduled task, instead of on every new visitor's first page view. * Rows with geolocation_type = 'bot' are never purged. We have about 245,000 of them after a year, and the number keeps growing. * Possible typo: a few lines above the DELETE in getZone(), if(empty($zones)) looks like it should be if(!empty($zones)). In practice the fallback query below it usually finds the zone anyway, but it's worth checking.") by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") 1 day 17 hours ago | | [](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#370595) | [Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#370595 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks") Category: [Discount & Coupon](/forum/46-discount-coupon "Increase your sales with our coupon/discount feature") Topic started 8 years 2 months ago, by [GB11](/forum/user/20674-gb11 "View GB11's Profile") [Last Post](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#370595 "Unfortunately, it seems that coupons and discounts used with floating taxes still don't work. We have tried to make it work for years now, but no luck. So we're running a script to correct the amounts...") 8 months 1 week ago by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") | Replies:9 Views:2237 | [Last Post](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#370595 "Unfortunately, it seems that coupons and discounts used with floating taxes still don't work. We have tried to make it work for years now, but no luck. So we're running a script to correct the amounts...") by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") 8 months 1 week ago | | [](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367608) | [How to inject custom text dynamically in email](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367608 "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.1 -- PHP version -- : 8.3.12 Hi, I'm trying to inject different custom texts, based on which product(s) the customer has bought, in the Order Status Notification email. Those texts must give product-specific information to the customer. For example, Customer 1 has bought a software license, and I want to inject that chunk of text in the ORDER STATUS NOTIFICATION email: "You bought a download version. You need to install the app first, then activate it with a serial number which you can find below...etc.etc.". Customer 2 has ordered a subscription, I want to inject that text instead of the first one: "Thanks for signing up. Now you need to do thais, and that, and then, blah blah..." I have created a Checkbox custom field called "email_tags" for the Product table, where I add values for each custom text I want to inject. I display those checkboxes on the backend only, so that for each product, I can select the value(s) I want to inject in the email (there can be more than one selected value). Then I create text chunks in the text overrides for each of the values defined in the "email_tags" custom checkbox, for example: MYTXT_DLD="You bought a download version. You need to..." So far so good... But I'm not sure how to proceed from here. What is the easiest way to get Hikashop to pick the texts that correspond to the checked boxes when generating the Order Status Notification email? Thank you for your help!") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 1 year 4 months ago, by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") [Last Post](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367609 "Great. Note that we can potentially work on such custom jobs. If you're interested, you can go through our contact form: www.hikashop.com/support/contact-us.html For what you want here, we would charge 40€ (without taxes)") 1 year 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:856 | [Last Post](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367609 "Great. Note that we can potentially work on such custom jobs. If you're interested, you can go through our contact form: www.hikashop.com/support/contact-us.html For what you want here, we would charge 40€ (without taxes)") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 4 months ago | | [](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367601) | [How to inject custom text dynamically in email](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367601 "-- HikaShop version -- : 5.1.6 -- Joomla version -- : 5.3.1 -- PHP version -- : 8.3.12 Hi, I'm trying to inject different custom texts, based on which product(s) the customer has bought, in the Order Status Notification email. Those texts must give product-specific information to the customer. For example, Customer 1 has bought a software license, and I want to inject that chunk of text in the ORDER STATUS NOTIFICATION email: "You bought a download version. You need to install the app first, then activate it with a serial number which you can find below...etc.etc.". Customer 2 has ordered a subscription, I want to inject that text instead of the first one: "Thanks for signing up. Now you need to do thais, and that, and then, blah blah..." I have created a Checkbox custom field called "email_tags" for the Product table, where I add values for each custom text I want to inject. I display those checkboxes on the backend only, so that for each product, I can select the value(s) I want to inject in the email (there can be more than one selected value). Then I create text chunks in the text overrides for each of the values defined in the "email_tags" custom checkbox, for example: MYTXT_DLD="You bought a download version. You need to..." So far so good... But I'm not sure how to proceed from here. What is the easiest way to get Hikashop to pick the texts that correspond to the checked boxes when generating the Order Status Notification email? Thank you for your help!") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 1 year 4 months ago, by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") [Last Post](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367609 "Great. Note that we can potentially work on such custom jobs. If you're interested, you can go through our contact form: www.hikashop.com/support/contact-us.html For what you want here, we would charge 40€ (without taxes)") 1 year 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:856 | [Last Post](/forum/31-development/909511-how-to-inject-custom-text-dynamically-in-email#367609 "Great. Note that we can potentially work on such custom jobs. If you're interested, you can go through our contact form: www.hikashop.com/support/contact-us.html For what you want here, we would charge 40€ (without taxes)") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 4 months ago | | [](/forum/29-payment-methods/903881-strong-customer-authentication-sca-for-stripe-payment-plugin#339649) | [Strong Customer Authentication (SCA) for Stripe payment plugin](/forum/29-payment-methods/903881-strong-customer-authentication-sca-for-stripe-payment-plugin#339649 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.5 -- PHP version -- : 7.3.33 -- Browser(s) name and version -- : any browser -- Error-message(debug-mod must be tuned on) -- : / Hi guys, i've just set up the Stripe payment plugin, (had to edit the file /plugins/hikashoppayment/stripe/stripe.php to add GBP in the $accepted_currencies variable, otherwise i couldn't use it with GBP). So that all went fine, i've tested it and it worked but then i got this email from Stripe: Hello, Thank you for choosing Stripe! We’re writing because we noticed your account is impacted by a regulatory requirement called Strong Customer Authentication (SCA). SCA requires two-factor authentication on many payments in Europe. Payments that are not authenticated are at risk of being declined by your customers’ banks. Your account (Clay Cellar Ltd) has payments (like this one) in live mode using the Charges API, which does not support the authentication requirements of SCA. We recommend using one of our SCA-ready integration paths to avoid more declined European payments. Read more: stripe.com/docs/strong-customer-authentication Will there be an update for the Stripe payment plugin, what should we do? regards") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 4 years 9 months ago, by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") [Last Post](/forum/29-payment-methods/903881-strong-customer-authentication-sca-for-stripe-payment-plugin#339651 "Hi, Thanks for your input. The problem is that it sets a bad example for our partners. If we develop plugins that they already developed and provide them for free with HikaShop while they sell it on our marketplace, why would they bother developing other plugins for HikaShop ? Most payment plugins are made by 3rd party developers and we can't develop them all ourselves. So we decided to not undercut our partners. I see your point of view but I believe that it's also important to encourage other developers to developer plugins for HikaShop.") 4 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:973 | [Last Post](/forum/29-payment-methods/903881-strong-customer-authentication-sca-for-stripe-payment-plugin#339651 "Hi, Thanks for your input. The problem is that it sets a bad example for our partners. If we develop plugins that they already developed and provide them for free with HikaShop while they sell it on our marketplace, why would they bother developing other plugins for HikaShop ? Most payment plugins are made by 3rd party developers and we can't develop them all ourselves. So we decided to not undercut our partners. I see your point of view but I believe that it's also important to encourage other developers to developer plugins for HikaShop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 years 8 months ago | | [](/forum/25-install-update/902373-dashboard-sales-graph-error#331712) | [Dashboard sales graph error](/forum/25-install-update/902373-dashboard-sales-graph-error#331712 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.19 -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : to split is not a function after switching the month and group, it will show but the hover appearing sales figure is not working also") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 5 years 6 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/25-install-update/902373-dashboard-sales-graph-error#331979 "I think I've found a solution. Download the latest package with version 4.4.2 (I had such a version, but I think the version has changed in the meantime without changing the marking). Install, clean...") 5 years 6 months ago by [StudioPrzyLesie](/forum/user/31654-studioprzylesie "View StudioPrzyLesie's Profile") | Replies:13 Views:2115 | [Last Post](/forum/25-install-update/902373-dashboard-sales-graph-error#331979 "I think I've found a solution. Download the latest package with version 4.4.2 (I had such a version, but I think the version has changed in the meantime without changing the marking). Install, clean...") by [StudioPrzyLesie](/forum/user/31654-studioprzylesie "View StudioPrzyLesie's Profile") 5 years 6 months ago | | [](/forum/25-install-update/902373-dashboard-sales-graph-error#331708) | [Dashboard sales graph error](/forum/25-install-update/902373-dashboard-sales-graph-error#331708 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.19 -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : to split is not a function after switching the month and group, it will show but the hover appearing sales figure is not working also") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 5 years 6 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/25-install-update/902373-dashboard-sales-graph-error#331979 "I think I've found a solution. Download the latest package with version 4.4.2 (I had such a version, but I think the version has changed in the meantime without changing the marking). Install, clean...") 5 years 6 months ago by [StudioPrzyLesie](/forum/user/31654-studioprzylesie "View StudioPrzyLesie's Profile") | Replies:13 Views:2115 | [Last Post](/forum/25-install-update/902373-dashboard-sales-graph-error#331979 "I think I've found a solution. Download the latest package with version 4.4.2 (I had such a version, but I think the version has changed in the meantime without changing the marking). Install, clean...") by [StudioPrzyLesie](/forum/user/31654-studioprzylesie "View StudioPrzyLesie's Profile") 5 years 6 months ago | | [](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331699) | [Hikashop dashboard error](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331699 "-- url of the page with the problem -- : accademiainfinita.it/administrator/index...ashop&ctrl=dashboard -- HikaShop version -- : 4.4.1 -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.16 -- Browser(s) name and version -- : Brave V 1.22.71 -- Error-message(debug-mod must be tuned on) -- : b.split is not a function× AND Invalid row index NaN. Should be in the range [0-1].× Hello, in the dashboard the orders statistics is not showed anymore see nimb.ws/NZ2nPo Last time I checked 2 days ago it was working, I didn't update or installed anything else since then. Thank you") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 5 years 6 months ago, by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") [Last Post](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331701 "Hi, It's coming from an update of Google Visualization API: www.hikashop.com/forum/install-update/90...ph-error.html#331700") 5 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:1099 | [Last Post](/forum/36-reports-statistics/902375-hikashop-dashboard-error#331701 "Hi, It's coming from an update of Google Visualization API: www.hikashop.com/forum/install-update/90...ph-error.html#331700") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 years 6 months ago | | [](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319855) | [Stripe connect v3 error when a card is declined - hanging on card details page](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319855 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.31 -- Browser(s) name and version -- : Chrome - Version 81.0.4044.138 (Official Build) (64-bit) -- Error-message(debug-mod must be tuned on) -- : There is no php error being reported Hi, I'm experiencing a problem with the Stripe connect payment method when a card is declined. When a card payment is declined the site hangs on the card details page of the checkout with a spinner spinning rather than either displaying an error message or redirecting another page. When turning on debug mode and error reporting I'm not seeing any errors, however when checking in the apache logs I can see the following: And also see the following via the browser developer console: Any help would be greatly appreciated Thanks KH") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 6 years 5 months ago, by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") [Last Post](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319857 "Hello, If you do not have the same issue than the first post of that thread ; please open a new one since it's a different problem and it will create more confusion than helping to solve the two different questions. Regards,") 6 years 5 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:7 Views:1663 | [Last Post](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319857 "Hello, If you do not have the same issue than the first post of that thread ; please open a new one since it's a different problem and it will create more confusion than helping to solve the two different questions. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 6 years 5 months ago | | [](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319791) | [Stripe connect v3 error when a card is declined - hanging on card details page](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319791 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.31 -- Browser(s) name and version -- : Chrome - Version 81.0.4044.138 (Official Build) (64-bit) -- Error-message(debug-mod must be tuned on) -- : There is no php error being reported Hi, I'm experiencing a problem with the Stripe connect payment method when a card is declined. When a card payment is declined the site hangs on the card details page of the checkout with a spinner spinning rather than either displaying an error message or redirecting another page. When turning on debug mode and error reporting I'm not seeing any errors, however when checking in the apache logs I can see the following: And also see the following via the browser developer console: Any help would be greatly appreciated Thanks KH") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 6 years 5 months ago, by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") [Last Post](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319857 "Hello, If you do not have the same issue than the first post of that thread ; please open a new one since it's a different problem and it will create more confusion than helping to solve the two different questions. Regards,") 6 years 5 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:7 Views:1663 | [Last Post](/forum/29-payment-methods/899939-stripe-connect-v3-error-when-a-card-is-declined-hanging-on-card-details-page#319857 "Hello, If you do not have the same issue than the first post of that thread ; please open a new one since it's a different problem and it will create more confusion than helping to solve the two different questions. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 6 years 5 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.150 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)