Database_Exception [ 1452 ]: Cannot add or update a child row: a foreign key constraint fails (`DWH_Analytics`.`FACT_JUEGO_DIA`, CONSTRAINT `DIA` FOREIGN KEY (`FH_DIA`) REFERENCES `LU_DIA` (`FH_DIA`) ON DELETE NO ACTION ON UPDATE NO ACTION) [ INSERT INTO FACT_JUEGO_DIA (LOCALIDAD_ESCUELA_ID, LOCALIDAD_ALUMNO_ID, IND_EFICIENCIA, IND_TROFEOS, IND_SESION_JUEGO, IND_TIEMPO_JUEGO, IND_SCORE_JUEGO, IND_NIVEL_ACTUAL, IND_MAX_NIVEL, IND_LIKES, CONCEPTO_ID, FH_DIA, JUEGO_ID, ALUMNO_SK, CICLO_ESCOLAR_ID) VALUES ('783', '783', '1', '540', '5075655', '435', '0', '0', '0', '1', '3', '2019-01-12', '84', '27932', '7') ]

MODPATH/database/classes/kohana/database/mysql.php [ 194 ]

189 			{
190 				// This benchmark is worthless
191 				Profiler::delete($benchmark);
192 			}
193 
194 			throw new Database_Exception(':error [ :query ]',
195 				array(':error' => mysql_error($this->_connection), ':query' => $sql),
196 				mysql_errno($this->_connection));
197 		}
198 
199 		if (isset($benchmark))
  1. MODPATH/database/classes/kohana/database/query.php [ 245 ] » Kohana_Database_MySQL->query(arguments)

  2. APPPATH/classes/model/datawarehouse.php [ 212 ] » Kohana_Database_Query->execute(arguments)

  3. APPPATH/classes/controller/frontend/datawarehouse.php [ 226 ] » Model_Datawarehouse->setNewDayFact(arguments)

  4. {PHP internal call} » Controller_Frontend_Datawarehouse->action_updateFactGames()

  5. SYSPATH/classes/kohana/request/client/internal.php [ 118 ] » ReflectionMethod->invoke(arguments)

  6. SYSPATH/classes/kohana/request/client.php [ 64 ] » Kohana_Request_Client_Internal->execute_request(arguments)

  7. SYSPATH/classes/kohana/request.php [ 1138 ] » Kohana_Request_Client->execute(arguments)

  8. DOCROOT/index.php [ 109 ] » Kohana_Request->execute()

Environment