Code Monkey home page Code Monkey logo

Comments (24)

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Thank you for reporting the issue!

Was this a complete new install in 4.3.0 or did you upgrade from an earlier plugin version or from the former Sexy Polling plugin?

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

I tried to reproduce with a new install on my 4.3.0 system. However, I did not get an error message.

Additional questions:

  • Did you get the error during installation or after installation while using the plugin?
  • Can you activate Joomla debugging (Global configuration => System => Debug => Debug System) and try to catch a more detailed error message (while installing the plugin)? If possible, please post the complete error stack trace or attach it as a text file

from joomla_plugin_sexypolling_reloaded.

MacNaught0n avatar MacNaught0n commented on September 26, 2024

from joomla_plugin_sexypolling_reloaded.

MacNaught0n avatar MacNaught0n commented on September 26, 2024

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Thank you for providing more information. I guess you answered with email. However, I am not sure if I can see all the information you provided, e.g. the screenshot is not visible to me. Maybe, you can check with a browser if everything you provided is visible.

What I can see is that you are using MySQL version 5.7.23-23, which was released 2018-07-27: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-23.html

With an internet search, I found that MySQL did not support to set default values for text columns in MySQL versions before 2018-10-22:
https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql

This could explain why you get the error message "BLOB, TEXT, GEOMETRY or JSON column 'country' can't have a default value"

In the mentioned source, I found the following explaination:
"The main reason is the flag STRICT_TRANS_TABLES for sql_mode setting. if a value is not specified in INSERT statement for TEXT datatype column and if the flag exist in the sql_mode setting then MySQL is reporting an error; and if the flag doesn't exist then MySQL is only reporting a warning and inserts the record.

So, to prevent this error, one can remove the STRICT_TRANS_TABLES from sql_mode setting of MySQL. (He my need to reset the mode to the previous value if it can affect other operations on the database.)"

Therefore, to get around this issue, you have two options:

  • Upgrade your MySQL database to a version after 2018-10-22
  • Change the sql_mode variable of your MySQL settings

Since changing the variable might also encounter side effects, updating the MySQL version would be prefered.

For changing the sql_mode variable, the following steps are proposed in the source above:

  • "If you have root access and are using phpMyAdmin, go to the main page (click the phpMyAdmin logo), go to the Variables tab, find the sql_mode variable, and click Edit. – "
  • "remove the STRICT_TRANS_TABLES from sql_mode setting"
  • Alternatively: set sql_mode='MYSQL40'. You can also run a MySQL query, e.g. in phpMyAdmin: SET @@global.sql_mode='MYSQL40'

Before trying this, you should backup your database and database settings. Also copy and save the previous/current setting of the sql_mode variable in order to roll back in case of problems.

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

it is not possible to install plugin on joomla 4.3.4

image

image

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Thank you for reporting the issue!

Can you check and provide your database version?
The error "TEXT, GEOMETRY or JSON column 'country' can't have a default value seems to be related to the database version.

Plugin releases starting from v4.1.7 need a MySQL version of 5.7.24 (8.0.13) or later.
For MySQL versions earlier than 5.7.24, the former plugin release v4.1.6 can be used.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Another point might be the PHP version. Until recently, there was a recomendation to use PHP 8.1 for Joomla 4.3. I have just checked that it seems to be 8.2 nowadays. However, my own Joomla 4.3.4 installation does not work properly with PHP 8.2. Since my Joomla site does not work with PHP 8.2, I can not provide any statements about sexypolling_reloaded and PHP 8.2.

If you have the chance to choose between PHP versions on your server, I recommend to try PHP 8.1

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

I've the following configuration:
[PHP --> 8.2](phpversion: 8.2.9)
dbversion: 8.0.26
version: Joomla! 4.3.4 Stable

I tried thee release v4.1.7, but it isn't work

I don't have the possibility to switch to PHP8.1 --> I can choise PHP8.0 or PHP8.2.

Do you have others suggestion?

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Thanks for the additional information. Since your database version (8.0.26) is newer than 8.0.13, the database should be o.k.

