--------- 

<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-09-2025 06:37:09
 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?
www.htlx.net, Client IP: 103.104.226.130</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-09-2025 06:37:09
 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?
www.htlx.net, Client IP: 103.104.226.130</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-09-2025 12:49:35
 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?
www.htlx.net, Client IP: 103.104.226.130</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-09-2025 12:49:35
 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?
www.htlx.net, Client IP: 103.104.226.130</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 16-09-2025 06:05:31
 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' => 658,
    '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?
www.htlx.net, Client IP: 103.104.226.130</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 16-09-2025 06:05:31
 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' => 660,
    '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?
www.htlx.net, Client IP: 103.104.226.130</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 16-09-2025 12:50:59
 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' => 658,
    '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?
www.htlx.net, Client IP: 156.174.50.211</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 16-09-2025 12:50:59
 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' => 275,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/User.php',
    'line' => 660,
    '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?
www.htlx.net, Client IP: 156.174.50.211</pre>--------- 

<br>Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.customer_id' in 'field list' on 23-11-2025 01:41:30
 Query:
 SELECT r.id,r.customer_id,r.DocNo,r.agent_id,r.currency_code,r.particulars,r.remarks,r.log_link, r.`unadjusted_amount`,r.`amount_received` AS amount_received ,r.`payment_mode`,  r.`bank_name`,r.`instrument_no`,r.`payment_date`,r.instrument_date,  SUM(rb.amount_received) AS total_amount_rec,  rb.`total_amount`,rb.`amount_received` AS allocat_amount FROM wh_receipts r left join wh_receipts_bookings rb  on   r.id=rb.receipt_id where r.status='A' AND r.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' => 77,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/Receipt.php',
    'line' => 2057,
    'function' => 'getRow',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/controller.php',
    'line' => 29,
    'function' => 'edit_receipt_amount',
    'class' => 'Receipt',
    'type' => '->',
  ),
)

/tms/controller.php?page=edit_receipt_amount&action=edit&agent_id=2650&rec_id=147&Rec_amount=5650.00&receipt_type=receipt&currency_code=USD
www.htlx.net, Client IP: 197.57.121.171</pre>--------- 

<br>Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.customer_id' in 'field list' on 23-11-2025 01:41:41
 Query:
 SELECT r.id,r.customer_id,r.DocNo,r.agent_id,r.currency_code,r.particulars,r.remarks,r.log_link, r.`unadjusted_amount`,r.`amount_received` AS amount_received ,r.`payment_mode`,  r.`bank_name`,r.`instrument_no`,r.`payment_date`,r.instrument_date,  SUM(rb.amount_received) AS total_amount_rec,  rb.`total_amount`,rb.`amount_received` AS allocat_amount FROM wh_receipts r left join wh_receipts_bookings rb  on   r.id=rb.receipt_id where r.status='A' AND r.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' => 77,
    'function' => 'writeError',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  1 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/classes/Receipt.php',
    'line' => 2057,
    'function' => 'getRow',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/controller.php',
    'line' => 29,
    'function' => 'edit_receipt_amount',
    'class' => 'Receipt',
    'type' => '->',
  ),
)

/tms/controller.php?page=edit_receipt_amount&action=edit&agent_id=2650&rec_id=147&Rec_amount=5650.00&receipt_type=receipt&currency_code=USD
www.htlx.net, Client IP: 197.36.192.226</pre>--------- 

<br>Error:
SQLSTATE[HY093]: Invalid parameter number: no parameters were bound on 25-11-2025 02:36:22
 Query:
select count(*)
        from wh_booking_rate_info bri left outer join bookings b on bri.booking_id = b.id  where 1=1  and  b.site_id = 7 and  b.wh_parent_agent_id = :wh_parent_agent_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/Reports.php',
    'line' => 8682,
    'function' => 'getVar',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/new_report.php',
    'line' => 132,
    'function' => 'get_wh_daily_sales',
    'class' => 'Reports',
    'type' => '->',
  ),
)

/tms/new_report.php?report=wh_daily_sales&run=1&is_chart_display=0&chk_agent_filter=1&sel_agent=2591&txt_booking_refno=&sel_currency=AED&sel_selected_service=all
www.htlx.net, Client IP: 197.36.118.91</pre>--------- 

<br>Error:
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: '-- 00:00:00' on 25-11-2025 03:10:10
 Query:
select b.service_date AS service_date,b.id,bri.create_date as status_date,b.create_date as create_date,b.expiration_date,b.agent_currency_multiplier,b.wh_agent_currency_multiplier,b.basecurrency_multiplier,b.display_currency_code,b.service_type,bri.bid as booking_rate_id ,bri.type ,agent_price + b.applicable_service_tax 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 = '2586'   AND  b.create_date >= '-- 00:00:00' AND  b.create_date <= '-- 23:59:59'  AND  bri.create_date >= '-- 00:00:00'  AND  bri.create_date <= '-- 23:59:59'  AND  b.service_date >= '--' AND  b.service_date <= '--' AND  b.site_id = '7'   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' => 3235,
    'function' => 'getRows',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/tms/new_report.php',
    'line' => 353,
    '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=&chk_status_date=1&status_from_date=&status_to_date=&chk_service_date=1&service_from_date=&service_to_date=&sel_paid_unpaid=onlypending&sel_agent=2586&txt_booking_refno=&sel_currency=
www.htlx.net, Client IP: 197.36.118.91</pre>