Rosters XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xf_nf_rosters_rank' doesn't exist in src\XF\Db\AbstractStatement.php at line 22

SeToY

Well-Known Member
Upgraded from the old v1 rosters add-on to this:

When clicking on "Roster Ranks" in Admin CP:

Code:
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xf_nf_rosters_rank' doesn't exist in src\XF\Db\AbstractStatement.php at line 228
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src\XF\Db\Mysqli\Statement.php at line 196
[*]XF\Db\Mysqli\Statement->getException() in src\XF\Db\Mysqli\Statement.php at line 39
[*]XF\Db\Mysqli\Statement->prepare() in src\XF\Db\Mysqli\Statement.php at line 54
[*]XF\Db\Mysqli\Statement->execute() in src\XF\Db\AbstractAdapter.php at line 94
[*]XF\Db\AbstractAdapter->query() in src\XF\Mvc\Entity\Finder.php at line 1294
[*]XF\Mvc\Entity\Finder->fetch() in src\addons\NF\Rosters\Admin\Controller\Rank.php at line 22
[*]NF\Rosters\Admin\Controller\Rank->actionIndex() in src\XF\Mvc\Dispatcher.php at line 350
[*]XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 257
[*]XF\Mvc\Dispatcher->dispatchFromMatch() in src\XF\Mvc\Dispatcher.php at line 113
[*]XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 55
[*]XF\Mvc\Dispatcher->run() in src\XF\App.php at line 2190
[*]XF\App->run() in src\XF.php at line 391
[*]XF::runApp() in admin.php at line 13
[/LIST]
 

SeToY

Well-Known Member
Still got those two tables after upgrading from v1 to the latest one:

Code:
xf_pe_roster_rosters_positions
xf_pe_roster_service_record
 
Last edited:

SeToY

Well-Known Member
When trying to add a position via "Roster positions" (or editing an existing one), the page stays empty:

New:
1591342460028.png

Edit:
1591342462756.png
 

SeToY

Well-Known Member
Upgraded from the old v1 rosters add-on to this:

When clicking on "rosters" in the navigation:
Code:
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xf_nf_rosters_roster_position' doesn't exist in src\XF\Db\AbstractStatement.php at line 228
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src\XF\Db\Mysqli\Statement.php at line 196
[*]XF\Db\Mysqli\Statement->getException() in src\XF\Db\Mysqli\Statement.php at line 39
[*]XF\Db\Mysqli\Statement->prepare() in src\XF\Db\Mysqli\Statement.php at line 54
[*]XF\Db\Mysqli\Statement->execute() in src\XF\Db\AbstractAdapter.php at line 94
[*]XF\Db\AbstractAdapter->query() in src\XF\Mvc\Entity\Finder.php at line 1294
[*]XF\Mvc\Entity\Finder->fetch() in src\XF\Mvc\Entity\FinderCollection.php at line 30
[*]XF\Mvc\Entity\FinderCollection->populateInternal() in src\XF\Mvc\Entity\AbstractCollection.php at line 24
[*]XF\Mvc\Entity\AbstractCollection->populate() in src\XF\Mvc\Entity\AbstractCollection.php at line 127
[*]XF\Mvc\Entity\AbstractCollection->pluck() in src\XF\Mvc\Entity\AbstractCollection.php at line 179
[*]XF\Mvc\Entity\AbstractCollection->pluckNamed() in src\addons\NF\Rosters\Pub\Controller\Roster.php at line 34
[*]NF\Rosters\Pub\Controller\Roster->actionIndex() in src\XF\Mvc\Dispatcher.php at line 350
[*]XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 257
[*]XF\Mvc\Dispatcher->dispatchFromMatch() in src\XF\Mvc\Dispatcher.php at line 113
[*]XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 55
[*]XF\Mvc\Dispatcher->run() in src\XF\App.php at line 2190
[*]XF\App->run() in src\XF.php at line 391
[*]XF::runApp() in index.php at line 20
[/LIST]
The correct table name is xf_nf_rosters_position, not xf_nf_rosters_roster_position.
 

NixFifty

Administrator
Staff member
I've merged these threads together because it seems like they stem from the same issue. Are you able to open a ticket with an admin login so I can have a poke around? It seems like some data is missing (i.e. admin templates) so I want to see what may have caused that.
 
Top