[Skip to main content](#vessel-content) # Profile for Storm ## [![Storm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/42764-storm "View Storm's Profile") **[ Offline](/forum/user/42764-storm)** - **User Type:** User - **Register Date:** 25 Apr 2016 - **Last login:** 2 weeks 1 day ago - **Time Zone:** UTC +0:00 - **Local Time:** 22:04 - **Posts:** 70 - **Profile views:** 214 - **Thank you received:** 1 - **Gender:** Unknown - **Birthdate:** Unknown - **Medals:** Hikashop Business Hikashop Essential - Posts # Storm's recent posts (70 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/33-customers/910766-custom-user-fields-not-saving-after-joomla-3-to-joomla-5-migration#373107) | [Custom user fields not saving after Joomla 3 to Joomla 5 migration](/forum/33-customers/910766-custom-user-fields-not-saving-after-joomla-3-to-joomla-5-migration#373107 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.3.4 -- PHP version -- : 8.3.33 We have recently migrated a website from Joomla 3 to Joomla 5 and upgraded HikaShop Business to version 6.5.2. When editing a customer through the HikaShop administrator area, values entered into the following custom user fields are not being saved: Field ID 29: e_CopyMinderKey Field ID 37: e_Product Field ID 41: e_MSValid The customer record appears to save successfully and no error is displayed. However, the values disappear when the page reloads and remain NULL in the database. We have checked the field definitions in #__hikashop_field. All three fields: * Use field_table = user * Are published * Have backend editing enabled * Are not read-only The physical columns also exist in #__hikashop_user: e_CopyMinderKey — text, NULL allowed e_Product — text, NULL allowed e_MSValid — text, NULL allowed The field names and physical database column names match exactly, including their case. We tested this against HikaShop user ID 1209 / Joomla user ID 10333. Before saving: e_CopyMinderKey = NULL e_Product = NULL e_MSValid = NULL We then entered values into all three fields through the HikaShop customer edit screen and saved the record. A direct database query afterwards showed that all three values were still NULL. The relevant query was: SELECT user_id, user_cms_id, user_email, e_CopyMinderKey, e_Product, e_MSValid FROM #__hikashop_user WHERE user_id = 1209; There are no related PHP, HikaShop or database errors in Joomla’s everything.php log. The save completes and redirects/reloads normally. The database columns currently use utf8mb3_general_ci, although the values we tested were ordinary text and dropdown/radio selections. The field configurations are: Field 29: * Table: user * Name key: e_CopyMinderKey * Type: text * Published: Yes * Backend: Yes * Read-only: No Field 37: * Table: user * Name key: e_Product * Type: singledropdown * Published: Yes * Backend: Yes * Read-only: No Field 41: * Table: user * Name key: e_MSValid * Type: radio * Published: Yes * Backend: Yes * Read-only: No Could you please advise: 1. Is there a known issue in HikaShop 6.5.2 affecting custom user fields after migrating from Joomla 3 to Joomla 5? 2. Are mixed-case legacy column names such as e_CopyMinderKey still supported? 3. Is there a database migration or field resave process that needs to be run? 4. Is there a particular request handler or HikaShop file we should inspect to see why these fields are being excluded from the update? 5. Could an administrator view override created under the old HikaShop/Joomla installation cause the fields to display but not be submitted or processed? Thanks") Category: [Customers](/forum/33-customers "How to manage your customers and their access") Topic started 2 months 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/33-customers/910766-custom-user-fields-not-saving-after-joomla-3-to-joomla-5-migration#373112 "Hi, Thanks for the very detailed report, it made this quick to pin down. You found a real bug in HikaShop and it is directly linked to the Joomla 3 to Joomla 5 migration. I reproduced it here with a field named e_CopyMinderKey and I've fixed it. The cause is the capital letters in the field name key. When HikaShop prepares the data of a record before writing it, it normalizes the column names to lower case, so e_CopyMinderKey is passed as e_copyminderkey. Under Joomla 3 that made no difference, since MySQL column names are not case sensitive. But since Joomla 4, Joomla's updateObject() compares the name you give it with the columns of the table letter for letter, and silently drops anything that doesn't match exactly. So the column is simply left out of the UPDATE query: no error, "Successfully Saved", and the value still NULL. That is why it started the day you migrated. To answer your questions: 1. Yes, now confirmed, and it affects any custom field with an uppercase letter in its name key, on the user, address, order and product tables alike. 2. They are supported again with this fix. HikaShop has been forcing new field name keys to lower case for years, which is why only fields created on your old installation are affected. 3. No migration or resave is needed. Note that creating a new record was already saving these fields correctly, it is only the update of an existing record that was losing them. 4. It was in checkFields() in administrator/components/com_hikashop/classes/field.php, at the line that lowercases the column name. 5. No, your view overrides are not involved here. Just download the install package of the latest version of HikaShop on our website and install it on yours and you'll get the patch for this.") 2 months 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:471 | [Last Post](/forum/33-customers/910766-custom-user-fields-not-saving-after-joomla-3-to-joomla-5-migration#373112 "Hi, Thanks for the very detailed report, it made this quick to pin down. You found a real bug in HikaShop and it is directly linked to the Joomla 3 to Joomla 5 migration. I reproduced it here with a field named e_CopyMinderKey and I've fixed it. The cause is the capital letters in the field name key. When HikaShop prepares the data of a record before writing it, it normalizes the column names to lower case, so e_CopyMinderKey is passed as e_copyminderkey. Under Joomla 3 that made no difference, since MySQL column names are not case sensitive. But since Joomla 4, Joomla's updateObject() compares the name you give it with the columns of the table letter for letter, and silently drops anything that doesn't match exactly. So the column is simply left out of the UPDATE query: no error, "Successfully Saved", and the value still NULL. That is why it started the day you migrated. To answer your questions: 1. Yes, now confirmed, and it affects any custom field with an uppercase letter in its name key, on the user, address, order and product tables alike. 2. They are supported again with this fix. HikaShop has been forcing new field name keys to lower case for years, which is why only fields created on your old installation are affected. 3. No migration or resave is needed. Note that creating a new record was already saving these fields correctly, it is only the update of an existing record that was losing them. 4. It was in checkFields() in administrator/components/com_hikashop/classes/field.php, at the line that lowercases the column name. 5. No, your view overrides are not involved here. Just download the install package of the latest version of HikaShop on our website and install it on yours and you'll get the patch for this.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 2 weeks ago | | [](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372255) | [Automatically add an option as selected](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372255 "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 5.4.6 We have software products which have additional options, one of which is 12 months Support We have got the "Support" option showing with the peroduct in the frontend (we have linked it an an "Option") but it's a selected option. We need to be able have have the "Support" option be set to "selected" by default. How can this be done please?") 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 months 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372257 "Hi, With several option products to pre-select, you do not want to hardcode each id in the override. The clean way is a custom product field that flags which products are pre-selected, then you check that field instead of a fixed id. 1. Go to Display > Custom Fields and create a new field with Table set to "Product" and type "Single dropdown", with two values: 0 for "No" and 1 for "Yes" (default "No"). Give it a column name, for example option_default. Publish it. It then appears on every product edit page. 2. Edit each Support product (39, 36, 13, ...) and set that new field to "Yes". Leave all the other products on "No". 3. In your option view override, replace the fixed id test with the field: Use the column name you chose in place of option_default. From then on you decide which options are pre-selected directly from the product edit page, with no further code change when you add a new product. If you would rather not add a field, you can instead list the ids in the override and add to the list over time: Note that, thinking about this, we've decided to add extra options to products for this in the next version of HikaShop. So, ideally, I would recommend switching to the new options after you update HikaShop to 6.5.1 (or a later version).") 4 months 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:300 | [Last Post](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372257 "Hi, With several option products to pre-select, you do not want to hardcode each id in the override. The clean way is a custom product field that flags which products are pre-selected, then you check that field instead of a fixed id. 1. Go to Display > Custom Fields and create a new field with Table set to "Product" and type "Single dropdown", with two values: 0 for "No" and 1 for "Yes" (default "No"). Give it a column name, for example option_default. Publish it. It then appears on every product edit page. 2. Edit each Support product (39, 36, 13, ...) and set that new field to "Yes". Leave all the other products on "No". 3. In your option view override, replace the fixed id test with the field: Use the column name you chose in place of option_default. From then on you decide which options are pre-selected directly from the product edit page, with no further code change when you add a new product. If you would rather not add a field, you can instead list the ids in the override and add to the list over time: Note that, thinking about this, we've decided to add extra options to products for this in the next version of HikaShop. So, ideally, I would recommend switching to the new options after you update HikaShop to 6.5.1 (or a later version).") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 months 2 weeks ago | | [](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372241) | [Automatically add an option as selected](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372241 "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 5.4.6 We have software products which have additional options, one of which is 12 months Support We have got the "Support" option showing with the peroduct in the frontend (we have linked it an an "Option") but it's a selected option. We need to be able have have the "Support" option be set to "selected" by default. How can this be done please?") 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 months 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372257 "Hi, With several option products to pre-select, you do not want to hardcode each id in the override. The clean way is a custom product field that flags which products are pre-selected, then you check that field instead of a fixed id. 1. Go to Display > Custom Fields and create a new field with Table set to "Product" and type "Single dropdown", with two values: 0 for "No" and 1 for "Yes" (default "No"). Give it a column name, for example option_default. Publish it. It then appears on every product edit page. 2. Edit each Support product (39, 36, 13, ...) and set that new field to "Yes". Leave all the other products on "No". 3. In your option view override, replace the fixed id test with the field: Use the column name you chose in place of option_default. From then on you decide which options are pre-selected directly from the product edit page, with no further code change when you add a new product. If you would rather not add a field, you can instead list the ids in the override and add to the list over time: Note that, thinking about this, we've decided to add extra options to products for this in the next version of HikaShop. So, ideally, I would recommend switching to the new options after you update HikaShop to 6.5.1 (or a later version).") 4 months 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:300 | [Last Post](/forum/26-product-category-display/910592-automatically-add-an-option-as-selected#372257 "Hi, With several option products to pre-select, you do not want to hardcode each id in the override. The clean way is a custom product field that flags which products are pre-selected, then you check that field instead of a fixed id. 1. Go to Display > Custom Fields and create a new field with Table set to "Product" and type "Single dropdown", with two values: 0 for "No" and 1 for "Yes" (default "No"). Give it a column name, for example option_default. Publish it. It then appears on every product edit page. 2. Edit each Support product (39, 36, 13, ...) and set that new field to "Yes". Leave all the other products on "No". 3. In your option view override, replace the fixed id test with the field: Use the column name you chose in place of option_default. From then on you decide which options are pre-selected directly from the product edit page, with no further code change when you add a new product. If you would rather not add a field, you can instead list the ids in the override and add to the list over time: Note that, thinking about this, we've decided to add extra options to products for this in the next version of HikaShop. So, ideally, I would recommend switching to the new options after you update HikaShop to 6.5.1 (or a later version).") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 4 months 2 weeks ago | | [](/forum/26-product-category-display/909621-add-to-cart-button-disappearing-then-showing-quantity#368099) | [Add to Cart button disappearing, then showing quantity](/forum/26-product-category-display/909621-add-to-cart-button-disappearing-then-showing-quantity#368099 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.3.15 For some reason, when you click "Add to Cart" this button disappears and the quantity button appears. This is really confusing as it's not very obvious that you have added a product to the cart. How can it be set to always show the "Add to Cart" button and the quantity button together?") 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 1 year 2 months ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/26-product-category-display/909621-add-to-cart-button-disappearing-then-showing-quantity#368104 "Hi, You want to turn off the "Synchronized add to cart" setting: www.hikashop.com/support/documentation/5...onfig.html#main_cart") 1 year 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:706 | [Last Post](/forum/26-product-category-display/909621-add-to-cart-button-disappearing-then-showing-quantity#368104 "Hi, You want to turn off the "Synchronized add to cart" setting: www.hikashop.com/support/documentation/5...onfig.html#main_cart") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 2 months ago | | [](/forum/26-product-category-display/907428-variant-options-hiding-price-add-to-cart-button-and-quantity#357429) | [Variant options hiding price, add to cart button and quantity](/forum/26-product-category-display/907428-variant-options-hiding-price-add-to-cart-button-and-quantity#357429 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 7.4.33 I have built an override, but when using variants on a product page and selecting the variant, the product price, quantity and Add to Cart button are hidden, so you can't add the product variant to the basket. Default view: Variant view:") 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 2 years 10 months ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/26-product-category-display/907428-variant-options-hiding-price-add-to-cart-button-and-quantity#357430 "Hi, When you select another variant, the system will replace each area on the page to display the information of the new variant. However, you ( or your template provider ) have customized the product details page ( the product / show_default view file which you can edit via the menu Display>Views ) incorrectly, with the HTML of the elements on the right side, all inside the contact button area: i.imgur.com/sSenkwC.png So when the variant system replace the contact button area in order to display the button of the newly selected variant, it replaces all that area with just the contact button. So you need to have that view override fixed by the person who made it.") 2 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:548 | [Last Post](/forum/26-product-category-display/907428-variant-options-hiding-price-add-to-cart-button-and-quantity#357430 "Hi, When you select another variant, the system will replace each area on the page to display the information of the new variant. However, you ( or your template provider ) have customized the product details page ( the product / show_default view file which you can edit via the menu Display>Views ) incorrectly, with the HTML of the elements on the right side, all inside the contact button area: i.imgur.com/sSenkwC.png So when the variant system replace the contact button area in order to display the button of the newly selected variant, it replaces all that area with just the contact button. So you need to have that view override fixed by the person who made it.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 10 months ago | | [](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356197) | [Stripe WebHook Endpoint](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356197 "-- url of the page with the problem -- : www.designs-on-silk.co.uk/ -- HikaShop version -- : 5.0.0 -- Joomla version -- : 4.2.7 I'm using the Stripe plugin for payments, and I can't find anywhere in the docs the URL to use for the webhook endpoint for a successful payment. Any ideas please?") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 3 years 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") 3 years 1 week ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:5 Views:805 | [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 3 years 1 week ago | | [](/forum/29-payment-methods/907142-stripe-webhook-endpoint#355944) | [Stripe WebHook Endpoint](/forum/29-payment-methods/907142-stripe-webhook-endpoint#355944 "-- url of the page with the problem -- : www.designs-on-silk.co.uk/ -- HikaShop version -- : 5.0.0 -- Joomla version -- : 4.2.7 I'm using the Stripe plugin for payments, and I can't find anywhere in the docs the URL to use for the webhook endpoint for a successful payment. Any ideas please?") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 3 years 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") 3 years 1 week ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:5 Views:805 | [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 3 years 1 week ago | | [](/forum/29-payment-methods/907142-stripe-webhook-endpoint#355928) | [Stripe WebHook Endpoint](/forum/29-payment-methods/907142-stripe-webhook-endpoint#355928 "-- url of the page with the problem -- : www.designs-on-silk.co.uk/ -- HikaShop version -- : 5.0.0 -- Joomla version -- : 4.2.7 I'm using the Stripe plugin for payments, and I can't find anywhere in the docs the URL to use for the webhook endpoint for a successful payment. Any ideas please?") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 3 years 2 weeks ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") 3 years 1 week ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:5 Views:805 | [Last Post](/forum/29-payment-methods/907142-stripe-webhook-endpoint#356200 "Hello, Please provide a screenshot of the error (and you can blank your email address from it). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 3 years 1 week ago | | [](/forum/4-how-to/866752-show-product-image-in-search-results#354283) | [Show product image in search results](/forum/4-how-to/866752-show-product-image-in-search-results#354283 "How would I show products in a search result with images. At the moment the product name and desc shows however the most important thing i think is the product image as people instantly know what they want. Thanks Alex") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 12 years 7 months ago, by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") [Last Post](/forum/4-how-to/866752-show-product-image-in-search-results#354287 "Hi, I'm not sure what you mean. When you search something on Google for example, you have the search input field at the top, potential filters below, and then below the results listing. If you create a products listing menu item displaying all your products and activate its filters display setting, you'll get a similar setup. If you want a page, like the Google homepage where you only have an input field and no results, you can do like this: - create an empty Joomla article and create a menu item to display that empty Joomla article. - create an instance of the HikaShop filter module via the Joomla module manager and assign it to this joomla article menu item. And in its settings, make sure that the "menu" setting is set to a menu item displaying all the products so that the user can see the results through that menu item listing.") 3 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:1726 | [Last Post](/forum/4-how-to/866752-show-product-image-in-search-results#354287 "Hi, I'm not sure what you mean. When you search something on Google for example, you have the search input field at the top, potential filters below, and then below the results listing. If you create a products listing menu item displaying all your products and activate its filters display setting, you'll get a similar setup. If you want a page, like the Google homepage where you only have an input field and no results, you can do like this: - create an empty Joomla article and create a menu item to display that empty Joomla article. - create an instance of the HikaShop filter module via the Joomla module manager and assign it to this joomla article menu item. And in its settings, make sure that the "menu" setting is set to a menu item displaying all the products so that the user can see the results through that menu item listing.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 2 months ago | | [](/forum/26-product-category-display/906851-edit-the-price-layout-in-the-checkout#354235) | [Edit the price layout in the checkout](/forum/26-product-category-display/906851-edit-the-price-layout-in-the-checkout#354235 "-- url of the page with the problem -- : store.alpha-electronics.com/ -- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 -- PHP version -- : 7.4.33 How can I change the way the price is shown? It's shown like this currently: but I'd like it to show like this:") 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 3 years 2 months ago, by [Storm](/forum/user/42764-storm "View Storm's Profile") [Last Post](/forum/26-product-category-display/906851-edit-the-price-layout-in-the-checkout#354241 "Hi, What you want to do is to edit the view file product / listing_price via the menu Display>Views. That's the view displaying the prices area. There, the price with taxes is displayed by this code: and the price without taxes by this one: So you can switch them and adapt the translations around, or add extra text directly in there as you see fit.") 3 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:514 | [Last Post](/forum/26-product-category-display/906851-edit-the-price-layout-in-the-checkout#354241 "Hi, What you want to do is to edit the view file product / listing_price via the menu Display>Views. That's the view displaying the prices area. There, the price with taxes is displayed by this code: and the price without taxes by this one: So you can switch them and adapt the translations around, or add extra text directly in there as you see fit.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 2 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.103 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)