mssql_query(): message: Invalid column name 'NewTripOrDates'. (severity 16)
ErrorException Object
(
[message:protected] => mssql_query(): message: Invalid column name 'NewTripOrDates'. (severity 16)
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/ACMS3/new_proof/acms/modules/ke_trips/functions_ext.php
[line:protected] => 2965
[trace:Exception:private] => Array
(
[0] => Array
(
[function] => exception_error_handler
[args] => Array
(
[0] => 2
[1] => mssql_query(): message: Invalid column name 'NewTripOrDates'. (severity 16)
[2] => /var/www/ACMS3/new_proof/acms/modules/ke_trips/functions_ext.php
[3] => 2965
[4] => Array
(
[TrekId] =>
[ShortTrekCode] => MIS
[TrekCode] =>
[getExtraData] => 1
[TrekCodeExact] =>
[query] =>
SELECT TOP 1
CAST(TrekId AS TEXT) AS TrekId,
CAST(CountryId AS TEXT) AS CountryId,
CAST(ActivityId AS TEXT) AS ActivityId,
CAST(TrekCode AS TEXT) AS TrekCode,
CAST(TrekShortDescription AS TEXT) AS TrekShortDescriptionText,
CAST(TrekDescription AS TEXT) AS TrekDescription,
CAST(TrekTypeDescription AS TEXT) AS TrekTypeDescription,
CAST(TrekSeverityDescription AS TEXT) AS TrekSeverityDescription,
TripGradeForWeb,
WebViewPassword,
TeenageDeparture,
ChildMinimumAge,
ChildMaximumAge,
CONVERT(char(10), TrekStart, 120) AS TrekStart,
CONVERT(char(10), TrekFinish, 120) AS TrekFinish,
CONVERT(char(10), LOTrekStart, 120) AS LOTrekStart,
CONVERT(char(10), LOTrekFinish, 120) AS LOTrekFinish,
CONVERT(char(10), UKDepart, 120) AS UKDepart,
CONVERT(char(10), UKArrive, 120) AS UKArrive,
DATEDIFF(day, TrekStart, TrekFinish) AS NumDays,
SterlingTripCost,
DollarTripCost,
EuroTripCost,
SterlingSingleSupp,
DollarSingleSupp,
EuroSingleSupp,
CAST(SingleSuppNotes AS TEXT) AS SingleSuppNotes,
SterlingChildDiscount,
DollarChildDiscount,
EuroChildDiscount,
ApproxFlightPrice,
ApproxFlightPriceChild,
SterlingDeposit,
DollarDeposit,
EuroDeposit,
GroupMaximum,
GroupMinimum,
NationalParkFees,
CAST(FeeCurrencyId AS TEXT) AS FeeCurrencyId,
CAST(OtherChargesDesc AS TEXT) AS OtherChargesDesc,
OtherCharges,
CAST(OtherCurencyId AS TEXT) AS OtherCurencyId,
TrekCancelled,
LimitedAvailability,
GuaranteedToRun,
TripClosed,
ProvisionalTrip,
SingleTentAvailable,
NewTripOrDates,
CAST(DossierDocument AS TEXT) AS DossierDocument,
CAST(FlightPaymentNotes AS TEXT) AS FlightPaymentNotes,
CAST(ChildDiscount AS TEXT) AS ChildDiscount
FROM
TrekDefinitions
WHERE
ShowTripOnWeb = 1 AND
SUBSTRING(TrekCode,1,4) = 'MIS ' AND
TrekStart >= '2011-12-31'
ORDER BY
TrekStart ASC
[mssql_handle] => Resource id #92
)
)
)
[1] => Array
(
[file] => /var/www/ACMS3/new_proof/acms/modules/ke_trips/functions_ext.php
[line] => 2965
[function] => mssql_query
[args] => Array
(
[0] =>
SELECT TOP 1
CAST(TrekId AS TEXT) AS TrekId,
CAST(CountryId AS TEXT) AS CountryId,
CAST(ActivityId AS TEXT) AS ActivityId,
CAST(TrekCode AS TEXT) AS TrekCode,
CAST(TrekShortDescription AS TEXT) AS TrekShortDescriptionText,
CAST(TrekDescription AS TEXT) AS TrekDescription,
CAST(TrekTypeDescription AS TEXT) AS TrekTypeDescription,
CAST(TrekSeverityDescription AS TEXT) AS TrekSeverityDescription,
TripGradeForWeb,
WebViewPassword,
TeenageDeparture,
ChildMinimumAge,
ChildMaximumAge,
CONVERT(char(10), TrekStart, 120) AS TrekStart,
CONVERT(char(10), TrekFinish, 120) AS TrekFinish,
CONVERT(char(10), LOTrekStart, 120) AS LOTrekStart,
CONVERT(char(10), LOTrekFinish, 120) AS LOTrekFinish,
CONVERT(char(10), UKDepart, 120) AS UKDepart,
CONVERT(char(10), UKArrive, 120) AS UKArrive,
DATEDIFF(day, TrekStart, TrekFinish) AS NumDays,
SterlingTripCost,
DollarTripCost,
EuroTripCost,
SterlingSingleSupp,
DollarSingleSupp,
EuroSingleSupp,
CAST(SingleSuppNotes AS TEXT) AS SingleSuppNotes,
SterlingChildDiscount,
DollarChildDiscount,
EuroChildDiscount,
ApproxFlightPrice,
ApproxFlightPriceChild,
SterlingDeposit,
DollarDeposit,
EuroDeposit,
GroupMaximum,
GroupMinimum,
NationalParkFees,
CAST(FeeCurrencyId AS TEXT) AS FeeCurrencyId,
CAST(OtherChargesDesc AS TEXT) AS OtherChargesDesc,
OtherCharges,
CAST(OtherCurencyId AS TEXT) AS OtherCurencyId,
TrekCancelled,
LimitedAvailability,
GuaranteedToRun,
TripClosed,
ProvisionalTrip,
SingleTentAvailable,
NewTripOrDates,
CAST(DossierDocument AS TEXT) AS DossierDocument,
CAST(FlightPaymentNotes AS TEXT) AS FlightPaymentNotes,
CAST(ChildDiscount AS TEXT) AS ChildDiscount
FROM
TrekDefinitions
WHERE
ShowTripOnWeb = 1 AND
SUBSTRING(TrekCode,1,4) = 'MIS ' AND
TrekStart >= '2011-12-31'
ORDER BY
TrekStart ASC
[1] => Resource id #92
)
)
[2] => Array
(
[file] => /var/www/ACMS3/new_proof/acms/modules/ke_hotm_v2/functions.php
[line] => 344
[function] => _getTrip
[class] => ke_trips_core_ext
[type] => ->
[args] => Array
(
[0] =>
[1] => MIS
)
)
[3] => Array
(
[file] => /var/www/ACMS3/new_proof/acms/modules/ke_hotm_v2/client/index.php
[line] => 8
[function] => render_nav_top_holidays
[class] => ke_hotm_v2_core
[type] => ->
[args] => Array
(
[0] => 001
)
)
[4] => Array
(
[file] => /var/www/ACMS3/new_proof/acms/include/commonFuncs.php
[line] => 265
[args] => Array
(
[0] => /var/www/ACMS3/new_proof/acms/modules/ke_hotm_v2/client/index.php
)
[function] => include
)
[5] => Array
(
[file] => /var/www/ACMS3/new_proof/index.php
[line] => 145
[function] => get_include_contents
[args] => Array
(
[0] => modules/ke_hotm_v2/client/index.php
)
)
)
[previous:Exception:private] =>
[severity:protected] => 2
)