| Author |
 Topic  |
|
|
Jitz
Starting Member
12 Posts |
 Posted - 26 April 2005 : 00:07:07
|
I just finished installed the following mod:
Poll Mod Version: 2.0.7
Current Author: Davio
Now my New Topic/New Post forms are screwed up, they look like this:
View Image
I'm pretty good with ASP, but it would take me forever to find the problem on my own as there is so much code. I'm hoping someone here can point me to the approximate area (Line #?) in Post.asp so I can get this thing back up and running as soon as possible!
But wait, that's not all... When I ran Setup after the install it won't create the database Tables because it thinks the Tables already exist. I checked the DB and the Tables are NOT there. I tried removing the mod and installing again, I even moved the database to a different location thinking it was a directory rights issue.
All I can say is I'm stumped, and now I have a crippled forum... I really hope someone can help!
Thanks! |
Signatures are for losers, that's why I don't have one! |
Edited by - Jitz on 27 April 2005 19:45:26 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 April 2005 : 04:00:27
|
| Can you post a text version of your post.asp and I will have a look at it for you. It is just wrong placement of the code.. |
Cheers,
David Greening |
 |
|
|
Jitz
Starting Member
12 Posts |
Posted - 26 April 2005 : 14:47:52
|
Sure, you can get a zipped copy here 
If you would rather I post the entire file here on the forum then let me know.
Thanks for the help! Do you have any idea what might be causing the database problem? I'm about to go in and create the tables manually, but I'm afraid I'll screw something else up. 
|
Signatures are for losers, that's why I don't have one! |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 April 2005 : 16:33:19
|
OK, at lines 935 you have a TD that doesn't need to be there: Lines 935 to 939: Response.Write " <td bgColor=""" & strPopUpTableColor & """ noWrap vAlign=""top"" align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Message:</b><br />" & vbNewLine & _
" <br />" & vbNewLine & _
" <table border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td align=""left"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine Change that code to be this: Response.Write " <br />" & vbNewLine & _
" <table border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td align=""left"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine I hope that helps as that is what mine has and it works great. It is all I could find with the quick look.
|
Cheers,
David Greening |
|
|
|
Jitz
Starting Member
12 Posts |
Posted - 26 April 2005 : 16:43:14
|
Hey! That did it!!! 
You Rule CMC! 
Now, if only I can get help with the database portion of the mod... |
Signatures are for losers, that's why I don't have one! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 April 2005 : 16:52:24
|
quote:
But wait, that's not all... When I ran Setup after the install it won't create the database Tables because it thinks the Tables already exist. I checked the DB and the Tables are NOT there. I tried removing the mod and installing again, I even moved the database to a different location thinking it was a directory rights issue.
All I can say is I'm stumped, and now I have a crippled forum... I really hope someone can help!
What? hehe Ok, the database tables for the mod are done by you, using the MOD Setup tool in your admin options. If you did that, and all went ok, then you are ready to use the poll mod.
The last step of running setup.asp is to ensure that the global variables used by the poll mod are initiated (or started to use a simplier word). When you run setup.asp it should tell you your forum is setup. Just go to your forum and use the poll mod. |
Support Snitz Forums
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 April 2005 : 17:11:18
|
Glad I could help....
|
Cheers,
David Greening |
|
|
|
Jitz
Starting Member
12 Posts |
Posted - 26 April 2005 : 21:29:54
|
Davio....
I did go into setup and installed the mod, and tried alternate method also. The install runs and when it shows the report screen it says that the tables used by the Poll Mod exist already.
That is what is screwed up, they don't exists... I checked, and trust me they are not there.
Here's what is shows me:
View Image |
Signatures are for losers, that's why I don't have one! |
Edited by - Jitz on 27 April 2005 19:46:09 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 April 2005 : 14:28:36
|
| Are you using a Access 97 or DSN connection? If so, try using the Access 2000 dsn-less connection string instead. |
Support Snitz Forums
|
Edited by - Davio on 27 April 2005 14:28:51 |
|
|
|
Jitz
Starting Member
12 Posts |
Posted - 27 April 2005 : 17:52:08
|
quote:
Are you using a Access 97 or DSN connection? If so, try using the Access 2000 dsn-less connection string instead.
Hehe, yeah I tried that too... I was using a DSN, then I switched to a 2000 virtual directory connect...
Looks like I'm going to have to do it manually...  |
Signatures are for losers, that's why I don't have one! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 April 2005 : 18:18:08
|
Have you tried the direct connection string? The one that uses the direct path to the database?
Can you post your connection string? Remove the location of your database but leave the rest intact.
My next advise would be to update your Jet drivers to make sure your server is using the latest version. http://support.microsoft.com/kb/239114/
Your host will have to do that for you. |
Support Snitz Forums
|
|
|
|
Jitz
Starting Member
12 Posts |
Posted - 27 April 2005 : 19:40:24
|
You are not going to believe this (well, maybe you will)... It seems that when I moved the forum database to a new location to get it off of a DSN I commented out the DSN connection string line. I then edited the 2000 Virtual Directory line to match the database location, and then forgot to uncomment that line.
So, in other words, since I installed this mod I have not had a connection string. Here's the weird part, the forum still operated properly...
I don't get it, maybe some kind of server cache by my provider... I don't know...
But the good news is now everything appears to be OK, except one thing. I installed the MOD again and it worked, then I went into the Poll Configuration and set up everything there. Where exactly is the option supposed to show up in the New Post form? I don't see any option for it anywhere...
Geez, I'm sorry for all the trouble!
Thanks!
Jitz
btw, I find it funny that another user named 'Fitz' is asking questions about the same mod I'm having trouble with ('Jitz')...
btw 2, I changed the image links to urls so this thread can load faster. |
Signatures are for losers, that's why I don't have one! |
Edited by - Jitz on 27 April 2005 19:47:20 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 April 2005 : 00:10:49
|
The option to create a new poll will show up on the forum.asp or topic.asp pages, right beside New Topic link.
But you will need to turn on Polls for each forum you want to allow persons to create new polls. So edit each forum properties, and turn the Poll on. |
Support Snitz Forums
|
|
|
|
Jitz
Starting Member
12 Posts |
Posted - 28 April 2005 : 03:16:42
|
quote:
Originally posted by Davio
The option to create a new poll will show up on the forum.asp or topic.asp pages, right beside New Topic link.
But you will need to turn on Polls for each forum you want to allow persons to create new polls. So edit each forum properties, and turn the Poll on.
Got it!!! Thanks for all your help!!! You Rock man! |
Signatures are for losers, that's why I don't have one! |
Edited by - Jitz on 28 April 2005 03:18:09 |
|
|
| |
Topic |
|
Topic Locked
