Postfix linked to sql syntax error

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

  1. Gordon Fielden

    Gordon Fielden New Member

    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 HowtoForge Supporter

    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