bbPress Showcase Topic: bbPress Attachments

_ck_ on "bbPress Attachments"

_ck_ — Mon, 04 May 2009 07:44:04 +0000

If you get a red x with no attachment info, that means that creating the db table failed and you might have to do it manually. A few people have reported this, I may need to update the plugin. Please try downloading a new copy of the plugin (remember to copy over your settings) and DEACTIVATE the plugin, and then REACTIVATE it again. <a href="http://plugins-svn.bbpress.org/bb-attachments/trunk/bb-attachments.php" rel="nofollow">http://plugins-svn.bbpress.org/bb-attachments/trunk/bb-attachments.php</a> The reactivation should cause the db table to be created and the errors to go away.

Joseph on "bbPress Attachments"

Joseph — Mon, 04 May 2009 07:22:17 +0000

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

Joseph on "bbPress Attachments"

Joseph — Mon, 04 May 2009 07:12:39 +0000

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

tfbpa on "bbPress Attachments"

tfbpa — Wed, 29 Apr 2009 00:29:10 +0000

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!

_ck_ on "bbPress Attachments"

_ck_ — Thu, 23 Apr 2009 01:03:38 +0000

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.

tfbpa on "bbPress Attachments"

tfbpa — Wed, 22 Apr 2009 22:40:55 +0000

Thanks very much, after creating the table it is working! :D 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! [attachment=1233,118]

_ck_ on "bbPress Attachments"

_ck_ — Wed, 22 Apr 2009 13:17:01 +0000

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: <pre><code>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</code></pre>

tfbpa on "bbPress Attachments"

tfbpa — Wed, 22 Apr 2009 11:57:12 +0000

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?

tfbpa on "bbPress Attachments"

tfbpa — Wed, 22 Apr 2009 11:46:24 +0000

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? [attachment=1230,117]

_ck_ on "bbPress Attachments"

_ck_ — Wed, 22 Apr 2009 11:13:33 +0000

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.