Could not create mail account because of error: incorrect syntax to use near and name = ok_language'' at line 1

Refers to:

  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • MG:5bd060d61ba4eae7a40b82adcb3d1c90
  • MT:02337453d1d2c28749816cd5db056445

Created:

2016-11-16 12:39:50 UTC

Modified:

2017-02-13 06:11:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Could not create mail account because of error: incorrect syntax to use near and name = ok_language'' at line 1

Symptoms

  1. Attempt to create mail account failed with the error below:

    Error: DB query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and name = 'ok_language'' at line 1
  2. There is no configuration file below:

    %plesk_dir%\\Additional\\Perl\\site\\share\\spamassassin\\user_prefs.template

Cause

  • Incorrect permissions on %plesk_dir%\\Additional directory (Read-only attribute).
  • Corrupted SpamAssassin package

Resolution

  • Check the Read-only attribute on the files in %plesk_dir%\\Additional\\ directory. Clear checkbox if it is checked.
  • Run "Plesk Reconfigurator" -> "Check component and folder permissions" -> Browse -> select %plesk_dir%\\Additional directory and press "Check"

If the issue persists, reinstall SpamAssassin package using " autoinstaller " utility.

Have more questions? Submit a request
Please sign in to leave a comment.