| Author |
 Topic  |
|
|
texanman
Junior Member
United States
410 Posts |
 Posted - 12 January 2008 : 14:34:32
|
I am trying to install this MOD. Just started with the database (using MS SQL). I got the following results:
quote:
File Attachements - New installation
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRALLOWATTACHMENT','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRUPLOADURL','')
Value(s) updated successfully
--------------------------------------------------------------------------------
Dropping Table..
Table does not exist
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_UPSIZE( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , UPLOAD_VAR nvarchar NULL , UPLOAD_VALUE int NULL )
Table created successfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_CONFIG_EXTENSION( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , EXTENSION nvarchar (15) NULL )
Table created successfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_UPSIZE (UPLOAD_VAR,UPLOAD_VALUE) VALUES ('STRTIMEOUT','3600')
INSERT INTO FORUM_UPSIZE (UPLOAD_VAR,UPLOAD_VALUE) VALUES ('STRUPLOADFILESIZE','100000')
INSERT INTO FORUM_UPSIZE (UPLOAD_VAR,UPLOAD_VALUE) VALUES ('STRUPLOADFILESIZE','100000')
-2147217833 | String or binary data would be truncated.
My question is with the parts that say: Dropping Table doesnot exist and also the last row about String or Binary data truncation. Will these prevent me from finishing the install of this MOD?
Thanks |
Edited by - texanman on 13 January 2008 17:23:36 |
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 12 January 2008 : 15:44:26
|
Getting this error when accessing Attachment Admin in the Admin section:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admin_attach.asp, line 65
line 56: strUploadFileSize = rsSize("UPLOAD_VALUE") |
 |
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 13 January 2008 : 17:25:02
|
| ok I found the fixes for the above issues. I have one problem with the attachments links when a user's name has a space in it. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 13 January 2008 : 19:02:17
|
| yeah I remember this coming up before I can't remember if a fix was made or if someone just said to put a note in saying it can't contain any apaces. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 13 January 2008 : 19:08:00
|
nevermind found the fix:
The file is outputfile.asp and pop_upload
If you change the line
if not bTemp then
bTemp = InStr(sValidate, " ") > 0
end if
to
if not bTemp then
bTemp = InStr(sValidate, "(two spaces)") > 0
end if
adding another space inside the " " you can upload a file with a space inside his name.
Check output file or reload the last version inserting the right upload dir in config
This was from modifici |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 13 January 2008 : 20:10:11
|
Thanks Jeff
It looks like this solves the problem. It puts something like '%20' in the space in the user's login name. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 13 January 2008 : 22:00:44
|
Yep then its working as it should. 
Glad you got it working |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 14 January 2008 : 10:54:46
|
Thanks!
I don't see that code in pop_upload_new though! Only outputfile. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 14 January 2008 : 11:41:36
|
| Yeah I am not sure just saw the fix in another thread. Maybe there have been some changes on it and that code isn't in pop_upload anymore |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 15 January 2008 : 22:32:57
|
quote:
Originally posted by texanman
ok I found the fixes for the above issues. I have one problem with the attachments links when a user's name has a space in it.
how did you fix the:
"String or binary data would be truncated."
I ran into that problem on setup and wish to know your solution. Thank you.
|
coaster crazy |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 15 January 2008 : 22:46:23
|
quote:
Originally posted by weeweeslap
quote:
Originally posted by texanman
ok I found the fixes for the above issues. I have one problem with the attachments links when a user's name has a space in it.
how did you fix the:
"String or binary data would be truncated."
I ran into that problem on setup and wish to know your solution. Thank you.
The fix is:
Here
Look in Page 2.
I don't think this mod is updated in snitzbitz.com |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 15 January 2008 : 23:26:06
|
| lol, was about to come and post that I found it. There's many erorrs that need fixing and I managed to fix all the missing &'s and stuff on the other pages. Someone whould update a fixed version thans texanman |
coaster crazy |
|
|
| |
Topic |
|
Topic Locked
