[Skip to main content](#vessel-content) # Profile for Mitrax ## [![Mitrax's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8602-mitrax "View Mitrax's Profile") **[ Offline](/forum/user/8602-mitrax)** - **User Type:** User - **Register Date:** 17 Aug 2012 - **Last login:** 2 years 11 months ago - **Time Zone:** UTC +10:00 - **Local Time:** 07:18 - **Posts:** 76 - **Profile views:** 237 - **Thank you received:** 5 - **Gender:** Unknown [ Mitrax Trading](http://www.mitrax.com.au) > MItrax Trading > [ www.mitrax.com.au](http://www.mitrax.com.au) - Posts # Mitrax's recent posts (76 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/907416-hikashop-admin-displayed-without-any-styling#357376) | [Hikashop Admin displayed without any styling](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357376 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : Joomla! 4.4.1 Stable [ Pamoja ] 28-November-2023 16:00 GMT -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome Version 120.0.6099.71 (Official Build) (x86_64) -- Error-message(debug-mod must be tuned on) -- : No error message Recently updated to Joomla 4 and at some point admin for Hikashop ahs lost all styling. Backends for other Joomla components are fine.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 2 years 11 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357376 "Thanks Nicolas, Not sure what was going on yesterday , possibly some sort of caching issue, but I am now getting an error message indicating crashed table. Repaired hikashop_cart table and all is ok now. Thanks for your help. Cheers Rob") 2 years 11 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:557 | [Last Post](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357376 "Thanks Nicolas, Not sure what was going on yesterday , possibly some sort of caching issue, but I am now getting an error message indicating crashed table. Repaired hikashop_cart table and all is ok now. Thanks for your help. Cheers Rob") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 2 years 11 months ago | | [](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357369) | [Hikashop Admin displayed without any styling](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357369 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : Joomla! 4.4.1 Stable [ Pamoja ] 28-November-2023 16:00 GMT -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome Version 120.0.6099.71 (Official Build) (x86_64) -- Error-message(debug-mod must be tuned on) -- : No error message Recently updated to Joomla 4 and at some point admin for Hikashop ahs lost all styling. Backends for other Joomla components are fine.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 2 years 11 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357376 "Thanks Nicolas, Not sure what was going on yesterday , possibly some sort of caching issue, but I am now getting an error message indicating crashed table. Repaired hikashop_cart table and all is ok now. Thanks for your help. Cheers Rob") 2 years 11 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:557 | [Last Post](/forum/25-install-update/907416-hikashop-admin-displayed-without-any-styling#357376 "Thanks Nicolas, Not sure what was going on yesterday , possibly some sort of caching issue, but I am now getting an error message indicating crashed table. Repaired hikashop_cart table and all is ok now. Thanks for your help. Cheers Rob") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 2 years 11 months ago | | [](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792) | [Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "-- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0.29 -- Browser(s) name and version -- : Chrome 114.0.5735.198 -- Error-message(debug-mod must be tuned on) -- : N/A Hi, I'm trying to copy my Joomla database in preparation for a J4 migration and it is failing due to insufficient permissions to execute the following SQL. CREATE ALGORITHM=UNDEFINED DEFINER=`xxxxx`@`localhost` SQL SECURITY DEFINER VIEW `xxxxx`.`pwmku_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id`, sum(`b`.`click_partner_price`) AS `click_price` FROM (`pwmku_hikashop_user` `a` left join `pwmku_hikashop_click` `b` on(`a`.`user_id` = `b`.`click_partner_id` and case when `a`.`user_currency_id` = 0 then 6 else `a`.`user_currency_id` end = `b`.`click_partner_currency_id`)) WHERE `a`.`user_partner_activated` = 1 AND `b`.`click_partner_paid` = 0 GROUP BY `b`.`click_partner_id` ; note: user details have been changed. I'm working with my hosting provider to attempt to resolve the issue but I would like to know how important this VIEW is for the correct functioning of Hikashop and If you have any suggested solutions. Any help is appreciated . Rob") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:4 Views:662 | [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353783) | [Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353783 "-- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0.29 -- Browser(s) name and version -- : Chrome 114.0.5735.198 -- Error-message(debug-mod must be tuned on) -- : N/A Hi, I'm trying to copy my Joomla database in preparation for a J4 migration and it is failing due to insufficient permissions to execute the following SQL. CREATE ALGORITHM=UNDEFINED DEFINER=`xxxxx`@`localhost` SQL SECURITY DEFINER VIEW `xxxxx`.`pwmku_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id`, sum(`b`.`click_partner_price`) AS `click_price` FROM (`pwmku_hikashop_user` `a` left join `pwmku_hikashop_click` `b` on(`a`.`user_id` = `b`.`click_partner_id` and case when `a`.`user_currency_id` = 0 then 6 else `a`.`user_currency_id` end = `b`.`click_partner_currency_id`)) WHERE `a`.`user_partner_activated` = 1 AND `b`.`click_partner_paid` = 0 GROUP BY `b`.`click_partner_id` ; note: user details have been changed. I'm working with my hosting provider to attempt to resolve the issue but I would like to know how important this VIEW is for the correct functioning of Hikashop and If you have any suggested solutions. Any help is appreciated . Rob") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:4 Views:662 | [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353747) | [Error when attempting to copy Joomla database](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353747 "-- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0.29 -- Browser(s) name and version -- : Chrome 114.0.5735.198 -- Error-message(debug-mod must be tuned on) -- : N/A Hi, I'm trying to copy my Joomla database in preparation for a J4 migration and it is failing due to insufficient permissions to execute the following SQL. CREATE ALGORITHM=UNDEFINED DEFINER=`xxxxx`@`localhost` SQL SECURITY DEFINER VIEW `xxxxx`.`pwmku_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id`, sum(`b`.`click_partner_price`) AS `click_price` FROM (`pwmku_hikashop_user` `a` left join `pwmku_hikashop_click` `b` on(`a`.`user_id` = `b`.`click_partner_id` and case when `a`.`user_currency_id` = 0 then 6 else `a`.`user_currency_id` end = `b`.`click_partner_currency_id`)) WHERE `a`.`user_partner_activated` = 1 AND `b`.`click_partner_paid` = 0 GROUP BY `b`.`click_partner_id` ; note: user details have been changed. I'm working with my hosting provider to attempt to resolve the issue but I would like to know how important this VIEW is for the correct functioning of Hikashop and If you have any suggested solutions. Any help is appreciated . Rob") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:4 Views:662 | [Last Post](/forum/25-install-update/906778-error-when-attempting-to-copy-joomla-database#353792 "Thanks Nicolas, Problem is solved now. FYI The affiliate plugin was not enabled and even after I uninstalled it the views were still in the database so I dropped them manually. The view also contained a user which was not assigned to the database so I suspect that they are leftovers from something that I have done in the past. Table and Row counts matched identically straight after the copy so I am good to move on to the next step now. Thanks again. Rob") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654) | [Joomla 4 upgrade errors for plugins](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654 "-- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0.29 -- Browser(s) name and version -- : Chrome 114.0.5735.198 -- Error-message(debug-mod must be tuned on) -- : N/A Hi , I'm preparing for a Joomla 4 upgrade and get the attached strong warnings. A few questions: - Which of these Hikashop plugins can I safely disable ? - Do I really need to worry about these ? - What is causing Joomla to create these warnings and make this strong recommendation ? Cheers Rob") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654 "Thankyou, appreciated.") 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:707 | [Last Post](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654 "Thankyou, appreciated.") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353623) | [Joomla 4 upgrade errors for plugins](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353623 "-- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.0.29 -- Browser(s) name and version -- : Chrome 114.0.5735.198 -- Error-message(debug-mod must be tuned on) -- : N/A Hi , I'm preparing for a Joomla 4 upgrade and get the attached strong warnings. A few questions: - Which of these Hikashop plugins can I safely disable ? - Do I really need to worry about these ? - What is causing Joomla to create these warnings and make this strong recommendation ? Cheers Rob") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654 "Thankyou, appreciated.") 3 years 3 months ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:707 | [Last Post](/forum/25-install-update/906751-joomla-4-upgrade-errors-for-plugins#353654 "Thankyou, appreciated.") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 3 years 3 months ago | | [](/forum/26-product-category-display/901026-which-file-to-edit-stock-quantity-in-category-view#325016) | [Which file to edit stock quantity in category view](/forum/26-product-category-display/901026-which-file-to-edit-stock-quantity-in-category-view#325016 "-- url of the page with the problem -- : www.mitrax.com.au/ -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.3.23 -- Browser(s) name and version -- : Chrome/86.0.4240.80 -- Error-message(debug-mod must be tuned on) -- : N/A Hi, I want to format the layout of products on my category page so that add to cart button is on a different line to stock quantity. I can find the file for product quantity but haven't been able to locate file with stock quantity for category view. Could you tell me which file I need to edit please ? Cheers Rob") 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 6 years 2 weeks ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/26-product-category-display/901026-which-file-to-edit-stock-quantity-in-category-view#325037 "Hello, I will answer you question by showing how you can easily find a view, but I have a better solution for you via Css. 1. Trouver les références des vues HikaShop, à partir de la page principale de configuration d'HikaShop, allez sur l'onglet Advanced, puis vous verrez immédiatement l'option Display view files (dans la partie Advanced settings) activé là sur frontend. Résultat : Vous aurez chaque vue qui sera annoté avec son nom et sa réference. 2. La solution pour vous besoin le plus simple est éfficace , et de changer le mode de display de vos éléments. Concrétement passer de "display: inline;" pour "display: block;" => Pour ajouter du custom Css, regardez . Puis créez une bonne commande Css, comme ce pseudo code par exemple : En espérant que cela conviendra pour avoir ce dont vous avez besoin. Cordialement") 6 years 2 weeks ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:1 Views:546 | [Last Post](/forum/26-product-category-display/901026-which-file-to-edit-stock-quantity-in-category-view#325037 "Hello, I will answer you question by showing how you can easily find a view, but I have a better solution for you via Css. 1. Trouver les références des vues HikaShop, à partir de la page principale de configuration d'HikaShop, allez sur l'onglet Advanced, puis vous verrez immédiatement l'option Display view files (dans la partie Advanced settings) activé là sur frontend. Résultat : Vous aurez chaque vue qui sera annoté avec son nom et sa réference. 2. La solution pour vous besoin le plus simple est éfficace , et de changer le mode de display de vos éléments. Concrétement passer de "display: inline;" pour "display: block;" => Pour ajouter du custom Css, regardez . Puis créez une bonne commande Css, comme ce pseudo code par exemple : En espérant que cela conviendra pour avoir ce dont vous avez besoin. Cordialement") by [Philip](/forum/user/34318-philip "View Philip's Profile") 6 years 2 weeks ago | | [](/forum/27-checkout/901018-change-guest-information#324994) | [Change guest information](/forum/27-checkout/901018-change-guest-information#324994 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.3.23 -- Browser(s) name and version -- : Chrome 86.0.4240.80 -- Error-message(debug-mod must be tuned on) -- : None Hi, I'm trying to make my checkout process as simple as possible but just don't seem to be able to get it "just right" Is there any way to get rid of the change guest information button or make it display something more useful ? At the moment I have cart → quick guest checkout → Address, shipping, payment which almost does what I want Unfortunately after the guest details screen it doesn't take me straight to Address, shipping, payment . Instead it puts an extra "change guest information" step in with nothing else on the page and displays very little information other than an email address. Is there any way I can make this work better e.g. get rid of the extra step , combine it with the next step or some other way of streamlining things ? Any advice regarding simplest the most user-friendly way to setup checkout would also be appreciated. Cheers Rob") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 6 years 3 weeks ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/27-checkout/901018-change-guest-information#324994 "Thanks Nicolas, appreciate the quick reply") 6 years 3 weeks ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:550 | [Last Post](/forum/27-checkout/901018-change-guest-information#324994 "Thanks Nicolas, appreciate the quick reply") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 6 years 3 weeks ago | | [](/forum/27-checkout/901018-change-guest-information#324978) | [Change guest information](/forum/27-checkout/901018-change-guest-information#324978 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.3.23 -- Browser(s) name and version -- : Chrome 86.0.4240.80 -- Error-message(debug-mod must be tuned on) -- : None Hi, I'm trying to make my checkout process as simple as possible but just don't seem to be able to get it "just right" Is there any way to get rid of the change guest information button or make it display something more useful ? At the moment I have cart → quick guest checkout → Address, shipping, payment which almost does what I want Unfortunately after the guest details screen it doesn't take me straight to Address, shipping, payment . Instead it puts an extra "change guest information" step in with nothing else on the page and displays very little information other than an email address. Is there any way I can make this work better e.g. get rid of the extra step , combine it with the next step or some other way of streamlining things ? Any advice regarding simplest the most user-friendly way to setup checkout would also be appreciated. Cheers Rob") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 6 years 3 weeks ago, by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") [Last Post](/forum/27-checkout/901018-change-guest-information#324994 "Thanks Nicolas, appreciate the quick reply") 6 years 3 weeks ago by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") | Replies:2 Views:550 | [Last Post](/forum/27-checkout/901018-change-guest-information#324994 "Thanks Nicolas, appreciate the quick reply") by [Mitrax](/forum/user/8602-mitrax "View Mitrax's Profile") 6 years 3 weeks ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)