XF 1.2 admin navigation id's

d12j28

Member
Since upgrading to 1.2 every time I try to upgrade/install a mod or if I try and rebuild master data I get an error that says "admin navigation ids must be unique. The specified I'd is already in use."

Any ideas what is causing this?
 

Brogan

XenForo moderator
Staff member
Do you have any errors in the log?
Can you post the full backtrace?

Which add-ons do you have installed?
 

d12j28

Member
I have all mods disabled right now.

#1 /home4/steeler6/public_html/247steelers/library/XenForo/Model/AdminNavigation.php(653): XenForo_DataWriter->save()
#2 /home4/steeler6/public_html/247steelers/library/XenForo/Model/AdminNavigation.php(608): XenForo_Model_AdminNavigation->importAdminNavigationAddOnXml(Object(SimpleXMLElement), 'XenForo')
#3 /home4/steeler6/public_html/247steelers/library/XenForo/Deferred/ImportMasterData.php(16): XenForo_Model_AdminNavigation->importAdminNavigationDevelopmentXml('/home4/steeler6...')
#4 /home4/steeler6/public_html/247steelers/library/XenForo/Deferred/Atomic.php(61): XenForo_Deferred_ImportMasterData->execute(Array, Array, 7.1668362617493, '')
#5 /home4/steeler6/public_html/247steelers/library/XenForo/Model/Deferred.php(197): XenForo_Deferred_Atomic->execute(Array, Array, 7.1672222614288, '')
#6 /home4/steeler6/public_html/247steelers/library/XenForo/Model/Deferred.php(320): XenForo_Model_Deferred->runDeferred(Array, 7.1672222614288, '', false)
#7 /home4/steeler6/public_html/247steelers/library/XenForo/Model/Deferred.php(273): XenForo_Model_Deferred->_runInternal(Array, 7.1672401428223, '', false)
#8 /home4/steeler6/public_html/247steelers/library/XenForo/ViewRenderer/Abstract.php(352): XenForo_Model_Deferred->run(true, 7.1672401428223)
#9 /home4/steeler6/public_html/247steelers/library/XenForo/ViewRenderer/HtmlAdmin.php(50): XenForo_ViewRenderer_Abstract::hasManualDeferredToRun()
#10 /home4/steeler6/public_html/247steelers/library/XenForo/FrontController.php(583): XenForo_ViewRenderer_HtmlAdmin->renderRedirect(4, 'http://www.247s...', NULL, Array)
#11 /home4/steeler6/public_html/247steelers/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_Redirect), Object(XenForo_ViewRenderer_HtmlAdmin), Array)
#12 /home4/steeler6/public_html/247steelers/admin.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
["url"] => string(52) "http://www.247steelers.com/admin.php?add-ons/install"
["_GET"] => array(1) {
["add-ons/install"] => string(0) ""
}
["_POST"] => array(3) {
["server_file"] => string(0) ""
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}
Delete...Close
 

Mike

XenForo developer
Staff member
Can you run this query?
Code:
SHOW CREATE TABLE xf_admin_navigation;
(Note if you're running it via phpMyAdmin you may need to choose to display "full texts".)
 

d12j28

Member
Thanks Mike. I will have to try that when I get out of work. My phone doesn't like it when I log in to myphp for some reason.
 

d12j28

Member
Ran the query but no luck. This is the error I get when I try an uninstall a mod.

An exception occurred: Admin navigation IDs must be unique. The specified ID is already in use. in /home4/steeler6/public_html/247steelers/library/XenForo/DataWriter.php on line 1333

  1. XenForo_DataWriter->_haveErrorsPreventSave() in XenForo/DataWriter.php at line 1375
  2. XenForo_DataWriter->save() in XenForo/Model/AdminNavigation.php at line 653
  3. XenForo_Model_AdminNavigation->importAdminNavigationAddOnXml() in XenForo/Model/AdminNavigation.php at line 608
  4. XenForo_Model_AdminNavigation->importAdminNavigationDevelopmentXml() in XenForo/Deferred/ImportMasterData.php at line 16
  5. XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 61
  6. XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 197
  7. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 320
  8. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 273
  9. XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
  10. XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/HtmlAdmin.php at line 50
  11. XenForo_ViewRenderer_HtmlAdmin->renderRedirect() in XenForo/FrontController.php at line 583
  12. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  13. XenForo_FrontController->run() in /home4/steeler6/public_html/247steelers/admin.php at line 13
It does uninstall it looks like. Problem is when I try to install one I get same error and it doesn't seem to install correctly.
 

d12j28

Member
Oops.....too early.....lol

CREATE TABLE `xf_admin_navigation` (
`navigation_id` varchar(25) NOT NULL,
`parent_navigation_id` varchar(25) NOT NULL,
`display_order` int(10) unsigned NOT NULL DEFAULT '0',
`link` varchar(50) NOT NULL DEFAULT '',
`admin_permission_id` varchar(25) NOT NULL DEFAULT '',
`debug_only` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hide_no_children` tinyint(3) unsigned NOT NULL DEFAULT '0',
`addon_id` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`navigation_id`),
KEY `parent_navigation_id_display_order` (`parent_navigation_id`,`display_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 

Mike

XenForo developer
Staff member
Yeah, as I expected - that's not right. And I'd have to guess that somehow a whole upgrade script wasn't run.

Can you submit a ticket with phpMyAdmin and FTP details? I need to figure out why that script didn't run (it was done for 1.2 beta 2).
 

d12j28

Member
I submitted a ticket Mike. Unfortunately my host is still having issues today. I have yet to be able to log into ftp, cpanel or anything for that matter. Let me know if you need anymore info and I will get it to you as soon as I am able.
 

Brogan

XenForo moderator
Staff member
If you have a particular problem related to upgrading, it's always best to start a new thread explaining the problem in as much detail as possible.
 
Top