Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

E-Commerce Modules /

Discuss about the various e-commerce modules available:
Ecommerce, SS Shop, SilverCart and SwipeStripe
Alternatively, have a look the shared mailinglist.

Moderators: martimiz, Nicolaas, Sean, Ed, frankmullenger, biapar, Willr, Ingo, Jedateach, swaiba

Ecom install.

Go to End

2 Posts   1357 Views


Community Member, 1 Post

6 March 2013 at 8:25am

I currently am running 2.4 and looking to upgrade to 3.x I have replaced code with the latest and try to flush and rebuild. I keep getting this message. Anyone receieve that before?

[User Error] Couldn't run query: SELECT DISTINCT "EcommerceCurrency"."ClassName", "EcommerceCurrency"."Created", "EcommerceCurrency"."LastEdited", "EcommerceCurrency"."Code", "EcommerceCurrency"."Name", "EcommerceCurrency"."InUse", "EcommerceCurrency"."ID", CASE WHEN "EcommerceCurrency"."ClassName" IS NOT NULL THEN "EcommerceCurrency"."ClassName" ELSE 'EcommerceCurrency' END AS "RecordClassName" FROM "EcommerceCurrency" WHERE ("EcommerceCurrency" = 'NZD') AND ("InUse" = '1') ORDER BY "EcommerceCurrency"."InUse" DESC, "EcommerceCurrency"."Name" ASC, "EcommerceCurrency"."Code" ASC LIMIT 1 Unknown column 'EcommerceCurrency' in 'where clause'
GET /dev/build?flush=1
Line 580 in framework\model\MySQLDatabase.php



Community Member, 8 Posts

15 March 2013 at 7:28pm

Hi guys,

I have also the same issue. I went step by step through Readme file and the same problem epeared after instalation.

Many thx.