Opened 22 months ago

Closed 8 months ago

#6462 closed defect (bug) (fixed)

Error displayed on

Reported by: arpitgshah's profile arpitgshah Owned by:
Milestone: Priority: normal
Component: General Keywords:


just checked the website and found one issue
it has a link to go with this website - and this website has some errors.

Error - Show query "SELECT DISTINCT YEAR(post_date), MONTH(post_date) FROM posts WHERE post_date < '2022-08-31 13:48:32' AND post_category > 0 ORDER BY post_date DESC
Expression #1 of ORDER BY clause is not in SELECT list, references column 'cafelog_cafelogcom.posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT"

Attachments (1)

screenshot.png (34.0 KB) - added by arpitgshah 22 months ago.

Download all attachments as: .zip

Change History (5)

This ticket was mentioned in Slack in #meta by xhtmlpoint. View the logs.

22 months ago

#2 follow-up: @dufresnesteven
22 months ago

Thanks for the ticket, I wonder if it's necessary to have a link to b2. I am not familiar with its history.

#3 in reply to: ↑ 2 @dd32
22 months ago

Replying to dufresnesteven:

I wonder if it's necessary to have a link to b2.

WordPress was forked from b2, so it makes sense for us to link to it. is hosted on the cPanel server it appears, @Otto42 or @coffee2code are probably the best people to have a look into the error (ie. who actually has access to the account)

#4 @coffee2code
8 months ago

  • Resolution set to fixed
  • Status changed from new to closed
  • Summary changed from Showing Error on website to Error displayed on

Unfortunately, I do not have access (or not access I'm aware of having) to the cPanel server for that site.

However, the issue appears to have since been fixed since the reported error (or any other for that matter) is not shown, and the archives listing that was meant to be shown is properly displayed.

Note: See TracTickets for help on using tickets.