Bug in attachment module

Current Version: 2.3.0
Released: 2023-03-19
Forum rules
Before creating a new support thread, please take a look at the board3 Portal FAQ and use the search!
Many questions have already been answered.

Topic author
playagiron
Active Member
Posts: 29
Joined: 4. July 2011 11:23

Bug in attachment module

Post by playagiron »

Hi,

the portal looks great.
However I get a bug in the attachment modules, whenever I select OR only specific forums or specific extensions to show.

The SQL command to subset these seems to generate wrong SQL code, and I can see it as it somehow adds / around ' signs.

Code: Select all

SELECT a.*, t.forum_id FROM phpbb_attachments a, phpbb_topics t WHERE a.topic_id <> 0 AND a.topic_id = t.topic_id AND t.forum_id IN (\'5\', \'15\', \'32\', \'33\', \'14\', \'31\', \'30\') AND a.extension = \'mp3\' ORDER BY filetime DESC, post_msg_id ASC LIMIT 2
My board runs on PHP 7.4 so dhousl be compatible no?
User avatar

Kirk
Dev
Posts: 1956
Joined: 27. July 2010 18:02
phpBB.de User: Kirk

Re: Bug in attachment module

Post by Kirk »

Open the File ./ext/board3/portal/modules/attachments.php
Find:

Code: Select all

						' . $this->db->sql_escape($where) . '
Replace with:

Code: Select all

						' . $where . '
Gruß Udo

Topic author
playagiron
Active Member
Posts: 29
Joined: 4. July 2011 11:23

Re: Bug in attachment module

Post by playagiron »

Perfect solution,

thanks a lot Udo!

Return to “Board3 Portal 2.3.x - English Support”