[CDB] Prime Post Revisions

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Locked
kpazdziorny
Registered User
Posts: 3
Joined: Thu Feb 02, 2023 12:29 pm

Re: [3.2][3.3][RC] Prime Post Revisions

Post by kpazdziorny »

Hi. I'm not programmer but i have a problem with this ext. When I try to read history then I get this:

PHPBB 3.3.9 ext 1.06

Code: Select all

SQL ERROR [ postgres ]

ERROR: column "r.revision_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...phpbb_primepostrev r WHERE r.post_id = 8 ORDER BY r.revision... ^ []

SQL

SELECT COUNT(*) as total_rev_cnt FROM phpbb_primepostrev r WHERE r.post_id = 8 ORDER BY r.revision_id DESC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/postgres.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\postgres->sql_query()

FILE: [ROOT]/ext/primehalo/primepostrevisions/controller/controller.php
LINE: 228
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: primehalo\primepostrevisions\controller\controller->view()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 68
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()
Last edited by Mick on Thu Feb 02, 2023 3:32 pm, edited 1 time in total.
Reason: Added code tags for clarity.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: [3.2][3.3][RC] Prime Post Revisions

Post by warmweer »

Nothing wrong with trying out v 1.0.6 (in fact it is helpful :thumbsup:), but keep in mind that strictly speaking there is no released 1.0.6 as it's still in development and hasn't been validated.
The most recent validated version is v1.0.5.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
kpazdziorny
Registered User
Posts: 3
Joined: Thu Feb 02, 2023 12:29 pm

Re: [3.2][3.3][RC] Prime Post Revisions

Post by kpazdziorny »

If i use 1.0.5 the problem is the same
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: [3.2][3.3][RC] Prime Post Revisions

Post by warmweer »

kpazdziorny wrote: Fri Feb 03, 2023 1:21 pm If i use 1.0.5 the problem is the same
Strange, I can't reproduce the error (on MySQLi)
Could it be postgres related?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
kpazdziorny
Registered User
Posts: 3
Joined: Thu Feb 02, 2023 12:29 pm

Re: [3.2][3.3][RC] Prime Post Revisions

Post by kpazdziorny »

Everything works good on postgres. How I can check what causes this problem?
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 6671
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [CDB] Prime Post Revisions

Post by HiFiKabin »

Released in the CDB
Locked

Return to “Extensions in Development”