Rosters Fixed 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]

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

When clicking on "Roster Ranks" in Admin CP:

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]

Still got those two tables after upgrading from v1 to the latest one:

xf_pe_roster_rosters_positions
xf_pe_roster_service_record

 

[SeToY]

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

New:


Edit:

 

[SeToY]

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

When clicking on "rosters" in the navigation:

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.

 

[Naz]

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.

 

[SeToY]

Are you able to open a ticket with an admin login

Done