| Author |
 Topic  |
|
|
Hopeful
Junior Member
130 Posts |
 Posted - 05 February 2006 : 03:07:44
|
I got this display after running the dbs setup...
quote:
New Events Calendar Mod (Recurring Dates) for Snitz 3.4.05
Dropping Column...
ALTER TABLE FORUM_TOPICS DROP COLUMN T_ISEVENT
ALTER TABLE FORUM_TOPICS DROP COLUMN T_ISEVENT
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Can't DROP 'T_ISEVENT'; check that column/key exists
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_A_TOPICS DROP COLUMN T_ISEVENT
ALTER TABLE FORUM_A_TOPICS DROP COLUMN T_ISEVENT
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Can't DROP 'T_ISEVENT'; check that column/key exists
--------------------------------------------------------------------------------
Adding Column F_ALLOWEVENTS...
ALTER TABLE FORUM_FORUM ADD F_ALLOWEVENTS int NULL DEFAULT 1
Column added successfully
UPDATE FORUM_FORUM SET F_ALLOWEVENTS=1
Populating Current Records with new Default value
Table(s) updated
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_CAL_EVENTS( TOPIC_ID int NOT NULL , EVENT_DATE varchar(50) NOT NULL )
Table created successfully
Since the only error that shows are the dropping of tables that don't exists anyway, does this mean I can proceed with the rest of the steps?
Thanks for an answer!
|
Please explain everything in layman terms!!! |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 05 February 2006 : 03:13:27
|
Yes, proceed. That step is just to check that it is really deleted. If it's not there, it's hard to delete it  |
 |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 05 February 2006 : 03:41:07
|
Thanks a bunch laser! I thought that was the case, but being pretty new to all this I figured better safe than sorry!
I'll get busy now! Thanks again! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 05 February 2006 : 05:05:42
|
Well got the code changes completed and see 1 error when I go to "Events list" on the calender.
The error is this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Invalid use of group function
/post/cal.asp, line 1155
This is the line in my cal.asp at line 1154 & 1155:
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn
Any ideas on how to clear this error?
I have snitz 3.4.05 and use mysql 4.1.8-nt db
ALL HELP GREATLY APPRECIATED!!!
|
Please explain everything in layman terms!!! |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 05 February 2006 : 05:31:51
|
Just before those lines, do this :
Response.Write StrSql
that will at least let you see what the error is. |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 05 February 2006 : 06:09:33
|
Thanks, I'll try that now!
|
Please explain everything in layman terms!!! |
Edited by - Hopeful on 05 February 2006 08:10:39 |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 05 February 2006 : 06:16:47
|
I added that line of code and this is what I get:
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 (((FORUM_TOPICS AS T INNER JOIN FORUM_CAL_EVENTS AS E ON T.TOPIC_ID = E.TOPIC_ID) INNER JOIN FORUM_CATEGORY AS C ON T.CAT_ID = C.CAT_ID) INNER JOIN FORUM_FORUM AS F ON T.FORUM_ID = F.FORUM_ID) INNER JOIN FORUM_CAL_EVENTS AS E2 ON E.TOPIC_ID = E2.TOPIC_ID WHERE E.EVENT_DATE >= '20060205000000' 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
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Invalid use of group function
/post/cal.asp, line 1155
Do not know what I'm looking for??? Help???
Thank you! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 05 February 2006 : 08:09:18
|
quote:
SLiPStreaM
Posted - 21 May 2005 : 09:26:23
--------------------------------------------------------------------------------
Well I have been playing around with the Events List code in the cal.asp file and found what was casuing the error. I have removed this and all seems to work okay.
I will post the 'before' and 'after' code below and ask if anyone can tell me why it would cause the 'Invalid use of group function' error and how it might fix it?
ORIGINAL 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 "
MODIFIED 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 T.TOPIC_ID Asc, E.EVENT_DATE Asc "
As you can see I took out the 'min(E2.EVENT_DATE) Asc' piece of code
Found a post that seems to have fixed this error!
Thank you all! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 05 February 2006 08:13:24 |
|
|
| |
Topic |
|
|
|
Topic Locked
