Recent posts
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
oqpmg
Posts: 4
Joined: Fri Jun 17, 2022 9:09 pm
Reactions: 3

Suggestion: phpBB Topic/Post Reactions

by oqpmg » Fri Oct 21, 2022 1:40 pm

Hey Steve,

Did you had a chance to look into the issue?

Cheers
Topic: sql debug info at the bottom of all pages? (post reactions) | Author: dantose | Replies 3 | Views 70
AVATAR
Steve
Site Admin
Posts: 97
Joined: Sun Jan 30, 2022 8:17 am
Reactions: 30

sql debug info at the bottom of all pages? (post reactions)

by Steve » Thu Aug 18, 2022 6:11 am

That’s one way of doing it. I’m not at the pc at the moment.
1 Image
Topic: sql debug info at the bottom of all pages? (post reactions) | Author: dantose | Replies 3 | Views 70
AVATAR
dantose
Posts: 2
Joined: Thu Aug 18, 2022 4:18 am

sql debug info at the bottom of all pages? (post reactions)

by dantose » Thu Aug 18, 2022 4:41 am

dantose wrote: Thu Aug 18, 2022 4:24 am Is there a way to turn this off? I'm seeing the folowing at the bottom of every page when post reactions is turned on:
Image
Looks like it can be turned off by editing \steve\postreactions\config\debug.yml and setting all to false.
Topic: sql debug info at the bottom of all pages? (post reactions) | Author: dantose | Replies 3 | Views 70
AVATAR
dantose
Posts: 2
Joined: Thu Aug 18, 2022 4:18 am

sql debug info at the bottom of all pages? (post reactions)

by dantose » Thu Aug 18, 2022 4:24 am

Is there a way to turn this off? I'm seeing the folowing at the bottom of every page when post reactions is turned on:
Image
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
oqpmg
Posts: 4
Joined: Fri Jun 17, 2022 9:09 pm
Reactions: 3

Suggestion: phpBB Topic/Post Reactions

by oqpmg » Sat Jun 18, 2022 10:49 am

Cool! Looking forward to hearing from you
1 Image
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
Steve
Site Admin
Posts: 97
Joined: Sun Jan 30, 2022 8:17 am
Reactions: 30

Suggestion: phpBB Topic/Post Reactions

by Steve » Sat Jun 18, 2022 8:16 am

I can fix that using distinct, let me test and I will let you know the outcome. It will come with the next version which should be in a week or so.
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
oqpmg
Posts: 4
Joined: Fri Jun 17, 2022 9:09 pm
Reactions: 3

Suggestion: phpBB Topic/Post Reactions

by oqpmg » Sat Jun 18, 2022 8:11 am

Yep, I've also thought so, considering PhpBB handles DB abstraction stuff.

Asking because I keep getting different SQL errors when trying to open user profile.
At first it was complaining to syntax with '' in query

Code: Select all

SQL ERROR [ postgres ]

ERROR: invalid input syntax for type integer: "" LINE 5: AND reaction_type_id <> '' ^ []

SQL

SELECT COUNT(reaction_user_id) AS reacted FROM phpbb_reactions WHERE reaction_user_id = 58 AND reaction_type_id = '1' AND reaction_type_id <> ''

BACKTRACE
...
I have removed this part from event/user_listener.php (around line 66):

Code: Select all

AND " . $this->db->sql_in_set('reaction_type_id', array_unique(explode('|',  $event['member']['user_disabled_reaction_ids'])), true);

Now it complains about

Code: Select all

SQL ERROR [ postgres ]

ERROR: function group_concat(character varying) does not exist LINE 1: ...otal_count, reaction_type_id, reaction_file_name, GROUP_CONC... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. []

SQL

SELECT COUNT(reaction_type_id) as total_count, reaction_type_id, reaction_file_name, GROUP_CONCAT(DISTINCT reaction_type_title) as title, GROUP_CONCAT(poster_id) as poster_id FROM phpbb_reactions WHERE poster_id = 58 AND reaction_type_id = '1' AND reaction_type_id <> '' GROUP BY reaction_type_id, reaction_file_name ORDER BY reaction_type_id ASC

BACKTRACE
...
1 Image
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
Steve
Site Admin
Posts: 97
Joined: Sun Jan 30, 2022 8:17 am
Reactions: 30

Suggestion: phpBB Topic/Post Reactions

by Steve » Sat Jun 18, 2022 4:31 am

I’ve never tried it, but phpBB should handle different database types.
Topic: Suggestion: phpBB Topic/Post Reactions | Author: bennybernaer | Replies 30 | Views 1680
AVATAR
oqpmg
Posts: 4
Joined: Fri Jun 17, 2022 9:09 pm
Reactions: 3

Suggestion: phpBB Topic/Post Reactions

by oqpmg » Fri Jun 17, 2022 9:11 pm

Looks cool, Steve! Thank you!
Does it works with PostgreSQL?
1 Image
Topic: PhpBB style: grid pro green | Author: Steve | Replies 1 | Views 52
AVATAR
Steve
Site Admin
Posts: 97
Joined: Sun Jan 30, 2022 8:17 am
Reactions: 30

PhpBB style: grid pro green

by Steve » Sun Jun 05, 2022 4:09 am

Style Name: Grid-Pro-Green

Style Description: Very simple style, layout of forums are In Grids.

Style Version: 1.0.4

Requirements:
  • phpBB 3.3.6,3.3.7 version 1.0.1
Features:
Minimal edits/changes, keeping updates easy to maintain.
Mobile/ responsive design forums