--------- 

<br>Error:
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: '-- 00:00:00' on 17-02-2025 09:44:09
 Query:
select b.service_date AS service_date,b.id,bri.create_date as status_date,b.create_date as create_date, b.agent_currency_multiplier ,b.wh_agent_currency_multiplier ,b.display_currency_code,b.service_type,bri.bid as booking_rate_id ,bri.type ,agent_price as debit,  b.voucher_id as agent_ref, concat_ws(' ', leader_title, leader_first_name,leader_last_name) as lead_name, b.check_out_date,bd.hotel_name  from bookings b LEFT JOIN bookings_details bd ON b.id = bd.booking_id INNER JOIN wh_booking_rate_info bri ON bri.booking_id = b.id and agent_price != 0  and  b.wh_parent_agent_id = '1806'   AND  b.create_date >= '-- 00:00:00' AND  b.create_date <= '-- 23:59:59'  AND b.display_currency_code like  'USD'  AND  b.site_id = 3   order by service_date

<pre>
Hostname: TripinClickWeb1-37
 <br>

Connection: tripinclick_live@tripinclick.c12yyeogef9x.eu-west-1.rds.amazonaws.com

Backtrace:
array (
  0 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/OtramsDB.php',
    'line' => 98,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/Reports.php',
    'line' => 2867,
    'function' => 'getRows',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/new_report.php',
    'line' => 349,
    'function' => 'get_detailed_customer_statement',
    'class' => 'Reports',
    'type' => '->',
  ),
)

/tms/new_report.php?report=customer_statement&run=1&is_chart_display=0&chk_booking_date=1&booking_from_date=&booking_to_date=&sel_paid_unpaid=all&sel_agent=1806&txt_booking_refno=&sel_currency=USD
online.taxidia.net, Client IP: 104.28.241.91</pre>--------- 

<br>Error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where site_id=''' at line 1 on 15-03-2025 10:53:41
 Query:
select id from psa_branches where where site_id=''

<pre>
Hostname: TripinClickWeb1-37
 <br>

Connection: tripinclick_live@tripinclick.c12yyeogef9x.eu-west-1.rds.amazonaws.com

Backtrace:
array (
  0 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/OtramsDB.php',
    'line' => 140,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/User.php',
    'line' => 655,
    'function' => 'getVar',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/user.php',
    'line' => 28,
    'function' => 'insert_user',
    'class' => 'User',
    'type' => '->',
  ),
)

/tms/user.php?
online.taxidia.net, Client IP: 104.28.241.91</pre>--------- 

<br>Error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where site_id=''' at line 1 on 15-03-2025 10:53:41
 Query:
insert into consultant_branches set  branch_id = '' where site_id=''

<pre>
Hostname: TripinClickWeb1-37
 <br>

Connection: tripinclick_live@tripinclick.c12yyeogef9x.eu-west-1.rds.amazonaws.com

Backtrace:
array (
  0 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/OtramsDB.php',
    'line' => 272,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/User.php',
    'line' => 657,
    'function' => 'query',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/user.php',
    'line' => 28,
    'function' => 'insert_user',
    'class' => 'User',
    'type' => '->',
  ),
)

/tms/user.php?
online.taxidia.net, Client IP: 104.28.241.91</pre>