| Author |
 Topic  |
|
|
codel
Starting Member
15 Posts |
 Posted - 14 March 2006 : 00:03:16
|
| I managed to configure the Events MOD for MySQL by working over the MOD files a bit, but I'm having a problem with posting events. I only get a regular topic form when I try to post a new event instead of the date picker I had before I fixed some of my SQL problems according to posts I've seen here. Now, when I try to edit my forum properties, logged in as admin, I get a "Note: Only an Administrator can edit a Category" with a small form with only the Subject field and a post changes button. What am I missing? Everything seems to be calling the db correctly, I just can't post an event to test it fully or, for that matter, get the thing to work. Ideas? Will e-mail a link for anyone wanting to check it out. This is a beta site for another forum I have up and running smoothly, thank God! |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 14 March 2006 : 02:29:07
|
| What changes did you make? I run it on MySql with no changes and no problems |
 |
|
|
codel
Starting Member
15 Posts |
Posted - 14 March 2006 : 08:45:31
|
| The packaged MOD files were not setup for MySQL, but I tried 'resetting' the SQL settings and using them. that didn't work for crap, so I went back through and manually made all the changes to the forum files (active.asp, admin_forums, etc.). Everything worked great that way, with one exception. I found an answer to that on a different post here...involved removing one line from cal.asp...'min(E2.EVENT_DATE) Asc' |
Edited by - codel on 14 March 2006 08:47:49 |
|
|
|
codel
Starting Member
15 Posts |
Posted - 14 March 2006 : 18:46:57
|
| OK, got it working...screwed up one line in topic.asp. evidently hit the space bar or something. Thanks for your attention! |
|
|
|
Etymon
Advanced Member
United States
2392 Posts |
Posted - 14 March 2006 : 22:26:50
|
quote:
Originally posted by codel
OK, got it working...screwed up one line in topic.asp. evidently hit the space bar or something. Thanks for your attention!
Would you mind posting the changes you made to those files? I'm working on the calendar MOD currently and want it to work for the MySQL folks too.
Cheers,
Etymon
|
|
|
|
codel
Starting Member
15 Posts |
Posted - 15 March 2006 : 11:40:09
|
sure. It wasn't that big of a deal, actually, I just screwed up by not paying attention. I was using a fresh set of scripts (no mods to date) and thought uploading the 'canned' 3.x modified files would work. Didn't notice that the config.asp was switched to access db, so I unchecked the MySQL and carried on. That made a helluva mess. Reverted to my old config.asp and manually edited the file for the rest of the changes. Worked ok but had another problem, so I manually edited all of the others. Worked better, but still issues with the topic.asp. Finally realized that my new MS Web Developer software was adding extensions onto some of the files. After I ftp'd them with the correct file names, everything was ok except the one screw up I mentioned above.
Long story short, all of the 'canned' files for the mod work fine except the config.asp. Manually edit that one according to the readme unless you have other mods installed. It will cruise just fine on MySQL. |
Edited by - codel on 15 March 2006 11:41:19 |
|
|
|
Etymon
Advanced Member
United States
2392 Posts |
Posted - 15 March 2006 : 21:24:35
|
| Thanks. Just wasn't sure. I know nothing at the moment of how to code for MySQL. |
|
|
|
codel
Starting Member
15 Posts |
Posted - 15 March 2006 : 22:11:58
|
No problem. Like I said, after working out that DB connection error, most of the 'canned' files worked fine. The only exception I mentioned earlier, I found help elsewhere in this forum. Posted by Slipstream, the edit to cal.asp to correct errors:
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. |
|
|
| |
Topic |
|
|
|
Topic Locked
