- Posts: 104
- Thank you received: 10
Error in SQL
- Impression eStudio
- Topic Author
- Offline
- Premium Member
-
Less
More
8 years 6 months ago #88642
by Impression eStudio
Error in SQL was created by Impression eStudio
Hi,
I was adding Customer Groups and suddenly the following message appeared:
Unknown column 'a.customergroup_name' in 'order clause' SQL=SELECT a.*, customergroup_name FROM #__eshop_customergroups AS a INNER JOIN #__eshop_customergroupdetails AS b ON (a.id = b.customergroup_id) WHERE b.language = "el-GR" ORDER BY a.customergroup_name asc LIMIT 100
I was adding Customer Groups and suddenly the following message appeared:
Unknown column 'a.customergroup_name' in 'order clause' SQL=SELECT a.*, customergroup_name FROM #__eshop_customergroups AS a INNER JOIN #__eshop_customergroupdetails AS b ON (a.id = b.customergroup_id) WHERE b.language = "el-GR" ORDER BY a.customergroup_name asc LIMIT 100
Please Log in or Create an account to join the conversation.
- Giang Dinh Truong
-
- Offline
- Administrator
-
8 years 6 months ago #88922
by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Error in SQL
Hello,
I think that because you didn't upgrade EShop properly. Please try to upgrade it to latest version 2.3.2 now and check again, then issue should be gone.
Sincerely, Giang
I think that because you didn't upgrade EShop properly. Please try to upgrade it to latest version 2.3.2 now and check again, then issue should be gone.
Sincerely, Giang
Please Log in or Create an account to join the conversation.
- Impression eStudio
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 104
- Thank you received: 10
8 years 6 months ago - 8 years 6 months ago #88943
by Impression eStudio
Replied by Impression eStudio on topic Error in SQL
Hi Giang,
I didn't do any upgrade. The Eshop is already at the latest version.
To be honest, the problem was solved by itself. When it appeared I could not do anything. I disconnected and connected in Joomla, checked the database etc but nothing.
I left the Eshop with the problem as it is, waiting for your answer. After a few days I connected to the Eshop and the problem was not there! Strange...
I didn't do any upgrade. The Eshop is already at the latest version.
To be honest, the problem was solved by itself. When it appeared I could not do anything. I disconnected and connected in Joomla, checked the database etc but nothing.
I left the Eshop with the problem as it is, waiting for your answer. After a few days I connected to the Eshop and the problem was not there! Strange...
Last edit: 8 years 6 months ago by Impression eStudio.
Please Log in or Create an account to join the conversation.
- Giang Dinh Truong
-
- Offline
- Administrator
-
8 years 5 months ago #88987
by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Error in SQL
That's strange! 
If you need any more helps, simply use ticket system so I can help.
Have a nice weekend!
Sincerely, Giang

If you need any more helps, simply use ticket system so I can help.
Have a nice weekend!
Sincerely, Giang
Please Log in or Create an account to join the conversation.
Moderators: Giang Dinh Truong
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.