[GWBangi]

I need to update tables in SQL but when the system is reaching the end, it pops up the error as below.
TGLTransRecord:Error Posting GL Transaction! Internal Query Processor Error: The query processor encountered an unexpected error during execution.

[RudiVisser]

This isn't a MySQL error this is a SQL Server error so you're in the wrong forum.

Aside from that, we'd need to see what sort of SQL you're actually running before we can help you to debug it.

[e_i_pi]

Moved to MSSQL. Your error appears to be a caught exception, as the text "TGLTransRecord:Error Posting GL Transaction!" is custom, while the remaining text is MSSQL error text. I would suggest doing a text search through your code for the text I quoted to find where the error is being generated, then look for the query(s) preceding that to locate the buggy script.