Snitz Forums 2000 - Proeders File Attachment Mod

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Proeders File Attachment Mod - Install errors

New Topic

Topic Locked

Printer Friendly

Author

Topic

withanhdammit
Junior Member

USA
236 Posts

Posted - 06 March 2005 : 23:14:29

I went through the instructions for Proeder's File Attachment Mod. During the db update section, I got the following error:

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 | [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

Not sure what to do next, I tried to enter the File Attachment control panel from Admin Options, and got this error:

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

I'm assuming it's because of the db setup problem. This is running on a Win03/IIS6 server with an MSSQL2k server connection.

Thanks for any help!

h

withanhdammit
Junior Member

USA
236 Posts

Posted - 08 March 2005 : 09:22:52

Anyone? I emailed proeder through the forum, but haven't heard back yet. I'm sure someone out there can help me fix this

Golem
Starting Member

2 Posts

Posted - 15 April 2005 : 15:03:41

I think it's very difficult to get the answer from author - he's obviously get tired of support ;)
You should manually add necessary values to your SQL database table. So did I.
1. Look for the table "FORUM_UPSIZE".
2. Right-click it and choose "Design Table" item.
3. Change the value in the "Length" column of "UPLOAD_VAR" item to e.g. "50".
4. Close "Design table" view.
5. Right-click the table "FORUM_UPSIZE" again and choose "Open Table" - "Return all rows" item.
Your table is most likely empty, so:
6. Enter the value "STRTIMEOUT" in the field of the "UPLOAD_VAR" column.
7. Enter the value "3600" in the field of the "UPLOAD_VALUE" column.
8. Click the next lower string. The "ID" of the 1st string should become "1".
9. Enter the value "STRUPLOADFILESIZE" and "100000" (or even "1000000") in the corresponding fields described above.
10. Click the next lower string. The "ID" of the 1st string should become "2".
11. Close "Open table" view.
That's all.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.22 seconds.