--0--
partida_individual
Oviedo El Reto I |
| # | Ronda: 1 |
G | P | EFE | PF |
| 0 |
EDWARD GONZALEZ
|
0 | 0 | 0 | 0 |
| 1 |
ELIZABETH CLAUDIO
|
0 | 0 | 0 | 0 |
| 2 |
ANTONIO ESQUIVEL
|
0 | 0 | 0 | 0 |
| 3 |
ALFRED YORSTON
|
0 | 0 | 0 | 0 |
| 4 |
CARMEN RIOS
|
0 | 0 | 0 | 0 |
| 5 |
ALMA MUNOZ
|
0 | 0 | 0 | 0 |
| 6 |
FRANCISCO HERNANDEZ
|
0 | 0 | 0 | 0 |
| 7 |
ELLEN RUIZ
|
0 | 0 | 0 | 0 |
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(434): PDODb->rawQuery('select a.id_torneo, a.id_ronda, a.id_partida, a.id_mesa, c.id_mano, a.Pareja1 , a.Pareja2, b.totalA, b.totalB , a.fotoA, a.fotoB , a.fotoC, a.fotoD, c.detalleA, c.detalleB, c.tarjetas, puntosAC , puntosBD from( select id_torneo, id_ronda, id_partida, id_mesa, concat(max(ifnull(personaA,'')) ,'/', max(ifnull(personaC,''))) Pareja1 , concat(max(ifnull(personaB,'')),'/',max(ifnull(personaD,'')) ) Pareja2, max(fotoA) fotoA, max(fotoB) fotoB , max(fotoC) fotoC, max(fotoD) fotoD , concat(sum(PuntosA),'/',sum(PuntosC)) puntosAC, concat(sum(PuntosB),'/',sum(PuntosD)) puntosBD from ( SELECT a.id_torneo,a.id_ronda, a.id_partida, case when a.ubicacion= 'A' then upper(concat(SUBSTRING_INDEX(b.nombres,' ', 1),' ',SUBSTRING_INDEX(b.apellidos,' ', 1))) end personaA, case when a.ubicacion= 'B' then upper(concat(SUBSTRING_INDEX(b.nombres,' ', 1),' ',SUBSTRING_INDEX(b.apellidos,' ', 1))) end personaB, case when a.ubicacion = 'C' then upper( concat(SUBSTRING_INDEX(b.nombres,' ', 1),' ',SUBSTRING_INDEX(b.apellidos,' ', 1))) end personaC, case when a.ubicacion = 'D' then upper(concat(SUBSTRING_INDEX(b.nombres,' ', 1),' ',SUBSTRING_INDEX(b.apellidos,' ', 1))) end personaD, case when a.ubicacion= 'A' then b.foto end fotoA, case when a.ubicacion= 'B' then b.foto end fotoB, case when a.ubicacion= 'C' then b.foto end fotoC, case when a.ubicacion= 'D' then b.foto end fotoD, a.id_mesa , case when a.ubicacion= 'A' then a.puntosnetos else 0 end PuntosA , case when a.ubicacion= 'B' then a.puntosnetos else 0 end PuntosB , case when a.ubicacion= 'C' then a.puntosnetos else 0 end PuntosC , case when a.ubicacion= 'D' then a.puntosnetos else 0 end PuntosD FROM partida_individual a inner join persona b on a.id_persona = b.id_persona WHERE a.id_torneo = 193 and a.id_ronda = 1 and a.estado <> 'N' order by a.id_mesa ) as a group by id_torneo, id_partida, id_mesa order by id_mesa ) as a inner join(select a.id_torneo , a.id_ronda, a.id_partida, sum(b.puntosA) totalA, sum(b.puntosB) totalB, 0 detalleA, 0 detalleB FROM (select DISTINCT id_torneo, id_ronda, id_partida from partida_individual WHERE id_torneo = 193 and id_ronda = 1) a left join ficha b on a.id_torneo = b.id_torneo and a.id_partida = b.id_partida WHERE a.id_torneo = 193 and a.id_ronda = 1 group by a.id_torneo , a.id_ronda, a.id_partida) b on a.id_torneo = b.id_torneo and a.id_partida = b.id_partida left join ( select a.id_torneo , a.id_partida, a.id_mano, a.puntosA detalleA ,a.puntosB detalleB, 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 WHERE a.id_torneo = 193 group by a.id_torneo , a.id_partida ) c on a.id_torneo = c.id_torneo and a.id_partida = c.id_partida order by a.id_torneo , a.id_partida, c.id_mano', NULL) 6 /home/u555994007/domains/kissimmeedominoclub.com/public_html/app/views/partials/partida_individual/vistayavanceindividualpublico.php(482): Shared2Controller->DetallePartidas('193', '1') 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', '193') 13 /home/u555994007/domains/kissimmeedominoclub.com/public_html/system/Router.php(109): Router->run('partida_individual/vistayavanceindividualpublico/id_torneo/193') 14 /home/u555994007/domains/kissimmeedominoclub.com/public_html/index.php(106): Router->init() |