--------- 

<br>Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.customer_id' in 'field list' on 28-09-2025 02:29:06
 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' => 2040,
    '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=1766&rec_id=69&Rec_amount=3130.00&receipt_type=receipt&currency_code=USD
www.skytripuae.com, Client IP: 156.185.245.130</pre>--------- 

<br>Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hotel_count' in 'field list' on 08-10-2025 06:55:50
 Query:
INSERT INTO ws_logs (userid, action_type, agent_log_id, log_date_time, end_time, xml_log_id, type, go_request, go_response, go_response_code, request_path, response_path, search_unique_id, booking_id, error_description, error_code, response_time, hotel_id, server_addr, hotel_count) VALUES ('1302', 'hotel_cancellation_policy', '', '2025-10-08 06:55:44', '2025-10-08 06:55:50', '66357914', 'website', '', '', ''_code, '', '', '', '', '', '', '', '', '', '')

<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/Logs.php',
    'line' => 76,
    'function' => 'query',
    'class' => 'OtramsDB',
    'type' => '->',
  ),
  2 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/common/functions/supplier.func.php',
    'line' => 2009,
    'function' => 'ws_logs_insert',
    'class' => 'Logs',
    'type' => '->',
  ),
  3 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/book_now.php',
    'line' => 401,
    'function' => 'getHotelRoomRatesRequest',
  ),
  4 => 
  array (
    'file' => '/efsdata/tripinclick_prod/V4_Otramsbase/book_now.php',
    'line' => 170,
    'function' => 'show_page',
  ),
)

/book_now.php?sessionid=13020820251006531996185268516
www.skytripuae.com, Client IP: 45.102.36.228</pre>--------- 

<br>Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.customer_id' in 'field list' on 17-12-2025 03:14:02
 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' => 2064,
    '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=1429&rec_id=156&Rec_amount=500.00&receipt_type=receipt&currency_code=USD
www.skytripuae.com, Client IP: 154.177.41.174</pre>