Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

BIGINT UNSIGNED value is out of range,Joomla 3.1.1
(1 viewing) (1) Guest
ARI Quiz Lite
Go to bottomPage: 1234
TOPIC: BIGINT UNSIGNED value is out of range,Joomla 3.1.1
#46180
BIGINT UNSIGNED value is out of range,Joomla 3.1.1 10 Years, 6 Months ago Karma: 0
Hi Admin

Just trying out Quiz Lite on Joomla 3.1.1 and am getting this error

1690 BIGINT UNSIGNED value is out of range in '(((unix_timestamp(utc_timestamp())) - unix_timestamp(`abcdef_jklxi`.`SS`.`StartDate`)) + `abcdef_jklxi`.`SS`.`UsedTime`)' SQL=SELECT COUNT(*) FROM jos_ariquizstatisticsinfo SSI LEFT JOIN jos_ariquizstatistics SS ON SSI.StatisticsInfoId = SS.StatisticsInfoId WHERE SSI.TicketId = '203124c846a653f4457efe8a2840d4d9' AND (SS.EndDate IS NOT NULL OR (SS.StartDate IS NOT NULL AND (SS.QuestionTime IS NOT NULL AND SS.QuestionTime > 0) AND (UNIX_TIMESTAMP(UTC_TIMESTAMP()) - UNIX_TIMESTAMP(SS.StartDate) + UsedTime) >= SS.QuestionTime))

Any clues on how to fix this ?
The administrator has disabled public write access.
 
#46181
Re:BIGINT UNSIGNED value is out of range,Joomla 3.1.1 10 Years, 6 Months ago Karma: 748
Hello,

It can be a problem if date and time is not synchronized on web and database server. We can investigate the problem in more detailed if you provide a temporary access to your J! backend and a link to a page where we can see the problem by email.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#53967
Re:BIGINT UNSIGNED value is out of range,Joomla 3.1.1 9 Years, 2 Months ago Karma: 0
HI.

I'd like to report similar issue;

Joomla 3.3.6
ARI Quiz Lite 1.2.7

PHP: 5.5.18
SQL: 5.5

memory_limit: 128M
connect_timeout: 60

URL: www.target-training.pl/testy-egzaminacyjne/egzaminy-na-pozwolenie-na-bron.html
Scroll to page bottom and click "Dalej" button to start quiz.

Screenshot: prntscr.com/6kesph

How to replicate:

1. Browse to: URL: www.target-training.pl/testy-egzaminacyjne/egzaminy-na-pozwolenie-na-bron.html
Scroll to page bottom and click "Dalej" button to start quiz.

2. Just answer to questions.

Result:

After a while error pops up. It's possible to click back in browser and apply question once again. After that another question is loaded.

It happens on irregular basis so you may need to start quiz few times.

Expected result:

No error.

I could provide backend and PHPmyAdmin access on request - just PM or say so here.
The administrator has disabled public write access.
 
#53977
Re:BIGINT UNSIGNED value is out of range,Joomla 3.1.1 9 Years, 2 Months ago Karma: 748
Hello,

Send credentials to your J! backend by email so we can investigate the problem.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54496
Re:BIGINT UNSIGNED value is out of range,Joomla 3.1.1 9 Years ago Karma: 0
same problem.....


joomla 3.4.1
The administrator has disabled public write access.
 
#54497
Re:BIGINT UNSIGNED value is out of range,Joomla 3.1.1 9 Years ago Karma: 0
i just emailed about the problem and also sent credentials of joomla backend..
thank you in advance..
The administrator has disabled public write access.
 
Go to topPage: 1234