Create articles in J 5.2.3 Topic is solved

[diasf]

Hello all you experts

I moved from J 3.9 to J 5.2.3 but as I wanted all new, I've created by hand what I could, including categories and menus, and now I'm trying to import the articles directly into database by phpMyAdmin. I think I've done everything, created the content records, assets records, the workflow records, everything seems ok.

The problem is, all articles are shown in backend, in administration, in correct categories, but none in frontend, inside the corresponding categories. I need to go in backend one by one, open and save, and so the articles appear in frontend.

I've disabled versioning.

I can't find what else could I correct in database to get the articles shown in frontend. As an example, I've seen a content record before (while does not show in frontend) and after opening in backend (shows in frontend), and seems just equal one to the other.

What else should I do? Can anyone help me, please? Thank you for any help!

[gws]

Try running this in your phpmyadmin, make a backup first;
INSERT INTO #__workflow_associations (item_id, stage_id, extension)
SELECT c.id as item_id, '1', 'com_content.article' FROM #__content AS c
WHERE NOT EXISTS (SELECT wa.item_id FROM #__workflow_associations AS wa WHERE wa.item_id = c.id);

[diasf]

Thank you gws for your quick reply.

I've had created all workflow_associations records "created the content records, assets records, the workflow records".

I really can't find what else is missing.

[diasf]

Found it!!!! Stupid error by myself... Didn't change access to 1. Was 0 and changed to 1 when updated... Stupid error...