A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 48

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 48
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 49

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 49
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 50

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 50
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 51

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 51
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 52

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 52
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 53

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 53
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 54

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 54
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 55

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 55
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 56

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 56
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 57

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 57
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: cpid

Filename: controllers/Tour.php

Line Number: 59

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 59
Function: _error_handler

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/u190090916/domains/summitsafari.com/public_html/system/core/Exceptions.php:272)

Filename: core/Common.php

Line Number: 573

Backtrace:

File: /home/u190090916/domains/summitsafari.com/public_html/application/models/Tour_model.php
Line: 109
Function: query

File: /home/u190090916/domains/summitsafari.com/public_html/application/controllers/Tour.php
Line: 59
Function: get_tour_hotels

File: /home/u190090916/domains/summitsafari.com/public_html/index.php
Line: 315
Function: require_once

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY th.hoteldest ORDER BY th.thlid' at line 1

SELECT th.hoteldest AS Destination, GROUP_CONCAT(CASE WHEN category = 'Standard' THEN h.hotelname END ORDER BY h.hotelname SEPARATOR ', ') AS Standard_Hotel_Name, GROUP_CONCAT(CASE WHEN category = 'Deluxe' THEN h.hotelname END ORDER BY h.hotelname SEPARATOR ', ') AS Deluxe_Hotel_Name FROM tour_hotels th LEFT JOIN m_hotel h ON h.hotelid = th.hotelid WHERE th.tpid = GROUP BY th.hoteldest ORDER BY th.thlid;

Filename: models/Tour_model.php

Line Number: 109