[Skip to main content](#vessel-content)
# Profile for tedfrazier
##
[](/forum/user/13305-tedfrazier "View tedfrazier's Profile")
**[ Offline](/forum/user/13305-tedfrazier)**
- **User Type:** User
- **Register Date:** 01 Feb 2013
- **Last login:** 13 years 9 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 04:13
- **Posts:** 2
- **Profile views:** 78
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# tedfrazier's recent posts (2 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/77954-mysql-command-error-on-product-list-in-admin#88253) | [MySQL command error on product list in admin](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#88253 "whenever I try to go here: . . . /administrator/index.php?option=com_hikashop&ctrl=product I get this: An error has occurred. 500 SQL=SELECT a.ordering, b.* FROM hikashop_product_category AS a LEFT JOIN hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id=2 AND b.product_type = 'main' ORDER BY a.category_name asc LIMIT 0, 20 Error in query: Unknown column 'a.category_name' in 'order clause'") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 13 years 9 months ago, by [tedfrazier](/forum/user/13305-tedfrazier "View tedfrazier's Profile") [Last Post](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#108291 "Hi, It's not that simple. The order by of the query is generated dynamically based on the title that is selected for the ordering on the listing. By default the products listing is ordered by the "ordering" column. So if you logout and login again, that should wipe out your user session and thus the title selection for the ordering and it should go back to the default "ordering" title of the products listing. If you want to look at the code, you can see that in administrator/components/com_hikashop/views/view.html.php, you have the line: $pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order', 'a.ordering','cmd' ); which loads the ordering title from the user selection/user session. And as you can see, the default column is a.ordering and not category_name. So I can't see how that's possible that you have the category_name title used for the ordering of the listing after a user session wipe out. At least, we are not able to reproduce the problem on our end and no one else besides you too reported the issue so I can only think of something that you have in common on your website which other users don't have. If there was such issue by default in HikaShop which would have had 100s of people reporting the issue since last release. Can you provide a backend access to your website so that we can see that error as otherwise we won't be able to move forward on the issue ?") 13 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9 Views:2247 | [Last Post](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#108291 "Hi, It's not that simple. The order by of the query is generated dynamically based on the title that is selected for the ordering on the listing. By default the products listing is ordered by the "ordering" column. So if you logout and login again, that should wipe out your user session and thus the title selection for the ordering and it should go back to the default "ordering" title of the products listing. If you want to look at the code, you can see that in administrator/components/com_hikashop/views/view.html.php, you have the line: $pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order', 'a.ordering','cmd' ); which loads the ordering title from the user selection/user session. And as you can see, the default column is a.ordering and not category_name. So I can't see how that's possible that you have the category_name title used for the ordering of the listing after a user session wipe out. At least, we are not able to reproduce the problem on our end and no one else besides you too reported the issue so I can only think of something that you have in common on your website which other users don't have. If there was such issue by default in HikaShop which would have had 100s of people reporting the issue since last release. Can you provide a backend access to your website so that we can see that error as otherwise we won't be able to move forward on the issue ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 13 years 4 months ago |
| [](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#88199) | [MySQL command error on product list in admin](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#88199 "whenever I try to go here: . . . /administrator/index.php?option=com_hikashop&ctrl=product I get this: An error has occurred. 500 SQL=SELECT a.ordering, b.* FROM hikashop_product_category AS a LEFT JOIN hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id=2 AND b.product_type = 'main' ORDER BY a.category_name asc LIMIT 0, 20 Error in query: Unknown column 'a.category_name' in 'order clause'") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 13 years 9 months ago, by [tedfrazier](/forum/user/13305-tedfrazier "View tedfrazier's Profile") [Last Post](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#108291 "Hi, It's not that simple. The order by of the query is generated dynamically based on the title that is selected for the ordering on the listing. By default the products listing is ordered by the "ordering" column. So if you logout and login again, that should wipe out your user session and thus the title selection for the ordering and it should go back to the default "ordering" title of the products listing. If you want to look at the code, you can see that in administrator/components/com_hikashop/views/view.html.php, you have the line: $pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order', 'a.ordering','cmd' ); which loads the ordering title from the user selection/user session. And as you can see, the default column is a.ordering and not category_name. So I can't see how that's possible that you have the category_name title used for the ordering of the listing after a user session wipe out. At least, we are not able to reproduce the problem on our end and no one else besides you too reported the issue so I can only think of something that you have in common on your website which other users don't have. If there was such issue by default in HikaShop which would have had 100s of people reporting the issue since last release. Can you provide a backend access to your website so that we can see that error as otherwise we won't be able to move forward on the issue ?") 13 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9 Views:2247 | [Last Post](/forum/3-bug-report/77954-mysql-command-error-on-product-list-in-admin#108291 "Hi, It's not that simple. The order by of the query is generated dynamically based on the title that is selected for the ordering on the listing. By default the products listing is ordered by the "ordering" column. So if you logout and login again, that should wipe out your user session and thus the title selection for the ordering and it should go back to the default "ordering" title of the products listing. If you want to look at the code, you can see that in administrator/components/com_hikashop/views/view.html.php, you have the line: $pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order', 'a.ordering','cmd' ); which loads the ordering title from the user selection/user session. And as you can see, the default column is a.ordering and not category_name. So I can't see how that's possible that you have the category_name title used for the ordering of the listing after a user session wipe out. At least, we are not able to reproduce the problem on our end and no one else besides you too reported the issue so I can only think of something that you have in common on your website which other users don't have. If there was such issue by default in HikaShop which would have had 100s of people reporting the issue since last release. Can you provide a backend access to your website so that we can see that error as otherwise we won't be able to move forward on the issue ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 13 years 4 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.067 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)