| Author |
 Topic  |
|
|
leroy
Starting Member
3 Posts |
 Posted - 26 April 2005 : 03:21:58
|
I am using Access, and I cannot get my FORUM_ATTACHMENT table to work correctly.
I created the table manually, since the .sql file doesn't work on Access tables. I keep getting an error in the INSERT query that runs against this table.
Any ideas? How should my table be formatted to work correctly?
Thanks in advance. |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 April 2005 : 04:06:20
|
Leroy,
there was a file called: dbs_bensfileattach.asp in the zip file, that is what you use to do the DB update. You logon as the Admin and in the alternative mod setup, place in this code:[DROP]
ATTACHMENTS
[END] The you go to the normal mod setup and select from the drop down box: MOD: Ben's File Attachment (beta)
Then your database should be setup.
I hope that helps.. |
Cheers,
David Greening |
 |
|
|
leroy
Starting Member
3 Posts |
Posted - 26 April 2005 : 11:33:30
|
I appriciate your reply. I will try that and post my results.
Thanks a lot! |
|
|
|
leroy
Starting Member
3 Posts |
Posted - 26 April 2005 : 19:52:12
|
OK - I tried your recommendation. It didn't work.
I got an error when I tried to run the "MOD:Ben's File Attachment (Beta)" mod from the list in MOD Setup (NOT Alternative MOD Setup). It claims that the "Table Already Exists", even though it didn't exist. Also, after the Mod Setup script executed the table still didn't exist.
Any ideas? |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 27 April 2005 : 00:46:06
|
I have registered at your site, please send me an e-mail with what connection string you are using as this may be the reason why you are having trouble running the dbs file.
|
Cheers,
David Greening |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 28 April 2005 : 17:46:17
|
I have changed the dbs file to now be like this:
Ben's Attachment Mod
[DROP]
ATTACHMENTS
[END]
[CREATE]
ATTACHMENTS
FORUM_ID#int#null#0
TOPIC_ID#int#null#0
REPLY_ID#int#null#0
FILENAME#varchar(220)##
[END]
I found it was missing the space between ATTACHMENTS and the FORUM_ID lines and also the 0 (zero's) after the int lines. Once these where added, the dbs worked in creating the tables. I have passed on the information to Leroy as we have been in contact about it.
So I hope it will help other users out as well.
|
Cheers,
David Greening |
|
|
| |
Topic |
|
Topic Locked
