I tryed to implemenet Richard Kinsers mod and recieved the following message when updating the databas with Huws mod_dbsetup. I dind't use the one Richard have in the zip - I used one I already had.
============== Dropping Column... ALTER TABLE FORUM_FORUM -2147217900 | Syntax error in ALTER TABLE statement. Table(s) updated
Dropping Column... ALTER TABLE FORUM_CATEGORY -2147217900 | Syntax error in ALTER TABLE statement. Table(s) updated
-------------------------------------------------------------------------------- There were errors please post a question in the MOD Implementation Forum at Snitz Forums ================ The result after trying to enter the forum is: =============== Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters
/forum/default.asp, line 84 ======================= I learned from Microsoft Knowledge databas that this is a know issue, but the solution needs more knowledge then I can araise.
The structure of the .dbs file has changed from when this MOD was released and the version of mod_dbsetup.asp that you have. If you use the one included with this MOD, you won't get the errors.
or you can change the contents of the catforumsort.dbs file with the following:
Category/Forum Sorting [ALTER] FORUM ADD#FORUM_ORDER#int#NULL#1 [END] [ALTER] CATEGORY ADD#CAT_ORDER#int#NULL#1 [END]
I found the solution looking at a old query. I imported the mod_dbsetup that was included in the zip and my problem were fixed! I never realised the difference between the mod_dbsetup files.
Topic Locked
Posted - 08 April 2001 : 04:33:55
