I have a problem with the fileatt. Mod. I have installed the required files - but when I run the mod_dbsetup.asp I get the following error: -------------------------------------------- Creating table(s)... CREATE TABLE FORUM_USERFILES( F_FILEID int COUNTER NOT NULL , MEMBER_ID int NOT NULL , F_FILENAME text (255) NOT NULL , F_FILESIZE int NULL , F_REPLY_ID int NULL , F_TOPIC_ID int NULL ) -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Adding Column... ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWDOWNLOADS int NULL DEFAULT 1 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. Adding Column... ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWUPLOADS int NULL DEFAULT 1 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. Table(s) updated ___________________________________________
I have installed the fileatt. mod also to see if the eror had any practical meaning. But the post.asp don´t produce a possibilty to att. a file. I have called the script on its own - and it works fine, my files are uploaded to the folder. Anybody having an idéa what I´m doing wrong ?
...uhhm...not much response. I tryed to set my db to acces 2000 instead of 97 and that seems to have solved some of the problems. The fileatt. icon now shows up when I post a message. The popupwindow also popup. And the file is uploaded (I see on my modem) - but after the fileupload I get a error 500. I have set Permissions correct, and the server does allow uploads. I have remembered to make a "uploaded" dir. I have followed the instructions in every detail (over and over).
Anybody here that have a clue what I´m doing wrong ?