Page 6 of 10

Re: [ALPHA] [3.2] PG Social Network

Posted: Sun Jan 13, 2019 9:05 pm
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)

Re: [ALPHA] [3.2] PG Social Network

Posted: Sun Jan 13, 2019 9:30 pm
by GanstaZ
Yes, at development stage you can do whatever you want with migrations (edit/delete/move/whatever).

Re: [ALPHA] [3.2] PG Social Network

Posted: Thu Jan 31, 2019 4:04 pm
by Mathieu M.
Hi PGreca,

Is there any news for your extension?

Thx a lot!

Re: [ALPHA] [3.2] PG Social Network

Posted: Thu Feb 07, 2019 7:28 pm
by Mathieu M.
Hello,

There's no news here? 😢

Re: [ALPHA] [3.2] PG Social Network

Posted: Sat Feb 09, 2019 2:08 am
by SinusVonAlpha
I would also be very interested in hearing some news :o

Hope the dev is still working on it :/

Re: [ALPHA] [3.2] PG Social Network

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

Suggestions for features?

Re: [ALPHA] [3.2] PG Social Network

Posted: Tue Feb 12, 2019 3:08 pm
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?

Re: [ALPHA] [3.2] PG Social Network

Posted: Wed Feb 20, 2019 11:32 pm
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.

Re: [ALPHA] [3.2] PG Social Network

Posted: Thu Feb 21, 2019 7:46 am
by koraldon
Any thoughts when will you mature the extension to beta / RC ?
Thanks

Re: [ALPHA] [3.2] PG Social Network

Posted: Sun Mar 03, 2019 3:56 pm
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

Re: [ALPHA] [3.2] PG Social Network

Posted: Mon Mar 04, 2019 12:40 am
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 :)

Re: [ALPHA] [3.2] PG Social Network

Posted: Mon Mar 04, 2019 1:27 am
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)

Re: [ALPHA] [3.2] PG Social Network

Posted: Mon Mar 04, 2019 9:55 pm
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

Re: [ALPHA] [3.2] PG Social Network

Posted: Tue Mar 05, 2019 7:22 am
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

Re: [ALPHA] [3.2] PG Social Network

Posted: Tue Mar 05, 2019 8:44 am
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