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

Who is online
Users browsing this forum: No registered users and 1 guest