Postfix linked to sql syntax error

Discussion in 'Installation/Configuration' started by Gordon Fielden, Feb 11, 2021.

  1. Gordon Fielden

    Gordon Fielden Member HowtoForge Supporter

    Hi Guys,
    A little help, new servers running Debian 10.8 IPSconfig 3.22 are reporting error as follows and I can't seem to tie down the reporting fault.

    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 'from where = limit 1' at line 1

    Any help would be appreciated.

    Mann thanks
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Where do you see this error?
     
  3. nhybgtvfr

    nhybgtvfr Well-Known Member

    you've left out the from and where arguments.
    unless you've deliberately left out exactly what you're looking for in your post.

    should be (matching where clause)
    from <tablename> where <field> = <argument eg '1' or 'string' > limit 1;
    or (no matching)
    from <tablename> limit 1;

    assuming you're already using a specific database, otherwise use: from <databasename.tablename>
     

Share This Page