List Manager Forum

Migrate from joomla 3 to 4

User jkosick 2024-08-18 01:34:41

I am trying import jooma 3 data into joomla 4. I am getting this error on the migration

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PRIMARY KEY (`id_internal`))' at line 1


Installing component version
5.4.0
Current component version
5.0.1
Installing minimum Joomla version
4
Current Joomla version
4.4.6

Moonsoft support 2024-08-19 10:38:46

Hi,
can you please check that you had set an 'internal name' for every field on your Joomla3 configuration? Data migration will try to create these fields as new database columns and it would fail if it finds a table column without the right name to be assigned.

If you're not able to locate the problem, you can share an access at the private section of this ticket and we'll let you know how to fix.

Thanks, regards
Guillermo V.
Moonsoft Team

User jkosick 2024-08-19 16:41:39

Thank you. I was able to add the internal names which it says it created the table "training" but I get this error now: Truncated incorrect DECIMAL value: '' and there is no matching result shown in list manger.

Moonsoft support 2024-08-20 10:59:57

Hi,
ok, we've taken a look to the new training table and we found a couple of issues that can be the origin of the problem. The 'hours' field is typed as a number, but on your previous data it seems there are also 'empty' values that may cause problems when saved at the new table. This should be solved now as we changed the new table column type. Another issue is that you have a couple of internal names (file and date) that are reserved words in sql, and they can also cause conflicts when building the required queries. Can you please change them to coursefile and coursedate and let us know so we can try to migrate data again?
Thanks, regards
Guillermo V.
Moonsoft Team

User jkosick 2024-08-20 14:02:44

OK. I was able to change those names. I had to also add 0 to the hours fields that were blank and fix missing or incorrectly formatted dates. I was able to complete the import.

Now when I go to manage date it is blank and when I go to fields/columns there are no values that I previously had. It only shows the internal name and none of the other settings I previously had.

User jkosick 2024-08-20 16:33:04

I figured it out. Looks like there were still a few dates that I missed that were not properly formatted. I fixed those and I was able to get it to show up now. I think I am good now. Thank you for your help.

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!