[ABD] Images from posts

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
Locked
belleejac
Registered User
Posts: 8
Joined: Mon Nov 02, 2015 8:22 pm

Re: [BETA] Images from posts

Post by 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

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by ouiouiphoto »

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

User avatar
John connor
Registered User
Posts: 2464
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Name: Aaron
Contact:

Re: [BETA] Images from posts

Post by John connor »

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.

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by ouiouiphoto »

John connor wrote:it will be marked as abandon which would be a shame.
For sure. This extension is very usefull for photo forums.

frankingermann
Registered User
Posts: 25
Joined: Sat Nov 21, 2015 4:51 pm
Location: Monschau, Germany
Name: Frank Ingermann

Re: [BETA] Images from posts

Post by frankingermann »

ouiouiphoto wrote:
John connor wrote: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

User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: [BETA] Images from posts

Post by Volksdevil »

Is this still being worked on?
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by ouiouiphoto »

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

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by 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

User avatar
irdem
Registered User
Posts: 172
Joined: Sat Oct 13, 2007 10:31 pm
Contact:

Re: [BETA] Images from posts

Post by 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');

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by ouiouiphoto »

Tanks for jour proposal. Il Will check if it helps

User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: [BETA] Images from posts

Post by 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 @Anv@r.all

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25955
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [ABD] Images from posts

Post by 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
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

Locked

Return to “Abandoned Extensions”