Post by ritey » Tue Jul 20, 2010 2:12 am

Managed to get this error:

Error: Column 'date_added' in order clause is ambiguous
Error No: 1052
SELECT e.extension_id, e.name, e.description, e.image, e.license, e.price, m.username AS member, (SELECT AVG(rating) FROM extension_rating er WHERE er.extension_id = e.extension_id GROUP BY er.extension_id) AS rating, e.status, e.date_added FROM extension e LEFT JOIN member m ON (e.member_id = m.member_id) WHERE e.status = '1' AND e.license = '0' AND e.extension_id IN (SELECT extension_id FROM extension_download_to_download ed2d WHERE ed2d.download_id = '5') ORDER BY LCASE(date_added) ASC LIMIT 0,10

When sorting by date added.

HTH

Dave
www.coderstudios.com


User avatar
Active Member

Posts

Joined
Fri Jan 22, 2010 4:28 am
Location - Richmond

Post by Xsecrets » Tue Jul 20, 2010 4:11 am

yeah obviously Daniel is working on the extensions listing as it has dramatically changed since yesterday. I'm sure he'll see it and fix it.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by Moggin » Tue Jul 20, 2010 7:30 am

Xsecrets wrote:yeah obviously Daniel is working on the extensions listing as it has dramatically changed since yesterday. ...
So it has!
It's looking very good too. It's going to be so much easier to use. Many thanks Daniel.... :good:

Active Member

Posts

Joined
Wed May 05, 2010 4:56 am
Who is online

Users browsing this forum: No registered users and 1 guest