CRM broken possible Rollback

[Davdi]

my client wrote their own CRM integration and the SQL Hotfix Beta Update 18.0.9.23 broke the integration.
So we kept them on 18.0.9.20
Now that the system has automictically updated to 9A, Build 18.0.9.31, the integration broke again
However I do not see anything in the build history about SQL
https://www.3cx.com/blog/change-log/phone-system-change-log-v18/
Is there a way to see if the updates were introduced in 18.0.9.23 were also pushed in 18.0.9.31?

Anyone know how to roll back to 18.0.9.20 from 18.0.9.31?
We are running standard debian image with 3CX backing up to offsite server using 3cx automatic backups.

 

[SteveITS]

It was a security fix so logically they would keep it in there. Was this a SQL query integration?
https://www.3cx.com/blog/news/sql-database-integration/
https://www.3cx.com/blog/news/sql-database-integration-update/

 

[Davdi]

Yes it is an sql database integration. I’m hoping I can roll back somehow.

 

[edossantos_sipcaller]

You should not rollback. You should adjust your SQL statements to use parameters instead of variables. This avoids SQL injection, so it's something you definitely want to keep. The change should be simple, for example:
- Instead of [Number] you should use @number.
- Instead of [CallType] you should use @CallType
- And so on....

The only "tricky" part is when you use dates, because you will probably need to use an SQL function to convert the parameter, which will be of timestamp type, to a string.

Take some time to do this change, you won't regret it.

 

[Davdi]

Thanks for the tips. I will pass this on.