Page 6 of 16
Re: [ALPHA] [3.2] PG Social Network
Posted: Sun Jan 13, 2019 9:05 pm
by PGreca
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
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.....