Advertisement

Insert Joomla 5 articles from SQL Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 5.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
sanzx25
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Jul 04, 2024 7:50 am

Insert Joomla 5 articles from SQL

Post by sanzx25 » Thu Jul 04, 2024 7:55 am

Hello. I have a very old joomla with version 2.5. So far I was able to move articles from one joomla to another using database movement, i.e. SQL statements, either in 3.5 or in other versions.
The process was as follows:
Currently I tried to transform the aaa_content table of the 2.5 database into the structure used by the new joomla. I exported this to SQL and then ran it on the kivant joomla database.
After that the articles appeared in the admin interface of the joomla.
In the 5.x joomla database, in the aaa5.x_content table, under the manually created articles (created in the interface), the articles that I created with sql also appeared, but they did not appear in the joomla admin interface.
As I was looking at the joomla database in 5.x it looks like the articles are not only stored in the content table but also in other tables.
Can someone help me with this, how can I move and create articles in a similar way to the above?
Thanks in advance for any answers.

Advertisement
User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 25079
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Insert Joomla 5 articles from SQL

Post by pe7er » Thu Jul 04, 2024 8:08 am

Welcome to Joomla forum!

Since Joomla 4 has Joomla a new "workflow" functionality.
For each imported article you need to create a reference in the #__workflow_associations table.
See viewtopic.php?t=993253#p3658054
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

sanzx25
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Jul 04, 2024 7:50 am

Re: Insert Joomla 5 articles from SQL

Post by sanzx25 » Thu Jul 04, 2024 10:07 am

Thank you! It worked well!
Only the created_by column had to be modified to assign the articles to the current user.

Code: Select all

UPDATE `DatabaseName`.`TablePrefix_content` SET `created_by` = 'ExisitingUserId'
Haw a Good day!

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 25079
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Insert Joomla 5 articles from SQL

Post by pe7er » Thu Jul 04, 2024 10:13 am

You're welcome! Good to hear that you've solved it.
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

Advertisement

Post Reply

Return to “Migrating and Upgrading to Joomla! 5.x”