bbPress Attachments « bbPress Showcase

bbPress Showcase » Plugins by _ck_

bbPress Attachments

(11 posts)

Tags:

bbPress Attachments

pages: 1 2 Next »

tfbpa

member
Joined: Apr '09
Posts: 12
offline
Reputation:15
Hi,

first of I want to thank you for all the work you have done on all plugins, amazing! I also tried to donate something, but is not working, do you already have something new so we non-programmers can give something back?

OK, now to my question...

I am trying to use bbPress Attachments http://bbpress.org/plugins/topic/bb-attachments/ on several alpha releases (4,5,6), but it does not seem to work for me.

The files get uploaded to the correct folder, but the images are not shown in the thread. The URL seems to be correct, but please see my attached picture here for details(the link to the image is the bottom of the browser).

Do you have any ideas as to why and maybe even have a solution?

Thanks,
Paul
Attachments
1. forumpic.JPG (104.9 KB, 7 downloads) 1 year old
Posted 1 year ago #
_ck_

senior admin
Joined: Jul '06
Posts: 685
offline
Reputation:733

Where is the list of attachments in that screenshot?
Something is wrong there.

If you can, temporarily switch to the default Kakumei theme and try uploading a test jpeg.

Posted 1 year ago #
tfbpa

member
Joined: Apr '09
Posts: 12
offline
Reputation:15
Thanks for fast reply.

Just to be safe I also got rid of my deep integration with bbpress and used the default template. Btw I am using WPMU 2.7.

Unfortunately nothing changed, see attached image.

Any ideas?
Attachments
1. forumpic2.JPG (79.2 KB, 0 downloads) 1 year old
Posted 1 year ago #
tfbpa

member
Joined: Apr '09
Posts: 12
offline
Reputation:15

Just had a look at my MySQL(5.0.67) and I cannot seem to find any new table. Don't know if it should use an existing one or not, but I cannot find anything.

Could that be the problem?

Posted 1 year ago #

_ck_

senior admin
Joined: Jul '06
Posts: 685

offline

Reputation:733

It's possible the create table failed for some reason.

I'd like to know why it failed but if you can try creating it manually with this:

CREATE TABLE IF NOT EXISTS bb_attachments (
	id		int(10)        UNSIGNED NOT NULL auto_increment,
	time       	int(10)        UNSIGNED NOT NULL default '0',
	post_id 	int(10)        UNSIGNED NOT NULL default '0',
	user_id 	int(10)        UNSIGNED NOT NULL default '0',
	user_ip 	int(10) 	       UNSIGNED NOT NULL default '0',
	status       	tinyint(10) UNSIGNED NOT NULL default '0',
	downloads 	int(10)         UNSIGNED NOT NULL default '0',
	size        	int(10)         UNSIGNED NOT NULL default '0',
	ext 	     	varchar(255)           NOT NULL default '',
	mime     	varchar(255) 	         NOT NULL default '',
	filename     	varchar(255) 	         NOT NULL default '',
	PRIMARY KEY (id),
	INDEX (post_id)
	) CHARSET utf8  COLLATE utf8_general_ci

Posted 1 year ago #

tfbpa

member
Joined: Apr '09
Posts: 12
offline
Reputation:15
Thanks very much, after creating the table it is working!

Is there anything I can give you so you might be able to find out why the table wasn't created?

Now I only have one small issue. Even after I set the max. upload size to 2048k, anything bigger than 1400k is not displayed. The upload works fine and all files are stored on the server, but in the post the images do not show. Inside the post it is possible to click on the attachment to download, that works fine, but it is not displayed in the post as an image.

Thanks again for the great plugin and your support!
Attachments
1. forumpic3.JPG (90.7 KB, 1 downloads) 1 year old
Posted 1 year ago #
_ck_

senior admin
Joined: Jul '06
Posts: 685
offline
Reputation:733

Are you sure the full file is really on the server?
It might mean your php.ini is limiting the maximum uploading size.
Do you have root on your server or is it shared hosting?

The only reason why it would offer only to download it is if php doesn't think it's an image. I don't have size limits in there.

Posted 1 year ago #
tfbpa

member
Joined: Apr '09
Posts: 12
offline
Reputation:15

Just changed to VPS hosting and now all is working as it should!

Still strange as I had set my custom php.ini on my shared host to 64MB, but at least I am happy now with my new VPS.

Thanks for the support and all your plugins!

Posted 1 year ago #
Joseph

new member
Joined: May '09
Posts: 3
offline
Reputation:3

Hi,

I want to Thank you as well BUT, I am having trouble getting this to work,

BBPRESS version: Newest 9.
Server: Linuix VPS
Attachment Location: in root like you said
Errors when trying to upload: [failed] red-man.jpg (2.9 KB) 11 minutes old

I have tried GIF, JPG etc, nothing works,

With a little red x square next to it,

I have read the install read me, This forum thread and search Google for a bit and I am stuck,

If you could let me what to do next that would be great,

Thanks

Joseph

Posted 1 year ago #
Joseph

new member
Joined: May '09
Posts: 3
offline
Reputation:3

Hi,

An update:

When I went to delete the "test post" I made I got this SQL error

bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE status=0 AND user_id>0 AND size>0 AND post_id IN (SELECT post_id FROM bb_p' at line 1]
SELECT count(*) as count FROM WHERE status=0 AND user_id>0 AND size>0 AND post_id IN (SELECT post_id FROM bb_posts WHERE post_status=0 AND topic_id=13)
1

I DEactibvated the plugin and when I go to delete a post there is no more error.

I also create the table manually like above and no go as well.

Please let me know the fix,

Thank you again

Joseph

Posted 1 year ago #

RSS feed for this topic

pages: 1 2 Next »

Reply »

You must log in to post.

keep _ck_ coding >> donate $5 << Theme Switcher: