Hello,
I got an error while using this latest code (never used before).
Code:
INVALID SQL: 1054 : Unknown column 'date' in 'field list'
SQL QUERY FAILURE:SELECT COUNT(*) as msg_count, MAX(date) AS last_date FROM xcart_newslists AS nl LEFT JOIN xcart_newsletter AS n ON n.listid = nl.listid WHERE nl.avail='Y' AND nl.show_as_news='Y' AND n.show_as_news = 'Y' ORDER BY n.date DESC
Anyone can help me ?
X-CART version 4.1.7