PGreca wrote: ↑Sun Mar 03, 2019 3:56 pm
From now you can change the privacy for each of your individual posts!
koraldon wrote: ↑Thu Feb 21, 2019 7:46 am
Any thoughts when will you mature the extension to beta / RC ?
Thanks
if no one notifies me of other bugs, I think I'll mature it on April 1st
Unfortunately I'll have to XD
Since the last 2 version of the extension (this and the previous one), an error appears again when I click on the username of a user (to get to their profiles). A similar error existed in the past, I posted in this thread, feel free to check it out again - You did successfully fix it, but now it's back.
Error code:
Code: Select all
General Error
SQL ERROR [ mysqli ]
Unknown column 'ph.album_id' in 'field list' [1054]
SQL
SELECT 'social' as type, ph.album_id, '' as gallery_name, ( SELECT photo_file FROM comm__pg_social_photos AS cov WHERE cov.user_id = ph.user_id AND ph.album_id = cov.album_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.album_id = contt.album_id AND contt.photo_where = '0' ) AS count_photo FROM comm__pg_social_photos AS ph WHERE ph.user_id = '1835' AND ph.photo_where = '0' AND ph.album_id != '0' GROUP BY album_id, gallery_cover, count_photo UNION SELECT 'user' as type, g.gallery_id, g.gallery_name, ( SELECT photo_file FROM comm__pg_social_photos AS cov WHERE cov.user_id = g.user_id AND g.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 = g.user_id AND g.gallery_id = contt.gallery_id AND contt.photo_where = '0' ) AS count_photo FROM comm__pg_social_gallery as g WHERE g.user_id = '1835' GROUP BY gallery_id, gallery_cover, count_photo
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 993
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: 125
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/pgreca/pgsocial/event/listener.php
LINE: 350
CALL: pgreca\pgsocial\social\social_photo->get_gallery()
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()
And as always, much appreciated