|
| Technical information |
| Error type | 256 |
| Error description | Query execution was interrupted, maximum statement execution time exceeded |
| URL | classes.amarillo.lk/booking/class_booking_list.php? |
| Error file | C:\Inetpub\vhosts\amarillo.lk\classes.amarillo.lk\booking\connections\Connection.php |
| Error line | 626 |
| SQL query | SELECT `Day` AS `alxlg6vyc5` FROM ( SELECT
`time-slots`.`ID`, `time-slots`.`Day`, `time-slots`.`Instructor`, `time-slots`.`Time_Slot`, `instructors`.`Instrument`, GROUP_CONCAT(instructors.Instrument SEPARATOR ', ') as `Instruments`, `reservation`.`Availability`, `reservation`.`Extra_Notes`
FROM `time-slots`
LEFT OUTER JOIN `reservation` ON (`time-slots`.`Instructor` = reservation.Teacher) AND (`time-slots`.`Time_Slot` = reservation.`Time`) AND (`time-slots`.`Day` = reservation.`Day`)
LEFT OUTER JOIN `instructors` ON `time-slots`.`Instructor` = instructors.Instructor GROUP BY `time-slots`.`Day`,`time-slots`.`Instructor`,`time-slots`.`Time_Slot`,`reservation`.`Availability`,`reservation`.`Extra_Notes` ) a WHERE ( NOT ( `Day` is null or `Day` = '' ) ) GROUP BY `Day` |
| #0. |
connections\Connection.php:626 |
trigger_error |
1. Query execution was interrupted, maximum statement execution time exceeded;
2. 256; |
| #1. |
connections\Connection.php:626 |
Connection->triggerError |
1. Query execution was interrupted, maximum statement execution time exceeded; |
| #2. |
connections\MySQLiConnection.php:160 |
MySQLiConnection->query |
1. SELECT `Day` AS `alxlg6vyc5` FROM ( SELECT
`time-slots`.`ID`, `time-slots`.`Day`, `time-slots`.`Instructor`, `time-slots`.`Time_Slot`, `instructors`.`Instrument`, GROUP_CONCAT(instructors.Instrument SEPARATOR ', ') as `Instruments`, `reservation`.`Availability`, `reservation`.`Extra_Notes`
FROM `time-slots`
LEFT OUTER JOIN `reservation` ON (`time-slots`.`Instructor` = reservation.Teacher) AND (`time-slots`.`Time_Slot` = reservation.`Time`) AND (`time-slots`.`Day` = reservation.`Day`)
LEFT OUTER JOIN `instructors` ON `time-slots`.`Instructor` = instructors.Instructor GROUP BY `time-slots`.`Day`,`time-slots`.`Instructor`,`time-slots`.`Time_Slot`,`reservation`.`Availability`,`reservation`.`Extra_Notes` ) a WHERE ( NOT ( `Day` is null or `Day` = '' ) ) GROUP BY `Day`; |
| #3. |
connections\dbfunctions\MySQLFunctions.php:145 |
MySQLFunctions->limitedQuery |
1. MySQLiConnection;
2. SELECT `Day` AS `alxlg6vyc5` FROM ( SELECT
`time-slots`.`ID`, `time-slots`.`Day`, `time-slots`.`Instructor`, `time-slots`.`Time_Slot`, `instructors`.`Instrument`, GROUP_CONCAT(instructors.Instrument SEPARATOR ', ') as `Instruments`, `reservation`.`Availability`, `reservation`.`Extra_Notes`
FROM `time-slots`
LEFT OUTER JOIN `reservation` ON (`time-slots`.`Instructor` = reservation.Teacher) AND (`time-slots`.`Time_Slot` = reservation.`Time`) AND (`time-slots`.`Day` = reservation.`Day`)
LEFT OUTER JOIN `instructors` ON `time-slots`.`Instructor` = instructors.Instructor GROUP BY `time-slots`.`Day`,`time-slots`.`Instructor`,`time-slots`.`Time_Slot`,`reservation`.`Availability`,`reservation`.`Extra_Notes` ) a WHERE ( NOT ( `Day` is null or `Day` = '' ) ) GROUP BY `Day`;
3. 0;
4. -1;
5. 1; |
| #4. |
connections\Connection.php:566 |
Connection->limitedQuery |
1. SELECT `Day` AS `alxlg6vyc5` FROM ( SELECT
`time-slots`.`ID`, `time-slots`.`Day`, `time-slots`.`Instructor`, `time-slots`.`Time_Slot`, `instructors`.`Instrument`, GROUP_CONCAT(instructors.Instrument SEPARATOR ', ') as `Instruments`, `reservation`.`Availability`, `reservation`.`Extra_Notes`
FROM `time-slots`
LEFT OUTER JOIN `reservation` ON (`time-slots`.`Instructor` = reservation.Teacher) AND (`time-slots`.`Time_Slot` = reservation.`Time`) AND (`time-slots`.`Day` = reservation.`Day`)
LEFT OUTER JOIN `instructors` ON `time-slots`.`Instructor` = instructors.Instructor GROUP BY `time-slots`.`Day`,`time-slots`.`Instructor`,`time-slots`.`Time_Slot`,`reservation`.`Availability`,`reservation`.`Extra_Notes` ) a WHERE ( NOT ( `Day` is null or `Day` = '' ) ) GROUP BY `Day`;
2. 0;
3. -1;
4. 1; |
| #5. |
classes\datasource\table.php:696 |
DataSourceTable->getTotals |
1. DsCommand; |
| #6. |
classes\controls\FilterValuesList.php:282 |
FilterValuesList->addFilterBlocksFromDB |
1. Array
(
)
; |
| #7. |
classes\controls\FilterControl.php:304 |
FilterControl->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
| #8. |
classes\controls\FilterValuesList.php:631 |
FilterValuesList->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
| #9. |
classes\filterpanel.php:70 |
FilterPanel->buildFilterPanel |
N/A |
| #10. |
classes\runnerpage.php:5561 |
RunnerPage->buildFilterPanel |
N/A |
| #11. |
classes\runnerpage.php:1640 |
RunnerPage->init |
N/A |
| #12. |
classes\listpage.php:2436 |
ListPage::createListPage |
1. Class_Booking;
2. Array
(
[pageName] =>
[pageType] => list
[id] => 1
[flyId] => 0
[mode] => 0
[xt] => XTempl Object
[firstTime] =>
[sortBy] =>
[masterPageType] =>
[masterPage] =>
[masterId] =>
[masterTable] =>
[dashElementName] =>
[dashTName] =>
)
; |
| #13. |
class_booking_list.php:128 |
Global scope |
N/A |