[Skip to main content](#vessel-content)
# Profile for AnnaM
##
[](/forum/user/37022-annam "View AnnaM's Profile")
**[ Offline](/forum/user/37022-annam)**
- **User Type:** User
- **Register Date:** 21 Apr 2015
- **Last login:** 10 years 4 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 04:49
- **Posts:** 6
- **Profile views:** 65
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# AnnaM's recent posts (6 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/3-bug-report/883339-error-message-when-going-into-order#234374) | [error message when going into "order"](/forum/3-bug-report/883339-error-message-when-going-into-order#234374 "-- url of the page with the problem -- : www.brainsugarhealth.com -- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.5.0 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : When going into "orders" this is the error I get: **An error has occurred.** 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM jos_hikashop_order AS b LEFT JOIN jos_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN jos_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN jos_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Call stack # Function Location 1 JApplicationCms->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/index.php:51 2 JApplicationAdministrator->doExecute() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/cms.php:257 3 JApplicationAdministrator->dispatch() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/administrator.php:152 4 JComponentHelper::renderComponent() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/administrator.php:98 5 JComponentHelper::executeComponent() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/component/helper.php:380 6 require_once() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/component/helper.php:405 7 hikashopController->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/hikashop.php:54 8 JControllerLegacy->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1628 9 hikashopController->listing() /home/zerogsol/public_html/brainsugarhealth.com/libraries/legacy/controller/legacy.php:728 10 hikashopController->display() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1382 11 JControllerLegacy->display() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1648 12 OrderViewOrder->display() /home/zerogsol/public_html/brainsugarhealth.com/libraries/legacy/controller/legacy.php:690 13 OrderViewOrder->listing() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/views/order/view.html.php:26 14 JDatabaseDriver->loadObjectList() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/views/order/view.html.php:167 15 JDatabaseDriverMysqli->execute() /home/zerogsol/public_html/brainsugarhealth.com/libraries/joomla/database/driver.php:1692 Hello please advise how I might remedy this issue. When going into orders, I am receiving error message. thanks, Pam") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 10 years 7 months ago, by [pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile") [Last Post](/forum/3-bug-report/883339-error-message-when-going-into-order#234374 "I had same problem after upgrading to Joomla latest version. Thanks for heads up :)") 10 years 7 months ago by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") | Replies:3 Views:1357 | [Last Post](/forum/3-bug-report/883339-error-message-when-going-into-order#234374 "I had same problem after upgrading to Joomla latest version. Thanks for heads up :)") by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") 10 years 7 months ago |
| [](/forum/26-product-category-display/881046-add-button-is-out-of-square#223936) | [Add button is out of square](/forum/26-product-category-display/881046-add-button-is-out-of-square#223936 "-- HikaShop version -- : 3.6.0. -- Joomla version -- : 3.4.5 When you select a category, I see all the products and the Add button is out of square. How can I solve that?") 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 years 10 months ago, by [rober1903](/forum/user/37591-rober1903 "View rober1903's Profile") [Last Post](/forum/26-product-category-display/881046-add-button-is-out-of-square#223980 "Hi, The issue is with the CSS of your Joomla template which forces the width of the quantity field and thus shifts the add to cart button to the right. Fix the CSS of your template, or turn off the "Display the quantity field on the product page" setting of the HikaShop configuration in order to remove the quantity field all together and it should display fine.") 10 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:621 | [Last Post](/forum/26-product-category-display/881046-add-button-is-out-of-square#223980 "Hi, The issue is with the CSS of your Joomla template which forces the width of the quantity field and thus shifts the add to cart button to the right. Fix the CSS of your template, or turn off the "Display the quantity field on the product page" setting of the HikaShop configuration in order to remove the quantity field all together and it should display fine.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 10 months ago |
| [](/forum/30-integrations/879734-sh404-and-hard-coding-of-choose-options-button#216653) | [Sh404 and hard coding of Choose Options Button](/forum/30-integrations/879734-sh404-and-hard-coding-of-choose-options-button#216653 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.4 -- PHP version -- : 5.6.5 -- Browser(s) name and version -- : Safari. v 9.0 Hi there, I've recently installed sh404 by weeblr to deal with 404 errors on my site. I have a problem with making this work with hika shop however. When i have sh404 enabled and click the usual 'choose options' button to be taken to the product page in my shop i get a 404 error. I have been in touch with the guys at sh404sef and they said: ----- Because it's hardcoded, instead of following the Joomla API for URLs, then the non-sef is never passed to sh404SEF which cannot create and record a SEF URL for it. Please note that this is not related to sh404SEF. The above screen shot was done with sh404SEF disabled and Joomla SEF disabled as well, and you get the same problem. In other words, the Joomla SEF URLs are hardcoded in your button and nothing can replace them. ----- Is there a setting i can alter to make this hika shop work with sh404sef correctly? Or anything else I can do to make it work? Thanks. Andy.") Category: [Integrations](/forum/30-integrations "Informations on all the different integrations available for Hikashop") Topic started 11 years 2 weeks ago, by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") [Last Post](/forum/30-integrations/879734-sh404-and-hard-coding-of-choose-options-button#216679 "Hi, The URL is not hard coded of course. If it was, it would be the same for all the products :) I suppose that the issue is that you have canonical URLs in your products and that you have the "force canonical URLs on listings" setting activated in the HikaShop configuration. And then, you installed SH404SEF, but since HikaShop already has canonical URLs in the products, it doesn't recalculate them through the SEF system but directly use them in the listings. SH404SEF doesn't have any knowledge of the non-SEF URL equivalent of the canonical URL and thus can't translate it, but Joomla's SEF doesn't have that problem as it dynamically recalculates its non-SEF equivalent. So you have two solutions: - You turn off the "force canonical URLs on listings" setting. - You clear the canonical URL of your products.") 11 years 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1123 | [Last Post](/forum/30-integrations/879734-sh404-and-hard-coding-of-choose-options-button#216679 "Hi, The URL is not hard coded of course. If it was, it would be the same for all the products :) I suppose that the issue is that you have canonical URLs in your products and that you have the "force canonical URLs on listings" setting activated in the HikaShop configuration. And then, you installed SH404SEF, but since HikaShop already has canonical URLs in the products, it doesn't recalculate them through the SEF system but directly use them in the listings. SH404SEF doesn't have any knowledge of the non-SEF URL equivalent of the canonical URL and thus can't translate it, but Joomla's SEF doesn't have that problem as it dynamically recalculates its non-SEF equivalent. So you have two solutions: - You turn off the "force canonical URLs on listings" setting. - You clear the canonical URL of your products.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 2 weeks ago |
| [](/forum/27-checkout/879119-response-to-your-email#214014) | [Response to your email](/forum/27-checkout/879119-response-to-your-email#214014 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.6.5 -- Browser(s) name and version -- : Firefox, Chrome, Safari -- Error-message(debug-mod must be tuned on) -- : none Nicolas, I have done everything you suggested re the settings, and in fact had changed many of them before I contacted you yesterday. Please see attached jpgs of setting and my added notes. I think it tells the story. Thanks Anna") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 11 years 1 month ago, by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") [Last Post](/forum/27-checkout/879119-response-to-your-email#214373 "Hi, I've added my own email address as BCC of your order status notification: take.ms/XlhYP I've then created an order on the frontend, and I went in the backend, edited the order, and changed its status to confirmed: take.ms/9tF2I I correctly received a copy of the order status notification on that email address: take.ms/nxnp7 And you should have received one too. So the emails are working exactly as they should, as I said previously. I've however checked your orders listing and I see that no orders status was automatically changed to confirmed. So it seems that your issue is with that. HikaShop is not being notified that the payment was made. This usually comes either from the setup of the payment method, or an issue on the server. Looking at your payment method settings, I see that you didn't configure any MD5 Hash. That is necessary to cofnigure it, both in your payment method settings in HikaShop, and in your merchant account on your payment gateway. Also, you turned off the "Instant Capture" setting of your payment method, which means that your payments are not validated automatically by your payment gateway. And finally, you also turned off the setting "Allow payment notifications from %s" of your payment method, which means that your payment gateway payment notifications will be refused by your website so that you'll have to manually confirm the orders. All of this is probably why you thought that there was a problem with the emails not being sent while in fact it's just a matter of correct configuring your payment method.") 11 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:675 | [Last Post](/forum/27-checkout/879119-response-to-your-email#214373 "Hi, I've added my own email address as BCC of your order status notification: take.ms/XlhYP I've then created an order on the frontend, and I went in the backend, edited the order, and changed its status to confirmed: take.ms/9tF2I I correctly received a copy of the order status notification on that email address: take.ms/nxnp7 And you should have received one too. So the emails are working exactly as they should, as I said previously. I've however checked your orders listing and I see that no orders status was automatically changed to confirmed. So it seems that your issue is with that. HikaShop is not being notified that the payment was made. This usually comes either from the setup of the payment method, or an issue on the server. Looking at your payment method settings, I see that you didn't configure any MD5 Hash. That is necessary to cofnigure it, both in your payment method settings in HikaShop, and in your merchant account on your payment gateway. Also, you turned off the "Instant Capture" setting of your payment method, which means that your payments are not validated automatically by your payment gateway. And finally, you also turned off the setting "Allow payment notifications from %s" of your payment method, which means that your payment gateway payment notifications will be refused by your website so that you'll have to manually confirm the orders. All of this is probably why you thought that there was a problem with the emails not being sent while in fact it's just a matter of correct configuring your payment method.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 1 month ago |
| [](/forum/27-checkout/879119-response-to-your-email#213411) | [Response to your email](/forum/27-checkout/879119-response-to-your-email#213411 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.6.5 -- Browser(s) name and version -- : Firefox, Chrome, Safari -- Error-message(debug-mod must be tuned on) -- : none Nicolas, I have done everything you suggested re the settings, and in fact had changed many of them before I contacted you yesterday. Please see attached jpgs of setting and my added notes. I think it tells the story. Thanks Anna") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 11 years 1 month ago, by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") [Last Post](/forum/27-checkout/879119-response-to-your-email#214373 "Hi, I've added my own email address as BCC of your order status notification: take.ms/XlhYP I've then created an order on the frontend, and I went in the backend, edited the order, and changed its status to confirmed: take.ms/9tF2I I correctly received a copy of the order status notification on that email address: take.ms/nxnp7 And you should have received one too. So the emails are working exactly as they should, as I said previously. I've however checked your orders listing and I see that no orders status was automatically changed to confirmed. So it seems that your issue is with that. HikaShop is not being notified that the payment was made. This usually comes either from the setup of the payment method, or an issue on the server. Looking at your payment method settings, I see that you didn't configure any MD5 Hash. That is necessary to cofnigure it, both in your payment method settings in HikaShop, and in your merchant account on your payment gateway. Also, you turned off the "Instant Capture" setting of your payment method, which means that your payments are not validated automatically by your payment gateway. And finally, you also turned off the setting "Allow payment notifications from %s" of your payment method, which means that your payment gateway payment notifications will be refused by your website so that you'll have to manually confirm the orders. All of this is probably why you thought that there was a problem with the emails not being sent while in fact it's just a matter of correct configuring your payment method.") 11 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:675 | [Last Post](/forum/27-checkout/879119-response-to-your-email#214373 "Hi, I've added my own email address as BCC of your order status notification: take.ms/XlhYP I've then created an order on the frontend, and I went in the backend, edited the order, and changed its status to confirmed: take.ms/9tF2I I correctly received a copy of the order status notification on that email address: take.ms/nxnp7 And you should have received one too. So the emails are working exactly as they should, as I said previously. I've however checked your orders listing and I see that no orders status was automatically changed to confirmed. So it seems that your issue is with that. HikaShop is not being notified that the payment was made. This usually comes either from the setup of the payment method, or an issue on the server. Looking at your payment method settings, I see that you didn't configure any MD5 Hash. That is necessary to cofnigure it, both in your payment method settings in HikaShop, and in your merchant account on your payment gateway. Also, you turned off the "Instant Capture" setting of your payment method, which means that your payments are not validated automatically by your payment gateway. And finally, you also turned off the setting "Allow payment notifications from %s" of your payment method, which means that your payment gateway payment notifications will be refused by your website so that you'll have to manually confirm the orders. All of this is probably why you thought that there was a problem with the emails not being sent while in fact it's just a matter of correct configuring your payment method.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 1 month ago |
| [](/forum/26-product-category-display/876694-can-i-list-individual-sub-categories-of-choice-in-menu#200321) | [Can i list individual sub categories of choice in menu?](/forum/26-product-category-display/876694-can-i-list-individual-sub-categories-of-choice-in-menu#200321 "-- HikaShop version -- : [1504151033] -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3.24 -- Browser(s) name and version -- : Safari 8.0.4 I want to create a new joomla menu where i can link individual category and sub category items of my choice. Is this possible? If so how? i can't seem to find a way and I'm stuck in an ocean of settings without any idea of what to do. Thanks. Andy") 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 11 years 5 months ago, by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") [Last Post](/forum/26-product-category-display/876694-can-i-list-individual-sub-categories-of-choice-in-menu#200343 "Hi, I'm not sure I understand what you want to do. If you want to create a menu item for a category so that when you click on it it displays the sub categories in the main area of the page, you can follow this tutorial: www.hikashop.com/support/documentation/6...html#categories_menu") 11 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:439 | [Last Post](/forum/26-product-category-display/876694-can-i-list-individual-sub-categories-of-choice-in-menu#200343 "Hi, I'm not sure I understand what you want to do. If you want to create a menu item for a category so that when you click on it it displays the sub categories in the main area of the page, you can follow this tutorial: www.hikashop.com/support/documentation/6...html#categories_menu") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 5 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.153 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)