Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Integrated Mods
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 20 December 2000 :  12:16:44  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
strsql = "Alter (tablenamehere) Add C_BGGRAPHIC Text(255)"
my_conn.execute(strsql)

etc etc....

<font color=red>Da_Stimulator</font id=red>
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
Go to Top of Page

evehawk
New Member

Australia
65 Posts

Posted - 20 December 2000 :  12:57:44  Show Profile  Send evehawk an ICQ Message
lol i think i am too dumb for that Da_Stimulator, follow what you said, it put up an error straight away.. now the server down so i guess i will go to bed .
Nite and thanks :)

Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 20 December 2000 :  14:54:47  Show Profile  Visit tilttek's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Also includes all the bug fixes posted to date.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

If there is other bug fixes later, will you update you file?


Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com
Go to Top of Page

Matthew
New Member

USA
91 Posts

Posted - 20 December 2000 :  15:23:16  Show Profile  Visit Matthew's Homepage  Send Matthew an AOL message  Send Matthew a Yahoo! Message
I just got all the mods working on 3.1 SR3 I don't think I'm gonna ever be able to upgrade again cause I probably will break it <img src=icon_smile.gif border=0 align=middle>

I do still hope that when ppl chnge certain mods they still put them up seperatly also.

<center><font color=red>Matt</font id=red>
<font color=green>If everything seems to be going well, you have obviously overlooked something.</font id=green></center>
Go to Top of Page

Duke_TheWarrior
New Member

Netherlands
91 Posts

Posted - 21 December 2000 :  01:55:53  Show Profile  Visit Duke_TheWarrior's Homepage  Send Duke_TheWarrior an ICQ Message
Hello!

I think you can help me out here...I've uploaded the files of you with no modification :: 'cause I don't know how to place the code in which file ?!? <img src=icon_smile_sad.gif border=0 align=middle>
So can you tell me that in steps <img src=icon_smile.gif border=0 align=middle> Thx a lot....here is the error message while I ran setup.asp and logged on and selected upgrade from SR2:

Please Wait until the upgrade has been completed !

Critical error: code: -2147217887 in statement [ALTER TABLE FORUM_CONFIG ADD C_STRAUTOLOGON SMALLINT NULL ; ] while trying to add C_STRAUTOLOGON to the CONFIG table
Critical error: code: -2147217887 in statement [ALTER TABLE FORUM_CONFIG ADD C_STRNTGROUPS SMALLINT NULL ; ] while trying to add C_STRNTGROUPS to the CONFIG table
Critical error: code: -2147217887 in statement [ALTER TABLE FORUM_FORUM ADD F_PASSWORD_NEW TEXT (255) NULL ; ] while trying to add F_PASSWORD_NEW to the FORUM table
Error: -2147217904 No value given for one or more required parameters.
strUpdateSql: UPDATE FORUM_FORUM SET F_PASSWORD_NEW = F_PASSWORD
Error: -2147217900 There is no field named 'F_PASSWORD' in table 'FORUM_FORUM'.
strUpdateSql: ALTER TABLE FORUM_FORUM DROP COLUMN F_PASSWORD
Upgraded: Added default values for new fields in CONFIG table
Error: -2147217900 Table 'FORUM_ALLOWED_MEMBERS' already exists.
strUpdateSql: CREATE TABLE FORUM_ALLOWED_MEMBERS (MEMBER_ID INT NOT NULL, FORUM_ID INT NOT NULL, CONSTRAINT FORUM_SnitzC373 PRIMARY KEY (MEMBER_ID, FORUM_ID) )
Upgrading: Starting transferring Member List to ALLOWED_MEMBERS table
Upgraded: Table opened
Upgrading: Finished transferring Member List to ALLOWED_MEMBERS table
Upgraded: Added default values for new fields in CONFIG table

The Upgrade has NOT been completed without errors !

There were 4 Critical Errors...

There were 2 noncritical errors...




<b><font color=blue>Duke_TheWarrior out <img src=icon_smile_cool.gif border=0 align=middle></font id=blue></b>

