Web Wiz Forums - Forum setuup Help needed.

Print Page | Close Window

Forum setuup Help needed.

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15319
Printed Date: 13 April 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Forum setuup Help needed.

Posted By: ahsher
Subject: Forum setuup Help needed.
Date Posted: 01 June 2005 at 6:11am

Hi,

I'd been trying to setup a forum for my client.

I already had the forum all setup on my development server(for testing purposes). Not sure why I'm unable to get the mssql setup page run(in order to create the tables) over the client server, so I generated the SQL script to create all the tables and stored procedures and also exported all the data out and requested my client database personel to run the scripts and import the data. (also grant permission for the tables and stored procedure)

I suppose all the tables are created properly... coz I can access the forum now. However, there're some error. Cannot register new user and cannot create new forum category. This is the error I got when trying to create new category from the admin menu. Any idea where went wrong? Something missing in the table creation?

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Cat_order', table 'webdata.dbo.tblCategory'; column does not allow nulls. INSERT fails.
/forum/admin/category_details.asp, line 88

Replies:

Posted By: dj air
Date Posted: 01 June 2005 at 6:26am

from that error i would say the problem is the default values for the table fields.

when you tranferred the tables you did not set the default values for some of the tables etc, so they are showing errors because there is no value and the field requires a value