I did a search, but could not find a definate answer...
I was adding the Poll Mod as per the instructions onto my forum. The forum runs on SQL 2000.
I get the following when running the add-on, which I think is related to permissions on the SQL Server. However, I do not want the "open up" the SQL Server to the world by mistake. So any help appreciated.
Here are the results..
quote:
Adding Column T_ISPOLL... ALTER TABLE FORUM_TOPICS ADD T_ISPOLL int NULL DEFAULT 0 ALTER TABLE FORUM_TOPICS ADD T_ISPOLL int NULL DEFAULT 0 -2147217900 | User does not have permission to perform this operation on table 'FORUM_TOPICS'. Adding Column T_POLLSTATUS... ALTER TABLE FORUM_TOPICS ADD T_POLLSTATUS int NULL DEFAULT 1 ALTER TABLE FORUM_TOPICS ADD T_POLLSTATUS int NULL DEFAULT 1 -2147217900 | User does not have permission to perform this operation on table 'FORUM_TOPICS'.
Adding Column T_ISPOLL... ALTER TABLE FORUM_A_TOPICS ADD T_ISPOLL int NULL DEFAULT 0 ALTER TABLE FORUM_A_TOPICS ADD T_ISPOLL int NULL DEFAULT 0 -2147217900 | User does not have permission to perform this operation on table 'FORUM_A_TOPICS'. Adding Column T_POLLSTATUS... ALTER TABLE FORUM_A_TOPICS ADD T_POLLSTATUS int NULL DEFAULT 1 ALTER TABLE FORUM_A_TOPICS ADD T_POLLSTATUS int NULL DEFAULT 1 -2147217900 | User does not have permission to perform this operation on table 'FORUM_A_TOPICS'.
Adding Column F_POLLS... ALTER TABLE FORUM_FORUM ADD F_POLLS int NULL DEFAULT 0 ALTER TABLE FORUM_FORUM ADD F_POLLS int NULL DEFAULT 0 -2147217900 | User does not have permission to perform this operation on table 'FORUM_FORUM'.
yes, when ever you edit the DB it must be the first admin (the one you made when setting up the forum) who edits it, less you have edited who the main admin is in config.asp.
Topic Locked
Posted - 19 February 2003 : 17:28:05
