Jefferson49/Joomla_extension_sexypolling_reloaded

SQL error when adding count to field Insert votes in Answers

WoodyF4u opened this issue · 3 comments

Hi,
If I go to Answers and then enter a certain value in the Insert Votes field and choose Save, I get this error message:

_An error has occurred.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '21??),(6, '', 2024-03-25 21??),(6, '', 2024-03-25 21??)' at line 1_ 

I work with Joomla 5.
Does anyone know how I can solve this?

I also cannot find the field in the SPR tables in the database.
So filling it in manually was not possible either.

Regards,
Wouter

Hi Wouter,

thank you for reporting the issue! Sorry, I did not react on your post in #37, because there was something going wrong with the email notification system and I did not get an email.

If I go to Answers and then enter a certain value in the Insert Votes field and choose Save, I get this error message:

Yes, I can reproduce the error and also get a PHP error message. I will check the code in the next days.

I found the bug and fixed it in the code. I will publish a bugfix release in the next days.

I have just published a bugfix release v5.5.1, which fixes the issue.