Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: strange email error on mssql

strange email error on mssql 6 months 4 days ago #59876

  • Mijalkovic
  • Mijalkovic's Avatar
  • Offline
  • Senior Member
  • Posts: 73
  • Thank you received: 9
  • Karma: 1
I have a setup an inbound email and one user is receiving it.
When this user is viewing his list of emails it shows it correctly but a strange and Fatal error is reported.

[FATAL] Query Failed:SELECT emails.*, users.user_name as assigned_user_name
FROM emails
LEFT JOIN users ON emails.assigned_user_id=users.id
WHERE emails.uid LIKE "1" AND emails.deleted=0
ORDER BY date_sent DESC::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name '1'.

I have run the same query against database and it has incorrect syntax because it should have only '' and not "" after like operator.

Is this a bug?

Version 7.9.12
The administrator has disabled public write access.

strange email error on mssql 6 months 4 days ago #59880

  • samus-aran
  • samus-aran's Avatar
  • Offline
  • Administrator
  • Posts: 310
  • Thank you received: 137
  • Karma: 36
Sounds like it, Are you able to create this in Github?

github.com/salesagility/SuiteCRM/issues
..........

SalesAgility - the authors and maintainers of SuiteCRM
Get Involved! Help contribute to the SuiteCRM documentation site.
The administrator has disabled public write access.

strange email error on mssql 5 months 4 weeks ago #60058

  • Mijalkovic
  • Mijalkovic's Avatar
  • Offline
  • Senior Member
  • Posts: 73
  • Thank you received: 9
  • Karma: 1
The administrator has disabled public write access.
Time to create page: 0.128 seconds
Powered by Kunena Forum