A PHP Error was encountered

Severity: Notice

Message: Undefined index: station

Filename: controllers/Page.php

Line Number: 204

Backtrace:

File: /home/marineintel/public_html/application/controllers/Page.php
Line: 204
Function: _error_handler

File: /home/marineintel/public_html/index.php
Line: 318
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/marineintel/public_html/system/core/Exceptions.php:271)

Filename: core/Common.php

Line Number: 570

Backtrace:

File: /home/marineintel/public_html/application/models/Common_model.php
Line: 442
Function: query

File: /home/marineintel/public_html/application/controllers/Page.php
Line: 206
Function: ship__data

File: /home/marineintel/public_html/index.php
Line: 318
Function: require_once

Database Error

A Database Error Occurred

Error Number: 1055

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'marinein_ais.vesselImages.file_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT p.*, ex_st.type as pType, vc.name, vc.imoNumber, vc.typeOfShip, st.type as ship_type, vc.destination, vc.draught, vc.bow, vc.stern, vc.port, vc.starboard, ns.message as n_status, c.name as c_name, c.name_official, LOWER(c.code2l) as c_code, LEFT(p.mmsi, 3) as mid, ex_ps.name as ex_name, vc.etaMonth, vc.etaDay, vc.etaHour, vc.etaMinute, vc.callSign, vc_fd.max_draught, vi.file_name FROM position p LEFT JOIN vessel v ON p.mmsi = v.mmsi LEFT JOIN (SELECT idvessel, file_name FROM vesselImages GROUP BY idvessel) vi ON vi.idvessel = v.id LEFT JOIN navigationStatus ns ON ns.status = p.navigationStatus LEFT JOIN (SELECT * FROM vesselCall WHERE mmsi = 416005096 ORDER BY id DESC LIMIT 1) as vc ON v.mmsi = vc.mmsi LEFT JOIN (SELECT mmsi, MAX(draught) as max_draught FROM vesselCall WHERE mmsi = 416005096) as vc_fd ON v.mmsi = vc_fd.mmsi LEFT JOIN shiptype st ON st.code = vc.typeOfShip LEFT JOIN country c ON c.mid = LEFT(p.mmsi, 3) LEFT JOIN (SELECT mmsi, name, type FROM position WHERE messageType = 24) ex_ps ON p.mmsi = ex_ps.mmsi LEFT JOIN shiptype ex_st ON ex_st.code = ex_ps.type WHERE tStamp IN ( SELECT MAX(tStamp) FROM position WHERE messageType IN (1, 3, 18) GROUP BY mmsi ) AND p.mmsi = 416005096

Filename: models/Common_model.php

Line Number: 442