1048 Column 'ordering' cannot be null

[melix]

Joomla 4x and Virtuemart 4x
I found this... 1048 Column 'ordering' cannot be null
When i tried this :

Reset booleans storing if main table needs to load an xref table. It also recreates the new category optimisations by rebuilding from category_categories table

In the database, the 'ordering' column is set to NOT NULL, the problem come from :

administrator/components/com_virtuemart/models/updatesmigration.php

At this block code :

Code Select Expand

$q = 'UPDATE #__virtuemart_categories SET `has_children`=NULL,`has_medias`=NULL, `category_parent_id`=NULL, `ordering`=NULL';
$db->setQuery($q);
$db->execute();
I replaced with :

Code Select Expand

$q = 'UPDATE #__virtuemart_categories SET `has_children`=NULL,`has_medias`=NULL, `category_parent_id`=NULL';
$db->setQuery($q);
$db->execute();
Is it safe this way ?

[hazael]

Code Select Expand

$q = 'UPDATE #__virtuemart_categories
      SET `has_children`=NULL,
          `has_medias`=NULL,
          `category_parent_id`=NULL,
          `ordering`=0';
$db->setQuery($q);
$db->execute();
The modified query sets ordering=0 instead of NULL to avoid potential issues with the database schema if the column ordering is defined as NOT NULL.

[melix]

Thanks mate !
But, the old 'ordering' settings (hand made) will be lost or not ?

[hazael]

this is just the numbering of the order of added categories. Nothing will happen even if your values are duplicated. This is only useful in the admin panel. "0" is the default value for the first created item and from there each subsequent one has 1, 2 and so on.