[Skip to main content](#vessel-content)
# Profile for It-networks
##
[](/forum/user/34698-it-networks "View It-networks's Profile")
**[ Offline](/forum/user/34698-it-networks)**
- **User Type:** User
- **Register Date:** 23 Oct 2014
- **Last login:** 10 years 7 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 21:07
- **Posts:** 1
- **Profile views:** 15
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# It-networks recent posts (1 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/872544-sql-error-when-trying-to-go-to-orders-page#176723) | [SQL Error when trying to go to orders-page](/forum/25-install-update/872544-sql-error-when-trying-to-go-to-orders-page#176723 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.25 -- Browser(s) name and version -- : Google Chrome 38.0.2125.104 m -- Error-message(debug-mod must be tuned on) -- : Error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=EXPLAIN EXTENDED SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM m8syu_hikashop_order AS b LEFT JOIN m8syu_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN m8syu_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN m8syu_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Get that sql error when trying to enter orders-page either in admin side->components->Hikashop->Orders or in Hikashop and via the Orders-menu->Orders. So mainly, the problem is that I can't get to Orders-page at all. This happened after I updated my starter-version to the business version.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 3 days ago, by [It-networks](/forum/user/34698-it-networks "View It-networks's Profile") [Last Post](/forum/25-install-update/872544-sql-error-when-trying-to-go-to-orders-page#176732 "Hi, The problem seems to be that you created your MySQL table with a "latin1" collation instead of "'utf8_general_ci" or vice versa. stackoverflow.com/questions/5906585/change-database-collation Please backup before anything.") 12 years 3 days ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:1 Views:322 | [Last Post](/forum/25-install-update/872544-sql-error-when-trying-to-go-to-orders-page#176732 "Hi, The problem seems to be that you created your MySQL table with a "latin1" collation instead of "'utf8_general_ci" or vice versa. stackoverflow.com/questions/5906585/change-database-collation Please backup before anything.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 3 days ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.132 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)