Author |
Topic |
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 05 September 2003 : 19:58:47
|
Okay, I just added the Poll MOD to my forum files... and I'm running into an issue I've had before with the Poll MOD, only this time I've got the (non-recurring date) new events calendar installed.
First, now that it is installed, I've noticed that in the forum view, the "New Topic" now shows twice, on both sides of the "New Event" link.
When I try to post a topic, the smilie table and the message box are one coloum to the right... which I've had before and resolved in this forum, but this time the calendar additions to the post.asp file make it dificult for me to figure out on my own how to fix.
When I tried to post a test topic, I got the following error message.
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/korloch/testforum/post_info.asp, line 966
I tried looking at the standard test post that comes with sf2k, I get this error.
Microsoft VBScript compilation error '800a03f4'
Expected 'If'
/korloch/testforum/topic.asp, line 1267
End Sub ----^
And when I click the "New Poll" link, I get this error. Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_POLLS.TOPIC_ID ='.
/korloch/testforum/post.asp, line 390
I've got txt copies of the files posted here..... any help would be greatly appreciated.
http://www22.brinkster.com/korloch/testforum/forum.txt http://www22.brinkster.com/korloch/testforum/post.txt http://www22.brinkster.com/korloch/testforum/post_info.txt http://www22.brinkster.com/korloch/testforum/topic.txt |
Believe disbelief and contemplate the simple. |
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 07 September 2003 : 01:41:36
|
Uhm.... so anyone wanna take a few shots at this? Any ideas? Even trying to help me with one at a time would be appreciated.
|
Believe disbelief and contemplate the simple. |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 September 2003 : 03:52:58
|
You didn't need to start another topic. What's wrong with this one? The other one will be locked.
Update this topic so I can see what you fixed already and what problems you have left. |
Support Snitz Forums
|
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 08 September 2003 : 20:33:28
|
Yes sir! And I don't mean that sarcastically.
As for what's been done so far....
Solved the double "New Topic" link on my own, turned out there was a link from the poll mod and from the calendar mode, so I commented out the first one (poll mod) from the forum.asp file and it seems to be working fine.
The issue with the topics, not displaying is on it's way to a resolution, but I need a pointer. I added an extra "end if" just above the End Sub statement on line 1267. It displays the topic post, but it looks like the page is being displayed in a coloum format. The topic itself is being displayed twice in two colums side by side. The topic links are displayed above the post on the right half, but below the post on the left half.
That's as far as I got so far, I figure get the display straightened out and then get the posting straightened out. The above links for the text files should be good, even updated to show the changes made so far. |
Believe disbelief and contemplate the simple. |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 September 2003 : 22:07:02
|
I modified your topic.asp file. Download it here! |
Support Snitz Forums
|
Edited by - Davio on 09 September 2003 00:31:44 |
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 08 September 2003 : 23:36:31
|
Oaky, so now it's down to where the post link show up.... I loaded your file, but it was giving the same error as above, but on line 1260 instead of line 1267. I added a "end if" at the line there, above the End Sub. So now it shows well, but the posting links are still showing on the right above the post, and on the left below the post. |
Believe disbelief and contemplate the simple. |
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 08 September 2003 : 23:43:38
|
I'm a dork, nevermind, that's how it's supposed to be....
okay, so it seems like there's one problem down!
So the next thing would be the problem with the table alignments....
When posting a new event, posting a new topic, or replying to a topic, the forum comes up with the smilies table and the message box being one cell to the right. |
Believe disbelief and contemplate the simple. |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 September 2003 : 00:20:16
|
You need to tell me which page you are talking about. I am guessing it is the post.asp page. I'll take a look at it. |
Support Snitz Forums
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 09 September 2003 : 22:57:10
|
Coolness! well that solved the post reply issue.
However when posting a new topic or a new poll, I get this error.
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/korloch/testforum/post_info.asp, line 966 And when posting a new calendar event I get this error
Microsoft JET Database Engine error '80040e57'
Overflow
/korloch/testforum/post_info.asp, line 966
|
Believe disbelief and contemplate the simple. |
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 15 September 2003 : 12:58:47
|
Can anyone help further with this error?
However when posting a new topic or a new poll, I get this error.
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/korloch/testforum/post_info.asp, line 966
And when posting a new calendar event I get this error
Microsoft JET Database Engine error '80040e57'
Overflow
/korloch/testforum/post_info.asp, line 966
|
Believe disbelief and contemplate the simple. |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 September 2003 : 13:54:40
|
We can't do anything without looking at your files. Post a link to a txt version of your post_info.asp file. |
Support Snitz Forums
|
|
|
Rrok007
Junior Member
USA
149 Posts |
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 September 2003 : 01:56:59
|
Oh sorry. Didn't remember you posted the links up there. [:/]
I'll look at it. |
Support Snitz Forums
|
|
|
Rrok007
Junior Member
USA
149 Posts |
Posted - 22 September 2003 : 13:07:27
|
Bump for more assistance......
|
Believe disbelief and contemplate the simple. |
|
|
|
Topic |
|