good point, as Admin. Revisited as a guest and it's not visible. I need more coffee....Did you view the post area page as an admin or a regular user?
Should solve the issues with not showing any posts.
2.1.3 Patch Level 1:
- Removed unused import from Standard Library by Xon
Refreshed admin.php?tools/run-job and it deleted a couple of members and then continued the rebuild process.XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction in src/XF/Db/AbstractStatement.php at line 230
- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
- XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 276
- XF\Db\AbstractAdapter->insertBulk() in src/addons/Awedo/PostAreas/Job/CacheRebuild.php at line 52
- Awedo\PostAreas\Job\CacheRebuild->rebuildById() in src/XF/Job/AbstractRebuildJob.php at line 42
- XF\Job\AbstractRebuildJob->run() in src/XF/Job/Manager.php at line 260
- XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
- XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
- XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
- XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in admin.php at line 13
<xf:title>{{ phrase('awedo_pa_xs_post_areas', {'name': $user.username}) }}</xf:title>
<xf:css src="awedo_post_areas_tab_content.css" />
<xf:if is="{$postAreas}">
<div class="block">
<div class="block-container">
<xf:datalist>
<xf:datarow rowtype="header">
<xf:cell>{{ phrase ('forum') }}</xf:cell>
<xf:cell class="dataList-cell--min">{{ phrase ('threads') }}</xf:cell>
<xf:cell class="dataList-cell--min">{{ phrase ('posts') }}</xf:cell>
</xf:datarow>
<xf:foreach loop="$postAreas" key="$key" value="$entry">
<xf:datarow rowclass="dataList-row--noHover">
<xf:cell class="dataList-cell--main">
<div class="dataList-mainRow">
<a href='{{ link ('forums', {'node_id': {$postAreas.{$key}.node_id}}) }}' rel="nofollow"> {$entry.title} </a>
</div>
</xf:cell>
<xf:cell class="dataList-cell--min">
<a href='{{ link('search/threads-of-member', null, {'user_id': {$user.user_id}, 'node': {$postAreas.{$key}.node_id} } ) }}'><xf:if is="$entry.thread_count > 0">{$entry.thread_count}</xf:if></a>
</xf:cell>
<xf:cell class="dataList-cell--min">
<a href='{{ link('search/search', null, {'search_type': 'post', 'c[users]': {$user.username}, 'c[nodes][]': {$postAreas.{$key}.node_id} } ) }}'>{$entry.post_count}</a>
</xf:cell>
</xf:datarow>
</xf:foreach>
</xf:datalist>
</div>
</div>
<xf:else />
<div class="blockMessage">{{ phrase ('awedo_pa_no_posts') }} </div>
</xf:if>
2.1.3 Patch Level 2:
Fix: rerun deadlock transactions on cache rebuild
This looks great Matt, thank you.Would you mind updating it to use XF's inhouse data table styling? It would be very easy to implement and looks much better.
I managed it on my site very easily:
HTML:<xf:title>{{ phrase('awedo_pa_xs_post_areas', {'name': $user.username}) }}</xf:title> <xf:css src="awedo_post_areas_tab_content.css" /> <xf:if is="{$postAreas}"> <div class="block"> <div class="block-container"> <xf:datalist> <xf:datarow rowtype="header"> <xf:cell>{{ phrase ('forum') }}</xf:cell> <xf:cell class="dataList-cell--min">{{ phrase ('threads') }}</xf:cell> <xf:cell class="dataList-cell--min">{{ phrase ('posts') }}</xf:cell> </xf:datarow> <xf:foreach loop="$postAreas" key="$key" value="$entry"> <xf:datarow rowclass="dataList-row--noHover"> <xf:cell class="dataList-cell--main"> <div class="dataList-mainRow"> <a href='{{ link ('forums', {'node_id': {$postAreas.{$key}.node_id}}) }}' rel="nofollow"> {$entry.title} </a> </div> </xf:cell> <xf:cell class="dataList-cell--min"> <a href='{{ link('search/threads-of-member', null, {'user_id': {$user.user_id}, 'node': {$postAreas.{$key}.node_id} } ) }}'><xf:if is="$entry.thread_count > 0">{$entry.thread_count}</xf:if></a> </xf:cell> <xf:cell class="dataList-cell--min"> <a href='{{ link('search/search', null, {'search_type': 'post', 'c[users]': {$user.username}, 'c[nodes][]': {$postAreas.{$key}.node_id} } ) }}'>{$entry.post_count}</a> </xf:cell> </xf:datarow> </xf:foreach> </xf:datalist> </div> </div> <xf:else /> <div class="blockMessage">{{ phrase ('awedo_pa_no_posts') }} </div> </xf:if>
View attachment 301051
View attachment 301052
Hello! Interesting addon, I like the concept however when attempted to try it out, it had unfortunately presented me with this issue. No error logs as far as I can see.
Size as in popularity? Uh not sure exactly. Site has existed since 2018, and has quite a bit of data. I assume, from your question, that it would take some time to get all the data to be easily displayed onto pages?I just tried this on a fresh install on a 2.3 site and it seems to be working correctly. What size is the site?
We use essential cookies to make this site work, and optional cookies to enhance your experience.