- Posts: 4
- Thank you received: 0
Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.
Explore our services SOLVED !Error 1054 -trying to access manage orders
- James Cato
- Topic Author
- Offline
- New Member
-
10 years 11 months ago - 10 years 11 months ago #67510
by James Cato
SOLVED !Error 1054 -trying to access manage orders was created by James Cato
Hi, I'm getting an error when trying to access the manage orders page. It followed after changing the 'from' and 'to' dates to today. I've tried purging cache etc, but it keeps throwing up the same error...
1054 Unknown column 'b.booking_date' in 'where clause' SQL = select count(a.id) FROM qrst_app_sch_orders AS a WHERE 1=1 AND b.booking_date >= '2015-08-21' group by a.id
I've attached a screenshot as the sql code gets flagged up as an injection, so I've edited it somewhat
1054 Unknown column 'b.booking_date' in 'where clause' SQL = select count(a.id) FROM qrst_app_sch_orders AS a WHERE 1=1 AND b.booking_date >= '2015-08-21' group by a.id
I've attached a screenshot as the sql code gets flagged up as an injection, so I've edited it somewhat
Last edit: 10 years 11 months ago by Dang Thuc Dam.
Please Log in or Create an account to join the conversation.
- James Cato
- Topic Author
- Offline
- New Member
-
Moderators: Dang Thuc Dam