The database migration for this upgrade does a lot of manipulation of the posts_likes table, and due to phpBB rules on database compatibility, they are not very efficient, but on my test data and server, it only took about 20 seconds to run.abravorus wrote: ↑Wed Jan 08, 2020 1:13 pm Latest version of master branch of Post Love from GitHub works for me too.
The update from previous version 1.2.0 was not smooth (may be because it was done on existing installation of phpBB 3.3.0).
First attempt to switch the extension on led to infinitive "wait till the extension will be initialized" on the extension's administration page (and forum didn't work during this process).
After 10 minutes I decided to reload that page and repeat "switch on" of the extension and this was successful, it works now. Even all data were preserved.
Thanks for support.
The ACP for this extension is where it has always been... on the left hand panel of the ACP Extensions tab.abravorus wrote: ↑Wed Jan 08, 2020 1:47 pm One more question.
How to find the ACP page of this extension? I see only the page with information. But somewhere should be the ACP page for configuration of the extension, as I understand. For example, I would like to remove the summary block from the forum page.
Code: Select all
$post_link = '<a href="' . $this->root_path.($short == 1 ? '' : ($page > 1 ? '../../../' : '../')) .'viewtopic.php?p=' . $row['post_id'] . '#'. $row['post_id'] .'" target="_blank" >' . $row['post_subject'] . '</a>';
$topic_link = '<a href="' . $this->root_path.($short == 1 ? '' : ($page > 1 ? '../../../' : '../')) .'viewtopic.php?t=' . $row['topic_id'] . '" target="_blank" class="topictitle">' . $row['topic_title'] . '</a>';
Code: Select all
$post_link = '<a href="' . $this->root_path.'../'.($short == 1 ? '' : ($page > 1 ? '../../../' : '../')) .'viewtopic.php?p=' . $row['post_id'] . '#'. $row['post_id'] .'" target="_blank" >' . $row['post_subject'] . '</a>';
$topic_link = '<a href="' . $this->root_path.'../'.($short == 1 ? '' : ($page > 1 ? '../../../' : '../')) .'viewtopic.php?t=' . $row['topic_id'] . '" target="_blank" class="topictitle">' . $row['topic_title'] . '</a>';
Migration here took quite some time as well, some 7 minutes or so. Fortunately I run my own MariaDB so I could runv12mike wrote: ↑Wed Jan 08, 2020 7:06 pm
The database migration for this upgrade does a lot of manipulation of the posts_likes table, and due to phpBB rules on database compatibility, they are not very efficient, but on my test data and server, it only took about 20 seconds to run.
How many 'likes' are in your database? How powerful is the server that it runs on?
mysqladmin proc stat
and saw that there was a large inefficient update running.Code: Select all
MariaDB [t_db]> select count(*) from posts_likes;
+----------+
| count(*) |
+----------+
| 60068 |
+----------+
1 row in set (0.01 sec)
Code: Select all
alter table profile_fields_data alter pf_postlove_hide set default 0;
Code: Select all
update profile_fields_data set pf_postlove_hide=0;
If you install the lastest version from github https://github.com/satanasov/postlove, you get the option to move the like button to the top of the post, where it doesn't conflict with anything.
ahahahah. This is not what I asked, the profile features part has shifted a bit. I asked him to fix itv12mike wrote: ↑Mon Apr 20, 2020 10:02 amIf you install the lastest version from github https://github.com/satanasov/postlove, you get the option to move the like button to the top of the post, where it doesn't conflict with anything.
pl_button.png