I need to list all K2 articles from a certain category.

In the K2 admin, I can see the Category, it is a root Category, it's published, uses the default template is and public.

I can also see all articles from this Category in the K2 admin, they are public and published.

Two menu items were created:

One for showing that Category (it's public and the desired Category was set). The public path to it is www.int.gov.br/arquivo-int-na-midia and, as you can see, it's completely empty;
One K2 Item, having been selected one item from that Category. It's public path is www.int.gov.br/k2-item and throws us a 404 error.

I tried disabling SEF altogether, but to no avail. No caches are being used.

Running on Joomla 3.4.8, K2 2.7.0

www.int.gov.br/k2-item is a URL generated from a menu item.
Can you double check the menu item's settings?

Furthermore since my Portuguese is really bad, can you point me the location of that item in the menu?

Hi Krikor

Yes, both are. I created them in a hidden menu (there's no module to show it) so I could test before moving to an exposed menu.

That the full path of that k2-item is index.php?option=com_k2&view=item&layout=item&id=8431, but the result. is the same.

These are some screen captures

/index.php?option=com_k2&view=item&id=8433
/index.php?option=com_k2&view=item&id=8432
/index.php?option=com_k2&view=item&id=8431

These links while work (using proper IDs of course) on my sites, on your site seem to fail.

Are you using any 3rd party SEO extensions? Is this site the result of a migration?

perfect

I'm not using any SEO or SEF third party extensions. A backup copy on my PC has the same problem even without using SEF at all.

But yes, it's gone through migration from an old Joomla 1.5. It seems that the K2 content ids are not being recognized by Joomla anymore.

Can you check on your db to see if these ids are being properly displayed?
Eg: is 8831 the correct id?

Furthermore, did this issue appear right out of the blue, or right after the migration?

I can't find those ids on the DB, but I can find 25, 254, 256, 426 and many others that, if used, still result in 404 error.

After the migration it's the first time I've accessed these items.

www.int.gov.br/index.php?option=com_k2&view=itemlist is not working either.

This could be related to either a migration issue (the items would need to remigrated)
or, locked db tables. This can be easily fixed by repairing the db tables.

Unfortunately repairing was not enough. It really seems to be a migration problem, I just don't understand why I can see and edit the items in the administration interface, but not point to them through a menu item or category listing.

Might it be the assets table?

Some improvement

I created a new category and moved some of the items to it. No result.

Then I started opening and saving one by one. Those show up.

The problem is: I have more then 6000 items...

This indicates that something went really wrong during the migration (captain obvious once again).

I think at this point, you might need to re-run the migration script.
Before you do this however make sure to backup.

I'll give it a try, but I might get to where I am again.

It would be great to have a script automating the open-save-close routine, that would certainly do.

Try the following:
Open phpMyAdmin or an equivalent software.
Go to the #_k2_items table and check an unsaved item's row.
Save it and see which aspects have been changed.
This way you can see which cells and values where affected and you can build your SQL script.

Finally got it!

The field "language" cannot be empty, and all were. After an update k2_items set language = "*" all is good again!

Nice to hear this Carlos :)
Kudos for your hard work!