Hello Trongate,
when i insert data array its show this error (Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'group, parent_id) VALUES ('Paper roc', '19506', 'Paper roc', 'A', '445')' at line 1 in D:\xampp\htdocs\investo\engine\Model.php:69 Stack trace: #0 D:\xampp\htdocs\investo\engine\Model.php(69): PDOStatement->execute() #1 D:\xampp\htdocs\investo\engine\Model.php(417): Model->prepare_and_execute('INSERT INTO ins...', Array) #2 D:\xampp\htdocs\investo\modules\instruments\controllers\Instruments.php(146): Model->insert(Array, 'instruments') #3 D:\xampp\htdocs\investo\engine\Core.php(209): Instruments->submit('') #4 D:\xampp\htdocs\investo\engine\Core.php(32): Core->serve_controller() #5 D:\xampp\htdocs\investo\public\index.php(5): Core->__construct() #6 {main} thrown in D:\xampp\htdocs\investo\engine\Model.php on line 69).
any idea why this error and how to solve this.

Hello,
Can you post your code to insert?
Use the following tags for code

Also, what is the database structure that you are trying to insert into, if possble.
Thanks, Dan

Hello Trongate, Good day.
I am trying every way in XAMPP + MariaDB. The insert method show this fatal error, Other method working good.

Have you turned debug to true?
https://trongate.io/docs_m/information/how-to-use-debug-mode

This will show you your query.
Without knowing the table structure and query hard to know.

Based only on the error message, I'd take a wild guess and say that the column named 'group' (or any of your column names) is using a MariaDB reserved word. This is best avoided as it can cause all sorts of problems down the track.

See: https://mariadb.com/kb/en/reserved-words/ for more info.

Assuming this is an Trongate-generated query, the system could be improved by enclosing each column name in backticks (`) to avoid similar issues moving forward.

I can't test it right now, but this should work:

trongate > engine > Model.php: ~ line 403

replace:


with:

Thanks D3mon,
Its work perfectly.

Awesome! Smash that star button on my last post for the win! ?

Well spotted D3mon! I often wrap column names with backticks and this is a great example as to why.

The solution should be put up as a pull request so DC can add it to the framework. As you may know, any changes in the engine folder will be overwritten on future updates.

Cheers,
Si

Ah Ok. I've posted it on GitHub as an issue (#79) as I'm not fully skilled in Git yet. ?