Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does the error message SQL error message: Syntax error in statement in the TR*.001 log file mean?

April 26, 2017Error file log mean message sql syntax tr*.001

0

Posted

What does the error message SQL error message: Syntax error in statement in the TR*.001 log file mean?

1 Answer

0

Posted

When having an error message “SQL error message : …Syntax error in … statement” in the TR*.001 log file, check whether you are not using reserved words (SQL Commands) as table or field-names in your database (i.e. do you have fields with names like group, date, time, …) and check whether your table name does not contain spaces (the RunTime does not like that; use a Undescores instead).