Insert DB activity throw an error

[kowsi (kowsalya)]

Hi All,
While Read range to get the Datatable values and Insert DB activity to Insert into database table throw an unknown error.

Insert: ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.33]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1

[raja.arslankhan (Raja Muhammad Arslan khan)]

@kowsi According to your error I think so your query syntax is in correct.

[supermanPunch (Arpan)]

Hi @kowsi ,

Could you check the below post which addresses the same issue :

Database Insert Activity Is Failing

Why error [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.23] is thrown. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT VALUES' at line 1 while using Database insert activity? The possible cause of the issue is the compatibility between Driver and SQL Database version. So, please make sure that the driver installed is compatible with SQL database version. Refer the Microsoft JDBC Driver For SQL…

[donfeng91]

I am sure this error caused by high vesion database activity package.
On my PC installed UiPath version 21.10.4 with database activity package 1.40 works perfectly with the insert activity.
However, my laptop installs the newest version UiPath and can’t install database activity package 1.40 but the lowest version is 1.50.
So, I recommand you to use old version UiPath which can install database activity package 1.40. And use firefox to address the issue of browser extension migration from MV2 to MV3.
At last, I truly hope UiPath team can address this insert activity issue in the near future.