Web+Center Support
28 Oct

Knowledge Base Detail

Case Summary: Problem with some 3.5 to 4.0 upgrades with missing database column - Reports ASP error messages of: Too few parameters. Expected 1 when bringing up search engine, case form ,etc
ID: 799
Date Created: 01/29/2003
Last Modified: 02/12/2003
Problem Type: Problem Report
Item: Web+Center 4.0 Production
Resolution:
It appears that some 3.5 databases may be missing a column in the categories called category_index. Open up the database directly and the categories table and add an autonumber field called Category_Index if this field is missing. The database should stay in Access 97 format. If you have Access 2000, to get into design mode, convert to 2000 format, make changes the database design and then convert back to 97 format using the tools... convert database to prior version. This column may be missing if your 3.5 database was actually already converted from a previous version that did not include that column. Once converted, then run the new script called FixCategoryLists.asp or go into manage category lists and touch all of the category lists to get the categories fix again.

Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com