DB Error [Unknown column 'ca.created_at' in 'field list']
Hello
I got this error while using the plugin
Please advise..
Apparently the "created_at" field is not in the table and there is "created" field instead
[Unknown column 'ca.created_at' in 'field list']<br /><code>SELECT DATE(ca.created_at) AS created_at, COUNT(1) AS quantity, p.paid AS revenue, ca.status, p.id FROM `demo_bookly_customer_appointments` AS `ca` LEFT JOIN `demo_bookly_payments` AS `p` ON p.id = ca.payment_id WHERE `ca`.`created_at` BETWEEN '2021-11-17' AND '2021-11-25' GROUP BY DATE(ca.created_at), p.id, ca.status ORDER BY `ca`.`id` ASC</code></p></div>{"success":true,"data":{"totals":{"approved":0,"pending":0,"total":0,"revenue":"0,000 \u062a\u0648\u0645\u0627\u0646"},"filters":{"approved":"https:\/\/digiden.ir\/wp-admin\/admin.php?page=bookly-appointments#created-date=2021-11-17-2021-11-24&appointment-date=any&status=approved","pending":"https:\/\/digiden.ir\/wp-admin\/admin.php?page=bookly-appointments#created-date=2021-11-17-2021-11-24&appointment-date=any&status=pending","total":"https:\/\/digiden.ir\/wp-admin\/admin.php?page=bookly-appointments#created-date=2021-11-17-2021-11-24&appointment-date=any","revenue":"https:\/\/digiden.ir\/wp-admin\/admin.php?page=bookly-payments#created-date=2021-11-17-2021-11-24"},"days":{"2021-11-17":{"total":0,"revenue":0},"2021-11-18":{"total":0,"revenue":0},"2021-11-19":{"total":0,"revenue":0},"2021-11-20":{"total":0,"revenue":0},"2021-11-21":{"total":0,"revenue":0},"2021-11-22":{"total":0,"revenue":0},"2021-11-23":{"total":0,"revenue":0},"2021-11-24":{"total":0,"revenue":0}},"labels":["\u0622\u0628\u0627\u0646 \u06f2\u06f6","\u0622\u0628\u0627\u0646 \u06f2\u06f7","\u0622\u0628\u0627\u0646 \u06f2\u06f8","\u0622\u0628\u0627\u0646 \u06f2\u06f9","\u0622\u0628\u0627\u0646 \u06f3\u06f0","\u0622\u0630\u0631 \u06f1","\u0622\u0630\u0631 \u06f2","\u0622\u0630\u0631 \u06f3"]}}
Comments
Hello,
Thank you for your message.
The issue you've raised requires personalized support, please follow the link below to create a support ticket, so we can look into this matter:
https://support.booking-wp-plugin.com/hc/en-us/requests/newÂ
Please sign in to leave a comment.