I downloaded and installed the latest version available to on Github. "Latest commit 8 days ago" it says and the files also date to November the 15th. Is there a newer one?
I downloaded and installed the latest version available to on Github. "Latest commit 8 days ago" it says and the files also date to November the 15th. Is there a newer one?
I'm sorry. For some strange reason, it did not commit to the new version.SinusVonAlpha wrote: ↑Fri Nov 23, 2018 3:05 pmI downloaded and installed the latest version available to on Github. "Latest commit 8 days ago" it says and the files also date to November the 15th. Is there a newer one?
Ok, I have the translations ready. The question now is, how do I send them to you?PGreca wrote: ↑Fri Nov 23, 2018 10:35 am Thanks! You can find the files here https://github.com/PGreca/pgsocial/tree ... anguage/en
If you want, you can send me the translations by PM, or use codebin, or i don't know ahahatotallybeautiful wrote: ↑Sat Nov 24, 2018 12:39 amOk, I have the translations ready. The question now is, how do I send them to you?PGreca wrote: ↑Fri Nov 23, 2018 10:35 am Thanks! You can find the files here https://github.com/PGreca/pgsocial/tree ... anguage/en
Code: Select all
SQL ERROR [ mysqli ]
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'HTO01FLQAYBP_app.ph.photo_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
SQL
SELECT *, (SELECT photo_file FROM comm__pg_social_photos as cov WHERE cov.user_id = ph.user_id AND ph.gallery_id = cov.gallery_id AND cov.photo_where = '0' ORDER BY cov.photo_time DESC LIMIT 0, 1) as gallery_cover, (SELECT COUNT(*) FROM comm__pg_social_photos as contt WHERE contt.user_id = ph.user_id AND ph.gallery_id = contt.gallery_id AND contt.photo_where = '0' ) as count FROM comm__pg_social_photos as ph WHERE ph.user_id = '246' AND ph.photo_where = '0' GROUP BY ph.gallery_id, ph.photo_where
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/pgreca/pgsocial/social/social_photo.php
LINE: 98
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/pgreca/pgsocial/event/listener.php
LINE: 292
CALL: pgreca\pgsocial\social\social_photo->getGallery()
FILE: (not given by php)
LINE: (not given by php)
CALL: pgreca\pgsocial\event\listener->memberlist_view_profile()
FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()
FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()
FILE: [ROOT]/memberlist.php
LINE: 685
CALL: phpbb\event\dispatcher->trigger_event()
sql_mode=only_full_group_by
is a default setting in newer mysql versions, so sql statements should respect that (and maybe those wrong statement will not work on other database systems). This error needs to be fixed by the extension author.mysqli
statement - keep it, because the old php mysql
interface is deprecated for nearly a decade and removed from php 7.0I know it, but i don't know how to resolve.canonknipser wrote: ↑Sat Nov 24, 2018 8:39 pm its a sql coding error -sql_mode=only_full_group_by
is a default setting in newer mysql versions, so sql statements should respect that (and maybe those wrong statement will not work on other database systems). This error needs to be fixed by the extension author.
For yourmysqli
statement - keep it, because the old phpmysql
interface is deprecated for nearly a decade and removed from php 7.0
I formatted your sql code from the message to make it a bit clearerExpression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'HTO01FLQAYBP_app.ph.photo_id' which is not functionally dependent on columns in GROUP BY clause;
Code: Select all
SELECT
*,
(SELECT photo_file FROM comm__pg_social_photos as cov WHERE cov.user_id = ph.user_id AND ph.gallery_id = cov.gallery_id AND cov.photo_where = '0' ORDER BY cov.photo_time DESC LIMIT 0, 1) as gallery_cover,
(SELECT COUNT(*) FROM comm__pg_social_photos as contt WHERE contt.user_id = ph.user_id AND ph.gallery_id = contt.gallery_id AND contt.photo_where = '0' ) as count
FROM comm__pg_social_photos as ph
WHERE ph.user_id = '246' AND ph.photo_where = '0'
GROUP BY ph.gallery_id, ph.photo_where
Expression #1 of SELECT list
(second line) is just *
for all columns in the table pg_social_photos
, but you are only allowed to used columns listed in the GROUP BY
(last line) statement which are ph.gallery_id
and ph.photo_where
in the statement or aggregated values (which are columns in function like count, sum, min, max etc.)
.*
are aggregated:ph.gallery_id, ph.photo_where, count(ph.column1) ...
*
.Code: Select all
SELECT ph.gallery_id, (
SELECT photo_file FROM phpbb_pg_social_photos AS cov WHERE cov.user_id = ph.user_id AND ph.gallery_id = cov.gallery_id AND cov.photo_where = '0' ORDER BY cov.photo_time DESC LIMIT 0, 1) AS gallery_cover, (
SELECT COUNT(*) FROM phpbb_pg_social_photos AS contt WHERE contt.user_id = ph.user_id AND ph.gallery_id = contt.gallery_id AND contt.photo_where = '0') AS count
FROM phpbb_pg_social_photos AS ph
WHERE ph.user_id = '2'
AND ph.photo_where = '0'
GROUP BY gallery_id, gallery_cover, count
Finally! Thank you for testing the ext!
1) have you enable from acp?totallybeautiful wrote: ↑Fri Nov 30, 2018 2:36 pm 1. sidebars don't work.
2. the chat does not work. No text arrives at the receiver and the opened chat cannot be clicked away and flies around somewhere in the screen.
Yes, I does.
2. Oops, sorry.
Fixed this bug's conflict with your template.totallybeautiful wrote: ↑Fri Nov 30, 2018 9:59 pmYes, I does.
2. Oops, sorry.
I'm afraid I didn't.
In any case, the message window of the recipient is somewhere in the middle of the screen and can no longer be clicked away.