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
Topic Options
Post Options
Thanks(0)
