[Skip to main content](#vessel-content)
# Profile for yanliom
##
[](/forum/user/45218-yanliom "View yanliom's Profile")
**[ Offline](/forum/user/45218-yanliom)**
- **User Type:** User
- **Register Date:** 27 Sep 2016
- **Last login:** 4 weeks 1 hour ago
- **Time Zone:** UTC +2:00
- **Local Time:** 15:48
- **Posts:** 66
- **Profile views:** 122
- **Thank you received:** 1
- **Gender:** Unknown
- **Birthdate:** Unknown
- **Medals:** Hikashop Business
- Posts
# yanliom's recent posts (66 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/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372226) | [Problem with calculation of product price by "decimal" length](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372226 "-- url of the page with the problem -- : www.ravopleko.gr -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.3 Hello, I'm using your solution for calculating product price by length. See topics: -https://www.hikashop.com/forum/product-category-display/898379-calculate-product-price-by-length.html -https://www.hikashop.com/forum/product-category-display/898421-decimal-calculate-product-price-by-length.html But at the cart the price is calculated wrong. Please see the attached screenshot were I'm testing various possibilities (I removed any restrictions for testing purposes).") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 10 months 3 weeks ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372229 "Hi, I've updated the plugin. Thanks for the feedback.") 4 months 4 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:481 | [Last Post](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372229 "Hi, I've updated the plugin. Thanks for the feedback.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 months 4 weeks ago |
| [](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#369772) | [Problem with calculation of product price by "decimal" length](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#369772 "-- url of the page with the problem -- : www.ravopleko.gr -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.3 Hello, I'm using your solution for calculating product price by length. See topics: -https://www.hikashop.com/forum/product-category-display/898379-calculate-product-price-by-length.html -https://www.hikashop.com/forum/product-category-display/898421-decimal-calculate-product-price-by-length.html But at the cart the price is calculated wrong. Please see the attached screenshot were I'm testing various possibilities (I removed any restrictions for testing purposes).") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 10 months 3 weeks ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372229 "Hi, I've updated the plugin. Thanks for the feedback.") 4 months 4 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:481 | [Last Post](/forum/26-product-category-display/909979-problem-with-calculation-of-product-price-by-decimal-length#372229 "Hi, I've updated the plugin. Thanks for the feedback.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 months 4 weeks ago |
| [](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567) | [Error calling Image thumbnail in Google Products XML](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567 "-- HikaShop version -- : 4.6.2 -- Joomla version -- : 4.2.5 Hello, after updating to Joomla 4 I get an error from an override you proposed some time ago for Google products plugin: The change is on line 436, of the plugin's PHP file. The altered code is: What change needs to be done? For reference, this is the URL of the related topic: www.hikashop.com/forum/development/90069...le-products-xml.html Thank you, Yannis") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 11 months ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567 "Thank you Nicolas!") 3 years 11 months ago by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") | Replies:2 Views:630 | [Last Post](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567 "Thank you Nicolas!") by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") 3 years 11 months ago |
| [](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346546) | [Error calling Image thumbnail in Google Products XML](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346546 "-- HikaShop version -- : 4.6.2 -- Joomla version -- : 4.2.5 Hello, after updating to Joomla 4 I get an error from an override you proposed some time ago for Google products plugin: The change is on line 436, of the plugin's PHP file. The altered code is: What change needs to be done? For reference, this is the URL of the related topic: www.hikashop.com/forum/development/90069...le-products-xml.html Thank you, Yannis") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 11 months ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567 "Thank you Nicolas!") 3 years 11 months ago by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") | Replies:2 Views:630 | [Last Post](/forum/25-install-update/905344-error-calling-image-thumbnail-in-google-products-xml#346567 "Thank you Nicolas!") by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") 3 years 11 months ago |
| [](/forum/37-import-export-csv-xls/905122-problem-with-product-variants-multiple-price-update#345348) | [Problem with product variants multiple price update](/forum/37-import-export-csv-xls/905122-problem-with-product-variants-multiple-price-update#345348 "-- HikaShop version -- : 4.6.1 -- Joomla version -- : 4.2.3 Hello, I'm trying to update my product prices using a CSV. My products have variants and each variant has Two prices, one price for registered users and one price for guests. When I import the CSV I get irregular prices even for same-priced products! Is it some bug related to the multiple prices used? I attach you here my CSV in case something went wrong. Thank you, Yannis") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 4 years 1 month ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/37-import-export-csv-xls/905122-problem-with-product-variants-multiple-price-update#345357 "Hi, If you want to import the prices of products and you want to restrict them to user groups, you need to have the column price_access with the user group ids separated by comma, separated by a \|. So for example: This will import the price 10 for the user groups with the id 4 and 6, and the price 20 for the user groups with the id 5 and 7 for the product with the code product1, and the price 15 for the user groups with the id 4 and 6, and the price 25 for the user groups with the id 5 and 7 for the product with the code product2") 4 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:975 | [Last Post](/forum/37-import-export-csv-xls/905122-problem-with-product-variants-multiple-price-update#345357 "Hi, If you want to import the prices of products and you want to restrict them to user groups, you need to have the column price_access with the user group ids separated by comma, separated by a \|. So for example: This will import the price 10 for the user groups with the id 4 and 6, and the price 20 for the user groups with the id 5 and 7 for the product with the code product1, and the price 15 for the user groups with the id 4 and 6, and the price 25 for the user groups with the id 5 and 7 for the product with the code product2") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 years 1 month ago |
| [](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721) | [Click two times in hikashop module to open product](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721 "-- url of the page with the problem -- : www.platonas.a2hosted.com/tfwr-sandbox -- HikaShop version -- : 4.6.1 -- Joomla version -- : 4.2.2 Hello, I'm trying a sandbox upgrade to Joomla 4 and I faced the following issue. When clicking on a product displayed in HikaShop Content Module (on home page) the url changes but the browser does not take me to the product's page. If I click a second time on product then the url changes again and I go to product page. * Url on first click: www.platonas.a2hosted.com/tfwr-sandbox/c...roduct/1614-cp-karma Url on second click: www.platonas.a2hosted.com/tfwr-sandbox/s...roduct/1614-cp-karma * What is going wrong? The weird thing is that if the second click is on another product it works too. It's like if the system "gets activated" after the first click. I have sent you the admin credentials using the contact form. Thank you, Yannis") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 4 years 1 month ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721 "Thank you Nicolas, problem solved!") 4 years 1 month ago by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") | Replies:2 Views:618 | [Last Post](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721 "Thank you Nicolas, problem solved!") by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") 4 years 1 month ago |
| [](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344715) | [Click two times in hikashop module to open product](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344715 "-- url of the page with the problem -- : www.platonas.a2hosted.com/tfwr-sandbox -- HikaShop version -- : 4.6.1 -- Joomla version -- : 4.2.2 Hello, I'm trying a sandbox upgrade to Joomla 4 and I faced the following issue. When clicking on a product displayed in HikaShop Content Module (on home page) the url changes but the browser does not take me to the product's page. If I click a second time on product then the url changes again and I go to product page. * Url on first click: www.platonas.a2hosted.com/tfwr-sandbox/c...roduct/1614-cp-karma Url on second click: www.platonas.a2hosted.com/tfwr-sandbox/s...roduct/1614-cp-karma * What is going wrong? The weird thing is that if the second click is on another product it works too. It's like if the system "gets activated" after the first click. I have sent you the admin credentials using the contact form. Thank you, Yannis") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 4 years 1 month ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721 "Thank you Nicolas, problem solved!") 4 years 1 month ago by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") | Replies:2 Views:618 | [Last Post](/forum/26-product-category-display/905008-click-two-times-in-hikashop-module-to-open-product#344721 "Thank you Nicolas, problem solved!") by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") 4 years 1 month ago |
| [](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343831) | [Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343831 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 4 years 3 months ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343838 "Hello, Indeed, we will need more elements to better understand the root issue, and so can you provide these elements : 1. Backend user references (with maximum ACL) 2. Url link to your backend access Note : Use our form to provide these elements, don't forget to add an Url link to this topic to keep the link. Awaiting your returns to progress on your subject. Regards") 4 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:3 Views:1285 | [Last Post](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343838 "Hello, Indeed, we will need more elements to better understand the root issue, and so can you provide these elements : 1. Backend user references (with maximum ACL) 2. Url link to your backend access Note : Use our form to provide these elements, don't forget to add an Url link to this topic to keep the link. Awaiting your returns to progress on your subject. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 4 years 2 months ago |
| [](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343821) | [Export all orders including order total](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343821 "-- HikaShop version -- : 4.6.0 Hello, when I am in Orders screen I click the Export button and I get the CSV with all my orders. But when I load it into Excel I can't find the order total as shown in the Orders screen. It seems like a bug. Is there another method to get the full orders record? Thanks in advance, Yannis") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 4 years 3 months ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343838 "Hello, Indeed, we will need more elements to better understand the root issue, and so can you provide these elements : 1. Backend user references (with maximum ACL) 2. Url link to your backend access Note : Use our form to provide these elements, don't forget to add an Url link to this topic to keep the link. Awaiting your returns to progress on your subject. Regards") 4 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:3 Views:1285 | [Last Post](/forum/37-import-export-csv-xls/904834-export-all-orders-including-order-total#343838 "Hello, Indeed, we will need more elements to better understand the root issue, and so can you provide these elements : 1. Backend user references (with maximum ACL) 2. Url link to your backend access Note : Use our form to provide these elements, don't forget to add an Url link to this topic to keep the link. Awaiting your returns to progress on your subject. Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 4 years 2 months ago |
| [](/forum/32-content-creation/904277-error-on-changing-encoding-of-hikashop-product-table#340953) | [Error on changing encoding of hikashop\_product table](/forum/32-content-creation/904277-error-on-changing-encoding-of-hikashop-product-table#340953 "-- HikaShop version -- : 4.5.0 -- Joomla version -- : 3.10.8 Hello, I'm trying to convert the encoding of hikashop_product table to utf8mb4 support emoticons through phpMyAdmin but I get the following error: ALTER TABLE `seemy_hikashop_product` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci #1071 - Specified key was too long; max key length is 1000 bytes What steps should I take to proceed with the conversion? Thank you, Yannis") Category: [Content Creation](/forum/32-content-creation "If you want to know more about the different options of the product and category creation.") Topic started 4 years 6 months ago, by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") [Last Post](/forum/32-content-creation/904277-error-on-changing-encoding-of-hikashop-product-table#340956 "Hi, In your hikashop_product table, you have several indexes and a unique key. By default these are: UNIQUE KEY `product_code` (`product_code`), KEY `product_parent_id` (`product_parent_id`), KEY `product_main_index` (`product_type`,`product_quantity`,`product_published`) These indexes allow MySQL to more rapidely find elements in the hikashop_product table, especially when there are hundreds of thousands or millions of entries. As you can see, these indexes are made on specific columns of the hikashop_product column. Out of these, 2 are varchar(255) columns: product_type and product_code So that means that each one can have up to 255 characters. With the default UTF8 collation on these, they go up to 3 byes per character, so they never go over the 1000 bytes threshold. If you want to convert these columns to use utf8mb4 it means that the maximum size of a text in these columns would be 4*255 (since utf8mb4 means that the characters are encoded with 4 bytes) which equals to 1020. However, this means that the indexes based on these columns would exceed the 1000 bytes key length limit of your MySQL and that's why you get that error message. To avoid that, you should edit these indexes and add a limit on the number of characters to index. For the product_type column, 20 characters will be enough. And for the product_code column, it depends on the length of your product codes but I doubt you would have codes bigger than 100 characters on a normal shop. So before changing to utf8mb4, you need first to reduce the size of the indexes on these two columns: stackoverflow.com/questions/50345159/wha...-index-in-phpmyadmin More information on that issue is available here: stackoverflow.com/questions/8746207/1071...length-is-1000-bytes") 4 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1040 | [Last Post](/forum/32-content-creation/904277-error-on-changing-encoding-of-hikashop-product-table#340956 "Hi, In your hikashop_product table, you have several indexes and a unique key. By default these are: UNIQUE KEY `product_code` (`product_code`), KEY `product_parent_id` (`product_parent_id`), KEY `product_main_index` (`product_type`,`product_quantity`,`product_published`) These indexes allow MySQL to more rapidely find elements in the hikashop_product table, especially when there are hundreds of thousands or millions of entries. As you can see, these indexes are made on specific columns of the hikashop_product column. Out of these, 2 are varchar(255) columns: product_type and product_code So that means that each one can have up to 255 characters. With the default UTF8 collation on these, they go up to 3 byes per character, so they never go over the 1000 bytes threshold. If you want to convert these columns to use utf8mb4 it means that the maximum size of a text in these columns would be 4*255 (since utf8mb4 means that the characters are encoded with 4 bytes) which equals to 1020. However, this means that the indexes based on these columns would exceed the 1000 bytes key length limit of your MySQL and that's why you get that error message. To avoid that, you should edit these indexes and add a limit on the number of characters to index. For the product_type column, 20 characters will be enough. And for the product_code column, it depends on the length of your product codes but I doubt you would have codes bigger than 100 characters on a normal shop. So before changing to utf8mb4, you need first to reduce the size of the indexes on these two columns: stackoverflow.com/questions/50345159/wha...-index-in-phpmyadmin More information on that issue is available here: stackoverflow.com/questions/8746207/1071...length-is-1000-bytes") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 years 6 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.061 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)