The error can occur due upgrade if some data are corrupted. Could you send SQL dump by email so we can investigate the problem in more details?

Regards,
ARI Soft

The SQL dump is 260mb Can you tell me what can we do? Do you think exporting and importing it again will make a difference?

I try exporting the DB again and importing it again. No luck the same error


Warning

BIGINT UNSIGNED value is out of range in '((unix_timestamp(`name_joom3`.`S`.`EndDate`) - unix_timestamp(`name_joom3`.`S`.`StartDate`)) + `name_joom3`.`S`.`UsedTime`)' SQL=UPDATE name_ariquizstatistics S INNER JOIN name_ariquizstatisticsinfo SI ON S.StatisticsInfoId = SI.StatisticsInfoId SET S.ElapsedTime = CASE WHEN S.EndDate IS NOT NULL THEN UNIX_TIMESTAMP(S.EndDate) - UNIX_TIMESTAMP(S.StartDate) + S.UsedTime WHEN SI.Status = "Finished" THEN IF( S.QuestionTime > 0, LEAST( S.QuestionTime, IF( S.StartDate IS NOT NULL, UNIX_TIMESTAMP(SI.EndDate) - UNIX_TIMESTAMP(S.StartDate) + S.UsedTime, S.UsedTime ) ), IF( S.StartDate IS NOT NULL, UNIX_TIMESTAMP(SI.EndDate) - UNIX_TIMESTAMP(S.StartDate) + S.UsedTime, S.UsedTime ) ) END


Do you think this has something to do to the fact on Joomla 2.5 we are running Ari quiz 2 and on the Joomla 3 i have install Ari Quiz 3 ?

Everything is there in only don't see the Quizess tab... it just saying: Loading...

I send you email

Execute the following SQL query after restore data from dump but before installing the component:

DELETE
SI,S
FROM
kxmk_ariquizstatisticsinfo SI LEFT JOIN kxmk_ariquizstatistics S
ON SI.StatisticsInfoId = S.StatisticsInfoId
WHERE
SI.StatisticsInfoId IN (686)


It can be executed in AceSQL component or via PHPMyAdmin. It should help.

Regards,
ARI Soft