<font color=green>Everthing that can go wrong, will go wrong eventually <img src=icon_smile_approve.gif border=0 align=middle></font id=green>
Go to Top of Page

evehawk
New Member

Australia
65 Posts

Posted - 21 December 2000 :  02:46:00  Show Profile  Send evehawk an ICQ Message
I added all the fields as the in readme file. Setup.asp ran through ok upgrade my database from SR2 to Sr3.
active_users_setup.asp ran fine (i guess i already has whoonline mod)
e_setup.asp give err:
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/evehawk/inc_top.asp, line 178

And yes i did populate the T_rate and T_ratect with 0

what am i doing wrong?

Thanks


Go to Top of Page

KXS
New Member

Canada
66 Posts

Posted - 21 December 2000 :  19:04:41  Show Profile  Send KXS an ICQ Message
Guys, everything seems to work ok, except when one logs off, and goes back to the forum, they have full access to edit, remove, a forum. It was working fine on my other forums, which were created by 2000_v3_1_final, the one I am working on right now is 2000 3.0 sr3 with these mods. Does anyone else have this problem?

I would like to retract the last comment/question, it works fine, it just displays the options for one to edit, delete, but you still need to enter the admin username & password. That's a relief. Is there a way to not diplay these options to just anyone?
------------------
"keeping it real"

Edited by - KXS on 21 December 2000 19:09:10
Go to Top of Page

iaewedar
Starting Member

USA
15 Posts

Posted - 03 January 2001 :  00:44:49  Show Profile
Scott, thanks for the great work :)

One question though: I am getting a few missing images such as the "reply to post" and "post new topic"

The images are there, but I am not sure where the path to them is in the code to make sure it is pointing to the correct place. Any assistance will be greatly appreciated :)

Iae

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 03 January 2001 :  01:02:59  Show Profile
I believe in Scott's Modified Forum, to set the path to the Images, you goto <b>Admin Options</b> --> <b>Main Forum Configuration</b> and there will be some added fields to set the path for those images.
Go to Top of Page

vortech
Starting Member

10 Posts

Posted - 29 January 2001 :  21:40:38  Show Profile
Getting a error after installing this. Hack. Did every thing it said in the readme and here and i am getting this error any help would be great. This is with a SQL 2000 database. One problem a saw not sure if its me or SQL changed or some thing not sure since i never use 7. But under C_BGGRAPHIC, C_NEWTOPICGRAPHIC, C_POLLGRAPHIC, C_REPLYGRAPHIC i can set these to text but cant change it from 16 in length in table FORUM_CONFIG. And on the FORUM_TOPIC i added T_RATE and T_RATECT but what is Number-Long Integer only thing i see close is numeric would this be right for Number-Long Integer.
Thanks

ERORRO
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UserIP'.

/forum/inc_top.asp, line 178

Go to Top of Page

InfinityWeb
Starting Member

USA
4 Posts

Posted - 30 January 2001 :  04:04:45  Show Profile  Visit InfinityWeb's Homepage  Send InfinityWeb an AOL message  Send InfinityWeb an ICQ Message
Scott,
I love your scripts, but I'm mainly interested in your great topic ratings enhancement since it is EXACTLY what I'm looking for with my site. Is there a way to just add this mod to the newest SR4? If so, where can I grab just that mod?

Thanks so much!

John Cornett

Edited by - infinityweb on 30 January 2001 04:30:56
Go to Top of Page

verbs
Starting Member

6 Posts

Posted - 30 January 2001 :  19:28:45  Show Profile
quote:

Guys, everything seems to work ok, except when one logs off, and goes back to the forum, they have full access to edit, remove, a forum.




I sort of get this - when I log off and go back to the forum and click admin options they are imediately listed and I can change anything ! even when I am logged off !

I have only installed the system and logged on and off as admin (I am praying this is not going to be the same for casual users ) ?

Verbs

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.58 seconds. Powered By: Snitz Forums 2000 Version 3.4.07