[ABD] PG Social Network

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
Locked
User avatar
PGreca
Registered User
Posts: 66
Joined: Mon Oct 29, 2018 12:36 pm
Location: Italy
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca »

mrgoldy wrote: Sun Jan 13, 2019 3:06 pm It's better to not run the SQL query directly from your migration file: https://github.com/PGreca/pgsocial/blob ... 03.php#L23
Altering SQL queries may differ per driver class.

Instead, use the migration tool for altering an existing column: https://area51.phpbb.com/docs/dev/3.2.x ... l#examples

Code: Select all

        'change_columns'    => array(
            $this->table_prefix . 'groups'        => array(
                'group_legend'        => array('UINT', 0),
            ),
        ),
However, you are trying to 'alter' a column to UINT:11 (here) which is already set up to be so (see here). And then you create another column with the same name here.
My intention is change the name of column not the his format.
As i have seen not is possible change the name from the tool migration, but only his format.

I read in the guide is better not change oldest migration file (in this case in migration 01), so i modifided the name column on the new migration (03) and for add the new column.

But at this point, if my ext is an Alpha i can edit my migration (01 - 03) for solve all this?

(excuse me always for my english)
User avatar
GanstaZ
Registered User
Posts: 1187
Joined: Wed Oct 11, 2017 10:29 pm
Location: GZOverse

Re: [ALPHA] [3.2] PG Social Network

Post by GanstaZ »

Yes, at development stage you can do whatever you want with migrations (edit/delete/move/whatever).
Usus est magister optimus! phpBB pre-Triton & latest php environment.
When answer lies in the question, question becomes redundant!
User avatar
Mathieu M.
Registered User
Posts: 181
Joined: Tue Nov 02, 2010 11:42 am
Location: France 🇫🇷
Name: Mathieu

Re: [ALPHA] [3.2] PG Social Network

Post by Mathieu M. »

Hi PGreca,

Is there any news for your extension?

Thx a lot!
😄😄😍😄😄
User avatar
Mathieu M.
Registered User
Posts: 181
Joined: Tue Nov 02, 2010 11:42 am
Location: France 🇫🇷
Name: Mathieu

Re: [ALPHA] [3.2] PG Social Network

Post by Mathieu M. »

Hello,

There's no news here? 😢
😄😄😍😄😄
SinusVonAlpha
Registered User
Posts: 17
Joined: Sat Nov 10, 2018 1:15 pm

Re: [ALPHA] [3.2] PG Social Network

Post by SinusVonAlpha »

I would also be very interested in hearing some news :o

Hope the dev is still working on it :/
User avatar
PGreca
Registered User
Posts: 66
Joined: Mon Oct 29, 2018 12:36 pm
Location: Italy
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca »

I will resume the work next week.
I had a bit of trouble with my studies and job.

Suggestions for features?
User avatar
eunaumtenhoid
Registered User
Posts: 1007
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [ALPHA] [3.2] PG Social Network

Post by eunaumtenhoid »

PGreca wrote: Tue Feb 12, 2019 9:57 am I will resume the work next week.
I had a bit of trouble with my studies and job.

Suggestions for features?
private profile?
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
PGreca
Registered User
Posts: 66
Joined: Mon Oct 29, 2018 12:36 pm
Location: Italy
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca »

eunaumtenhoid wrote: Tue Feb 12, 2019 3:08 pm
PGreca wrote: Tue Feb 12, 2019 9:57 am I will resume the work next week.
I had a bit of trouble with my studies and job.

Suggestions for features?
private profile?
I will add the privacy in the albums next week.
koraldon
Registered User
Posts: 530
Joined: Sat Jun 30, 2007 12:42 pm

Re: [ALPHA] [3.2] PG Social Network

Post by koraldon »

Any thoughts when will you mature the extension to beta / RC ?
Thanks
User avatar
PGreca
Registered User
Posts: 66
Joined: Mon Oct 29, 2018 12:36 pm
Location: Italy
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca »

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
SinusVonAlpha
Registered User
Posts: 17
Joined: Sat Nov 10, 2018 1:15 pm

Re: [ALPHA] [3.2] PG Social Network

Post by SinusVonAlpha »

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 :)
User avatar
PGreca
Registered User
Posts: 66
Joined: Mon Oct 29, 2018 12:36 pm
Location: Italy
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca »

SinusVonAlpha wrote: Mon Mar 04, 2019 12:40 am
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 :)
Yes, at development stage you can do whatever you want with migrations (edit/delete/move/whatever).
I edited table used.
Disable ext, delete his data and enable
(I hope to be right xD)
User avatar
LeCabochon
Registered User
Posts: 10
Joined: Mon Mar 04, 2019 8:40 pm

Re: [ALPHA] [3.2] PG Social Network

Post by LeCabochon »

Nice jobs Pgreca

Somes errors occur on a fresh install phpbb 3.2.5 with php 7.0

1: When i click on link pages error appears : [phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 317: mysqli_free_result(): Couldn't fetch mysqli_result

" : In ACP when i click on adminster pages i have an error : Fatal error: Uncaught Error: Call to a member function sql_freeresult() on null in /home/bones/public_html/ext/pgreca/pgsocial/acp/main_module.php:147 Stack trace: #0 /home/bones/public_html/includes/functions_module.php(676): pgreca\pgsocial\acp\main_module->main('\\pgreca\\pgsocia...', 'page_manage') #1 /home/doc1956/public_html/adm/index.php(82): p_master->load_active() #2 {main} thrown in /home/bones/public_html/ext/pgreca/pgsocial/acp/main_module.php on line 147

3 : When members edit there own link profil error appears:
General Error
Module not accessible
Please notify the board administrator or webmaster: **email address deleted**


Thank for your help
Last edited by HiFiKabin on Tue Mar 05, 2019 8:34 am, edited 1 time in total.
Reason: Email address deleted
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by mrgoldy »

LeCabochon wrote: Mon Mar 04, 2019 9:55 pm 1: When i click on link pages error appears : [phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 317: mysqli_free_result(): Couldn't fetch mysqli_result
You're trying to "free" the database results twice, see here
LeCabochon wrote: Mon Mar 04, 2019 9:55 pm" : In ACP when i click on adminster pages i have an error : Fatal error: Uncaught Error: Call to a member function sql_freeresult() on null in /home/bones/public_html/ext/pgreca/pgsocial/acp/main_module.php:147 Stack trace: #0 /home/bones/public_html/includes/functions_module.php(676): pgreca\pgsocial\acp\main_module->main('\\pgreca\\pgsocia...', 'page_manage') #1 /home/doc1956/public_html/adm/index.php(82): p_master->load_active() #2 {main} thrown in /home/bones/public_html/ext/pgreca/pgsocial/acp/main_module.php on line 147
You're using $this->db-> while it's not a declared property of this class, just use $db->, see here
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
LeCabochon
Registered User
Posts: 10
Joined: Mon Mar 04, 2019 8:40 pm

Re: [ALPHA] [3.2] PG Social Network

Post by LeCabochon »

Thanks Mr. Goldy

Both link for pages and administer pages are solved...

Just the profile link do not work for members....

Thanks for your help..... :D
Locked

Return to “Abandoned Extensions”