search

Jefferson49 / Joomla_plugin_sexypolling_reloaded

Migration of the joomla plugin "Sexy Polling" to joomla 4.x
GNU General Public License v3.0
2 stars 3 forks source link

SQL error when adding count to field Insert votes in Answers #98

Closed WoodyF4u closed 4 months ago

WoodyF4u commented 5 months ago

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

Jefferson49 commented 4 months ago

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.

Jefferson49 commented 4 months ago

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

Jefferson49 commented 4 months ago

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