|
| ข้อมูลด้านเทคนิค |
| ประเภทข้อผิดพลาด | 256 |
| รายละเอียดข้อผิดพลาด | 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 ') ) and ( highland_eval.acadyears =2567 ) ) a' at line 4 |
| URL | www.ssra.info/saoadmin/highland_eval_list.php? |
| ไฟล์ผิดพลาด | /home/ssrainfo/domains/ssra.info/public_html/saoadmin/connections/Connection.php |
| บรรทัดผิดพลาด | 668 |
| ค้นหา SQL | select count(*) from (SELECT
`highland_eval`.`sc_id`, `highland_eval`.`sc_names`, `highland_eval`.`director_name`, `highland_eval`.`director_tel`, `highland_eval`.`editor_name`, `highland_eval`.`editor_tel`, `highland_eval`.`sao_names`, `highland_eval`.`adresss`, `highland_eval`.`viledges`, `highland_eval`.`moo`, `highland_eval`.`subdistrict`, `highland_eval`.`district`, `highland_eval`.`provinces`, `highland_eval`.`lgo`, `highland_eval`.`stu_kinder`, `highland_eval`.`stu_prim`, `highland_eval`.`stu_second`, `highland_eval`.`stu_high`, `highland_eval`.`stu_sum`, `highland_eval`.`stu_hilltrib`, `highland_eval`.`stu_hilltrib_group`, `highland_eval`.`stu_sleep_girl`, `highland_eval`.`stu_sleep_boy`, `highland_eval`.`stu_sleep_sum`, `highland_eval`.`lat`, `highland_eval`.`lng`, `highland_eval`.`highest`, `highland_eval`.`average_height`, `highland_eval`.`distance_to_province`, `highland_eval`.`distance_to_`, `highland_eval`.`citeria01`, `highland_eval`.`citeria01_refdoc`, `highland_eval`.`citeria02`, `highland_eval`.`citeria02_refdoc`, `highland_eval`.`citeria03`, `highland_eval`.`citeria03_refdoc`, `highland_eval`.`citeria04`, `highland_eval`.`citeria041`, `highland_eval`.`citeria04_refdoc`, `highland_eval`.`citeria05`, `highland_eval`.`citeria05_refdoc`, `highland_eval`.`citeria06`, `highland_eval`.`citeria06_refdoc`, `highland_eval`.`citeria07`, `highland_eval`.`citeria07_refdoc`, `highland_eval`.`citeria08`, `highland_eval`.`citeria08_refdoc`, `highland_eval`.`citeria09`, `highland_eval`.`citeria09_refdoc`, `highland_eval`.`citeria10`, `highland_eval`.`citeria10_refdoc`, `highland_eval`.`citeria11`, `highland_eval`.`citeria11_refdoc`, `highland_eval`.`citeria12`, `highland_eval`.`citeria12_refdoc`, `highland_eval`.`citeria13`, `highland_eval`.`citeria13_refdoc`, `highland_eval`.`citeria14`, `highland_eval`.`citeria14_refdoc`, `highland_eval`.`citeria15`, `highland_eval`.`citeria15_refdoc`, `highland_eval`.`citeria16`, `highland_eval`.`citeria16_refdoc`, `highland_eval`.`score01`, `highland_eval`.`score02`, `highland_eval`.`score03`, `highland_eval`.`score04`, `highland_eval`.`score05`, `highland_eval`.`score06`, `highland_eval`.`score07`, `highland_eval`.`score08`, `highland_eval`.`score09`, `highland_eval`.`score10`, `highland_eval`.`score11`, `highland_eval`.`score12`, `highland_eval`.`score13`, `highland_eval`.`score14`, `highland_eval`.`score15`, `highland_eval`.`score16`, `highland_eval`.`sum_score`, `highland_eval`.`comments`, `highland_eval`.`status`, `highland_eval`.`sc_id` as `printlink`, `highland_eval`.`sc_id` as `maplink`, `highland_eval`.`sc_id` as `remote`, `highland_eval`.`sc_id` as `mapelev`, `highland_eval`.`highland_type`, `highland_eval`.`spt_commit`, `highland_eval`.`spt_comment`, `highland_eval`.`status` as `status1`, `highland_eval`.`spt_commit` as `spt_commit1`, `highland_eval`.`acadyears`, `highland_eval`.`date_created`, `scssra`.`saoid`, `scssra`.`saoname`, `highland_eval`.`sao_proved2567`, `highland_eval`.`sao_comment2567`, `highland_eval`.`fail_reason`
FROM `highland_eval`
LEFT OUTER JOIN `scssra` ON scssra.sc_id = highland_eval.sc_id WHERE ( ( scssra.saoid= ) ) and ( highland_eval.acadyears =2567 ) ) a |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. 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 ') ) and ( highland_eval.acadyears =2567 ) ) a' at line 4 |
| #1 |
connections/MySQLiConnection.php:173 |
MySQLiConnection->query |
0. select count(*) from (SELECT
`highland_eval`.`sc_id`, `highland_eval`.`sc_names`, `highland_eval`.`director_name`, `highland_eval`.`director_tel`, `highland_eval`.`editor_name`, `highland_eval`.`editor_tel`, `highland_eval`.`sao_names`, `highland_eval`.`adresss`, `highland_eval`.`viledges`, `highland_eval`.`moo`, `highland_eval`.`subdistrict`, `highland_eval`.`district`, `highland_eval`.`provinces`, `highland_eval`.`lgo`, `highland_eval`.`stu_kinder`, `highland_eval`.`stu_prim`, `highland_eval`.`stu_second`, `highland_eval`.`stu_high`, `highland_eval`.`stu_sum`, `highland_eval`.`stu_hilltrib`, `highland_eval`.`stu_hilltrib_group`, `highland_eval`.`stu_sleep_girl`, `highland_eval`.`stu_sleep_boy`, `highland_eval`.`stu_sleep_sum`, `highland_eval`.`lat`, `highland_eval`.`lng`, `highland_eval`.`highest`, `highland_eval`.`average_height`, `highland_eval`.`distance_to_province`, `highland_eval`.`distance_to_`, `highland_eval`.`citeria01`, `highland_eval`.`citeria01_refdoc`, `highland_eval`.`citeria02`, `highland_eval`.`citeria02_refdoc`, `highland_eval`.`citeria03`, `highland_eval`.`citeria03_refdoc`, `highland_eval`.`citeria04`, `highland_eval`.`citeria041`, `highland_eval`.`citeria04_refdoc`, `highland_eval`.`citeria05`, `highland_eval`.`citeria05_refdoc`, `highland_eval`.`citeria06`, `highland_eval`.`citeria06_refdoc`, `highland_eval`.`citeria07`, `highland_eval`.`citeria07_refdoc`, `highland_eval`.`citeria08`, `highland_eval`.`citeria08_refdoc`, `highland_eval`.`citeria09`, `highland_eval`.`citeria09_refdoc`, `highland_eval`.`citeria10`, `highland_eval`.`citeria10_refdoc`, `highland_eval`.`citeria11`, `highland_eval`.`citeria11_refdoc`, `highland_eval`.`citeria12`, `highland_eval`.`citeria12_refdoc`, `highland_eval`.`citeria13`, `highland_eval`.`citeria13_refdoc`, `highland_eval`.`citeria14`, `highland_eval`.`citeria14_refdoc`, `highland_eval`.`citeria15`, `highland_eval`.`citeria15_refdoc`, `highland_eval`.`citeria16`, `highland_eval`.`citeria16_refdoc`, `highland_eval`.`score01`, `highland_eval`.`score02`, `highland_eval`.`score03`, `highland_eval`.`score04`, `highland_eval`.`score05`, `highland_eval`.`score06`, `highland_eval`.`score07`, `highland_eval`.`score08`, `highland_eval`.`score09`, `highland_eval`.`score10`, `highland_eval`.`score11`, `highland_eval`.`score12`, `highland_eval`.`score13`, `highland_eval`.`score14`, `highland_eval`.`score15`, `highland_eval`.`score16`, `highland_eval`.`sum_score`, `highland_eval`.`comments`, `highland_eval`.`status`, `highland_eval`.`sc_id` as `printlink`, `highland_eval`.`sc_id` as `maplink`, `highland_eval`.`sc_id` as `remote`, `highland_eval`.`sc_id` as `mapelev`, `highland_eval`.`highland_type`, `highland_eval`.`spt_commit`, `highland_eval`.`spt_comment`, `highland_eval`.`status` as `status1`, `highland_eval`.`spt_commit` as `spt_commit1`, `highland_eval`.`acadyears`, `highland_eval`.`date_created`, `scssra`.`saoid`, `scssra`.`saoname`, `highland_eval`.`sao_proved2567`, `highland_eval`.`sao_comment2567`, `highland_eval`.`fail_reason`
FROM `highland_eval`
LEFT OUTER JOIN `scssra` ON scssra.sc_id = highland_eval.sc_id WHERE ( ( scssra.saoid= ) ) and ( highland_eval.acadyears =2567 ) ) a |
| #2 |
connections/Connection.php:635 |
Connection->getFetchedRowsNumber |
0. SELECT
`highland_eval`.`sc_id`, `highland_eval`.`sc_names`, `highland_eval`.`director_name`, `highland_eval`.`director_tel`, `highland_eval`.`editor_name`, `highland_eval`.`editor_tel`, `highland_eval`.`sao_names`, `highland_eval`.`adresss`, `highland_eval`.`viledges`, `highland_eval`.`moo`, `highland_eval`.`subdistrict`, `highland_eval`.`district`, `highland_eval`.`provinces`, `highland_eval`.`lgo`, `highland_eval`.`stu_kinder`, `highland_eval`.`stu_prim`, `highland_eval`.`stu_second`, `highland_eval`.`stu_high`, `highland_eval`.`stu_sum`, `highland_eval`.`stu_hilltrib`, `highland_eval`.`stu_hilltrib_group`, `highland_eval`.`stu_sleep_girl`, `highland_eval`.`stu_sleep_boy`, `highland_eval`.`stu_sleep_sum`, `highland_eval`.`lat`, `highland_eval`.`lng`, `highland_eval`.`highest`, `highland_eval`.`average_height`, `highland_eval`.`distance_to_province`, `highland_eval`.`distance_to_`, `highland_eval`.`citeria01`, `highland_eval`.`citeria01_refdoc`, `highland_eval`.`citeria02`, `highland_eval`.`citeria02_refdoc`, `highland_eval`.`citeria03`, `highland_eval`.`citeria03_refdoc`, `highland_eval`.`citeria04`, `highland_eval`.`citeria041`, `highland_eval`.`citeria04_refdoc`, `highland_eval`.`citeria05`, `highland_eval`.`citeria05_refdoc`, `highland_eval`.`citeria06`, `highland_eval`.`citeria06_refdoc`, `highland_eval`.`citeria07`, `highland_eval`.`citeria07_refdoc`, `highland_eval`.`citeria08`, `highland_eval`.`citeria08_refdoc`, `highland_eval`.`citeria09`, `highland_eval`.`citeria09_refdoc`, `highland_eval`.`citeria10`, `highland_eval`.`citeria10_refdoc`, `highland_eval`.`citeria11`, `highland_eval`.`citeria11_refdoc`, `highland_eval`.`citeria12`, `highland_eval`.`citeria12_refdoc`, `highland_eval`.`citeria13`, `highland_eval`.`citeria13_refdoc`, `highland_eval`.`citeria14`, `highland_eval`.`citeria14_refdoc`, `highland_eval`.`citeria15`, `highland_eval`.`citeria15_refdoc`, `highland_eval`.`citeria16`, `highland_eval`.`citeria16_refdoc`, `highland_eval`.`score01`, `highland_eval`.`score02`, `highland_eval`.`score03`, `highland_eval`.`score04`, `highland_eval`.`score05`, `highland_eval`.`score06`, `highland_eval`.`score07`, `highland_eval`.`score08`, `highland_eval`.`score09`, `highland_eval`.`score10`, `highland_eval`.`score11`, `highland_eval`.`score12`, `highland_eval`.`score13`, `highland_eval`.`score14`, `highland_eval`.`score15`, `highland_eval`.`score16`, `highland_eval`.`sum_score`, `highland_eval`.`comments`, `highland_eval`.`status`, `highland_eval`.`sc_id` as `printlink`, `highland_eval`.`sc_id` as `maplink`, `highland_eval`.`sc_id` as `remote`, `highland_eval`.`sc_id` as `mapelev`, `highland_eval`.`highland_type`, `highland_eval`.`spt_commit`, `highland_eval`.`spt_comment`, `highland_eval`.`status` as `status1`, `highland_eval`.`spt_commit` as `spt_commit1`, `highland_eval`.`acadyears`, `highland_eval`.`date_created`, `scssra`.`saoid`, `scssra`.`saoname`, `highland_eval`.`sao_proved2567`, `highland_eval`.`sao_comment2567`, `highland_eval`.`fail_reason`
FROM `highland_eval`
LEFT OUTER JOIN `scssra` ON scssra.sc_id = highland_eval.sc_id WHERE ( ( scssra.saoid= ) ) and ( highland_eval.acadyears =2567 ) |
| #3 |
classes/datasource/table.php:621 |
DataSourceTable->getCount |
0. DsCommand |
| #4 |
classes/listpage.php:2793 |
ListPage->calculateRecordCount |
N/A |
| #5 |
classes/listpage.php:2205 |
ListPage->prepareForBuildPage |
N/A |
| #6 |
highland_eval_list.php:158 |
Global scope |
N/A |