Error 500
Server Error
Exception Traces
This will only be displayed in DEVELOPMENT_MODE.| Error Message | SQLSTATE[HY000] [2002] Operation not permitted |
|---|---|
| File | /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/models/PDODb.php On Line 299 |
| Stack Trace |
1 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/models/PDODb.php(299): PDO->__construct('mysql:host=localhost;dbname=u555994007_domino;port=3306', 'u555994007_kissi_admin', 'Domino_7941', Array) 2 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/models/PDODb.php(1506): PDODb->connect() 3 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/models/PDODb.php(1526): PDODb->pdo() 4 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/models/PDODb.php(1606): PDODb->prepare() 5 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/controllers/Shared2Controller.php(784): PDODb->rawQuery('SELECT a.id, a.id_mesa, b.foto, a.id_persona, concat( SUBSTRING_INDEX(b.nombres,' ', 1),' ' ,SUBSTRING_INDEX(b.apellidos,' ', 1)) Persona, c.nombre_equipo, a.ganados, a.perdidos, a.efectividad, a.puntosnetos, punto_favor pfavor, puntos_contra pcontra, a.ubicacion, r.pareja, a.estado, a.id_partida, a.estado, case when a.activo= 1 then 'Act' else 'Out' end activo, e.id_evento, e.id_tipoevento, t.suma_tarjeta, t.total_tarjeta, t.tarjetas, a.lugar FROM partida_individual a inner join evento e on a.id_torneo=e.id_evento inner JOIN persona b on a.id_persona = b.id_persona left join equipo c on a.id_equipo = c.id_equipo left join ( select id_torneo, id_partida, id_ronda, case when max(idA) < max(idC) then concat( max(idA),',', max(idC)) else concat( max(idC),',', max(idA)) end pareja from ( SELECT a.id_torneo, a.id_partida,id_ronda, case when a.ubicacion= 'A' then b.id_persona end idA, case when a.ubicacion= 'C' then b.id_persona end idC FROM `partida_individual` a inner join persona b on a.id_persona = b.id_persona WHERE a.id_torneo = 256 and a.id_ronda = 2) as dato group by id_torneo, id_partida, id_ronda UNION ALL select id_torneo, id_partida, id_ronda, case when max(idB) < max(idD) then concat(max(idB),',' , max(idD)) else concat(max(idD),',' , max(idB)) end pareja from ( SELECT a.id_torneo, a.id_partida,id_ronda, case when a.ubicacion= 'B' then b.id_persona end idB, case when a.ubicacion= 'D' then b.id_persona end idD FROM `partida_individual` a inner join persona b on a.id_persona = b.id_persona WHERE a.id_torneo = 256 and a.id_ronda = 2) as dato group by id_torneo, id_partida, id_ronda order by id_torneo, id_partida, id_ronda, pareja) r on a.id_torneo = r.id_torneo and a.id_ronda = r.id_ronda and a.id_partida = r.id_partida and (a.id_persona = SUBSTRING_INDEX(r.pareja, ',', 2) or a.id_persona = SUBSTRING_INDEX(SUBSTRING_INDEX(r.pareja, ',', 2), ',', -1)) left join (SELECT a.id_torneo, a.id_persona, sum(tarjeta) suma_tarjeta, count(tarjeta) total_tarjeta, case when sum(tarjeta) = 1 then 'amarilla' else case when sum(tarjeta) = 3 and count(tarjeta) = 2 then 'amarilla,roja' else case when sum(tarjeta) = 4 and count(tarjeta) = 2 then 'amarilla,negra' else case when sum(tarjeta) = 6 and count(tarjeta) = 3 then 'amarilla,roja,negra' else case when sum(tarjeta) = 5 and count(tarjeta) = 2 then 'roja,negra' else case when sum(tarjeta) = 2 and count(tarjeta) = 1 then ' roja' else case when sum(tarjeta) = 3 and count(tarjeta) = 1 then 'negra' end end end end end end end tarjetas FROM `ficha` a inner join partida_individual b on a.id_torneo = b.id_torneo and a.id_partida = b.id_partida and a.id_persona = b.id_persona where a.id_torneo= 256 and b.id_ronda <=2 and a.tipo <> 'P' group by a.id_torneo, a.id_persona) t on a.id_persona = t.id_persona where a.id_torneo = 256 and a.id_ronda = 2 order by a.id_ronda, a.ganados desc, a.efectividad desc , a.punto_favor desc , id_mesa asc, ubicacion asc', NULL) 6 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/views/partials/partida_individual/vistayavanceindividualpublico.php(29): Shared2Controller->ResultadosParcialesPublico('256', '2') 7 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/BaseView.php(418): include('/home/u555994007/domains/kissimmeedominoclub.com/public_html/app/views/partials/partida_individual/vistayavanceindividualpublico.php') 8 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/views/layouts/main_layout.php(71): BaseView->render_body() 9 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/BaseView.php(385): include('/home/u555994007/domains/kissimmeedominoclub.com/public_html/app/views/layouts/main_layout.php') 10 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/BaseController.php(383): BaseView->render('partida_individual/vistayavanceindividualpublico.php', stdClass, 'main_layout.php') 11 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/controllers/Partida_individualController.php(1356): BaseController->render_view('partida_individual/vistayavanceindividualpublico.php', stdClass) 12 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/Router.php(196): Partida_individualController->vistayavanceindividualpublico('id_torneo', '256') 13 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/Router.php(109): Router->run('partida_individual/vistayavanceindividualpublico/id_torneo/256') 14 /home/u555994007/domains/kissimmeedominoclub.com/public_html/index.php(106): Router->init() |