Summary

Follow the test instructions
1690 BIGINT UNSIGNED value is out of range in '(`jcedemonl`.`vg5u2_assets`.`level` - 1)' SQL=UPDATE vg5u2_assets SET lft = lft - 1 , rgt = rgt - 1 , level = level - 1 WHERE lft BETWEEN 28 AND 81
Opened On:
18 Apr 2013, 17:00 by Brian Teeman
Closed On:
10 May 2013, 14:24
Status:
Closed

Filed Under

  • Database
  • No Platform Implications

Responses

Posted on 18 Apr 2013, 17:02 by Brian Teeman
The above error was from trying to remove all categories in the trash

Subsequently when trying to delete JUST the category fruit encylopedia

exception 'UnexpectedValueException' with message 'CategoriesTableCategory::publish(Array, 1, 448) ancestors have lower state.' in /Applications/MAMP/htdocs/joomla-cms-master/libraries/joomla/table/nested.php:939 Stack trace: #0 /Applications/MAMP/htdocs/joomla-cms-master/libraries/legacy/model/admin.php(869): JTableNested->publish(Array, 1, '448') #1 /Applications/MAMP/htdocs/joomla-cms-master/administrator/components/com_categories/models/category.php(595): JModelAdmin->publish(Array, 1) #2 /Applications/MAMP/htdocs/joomla-cms-master/libraries/legacy/controller/admin.php(206): CategoriesModelCategory->publish(Array, 1) #3 /Applications/MAMP/htdocs/joomla-cms-master/libraries/legacy/controller/legacy.php(722): JControllerAdmin->publish() #4 /Applications/MAMP/htdocs/joomla-cms-master/administrator/components/com_categories/categories.php(24): JControllerLegacy->execute('publish') #5 /Applications/MAMP/htdocs/joomla-cms-master/libraries/legacy/component/helper.php(359): require_once('/Applications/M...') #6 /Applications/MAMP/htdocs/joomla-cms-master/libraries/legacy/component/helper.php(339): JComponentHelper::executeComponent('/Applications/M...') #7 /Applications/MAMP/htdocs/joomla-cms-master/administrator/includes/application.php(166): JComponentHelper::renderComponent('com_categories') #8 /Applications/MAMP/htdocs/joomla-cms-master/administrator/index.php(56): JAdministrator->dispatch() #9 {main}

Posted on 10 May 2013, 14:24 by Valentin Despa
Tested it in 3.1.1 and had no problems. Please post if you are still having issues.
Posted on 17 May 2013, 3:18 by Brian Teeman
Closing this as I can no longer repeat
Posted on 19 Oct 2014, 3:14 by Julian Lilio

Apologies for posting on an old thread. I ran into the same issue today. Seems the error appears when you have more than 1 Joomla site opened for administration. When I logged out of the other site, then did the menu trash uninstallation on the erring site, the problem dissapeared and I was able to delete the trashed menu without further issues.

This is on Joomla 3.3.6.
Posted on 19 Dec 2014, 2:39 by julien benisty

Hi everyone,

I guess it's an issue that came back as i ran into the very same problem. It was on a 3.3.6 version. And i was just trying to empty the trash of a menu. 

As soon as i logged out of another joomla 3.3.6 site opened on the same browser, it worked right away with no erreur message.