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
 mod_dbsetup issues again...
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

TheMarkel
Starting Member

USA
14 Posts

Posted - 21 April 2001 :  16:08:43  Show Profile  Visit TheMarkel's Homepage  Send TheMarkel an AOL message  Send TheMarkel an ICQ Message
This is what I'm trying to install:
quote:

Category/Forum Sorting Mod (Default)
[ALTER]
FORUM
FORUM_ORDER;int;NULL;1
[END]
[ALTER]
CATEGORY
CAT_ORDER;int;NULL;1
[END]


It returns this:
quote:

Dropping Column...
ALTER TABLE FORUM_FORUM
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated

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

Dropping Column...
ALTER TABLE FORUM_CATEGORY
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated


If I change to this:
quote:

Category/Forum Sorting Mod (Default)
[ALTER]
FORUM
FORUM_ORDER#int#NULL#1
[END]
[ALTER]
CATEGORY
CAT_ORDER#int#NULL#1
[END]


I get this:
quote:

Dropping Column...
ALTER TABLE FORUM_FORUMint
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated

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

Dropping Column...
ALTER TABLE FORUM_CATEGORYint
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated



I've been banging my head against my desk trying to figure out what I'm doing wrong here - can anyone offer input?



'move every 'sig.''


--markel

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 21 April 2001 :  17:21:53  Show Profile
change it to this:


[ALTER]
FORUM
ADD#FORUM_ORDER#int#NULL#1
[END]
[ALTER]
CATEGORY
ADD#CAT_ORDER#int#NULL#1
[END]

Go to Top of Page

TheMarkel
Starting Member

USA
14 Posts

Posted - 21 April 2001 :  22:33:57  Show Profile  Visit TheMarkel's Homepage  Send TheMarkel an AOL message  Send TheMarkel an ICQ Message
Much better now, thank you.



'move every 'sig.''


--markel
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 22 April 2001 :  01:26:23  Show Profile
you're welcome
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.51 seconds. Powered By: Snitz Forums 2000 Version 3.4.07