79813202

Date: 2025-11-08 13:19:37
Score: 2.5
Natty:
Report link

thanks for your reply.

There are different problems, like there are definer clauses or there are HTML tags in the SQL dump, etc. So there are different syntax errors that all lead to "You have an error in your SQl syntax..."

I have fixed a couple of them with a python script that goes through the SQL and searches for regex and replaces/deletes stuff. But this obviously is not a good solution and has never fixed all the issues.

But maybe there is some library that does that with a script or so? I mean I cant be the first person to encounter this issue.

Reasons:
  • Blacklisted phrase (0.5): thanks
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Stefan L.