Syntax error - Error after importing data into the database.
Sample Error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='
Solution or Workaround
The following error can occur after you import records into your PDshop database, or you modified or added records directly using MSAccess or the MSSQL Enterprise Manager.
This error is due to missing data, a 'null' value, in a field that is required by the storefront. For example, in the Standard Edition of PDshop, all items must have a category ID (catid) assigned to them by the system. This number must match an existing category ID (catid) in the "category" table.
This error is due to missing data, a 'null' value, in a field that is required by the storefront. For example, in the Standard Edition of PDshop, all items must have a category ID (catid) assigned to them by the system. This number must match an existing category ID (catid) in the "category" table.
Related Articles
Related Topics
Search for help...