[ABD] Images from posts

[belleejac]

Hi now it works if i choose "In list of topics" in display settings. If i choose "on index page", i get sql error

[ouiouiphoto]

Is this extension abandoned ? We are several to raise problem. I have try to contact the author directly but get no answer

[2600]

I just talked to him in PMs about another EXT. But if this EXT continues to not get any responses from the author it will be marked as abandon which would be a shame.

[ouiouiphoto]

it will be marked as abandon which would be a shame.

For sure. This extension is very usefull for photo forums.

[frankingermann]

it will be marked as abandon which would be a shame.

For sure. This extension is very usefull for photo forums.

Yes, indeed - we're preparing to move our (very old) phpBB2 photo forum to phpbb3.1, and
having thumbnails of the photos in the topic lists is a must-have feature before we can move.

fwiw, we'd like to have the thumbnails "clickable" to take you to the topic.

in ext\bb3mobi\imgposts\styles\prosilver\template\event\topiclist_row_prepend.html,

replacing line 3

Code: Select all

<!-- IF topicrow.FILSE_EXIST --><img src="{topicrow.ATTACH_IMG}" width="{FIRST_IMAGES_TOPIC}" height="{FIRST_IMAGES_TOPIC}" alt="" />

with

Code: Select all

<!-- IF topicrow.FILSE_EXIST --><a href="{topicrow.U_VIEW_TOPIC}"><img src="{topicrow.ATTACH_IMG}" width="{FIRST_IMAGES_TOPIC}" height="{FIRST_IMAGES_TOPIC}" alt="" /></a>

does just that. @Anvar, if you're still here... it would be very nice to see this "built-in"!

cheers, Frank

[Volksdevil]

Is this still being worked on?

[ouiouiphoto]

We have receive no feed back from the developer. So i would say no.

[ouiouiphoto]

Hello all

My knowledge in MySQL and Wamp server and phpBB is improving

So i have decided to understand why this query included in the extension crash my forum

Code: Select all

SELECT a.attach_id, a.post_msg_id, a.extension, p.post_id, p.topic_id, p.post_time, p.post_visibility FROM phpbb_attachments a, phpbb_posts p, phpbb_topics t WHERE a.post_msg_id = p.post_id AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif") AND p.post_visibility = 1 GROUP BY a.post_msg_id DESC LIMIT 12 

If you remove the

Code: Select all

GROUP BY a.post_msg_id DESC LIMIT 12

The query return more than 6 000 000 of record. This is not normal. I have only 3 000 attachements in phpbb_attachments.

The problem is here

Code: Select all

FROM phpbb_attachments a, phpbb_posts p, phpbb_topics t 

At the end you can see

Code: Select all

phpbb_topics t 

But this table is not used in the query select neither in the condition. So you can remove it and the query will work again

Now i have to check where is this query in the extension and to test it on my forum. I will let you know

[irdem]

i am not sure but i think your problem is coming from this :

Code: Select all

AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")

you can use this instead of:

Code: Select all

AND ' . $this->db->sql_in_set('extension', $ext_type) . '

and add this line before the sql command:

Code: Select all

$ext_type = array('jpeg', 'jpg', 'JPG', 'gif', 'png', 'bmp');

[ouiouiphoto]

Tanks for jour proposal. Il Will check if it helps

[ouiouiphoto]

So for those that have the

Query execution was interrupted [1317] error

This seems to be linked to a timeout in a query execution that is too long. The query execution is too long because of a query in

ext/bb3mobi/imgposts/core/helper.php

Select (line 485)

Code: Select all

		$sql = 'SELECT a.attach_id, a.post_msg_id, a.extension, p.post_id, p.topic_id, p.post_time, p.post_visibility
			FROM ' . ATTACHMENTS_TABLE . ' a, ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t
			WHERE a.post_msg_id = p.post_id
			AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")
			AND p.post_visibility = 1
			GROUP BY a.post_msg_id DESC LIMIT ' . $this->config['last_images_attachment_count'] .' ';

replace with

Code: Select all

$sql = 'SELECT a.attach_id, a.post_msg_id, a.extension, p.post_id, p.topic_id, p.post_time, p.post_visibility
			FROM ' . ATTACHMENTS_TABLE . ' a, ' . POSTS_TABLE . ' p
			WHERE a.post_msg_id = p.post_id
			AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")
			AND p.post_visibility = 1
			GROUP BY a.post_msg_id DESC LIMIT ' . $this->config['last_images_attachment_count'] .' ';

the extension works again for me

hope it helps @[email protected]

[Paul]

This topic has been marked as [ABD] - Abandoned as the extension author has not been active recently. If the extension author wishes to continue development, please PM anyone on the Extensions Team to request this topic be unlocked.

Notice!
We do not recommend that a user of the phpBB software install this extension, or any other extension that is marked as “abandoned” or “in development”, on a live forum. Doing so may cause your forum to not perform in the manner it should.

Thank you,
The phpBB Extensions Team