Snitz Forums 2000 - Poll mod problems with brinkster

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Poll mod problems with brinkster

New Topic

Topic Locked

Printer Friendly

Author

Topic

pinguish
Starting Member

4 Posts

Posted - 01 May 2002 : 03:51:14

Hi,

I'm having a few problems installing the poll mod on brinkster.
first off the mod installer didn't make the tables correctly..
anyway i went ahead and made the code changes anyways (mad aren't i)
then i figured hmm okay lets try and make the DB changes myself..
made them..
somehow i think i messed up.
can anyone tell me what fields it should have added into an access 97 db? so i can check please?
if anyone wants to have a look at the errors i'm getting i have added a user called test (Pass = test) to www27.brinkster.com/pinguish
its driving me mad any help appreciiated.

Edited by - Davio on 01 May 2002 11:18:11

Chiz
Junior Member

245 Posts

Posted - 01 May 2002 : 05:22:03

Just went to your forum and it loaded fine. I can view the default page, see the topic list, read a thread and even fire-up the Add Poll form.

What was exactly the problem?

BTW, I can't log-in as test.

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons

pinguish
Starting Member

4 Posts

Posted - 01 May 2002 : 06:56:33

thanks for looking...yeah it all seems to be going swimmingly until i try to make a poll..
i get an error when i try to make one..

when i submit the poll i get this.

Microsoft JET Database Engine error '80040e14'

Number of query values and destination fields are not the same.

/pinguish/post_info.asp, line 753

now i know i have done something really sill but can't see what.

the more i look i think it may be one of the code parts as oppose to the DB.
but i'm sure you knwo what s it like the more u look the less you see :)

pinguish
Starting Member

4 Posts

Posted - 01 May 2002 : 11:02:33

found my error...thanks for looking anyway

Cyberjunkie
Junior Member

111 Posts

Posted - 05 May 2002 : 13:51:57

Hi I am having a problem with the Poll MOD to. The database was opdated correctly the problems lies in the code. I think I must have pasted some of the code lines in the wrong place. I Cant wiew my topic.asp page and the places in the forum.asp file where the Poll mod is highlighted with ******Poll Mod**** is visible sum places, weird! Can anyone help please!?

http://www.vision-lighed.dk/forum/
Username: Test
Password: Test

Cyberjunkie
Junior Member

111 Posts

Posted - 05 May 2002 : 14:44:10

In my original forum.asp file there is a piece of code I am uncertain of how to alter

'## Forum_SQL - Get all topics from DB
strSql ="SELECT " & strActivePrefix & "TOPICS.T_STATUS, "
strSql = strSql & strActivePrefix & "TOPICS.CAT_ID, "
strSql = strSql & strActivePrefix & "TOPICS.FORUM_ID, "
strSql = strSql & strActivePrefix & "TOPICS.TOPIC_ID, "
strSql = strSql & strActivePrefix & "TOPICS.T_VIEW_COUNT, " & strActivePrefix & "TOPICS.T_ISPOLL, "
strSql = strSql & strActivePrefix & "TOPICS.T_SUBJECT, "
strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, "
strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, "
strSql = strSql & strActivePrefix & "TOPICS.T_MSGICON, "  
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "

The red code is the line added from the Poll MOD. But in the Poll Mod file this piece of code is like this:

 '## Forum_SQL - Get all topics from DB
strSql ="SELECT " & strActivePrefix & "TOPICS.T_STATUS, " & strActivePrefix & "TOPICS.CAT_ID, " 
strSql = strSql & strActivePrefix & "TOPICS.FORUM_ID, " & strActivePrefix & "TOPICS.TOPIC_ID, " 
' ############## Poll Mod - Modified next line ############
strSql = strSql & strActivePrefix & "TOPICS.T_VIEW_COUNT, " & strActivePrefix & "TOPICS.T_SUBJECT, " & strActivePrefix & "TOPICS.T_ISPOLL, "
strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, " 
strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, " & strActivePrefix & "TOPICS.T_LAST_POST, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, "  
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "

Is there any difference?

Cyberjunkie
Junior Member

111 Posts

Posted - 05 May 2002 : 15:31:56

Ok I fixed it :)

Davio
Development Team Member