| Author |
 Topic  |
|
|
JMT
Starting Member
17 Posts |
 Posted - 07 August 2003 : 23:30:14
|
Whenever I go to the event list I get the error below. Did I miss something posted about this elsewhere?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.13-nt]Invalid use of group function
/rhs/cal.asp, line 1098
Thanks! |
|
|
vmplanet
Junior Member
112 Posts |
Posted - 25 August 2003 : 04:40:28
|
I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Invalid use of group function
/forum/cal.asp, line 1097
On that line it says:
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn
I'm an user of MySQL. I think it's the same problem as the problem above. Please help us!! |
 |
|
|
vmplanet
Junior Member
112 Posts |
Posted - 26 August 2003 : 18:07:42
|
| Somebody plz help?!? |
|
|
|
vmplanet
Junior Member
112 Posts |
Posted - 27 August 2003 : 08:44:14
|
 |
|
|
|
choppermc
New Member
Australia
80 Posts |
Posted - 20 October 2003 : 07:08:40
|
I'm getting this Problem too, only does this with MySQL I think.
Can anyone help.
I think it has something to do with this piece of code from cal.asp-
'Get the events from the database
strSql = "SELECT T.TOPIC_ID, " & _
"T.FORUM_ID, " & _
"T.CAT_ID, " & _
"T.T_SUBJECT, " & _
"T.T_AUTHOR, " & _
"T.T_STATUS, " & _
"E.EVENT_DATE, " & _
"C.CAT_MODERATION, " & _
"F.F_MODERATION " & _
"FROM (((" & _
strTablePrefix & "TOPICS AS T " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS AS E ON T.TOPIC_ID = E.TOPIC_ID) " & _
"INNER JOIN " & _
strTablePrefix & "CATEGORY AS C ON T.CAT_ID = C.CAT_ID) " & _
"INNER JOIN " & _
strTablePrefix & "FORUM AS F ON T.FORUM_ID = F.FORUM_ID) " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS AS E2 ON E.TOPIC_ID = E2.TOPIC_ID " & _
"WHERE T.T_ISEVENT = 1 " & _
"AND T.FORUM_ID IN (" & arrRqCalForumID & ") "
Select Case strDisplay
Case "future"
strSql = strSql & "AND E.EVENT_DATE >= '" & DateToStr(DateValue(strForumTimeAdjust)) & "' "
Case "past"
strSql = strSql & "AND E.EVENT_DATE < '" & DateToStr(DateValue(strForumTimeAdjust)) & "' "
End Select
strSql = strSql & _
"GROUP BY T.TOPIC_ID, T.FORUM_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STATUS, " & _
"E.EVENT_DATE, C.CAT_MODERATION, F.F_MODERATION " & _
"ORDER BY min(E2.EVENT_DATE) Asc, T.TOPIC_ID Asc, E.EVENT_DATE Asc "
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn
here's a link to cal.asp text copy
Any help would be appreciated.
|
Oh....Is that it? |
Edited by - choppermc on 22 October 2003 02:45:21 |
|
|
|
choppermc
New Member
Australia
80 Posts |
Posted - 23 October 2003 : 06:40:53
|
OK I have narrowed it down to this piece of code-
strSql = strSql & _
"GROUP BY T.TOPIC_ID, T.FORUM_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STATUS, " & _
"E.EVENT_DATE, C.CAT_MODERATION, F.F_MODERATION " & _
"ORDER BY min(E2.EVENT_DATE) Asc, T.TOPIC_ID Asc, E.EVENT_DATE Asc "
Because when I delete or comment this piece of code out, the list shows up without errors. But I think the list is in no particular order, which is what I think this piece of code is for.
Any MySql gurus out there that might like to take a shot.
|
Oh....Is that it? |
|
|
|
edmartin
Starting Member
46 Posts |
Posted - 02 April 2004 : 19:53:33
|
Did anyone ever solve this? I'm having exactly the same problem. Commenting out the entire line solves it and just removing the "min(E2.EVENT_DATE) Asc," solves it. Well, at least it makes the error message go away - I have no idea what other impact removing the "min" has.
Help? |
|
|
|
jgillie1
Starting Member
28 Posts |
Posted - 02 April 2004 : 22:24:29
|
Gentleman, had the same problem
See Topic:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=51290
So far no problems just removing MIN function. Been running for about a month and a half. |
Take the Road less Traveled. - Robert Frost |
Edited by - jgillie1 on 02 April 2004 22:27:26 |
|
|
| |
Topic |
|
Topic Locked
