Error in SQL

  • Impression eStudio
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
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

Please Log in or Create an account to join the conversation.

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
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

Please Log in or Create an account to join the conversation.

  • Impression eStudio
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
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...
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
  • Administrator
More
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

Please Log in or Create an account to join the conversation.

Moderators: Giang Dinh Truong