Jump to content

(NB40) Recent Forum Images (Attachments)


Recommended Posts

This is weird because the date of that post and the image was uploaded with it was Posted 11 hours ago

https://www.walkingfootball.com/forums/topic/995-tra-walking-football-national-league/

I myself uploaded the other one on Posted Tuesday at 11:28 AM

 

you are looking at this image of a football team

https://www.walkingfootball.com/forums/topic/995-tra-walking-football-national-league/?tab=comments#comment-1650

Link to comment
34 minutes ago, Unlucky said:

This is weird because the date of that post and the image was uploaded with it was Posted 11 hours ago

https://www.walkingfootball.com/forums/topic/995-tra-walking-football-national-league/

I myself uploaded the other one on Posted Tuesday at 11:28 AM

You can run sql query 

SELECT attach_id, FROM_UNIXTIME(attach_date) as uploaded, CONCAT('https://www.walkingfootball.com/uploads/', attach_location) as location FROM core_attachments WHERE attach_id IN (1367, 1400);

and compare results

Edited by newbie LAC
Link to comment
  • 6 months later...
38 minutes ago, Soniceffect said:

Dont know if you are aware or not @newbie LAC but this doesnt seem to work with 4.3. I realize its in beta, but thought I would let you know.

Hello,

I'm not support beta versions. But I made quick test and confirm the bug with carousel.

I fixed it for 4.3.0. If you know any issues please tell me.

Edited by newbie LAC
Link to comment
  • 3 weeks later...
On 4/6/2018 at 5:49 AM, newbie LAC said:

Hello,

I'm not support beta versions. But I made quick test and confirm the bug with carousel.

I fixed it for 4.3.0. If you know any issues please tell me.

We're on 4.3.1 now but it looks like the latest version of your plugin was uploaded in February... Will you be uploading a new version?

Link to comment
  • 1 month later...
3 minutes ago, newbie LAC said:

What do you mean?

The plugin loads but not fully, the slider is working but the tiny loading icon in the browser tab continues to spin and my site becomes slow, when I disable the plugin all is fine.

I'm using Chrome BTW.

Link to comment
  • 5 weeks later...

I've installed the plugin on 4.3.4, but fails to add, showing an "Error" text. Reloading the page the message does not appear but neither the plugin. Enabled hook, activated, select all forums, suggested settings but nothing. 

Adding the block (error on the place I've drag and dropped Recent Forum Images)

769942148_Capturadepantalla2018-07-1819_19_35.png.c8e0291e668cd2fe1f97dad9bee2e3b7.png

 

Show this when I finished adding the block

29870948_Capturadepantalla2018-07-1819_19_42.png.67a88854be85cc48eb01f43f13c0314d.png

 

On page reload it dissapears but the block is missing

127825936_Capturadepantalla2018-07-1819_19_48.png.c9c125bd8ccc75016f043ffd4dce0ef5.png

 

These are the settings I'm using

 

1945261635_Capturadepantalla2018-07-1819_15_46.thumb.png.9aadef1ac6b40eec7b99f1b404f0748c.png

Thanks in advance!

 

Captura de pantalla 2018-07-18 19.19.26.png

Edited by rfcontreras
Link to comment

Maybe it's related, I get this error when changing themes... 

 

SELECT DISTINCT(pid) FROM `core_attachments`  LEFT JOIN `core_attachments_map` ON core_attachments_map.attachment_id=core_attachments.attach_id  LEFT JOIN `forums_posts` ON forums_posts.pid=core_attachments_map.id2  LEFT JOIN `forums_topics` ON forums_posts.topic_id=forums_topics.tid  LEFT JOIN `core_permission_index` ON core_permission_index.perm_type_id=forums_topics.forum_id WHERE ( forum_id IN(3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,36,37,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,58,60,61,63,64,66,67,69,71,73,74) ) AND forums_posts.new_topic=1 AND core_permission_index.app='forums' AND core_permission_index.perm_type='forum' AND core_attachments.attach_is_image=1 AND core_attachments_map.location_key='forums_Forums' AND core_attachments.attach_is_archived=0 AND forums_posts.queued=0 AND forums_topics.approved=1 ORDER BY attach_date DESC LIMIT 0,15
IPS\Db\Exception: Expression #1 of ORDER BY clause is not in SELECT list, references column 'espacio_ipb.core_attachments.attach_date' which is not in SELECT list; this is incompatible with DISTINCT (3065)

 

  • PHP Version7.0.30-0ubuntu0.16.04.1
     
  • MySQL Version5.7.22-0ubuntu0.16.04.1 

Edited by rfcontreras
Link to comment

Changing the settings in my.cnf to sql-mode="" solves the issue temporarily, but adding attach_date to the sql statement should solve the issue. Mysql 5.7 is way more restrictive and requires the order by fields on the select statement.

Looking forward this change on the plugin

Thanks in advance!

Link to comment
2 hours ago, rfcontreras said:

Thanks! This fix worked, but whatever I put on image quantity it shows Just 1 image.    Should I need to remové and install or just upgrade  that I did ?

Thanks in advance

I setup the settings as on your screenshot.

I can't reproduce.

Try to disable 2 settings

- First post

- First attachment

Link to comment
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...