Title: Debugging of SQL statements created?
Last modified: February 9, 2021

---

# Debugging of SQL statements created?

 *  Resolved [markwill](https://wordpress.org/support/users/markwill/)
 * (@markwill)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/debugging-of-sql-statements-created/)
 * I have been using WordPress for many years and my business is heavily dependent
   on that plus WooCommerce. Over that time I have used a TON of plugins, across
   various sites – and have absolutely no idea how I missed WP Data Access. I discovered
   it last night and love what I have seen so far! It will help me tremendously.
 * With that said, my first question relates to a problem I am having importing 
   a CSV file. I have been looking at this for a while and can’t get my data imported
   correctly. I THINK this may be a data/delimiter issue but not clear yet.
 * When I import I see this error many time. About half my rows seem to import OK.
 * **Error: 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 ‘)’ at line 1**
 * I am actively looking at this but wondered if there is any way to actually see
   the SQL being used. I suspect the issue would leap out at me, when I see the 
   SQL. Is there any form of trace/debugging I can enable to actually see this SQL?
 * Thank you.

Viewing 1 replies (of 1 total)

 *  Thread Starter [markwill](https://wordpress.org/support/users/markwill/)
 * (@markwill)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/debugging-of-sql-statements-created/#post-14027301)
 * I’ve subsequently installed Query Monitor (duh!) and that’s helping but, for 
   a data-centric plugin like this, it would be kinda nice to have a focused “debugger”
   or trace mode, to show what’s happening under the covers.

Viewing 1 replies (of 1 total)

The topic ‘Debugging of SQL statements created?’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [markwill](https://wordpress.org/support/users/markwill/)
 * Last activity: [5 years, 3 months ago](https://wordpress.org/support/topic/debugging-of-sql-statements-created/#post-14027301)
 * Status: resolved