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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 installing messageicons MOD on 3.3		  New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  22:34:17  Show Profile
when i used the db setup file i got the following errors:


Adding Column T_MSGICON...
Column added successfully

--------------------------------------------------------------------------------

Adding Column R_MSGICON...
Column added successfully

--------------------------------------------------------------------------------

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_TOPICS SET T_MSGICON = 1 WHERE

--------------------------------------------------------------------------------

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_REPLY SET R_MSGICON = 1 WHERE


RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  22:35:52  Show Profile
Sounds like a version problem with the mod_dbsetup.asp file.

Are you using the admin_mod_dbsetup.asp file that came with v3.3
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  22:47:11  Show Profile
i am using the one that came with the mod..i think its the mod...some of the script replacments didn't match the 3.3 script that was there.
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  22:49:02  Show Profile
everything is screwed up soo i replaced the original files back and tried to re-run the db setup and got this:...


Adding Column T_MSGICON...
Column already exists

--------------------------------------------------------------------------------

Adding Column R_MSGICON...
Column already exists

--------------------------------------------------------------------------------

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_TOPICS SET T_MSGICON = 1 WHERE

--------------------------------------------------------------------------------

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_REPLY SET R_MSGICON = 1 WHERE


*edit...notices that u r the creator of the mod oO...u got copies of the files already done?...lol im getting lazy

Edited by - Goku121 on 30 July 2001 22:50:43
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  22:50:30  Show Profile
Have you tried using the MOD Setup from the Admin Options?
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  22:51:42  Show Profile
(that's what im using oO)
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  23:05:25  Show Profile
OK so now i have no idea what to do...should i re-attepmt to change the scrpits in the files and then try to run the db setup?...
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  23:10:37  Show Profile
For some reason the UPDATE is not working right.

Try creating a new file called dbs_messageicons3.asp

Here is what should be in that file:


Message Icons Update
[UPDATE]
TOPICS
T_MSGICON#1#
[END]
[UPDATE]
REPLY
R_MSGICON#1#
[END]


Then run MOD Setup again and choose Message Icons Update from the dropdown.
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  23:22:42  Show Profile

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_TOPICS SET T_MSGICON = 1 WHERE

--------------------------------------------------------------------------------

Updating Forum Values..
-2147217900 | Syntax error in WHERE clause.
UPDATE FORUM_REPLY SET R_MSGICON = 1 WHERE

--------------------------------------------------------------------------------
...I guess that's because I have yet to put in all the changes to the 4 asp right?*Is updating scripts...*
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  23:30:06  Show Profile
No, updating the database isn't affected by not having the .asp pages edited yet.

Must be something in the admin_mod_dbsetup.asp file.

Are you using MS Access or MS SQL (or MySQL) ?
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  23:31:09  Show Profile
access -im on brinkster if it matters
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  23:34:01  Show Profile
do you know how to use the Database Manager that Brinkster has?

If not, if you e-mail me you Brinkster Username/password, I'll update your database for you if you'd like.
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  23:37:13  Show Profile
(I know nothing about asp,..but i get by lol) Um...sure what's ur E-mail...?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  23:41:30  Show Profile
mailto:richard_kinser@yahoo.com
Go to Top of Page

Goku121
Starting Member

30 Posts
Posted - 30 July 2001 :  23:43:43  Show Profile
I sent it to u thru the mb popup window. if u don't get it let me know
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 July 2001 :  23:49:32  Show Profile
You're database has been updated.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next 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 1.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07