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 DEV-Group
 DEV Bug Reports (Closed)
 (v3.4) BUG+FIX: admin_mod_dbsetup.asp
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 20 August 2002 :  16:13:29  Show Profile
affects both admin_mod_dbsetup.asp & admin_mod_dbsetup2.asp

I've got a problem when adding a dbs file the database for one of the mods I was trying out.

I have my tables configured with the following names:

strTablePrefix = "FORUM_"
strMemberTablePrefix = "MAIN_"

The message I got was:
quote:
Creating table(s)...
CREATE TABLE FORUM_HOTKEYS( HK_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , MEMBER_ID int NULL , HOTKEY varchar(250) NULL )
Table created succesfully

Adding Column HOTKEY_NICK...
ALTER TABLE MAIN_HOTKEYS ADD COLUMN HOTKEY_NICK text(50) NULL
ALTER TABLE MAIN_HOTKEYS ADD COLUMN HOTKEY_NICK text(50) NULL
-2147217865 | Cannot find table or constraint.



Notice the main table is created with the FORUM_ prefix but the update tried to use the MAIN_ prefix.

The problem is with the line:
if Instr(strTableName,"MEMBER",1) > 0 then


5 times in admin_mod_dbsetup.asp
5 times in admin_mod_dbsetup2.asp

Needs changing to:
if Instr(strTableName,"MEMBER") > 0 then

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 August 2002 :  18:09:41  Show Profile
actually they need to be changed to:

if Instr(1,strTableName,"MEMBER",1) > 0 then

discussed here:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=33039#162580
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 20 August 2002 :  18:32:01  Show Profile
The instr in the CreateTables Sub will probably need changing as well then.

It is currently:
if Instr(strTableName,"MEMBER") > 0 then
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 21 August 2002 :  01:16:22  Show Profile
Yes, I changed that one as well

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