You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We need to get rid of this IF syntax because it's not supported in SQL Server. We could switch to CASE or we could refactor the model to not do such crazy SQL at all... also on line 328 in this file there's
a 1=1 that doesn't work in SQL Server either. https://github.com/twilio/OpenVBX/blob/master/OpenVBX/models/vbx_message.php#L331
There are places in the code where we use a literal SQL value of UTC_TIMESTAMP() which also doesn't work in SQL Server. We should generate these time stamps in PHP land and just insert them probably.
There's also places where queries are run repeatedly. I modified the driver file to log all queries it was asked to execute and it was alarming. anything we can do to minimize that will help performance
of the application greatly.