Do you have other suggestions?

  • You can switch to PHP 8.0. For Joomla and the plugin, this should also be o.k.; maybe a little bit lower performance than 8.2. It would be interesting for me, if another PHP version would fix the issue, because until now it only showed up with old database versions.
  • You can try to install the earlier plugin version v4.1.6. The "can't have a default value" type of errors did not show up in v4.1.6

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

Thanks for your suggestion. I tried to install the version 4.1.6 and it is work fine.
Next 2 question:
1- Now, can I install also version 4.1.7 or it is in conflict with version v4.1.6?
2- the installation of v4.1.7 substitute v4.1.6 or create another plugin?

thanks for now

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

1- Now, can I install also version 4.1.7 or it is in conflict with version v4.1.6?

You can install v4.1.7. However, you will probably get the same error again. In general, you can switch between the versions.

2- the installation of v4.1.7 substitute v4.1.6 or create another plugin?

The versions substitute each other and use the existing database. Plugin v4.1.7 will change some settings in the database, but the changes should be backwards compatible to v4.1.6.

The only thing, where I do not have an answer yet, are future versions. At the moment, it looks like I will have to support two different branches, because otherwise the v4.1.6 will have no successor.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

You can install v4.1.7. However, you will probably get the same error again.

If you have some time for a short test, it would be interesting for me, if you get the error again if installing v4.1.7. Indeed, I have no experience yet, what happens in this case. Maybe, there is a chance that it is working.

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

I tried install the version 4.1.7 on top of v4.1.6 but the issue still show up

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

I tried install the version 4.1.7 on top of v4.1.6 but the issue still show up

Thanks for testing. I was now able to fix some issues in my Joomla 4.3.4 installation and got it running with PHP 8.2. I can install the sexy_polling plugin v4.1.7 without any errors. Therefore, I think the behavior is not related to the PHP version but to the database configuration.

Like posted above, some background can be found here:
https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql

However, it is difficult to sort.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

I tried install the version 4.1.7 on top of v4.1.6 but the issue still show up

After further considerations, I think I have found the root cause of the issue in the code. I have created a beta version (v4.1.8beta) with a bugfix. It would be nice, if you could test it. If it is working and fixes the issue, I will publish it as a new release.

com_sexypolling_v4.1.8beta.zip

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

I tried the v4.1.8beta, but it isn't working.

from joomla_plugin_sexypolling_reloaded.

Gimopa avatar Gimopa commented on September 26, 2024

Other question for me importat:
is it not possible to show all surveys?
In module i saw that is possible only show 1 survey for time

image

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

I tried the v4.1.8beta, but it isn't working.

Would it be possible for you to switch on debugging with maximum error reporting and post the detailed error messages after failed installation?

  • Global configuration -> System -> Debug System -> Yes
  • Global configuration -> Server -> Error Reporting -> Maximum

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

is it not possible to show all surveys?
In module i saw that is possible only show 1 survey for time

You need to create one site module for each poll you want to show. After installation, there is only one default site module created. Just add more site modules with the "New" button and assign different polls to the different site modules.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

I tried the v4.1.8beta, but it isn't working.

I improved the bugfix and created a second beta version. It would be nice if you could test once more:

com_sexypolling_v4.1.8beta2.zip

I guess it only works for a new install. Therefore, you would need to de-install an existing plugin first. However, this will loose the data of the plugin. If you want to keep the data, you could use phpMyAdmin and create a backup of all the sexy_XYZ tables first.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

is it not possible to show all surveys?

I just recognized that you can show all polls, if you select "polls" ("Sondaggi"), like you did in the screenshot above. In this case, the selection of any single poll in the drop down menu has no effect. However, you can (but dont have to) choose a category. In this case, all polls which belong to the category are shown.

Simularly, if you choose to show a single poll ("Sondaggio singulo"), the category has no effect and the drop down menu selects the poll.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Just recently, I published a new release v5.0.0, which is avoiding installation errors of the tpye "column 'country' can't have a default value". Maybe, you can check if the new version also solves the issues you described.

from joomla_plugin_sexypolling_reloaded.

Jefferson49 avatar Jefferson49 commented on September 26, 2024

Hopefully fixed with v5.0.0

from joomla_plugin_sexypolling_reloaded.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.