Browse By Tags

  • Wiki Page: 536-17216 - SQL error shows when deleting records

    Summary: Deleting a person or company results in an SQL error: "An unexpected event has occured: Exception: SQL Error" However the record is actually deleted. Symptoms: SQL Error : Incorrect syntax near the keyword 'WHERE' (DELETE FROM WHERE Visi_CompanyId = 27579) SQL Error : Incorrect...
  • Wiki Page: 492-17719 - Upgrades: Cannot open a query with no SQL

    Summary: On upgrading a copy of Sage CRM, an error may be logged on running tables.es. The error refers to an issue opening a query with no SQL. This issue is likely caused by the presence of an index on a table, blocking the changing of a column's data type. Symptoms: A specific example was logged...
  • Wiki Page: 492-17721 - Sage CRM iPhone component: Errors creating views

    Summary: Errors may occur when setting up new views to be used by the Sage CRM iPhone app. These errors will prevent users from synching their iPhones with Sage CRM, since data cannot be retrieved from the system. Symptoms: On running the component to install the app, you may encounter errors relating...