- Posts: 4
- Thank you received: 0
SOLVED !Error 1054 -trying to access manage orders
- James Cato
- Topic Author
- Offline
- New Member
Less
More
8 years 8 months ago - 8 years 8 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: 8 years 8 months ago by Mr. Dam.
Please Log in or Create an account to join the conversation.
- James Cato
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
8 years 8 months ago #67511
by James Cato
Replied by James Cato on topic Error 1054 -trying to access manage orders section
SOLVED - I LOGGED OUT AND BACK IN AGAIN AND THE PROBLEM WAS GONE
Please Log in or Create an account to join the conversation.
Moderators: Mr. Dam
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.