SOLVED !Error 1054 -trying to access manage orders

  • James Cato
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 8 months ago - 8 years 8 months ago #67510 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
Attachments:
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
  • New Member
More
8 years 8 months ago #67511 by James Cato
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