[ALPHA] [3.2] PG Social Network

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!
Scam Warning
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)
Post Reply
User avatar
PGreca
Registered User
Posts: 34
Joined: Mon Oct 29, 2018 12:36 pm
Location: Catania
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca » Sun Jan 13, 2019 9:05 pm

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
Jr. Extension Validator
Posts: 804
Joined: Wed Oct 11, 2017 10:29 pm
Location: Zverse

Re: [ALPHA] [3.2] PG Social Network

Post by GanstaZ » Sun Jan 13, 2019 9:30 pm

Yes, at development stage you can do whatever you want with migrations (edit/delete/move/whatever).
"When answer lies in the question,.. question becomes redundant!"

User avatar
Mathieu M.
Registered User
Posts: 176
Joined: Tue Nov 02, 2010 11:42 am
Location: France
Name: Mathieu

Re: [ALPHA] [3.2] PG Social Network

Post by Mathieu M. » Thu Jan 31, 2019 4:04 pm

Hi PGreca,

Is there any news for your extension?

Thx a lot!
πŸ˜„πŸ˜„πŸ˜πŸ˜„πŸ˜„

User avatar
Mathieu M.
Registered User
Posts: 176
Joined: Tue Nov 02, 2010 11:42 am
Location: France
Name: Mathieu

Re: [ALPHA] [3.2] PG Social Network

Post by Mathieu M. » Thu Feb 07, 2019 7:28 pm

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 » Sat Feb 09, 2019 2:08 am

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: 34
Joined: Mon Oct 29, 2018 12:36 pm
Location: Catania
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca » 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?

User avatar
eunaumtenhoid
Registered User
Posts: 832
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [ALPHA] [3.2] PG Social Network

Post by eunaumtenhoid » 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?
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes

User avatar
PGreca
Registered User
Posts: 34
Joined: Mon Oct 29, 2018 12:36 pm
Location: Catania
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca » Wed Feb 20, 2019 11:32 pm

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: 498
Joined: Sat Jun 30, 2007 12:42 pm

Re: [ALPHA] [3.2] PG Social Network

Post by koraldon » Thu Feb 21, 2019 7:46 am

Any thoughts when will you mature the extension to beta / RC ?
Thanks

User avatar
PGreca
Registered User
Posts: 34
Joined: Mon Oct 29, 2018 12:36 pm
Location: Catania
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca » 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

SinusVonAlpha
Registered User
Posts: 17
Joined: Sat Nov 10, 2018 1:15 pm

Re: [ALPHA] [3.2] PG Social Network

Post by SinusVonAlpha » 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 :)

User avatar
PGreca
Registered User
Posts: 34
Joined: Mon Oct 29, 2018 12:36 pm
Location: Catania
Contact:

Re: [ALPHA] [3.2] PG Social Network

Post by PGreca » Mon Mar 04, 2019 1:27 am

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: 3
Joined: Mon Mar 04, 2019 8:40 pm

Re: [ALPHA] [3.2] PG Social Network

Post by LeCabochon » Mon Mar 04, 2019 9:55 pm

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
Jr. Extension Validator
Posts: 946
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [ALPHA] [3.2] PG Social Network

Post by mrgoldy » Tue Mar 05, 2019 7:22 am

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 / ''Proud member of the Studio"

User avatar
LeCabochon
Registered User
Posts: 3
Joined: Mon Mar 04, 2019 8:40 pm

Re: [ALPHA] [3.2] PG Social Network

Post by LeCabochon » Tue Mar 05, 2019 8:44 am

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

Post Reply

Return to β€œExtensions in Development”

Who is online

Users browsing this forum: Gubkin, nou nou, Tbot [Bot] and 15 guests