During AtroCore installation process on Linux server with MariaDB, there's a SQL syntax error occurring due to the use of the reserved word 'row_number' without backticks in table creation queries.