× Help Forum English

Incorrect double value: 'NaN'

Szymański
Topic Author
Junior Member

3 years 10 months ago #18007 by Szymański

Incorrect double value: 'NaN' was created by Szymański

Hello.When I correct an already saved event and try to save it, I get the following message:Incorrect double value: 'NaN' for column `xxxxxx`.`te4fn_icagenda_events`.`lat` at row 1.

Joomla 4; iCagenda core 3.8.11

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

3 years 10 months ago #18013 by Lyr!C

Replied by Lyr!C on topic Incorrect double value: 'NaN'

Hello,
Not have anyone else reported me such issue...
Could you check latitude and longitude fields in Map ?
Maybe, set again the address before storing to see if it solves the issue.
(an old event ?)

Best regards,
Cyril

Latest version : iCagenda 4.0.17 Joomla! 4 > Joomla! 6
We recommend every user to keep iCagenda updated.
Support for iCagenda version 3.9 (the final version compatible with Joomla 3) ended on October 13, 2026
Extended security support for the iCagenda PRO 3.9 version until October 13, 2027 (to benefit from this extended support, you must have a Pro subscription: www.joomlic.com/extensions/icagenda)
Don't forget to have your Joomla!® up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Please Log in or Create an account to join the conversation.

Szymański
Topic Author
Junior Member

3 years 10 months ago #18019 by Szymański

Replied by Szymański on topic Incorrect double value: 'NaN'

I have this problem on two different websites.
After changing the data in the map position as you suggested, I still get the error:
Incorrect integer value: '' for column `piotrszymd_ZLD`.`te4fn_icagenda_events`.`hits` at row 1.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

3 years 9 months ago #18025 by Lyr!C

Replied by Lyr!C on topic Incorrect double value: 'NaN'

Hello,

It seems you had an issue in iCagenda update process...

Did you install back older versions of iCagenda before updating to latest iCagenda version ?

Best regards,
Cyril

Please Log in or Create an account to join the conversation.

Szymański
Topic Author
Junior Member

3 years 9 months ago #18027 by Szymański

Replied by Szymański on topic Incorrect double value: 'NaN'

I remade the new page. I didn't update Joomla 3 to Joomla 4, just installed Joomla 4 and the latest version of iCagenda on the new site. It was about half a year ago. Since then, this problem appears in some events. Interestingly, not all, but most.
How do you have a suggestion?

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

3 years 9 months ago #18028 by Lyr!C

Replied by Lyr!C on topic Incorrect double value: 'NaN'

That's weird... since half a year ago, no changes in sql update could explain this issue...

Could you try to install the lastest version (of course, don't uninstall iCagenda, just like a first install), to see if any sql error message ?

Best regards,
Cyril

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

3 years 9 months ago #18029 by Lyr!C

Replied by Lyr!C on topic Incorrect double value: 'NaN'

Could you check too if you have not created overrides for iCagenda in admin termplate Atum ?

Regards,
Cyril

Please Log in or Create an account to join the conversation.

Szymański
Topic Author
Junior Member

3 years 9 months ago #18030 by Szymański

Replied by Szymański on topic Incorrect double value: 'NaN'

I have the lastest version (iCagenda core 3.8.12 (2022-12-31))

Please Log in or Create an account to join the conversation.

Szymański
Topic Author
Junior Member

3 years 9 months ago #18031 by Szymański

Replied by Szymański on topic Incorrect double value: 'NaN'

Explain to me what you mean by overrides for iCagenda in admin termplate Atum

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

3 years 9 months ago #18032 by Lyr!C

Replied by Lyr!C on topic Incorrect double value: 'NaN'

Szymański wrote:
I have the lastest version (iCagenda core 3.8.12 (2022-12-31))

Ok, but did you install it again as i asked in my previous message, to check if any SQL error messages reported by Joomla ?...

About overrides, check if a folder named "com_icagenda" in the "html" folder of admin template Atum.

Regards,
Cyril

Please Log in or Create an account to join the conversation.

Moderators: Lyr!C

Time to create page: 0.066 seconds

Forum

Incorrect double value: 'NaN'

Legal

Follow Us