| Author |
 Topic  |
|
modifichicci
Average Member
Italy
787 Posts |
|
|
phatmike11
Starting Member
USA
20 Posts |
 Posted - 05 October 2005 : 10:36:22
|
Getting this error. I tried adding what moddifichicci said in the red font. But get the same error.
Creating table(s)...
CREATE TABLE FORUM_UPSIZE( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , UPLOAD_VAR nvarchar (20) NULL , UPLOAD_VALUE int NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_CONFIG_EXTENSION( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , EXTENSION nvarchar (15) NULL )
Table already exists
--------------------------------------------------------------------------------
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')
-2147217865 | [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_UPSIZE'.< |
Edited by - phatmike11 on 05 October 2005 10:50:29 |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 05 October 2005 : 15:07:01
|
As I sad, this has worked on mysql 4.0.25.
I don't know mssql, but from what I understand table are created, you need to insert the two records:
1° record
UPLOAD_VAR = STRTIMEOUT
UPLOAD_VALUE = 3600
2° record
UPLOAD_VAR = STRUPLOADFILESIZE
UPLOAD_VALUE = 100000
in TABLE FORUM_UPSIZE
You can do it manually, or someone knowing mssql could help you. (It is working in acces too....)
< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
phatmike11
Starting Member
USA
20 Posts |
Posted - 05 October 2005 : 16:54:36
|
I looked in the database and there is no table called FORUM_UPSIZE! What actually is supposed to create this database? I guess I could create it from scractch but I don't know what needs to be inside of it.
I have also entered that code into the mod like 7 times and it looks as if it has created multiple entries in the table. Any idea if this will screw stuff up?< |
Edited by - phatmike11 on 05 October 2005 16:58:54 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 05 October 2005 : 18:17:31
|
Creating table(s)...
CREATE TABLE FORUM_UPSIZE( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , UPLOAD_VAR nvarchar (20) NULL , UPLOAD_VALUE int NULL )
Table already exists
That is what let me suppose the table exist
If not you can create it
[CREATE]
UPSIZE this is the name of table FORUM_UPSIZE
ID this is the id field that is ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL
UPLOAD_VAR#VARCHAR (20)#NULL# that is another field nvarchar (20) NULL
UPLOAD_VALUE#int#NULL# that is another field int NULL
[END]
the same for
[CREATE]
CONFIG_EXTENSION name of table
ID id field the same as previous
EXTENSION#VARCHAR (15)#NULL# the same varchar previous
[END]
Then you can insert the values in the fields,
1° record
UPLOAD_VAR = STRTIMEOUT
UPLOAD_VALUE = 3600
2° record
UPLOAD_VAR = STRUPLOADFILESIZE
UPLOAD_VALUE = 100000
in TABLE FORUM_UPSIZE
< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
phatmike11
Starting Member
USA
20 Posts |
Posted - 06 October 2005 : 09:08:15
|
OK I got the database fixed now how do I get the img forum code to work? For some reason this is simply being printed out in the message not showing the icon.
I typed in with (a bracket before the img) img]icon_paperclip.gif[/img] what file allows you to edit the forum code?
Second, when I click on the link to the attachment it never opens!
Third, when I try and upload an attachment with spaces in it, I get an error message, which is expected. However the text that says you can't use special characters or spaces is white out. YOu have to highlight it to see it. I have been trying to figure out which file contains this text to change the font color but have yet to find it as well.< |
Edited by - phatmike11 on 06 October 2005 09:44:47 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 06 October 2005 : 17:23:30
|
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
< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
Edited by - modifichicci on 06 October 2005 17:24:34 |
|
|
|
phatmike11
Starting Member
USA
20 Posts |
Posted - 07 October 2005 : 09:51:22
|
| Thanks again. I figured out why I could not get to the files that I have uploaded. The server that I have this installed on is sentry.tybrin.com for right now but will be info.tybrin.com and it was pointing to info which does not exist yet. SO that means everything is fixed, except the {img}something.gif[/img] (i put in squirly brackets so it would show up on the page. For some reason this part of the forum code seems to be busted. I am not geting a broken image, it is simply print that exact string out. For some reason the img tag in the forum code file is corrupt or something. I am going to do a little research in the forums< |
|
|
|
phatmike11
Starting Member
USA
20 Posts |
Posted - 07 October 2005 : 10:01:31
|
| I just did a little research and found that the forum code is located in in inc_func_common.asp and went in there. Everything looks good inside there. The forum image tag with the brakets around img is there. But for some reason my images are still not being converted. Any suggestions?< |
|
|
|
phatmike11
Starting Member
USA
20 Posts |
Posted - 07 October 2005 : 10:20:20
|
| EUREKA! I have got it. I started thinking, this has to be something simple because the code is there. And boom it hit me, check your settings. So I went into admin and the images were disallowed in posts and now I got them working haha. Anyhow thanks for all the help, I got everything running properly now other than the attachment links working, but that will fix itself when I deploy this live.< |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 08 November 2005 : 18:49:51
|
Is there any way to use as uploading directory one not in the forum root? Did anyone of you made that change?
My server gives to me only one directory with right permissions, and it's in the domain root: domain.com/public
The forum is in domain.com/forum ....
Thank you< |
|
|
|
stevem
Starting Member
3 Posts |
Posted - 09 November 2005 : 09:55:48
|
quote:
Originally posted by Classicmotorcycling
I have placed this on my forum so Moderators and Admins are the only ones that can post attachments in thier posts.
Any hints on how to do this? I would like to lock down the file sharing to either certain forums or certain users (moderdators & administrators).
Thanks< |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 09 November 2005 : 10:30:23
|
Just make a check in all appropriate files? if mlev > 1 then allow uploads or something =)
That's how I usually do these things.
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
stevem
Starting Member
3 Posts |
Posted - 09 November 2005 : 13:34:30
|
quote:
Originally posted by tribaliztic
Just make a check in all appropriate files? if mlev > 1 then allow uploads or something =)
That's how I usually do these things.
Thanks, I was able to lock it down using a new variable option to restrict the forum code and the following if statement in post.asp.
elseif (strRestrictAttachment = 1) and ((mlev > 3) or ((mlev > 2) and (chkForumModerator(strRqForumId, strDBNTUserName) = "1")))
this way only moderators for that particular forum and administrators can attach files in that forum.
If anyone needs more details on this, let me know.< |
|
|
|
Topic |
|
proeder's File Attachment Mod 1.0
<