Debugging of SQL statements created?

  • Resolved markwill

    (@markwill)


    5 years, 2 months ago

    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

    (@markwill)

    5 years, 2 months ago

    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.