View Single Post
Old 19 Oct 2015, 16:20
kgroneman's Avatar
kgroneman kgroneman is offline
Join Date: Aug 2007
Question SQL Query for number of posts per user group


I'm trying to get the number of posts for users in a specific user group in a specific timeframe and am using this query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

However, I get the following error regarding "dateline"

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'dateline' in 'where clause'

Can anyone help me with this? I have four 4.2.2 PL4 forum sets and this happens on all four

If I take out the dateline sections, it works, but it gives me stats for all time, not just the date range I'm looking for. What am I doing wrong?
Reply With Quote