Attachments

[Migrated From Jforum.net]

Does anyone have a full list of the allowed attachments on jforum and can I add to this?

Is there a reason why certain docs aren't allowed?

Thanks,

Liam
[originally posted on jforum.net by liam]

[Migrated From Jforum.net]

liam wrote:Does anyone have a full list of the allowed attachments on jforum and can I add to this?

Is there a reason why certain docs aren't allowed?

Thanks,

Liam

I don't think there are any limitations on the file type of attachments.

What version of JForum are you using? Some of the older versions have a file size limitation bug, which has been corrected in CVS.
[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

I'm using 2.1.4 but don't want to update the version from CVS as there are lots of modifications i have made which i don't want to lose.

I'm not sure if it is a file size issue as i tried to upload blank versions of the following documents yesterday on the test forum on this site and got the same result:-

http://www.jforum.net/posts/list/1654.page#10271

.bmp
.txt
.ppt
.psd

There are no error messages the files just don't upload.

Any ideas?

Thanks

Liam
[originally posted on jforum.net by liam]

[Migrated From Jforum.net]

hi .. i have just installed jForum-2.1.6 on weblogic with oracle as the db.

I am not able to add attachments. surfed through some of the faqs

AdminPanel>Attachements>Extension Groups page. i added a jpg extension, checked the allowd box and download mode is inline upload icon ( some absolute path with an existing image) when i click submit..

i get the following error..

ORA-02289: sequence does not exist


Please help to sort out things in getting my attachments working.. this is very urgent.

Thanks
Nagzu
[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

also in AdminPanel>Attachments>QuotaLimit..

1.i created a new quota limit successfully
2. i selected the group and the corresponding quota limit using the drop down menus and clicked on submnit.

i see the following exception..
ORA-00911: invalid character


does nebody getting the same..

can newbody help me arnd this thing..

Thanks
Nagzu


[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

Which Oracle server are you using? Also, which is the version of the JDBC driver?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Try logging into oracle sqlplus as the jforum user and executing the following.. It appears the create sequence is missing from the oracle ddl file

create sequence jforum_extension_group_seq
[originally posted on jforum.net by mark_d_drake]

[Migrated From Jforum.net]

Rafael Steil wrote:Which Oracle server are you using? Also, which is the version of the JDBC driver?

Rafael

i am running on Oracle 9i + thin driver


I am out of the invalid character bug.. had to debug the code a bit.

error is in generic_queries.sql

1.for ORA-00911: invalid character

AttachmentModel.removeQuotaLimit = DELETE FROM jforum_quota_limit WHERE quota_limit_id = ?;

changed to

AttachmentModel.removeQuotaLimit = DELETE FROM jforum_quota_limit WHERE quota_limit_id = ?


2. for ORA-02289: sequence does not exist
in generic_queries.sql

AttachmentModel.addExtensionGroup = INSERT INTO jforum_extension_groups (name, allow, upload_icon, download_mode) VALUES (?, ?, ?)

changed to

AttachmentModel.addExtensionGroup = INSERT INTO jforum_extension_groups (EXTENSION_GROUP_ID, name, allow, upload_icon, download_mode) VALUES (jforum_extension_groups_seq.nextval,?, ?, ?, ?)


Now. attachments are working fine.. Thanks for the responses:)

Another nice-to-have feature: the search function returns just the topic and not the exact message in which the word has occured




[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

mark_d_drake wrote:Try logging into oracle sqlplus as the jforum user and executing the following.. It appears the create sequence is missing from the oracle ddl file

create sequence jforum_extension_group_seq

The sequence already existed. What i observed was that the seq.nextval wasnt inserted in the respective insert statements .

either u shld have a seq.nextval or have a trigger for all the inserts..

thanks for the response.

Nagzu
[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

In the 2.1.6 scripts the DDL referers to a sequence called jforum_extension_groups_seq but the DML uses jforum_extension_group_seq.
[originally posted on jforum.net by mark_d_drake]

[Migrated From Jforum.net]

mark_d_drake wrote:In the 2.1.6 scripts the DDL referers to a sequence called jforum_extension_groups_seq but the DML uses jforum_extension_group_seq.

oh.. good observation..

Thanks
Nagzu
[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

naga2054 wrote:hi .. i have just installed jForum-2.1.6 on weblogic with oracle as the db.

I am not able to add attachments. surfed through some of the faqs

AdminPanel>Attachements>Extension Groups page. i added a jpg extension, checked the allowd box and download mode is inline upload icon ( some absolute path with an existing image) when i click submit..

i get the following error..

ORA-02289: sequence does not exist


Please help to sort out things in getting my attachments working.. this is very urgent.

Thanks
Nagzu

I have installed jforum216 on linux this time weblogic/oracle being the config. i replaced the modified generic_sql file..

all extensiongroups and extensions are working fine.. but issue is i am not able to c the "attache files" icon during reply of my users.. please guide me once again

Thanks
Nagzu
[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

I traced the source code to PostAction.java

this.context.put("attachmentsEnabled", SecurityRepository.canAccess(
SecurityConstants.PERM_ATTACHMENTS_ENABLED, Integer.toString(topic.getForumId())));


Now, does anybody know what does this securityRepository mean when working on unix based systems ( linux in my case)

Thanks
Nagzu
[originally posted on jforum.net by naga2054]

[Migrated From Jforum.net]

Just add the right permissions:

Admin Panel -> Groups -> Permissions

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

for those of you interested in an answer to the initial question (as the thread went a little of track) there are no restrictions unless the file is truely empty.

Certain files such as psd, txt, zip and bmp need some data in the file for it to upload as a blank document merely acts as a pointer to the application and not the file.

When i was testing i just right clicked and created a new document without adding content or opening the files. This is why it wasn't uploaded.
[originally posted on jforum.net by liam]

[Migrated From Jforum.net]

I have an issue when I try to attach to a forum- this is using a .doc which we have sucessfully uploaded before

I get-

HTTP Status 500 -

type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
net.jforum.JForumExecutionContext.enableRollback(JForumExecutionContext.java:272)
net.jforum.JForum.service(JForum.java:209)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.


Now- as I have just built this forum is there something I forgot? or Bolloxed up? Or is this a bug?
[originally posted on jforum.net by Dr J]

[Migrated From Jforum.net]

The most likely cause of this is that you don't have a "tmp" directory in your jForum webapp root. E.g.:

$TOMCAT_HOME/webapps/jforum/tmp

There is a minor bug in the code that if an exception occurs prior to the JforumExecutionContext being initialized, the enableRollback call in the exception catch will fail with a null pointer exception.
[originally posted on jforum.net by monroe]