| Author |
 Topic  |
|
CoarsefishAnton
New Member
73 Posts |
 Posted - 04 April 2003 : 19:44:21
|
Is it possible to download my forum database and manually add the required table?
Fools like me, like fools like me. |
**************************
Explain it like I'm a five year old..... |
Edited by - CoarsefishAnton on 05 April 2003 06:53:33 |
 |
|
|
chotie
Starting Member
25 Posts |
Posted - 06 April 2003 : 13:07:59
|
Have anyone tried it with an access database?
I am using my snitz forum with an access database 2000.
If i apply the tables using the admin->MOD update,
would this work?
Btw: I also like the inline showing of images..
Thanks to BJH and all others that helped me before...
Christian O.
chot@home.se
|
Br,
Christian O.
chot@home.se |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
chotie
Starting Member
25 Posts |
Posted - 06 April 2003 : 16:19:13
|
Thanks a million, OneWayMule!! :)
/Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
|
|
|
headmaster
Starting Member
16 Posts |
Posted - 15 April 2003 : 16:48:18
|
I seem to be getting an eror when I reply to a post.
There has been a problem!
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
This error happens around line 1026 in post_info.asp
I am usint ASPUpload instead or smartupload. Very minor changes to make these compatible. But the error is happening in a REPLY table insert and not the attachment insert.
MS ACCCESS 2000.
I created the table with the fields you described and all is well there. I have write permissions to the directory and and it actually puts the file there. So that part of the mod seems to be intact.
Thanks,
headmaster
|
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
chotie
Starting Member
25 Posts |
Posted - 18 April 2003 : 06:22:12
|
Hello.
I tried to created the database fields manually as follow:
Under FORUM_ATTACHMENTS
-FORUM_ID for INT and NOT NULL
-TOPIC_ID for INT and NOT NULL
-REPLY_ID FOR INT and NULL
-FILENAME FOR text(char)216 length and NOT NULL
I am not an expert on access so i guess this with
NOT NULL are the field dont get to be empty then?
By now everything went well. The only 2 things i noticed
was:
1. When i want to preview a message with an image
it comes up empty. If i just go ahead and post it
everything works great.. Do i have to change something
in order to make preview to work?
2. I tried to post an image that were 800*600 and
it showed up in al its beauty. Can i limit the showm
image size in anyway? Have anyone done it? If not,
which file will i have to work with?
Thanks to everyone for helping like BJH, OneWayMule, ruirib
and everybody else that helped me before!!
Br,
Christian O.
chot@home.se |
Br,
Christian O.
chot@home.se |
Edited by - chotie on 19 April 2003 08:28:22 |
|
|
|
BJH
Starting Member
16 Posts |
Posted - 21 April 2003 : 14:24:33
|
| hi christian. you're correct about the NOT NULL. those fields cannot be left blank. i forgot about the preview thing. i never use that feature myself. i will try to fix that when i have the time. about the image size, limiting the dimensions would be a little complicated. to do it on the server side, it would require another 3rd party component that can determine the image dimensions, and maybe resize the image. it might be possible to do it on the client side, using javascript. we might run into browser compatibility issues though. if i get a lot of requests for this feature, i might look into adding it. note that you can limit the attachment file size by editing inc_func_attachments.asp. |
|
|
|
username_not_found
Starting Member
1 Posts |
Posted - 30 May 2003 : 14:34:36
|
quote:
Originally posted by rond
I am having a problem with the quick reply feature after installing this mod. The regular reply to topic works fine and I can add attachments, however when someone uses the quick reply the get the following error:
aspSmartUpload error '800a0009'
Subscript out of range
/forum/post_info.asp, line 46
Here is the code.
43 -'this code has to come before the includes below
44 -dim oUpload
45 -Set oUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
46 -oUpload.Upload
I am running IIS 5 on Windows 2000 and this is the only mod I have installed.
I am using version 3.4.03. with MS SQL
I have aspSmartUpload installed on the server.
Can anyone help?
Thanks
Ron Dowell 
I was having the same problem with this code earlier this morning. I thought I'd post the fix because I didn't actually see the fix on this message board.
The fix needs to be added to "topic.asp". You need to put this piece of code into the FORM TAG of the quick reply form:
ENCTYPE=""multipart/form-data""
As soon as you put that into the form tag of the quick reply everything works out perfectly.
|
|
|
|
Topic |
|
Topic Locked
