Kelly you're using a MS SQL Server database, right? Are you capable of taking a look at the value of the field F_PRIVATEFORUMS in the FORUM_FORUM folder? Can you tell me what value does it have?
Ok, I just had another user with a problem similar to yours and looks like the issue lies indeed with the database.
Kelly, please run setup.asp like this: setup.asp?RC=5
Let me know how it goes. Beware that this will erase the contents of your Snitz forum tables, so do not do it if you have data you do want to keep in those tables.
Well ok I will do that but it say? To install the tables in the database you need to create the empty database on the server first. How do I do that cause I dont wnat to mess things up worse. Thank you have a goodone.
Run setup.asp?RC=5 and the tables will be created on the database you have already specified. If your connection string is correct, the tables will be properly created and the problem will disappear.
I try and upgrade but says Couldn't open the database. Make sure you supplied a correct user name and password. Code : 80040E4D Error Description : Login failed for user 'webforumadmin' I cant get past that Thxs again.
That means the user name and/or the password to login into the database, you specified in your connection string, is not correct. Talk to your host to find out what are the correct values to use.
Well I found that forum_forum folder you were talking about. I ran the setup.asp?rc=5 and here what I get Please Wait until the upgrade has been completed !
Upgraded: T_STICKY field value updated in the TOPICS table Upgraded: Added default values for new fields in CONFIG table Error: 80040E14 Cannot alter column 'T_MESSAGE' because it is 'ntext'. strUpdateSql: ALTER TABLE FORUM_A_TOPICS ALTER COLUMN T_MESSAGE NTEXT NULL Error: 80040E14 Cannot alter column 'T_MESSAGE' because it is 'ntext'. strUpdateSql: ALTER TABLE FORUM_TOPICS ALTER COLUMN T_MESSAGE NTEXT NULL Upgraded: T_SUBJECT Field has been changed Upgraded: T_SUBJECT Field has been changed Error: 80040E14 Cannot alter column 'R_MESSAGE' because it is 'ntext'. strUpdateSql: ALTER TABLE FORUM_A_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL Error: 80040E14 Cannot alter column 'R_MESSAGE' because it is 'ntext'. strUpdateSql: ALTER TABLE FORUM_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL Upgraded: Added default values for new fields in CONFIG table
The Upgrade has been completed without errors !
Click here to return to the forum....
I going to delete everything again even all the files under the my data base. reinstall and try it again. Thank You again.
Well I think There must of been a bad file or something in my MS SQL database. I deleted all of it deleted all the files I uploaded re uploaded Snitz 3.4.04 ran the setup.asp?5 IT all installed correctly it said anyway. I did not change any admin setting. Maid up a new forum and lodged off the admin user. created a test user logged in and proceeded to post a reply to the test forum I created. Ill run a few more test tonight to make sure. I hope I have it this time though hehe. Thank you bunches.
Topic Locked
Posted - 09 July 2004 : 06:21:21
