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

Error installing component: "TEXT, GEOMETRY or JSON column 'country' can't have a default value" #46

Closed MacNaught0n closed 10 months ago

MacNaught0n commented 1 year ago

Receiving Error when installing joomla_plugin_sexypolling_reloaded_v4.1.7.zip into Joomla 4.3.0 BLOB, TEXT, GEOMETRY or JSON column 'country' can't have a default value

Jefferson49 commented 1 year ago

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?

Jefferson49 commented 1 year ago

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

Additional questions:

MacNaught0n commented 1 year ago

Jefferson,

Thanks for your prompt reply.

This is a new install.

I had SexyPoll when the site was J3.x but it hung up when I did the J3.x -> J4.x conversion so I uninstalled it.

It does not successfully install.

I have attached a screenshot of the install results & a FPA report.

Michael S. "Mac" Miller

Webmaster – Bengalhome Enterprises

www.bengalhome.com http://www.bengalhome.com/

@. @.> (574) 440-0076

Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for addressee only. Any unauthorized disclosure, reproduction, distribution is not allowed without prior written permission from the author.
If you have received this message in error, please notify the sender and delete the message without disclosure.

From: Jefferson49 @.> Sent: Sunday, April 23, 2023 17:03 To: Jefferson49/Joomla_plugin_sexypolling_reloaded @.> Cc: MacNaught0n @.>; Author @.> Subject: Re: [Jefferson49/Joomla_plugin_sexypolling_reloaded] Error installing component (Issue #46)

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

Additional questions:

— Reply to this email directly, view it on GitHub https://github.com/Jefferson49/Joomla_plugin_sexypolling_reloaded/issues/46#issuecomment-1519167551 , or unsubscribe https://github.com/notifications/unsubscribe-auth/A3TZQABXJQ6VO4LGAJFV2IDXCWKJHANCNFSM6AAAAAAXIWADXU . You are receiving this because you authored the thread. https://github.com/notifications/beacon/A3TZQAEFJXGMWJYEY77MV2DXCWKJHA5CNFSM6AAAAAAXIWADXWWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTS2RSUD6.gif Message ID: @. @.> >

-- This email has been checked for viruses by AVG antivirus software. www.avg.com FIRST RUN - NO PLUGINS

[quote="Forum Post Assistant (v1.6.6) : 24-Apr-2023"][quote="Basic Environment ::"][size=85][b]Joomla! Instance :: [/b][color=Blue]Joomla! [b]4.3.0[/b]-Stable (Bora) 18-April-2023[/color] [b]Joomla! Configured :: [/b][color=Green]Yes[/color] | Read-Only ([color=Green]444[/color]) | [b]Configuration Options :: Offline:[/b] false | [b]SEF:[/b] true | [b]SEF Suffix:[/b] false | [b]SEF ReWrite:[/b] false | [b].htaccess/web.config:[/b] [color=orange]No[/color] | [b]GZip:[/b] false | [b]Cache:[/b] false | [b]CacheTime:[/b] 15 | [b]CacheHandler:[/b] file | [b]CachePlatformPrefix:[/b] false | [b]FTP Layer:[/b] N/A | [b]Proxy:[/b] false | [b]LiveSite:[/b] | [b]Session lifetime:[/b] 999 | [b]Session handler:[/b] database | [b]Shared sessions:[/b] false | [b]SSL:[/b] 0 | [b]Error Reporting:[/b] default | [b]Site Debug:[/b] true | [b]Language Debug:[/b] false | [b]Default Access:[/b] Public | [b]Unicode Slugs:[/b] false | [b]dbConnection Type:[/b] mysqli | [b]PHP Supports J! 4.3.0: [/b][color=Green]Yes[/color] | [b]Database Supports J! 4.3.0: [/b][color=Green]Yes[/color] | [b]Database Credentials Present:[/b] [color=Green]Yes[/color] |

[b]Host Configuration :: OS:[/b] Linux | [b]OS Version:[/b] 4.19.150-76.ELK.el7.x86_64 | [b]Technology:[/b] x86_64 | [b]Web Server:[/b] Apache | [b]Encoding:[/b] gzip, deflate | [b]System TMP Writable:[/b] [color=Green]Yes[/color] | [b] Free Disk Space :[/b] 665.73 GiB |

[b]PHP Configuration :: Version:[/b] [b]8.0.28[/b] | [b]PHP API:[/b] [b]cgi-fcgi[/b] | [b]Session Path Writable:[/b] [color=Green]Yes[/color] | [b]Display Errors:[/b] 0 | [b]Error Reporting:[/b] 22519 | [b]Log Errors To:[/b] error_log | [b]Last Known Error:[/b] 15th October 2022 14:42:19. | [b]Register Globals:[/b] | [b]Magic Quotes:[/b] | [b]Safe Mode:[/b] | [b]Allow url fopen:[/b] 1 | [b]Open Base:[/b] | [b]Uploads:[/b] 1 | [b]Max. Upload Size:[/b] 512M | [b]Max. POST Size:[/b] 516M | [b]Max. Input Time:[/b] 60 | [b]Max. Execution Time:[/b] 30 | [b]Memory Limit:[/b] 256M

[b]Database Configuration :: [/b] [b]Version:[/b] [b]5.7.23-23[/b] (Client:mysqlnd 8.0.28) | [b]Database Size:[/b] 21.91 MiB | [b]#of Tables with config prefix: [/b] 117 | [b]#of other Tables: [/b] 0 | [b]User Privileges : [/b]GRANT ALL[/size][/quote][quote="Detailed Environment ::"][size=85][b]PHP Extensions :: [/b]Core (8.0.28) | date (8.0.28) | [color=Green][b]libxml[/b][/color] (8.0.28) | [color=Green][b]openssl[/b][/color] (8.0.28) | pcre (8.0.28) | [color=Green][b]zlib[/b][/color] (8.0.28) | filter (8.0.28) | hash (8.0.28) | json (8.0.28) | pcntl (8.0.28) | readline (8.0.28) | Reflection (8.0.28) | SPL (8.0.28) | session (8.0.28) | standard (8.0.28) | [color=Green][b]cgi-fcgi[/b][/color] (8.0.28) | bcmath (8.0.28) | bz2 (8.0.28) | calendar (8.0.28) | ctype (8.0.28) | [color=Green][b]curl[/b][/color] (8.0.28) | dom (20031129) | [color=Green][b]mbstring[/b][/color] (8.0.28) | [color=Green][b]fileinfo[/b][/color] (8.0.28) | ftp (8.0.28) | [color=Green][b]gd[/b][/color] (8.0.28) | gettext (8.0.28) | gmp (8.0.28) | [color=Green][b]iconv[/b][/color] (8.0.28) | imap (8.0.28) | intl (8.0.28) | exif (8.0.28) | mysqlnd (mysqlnd 8.0.28) | odbc (8.0.28) | PDO (8.0.28) | pgsql (8.0.28) | Phar (8.0.28) | posix (8.0.28) | pspell (8.0.28) | SimpleXML (8.0.28) | soap (8.0.28) | sockets (8.0.28) | sodium (8.0.28) | sqlite3 (8.0.28) | tidy (8.0.28) | tokenizer (8.0.28) | [color=Green][b]xml[/b][/color] (8.0.28) | xmlwriter (8.0.28) | xsl (8.0.28) | [color=Green][b]zip[/b][/color] (1.19.5) | [color=Green][b]mysqli[/b][/color] (8.0.28) | [color=Green][b]pdo_mysql[/b][/color] (8.0.28) | PDO_ODBC (8.0.28) | pdo_pgsql (8.0.28) | pdo_sqlite (8.0.28) | xmlreader (8.0.28) | imagick (3.5.0) | SourceGuardian (14.0.2) | Zend Engine (4.0.28) | [b]Potential Missing Extensions :: [/b]

[b]Switch User Environment :: PHP CGI:[/b] Yes | [b]Server SU:[/b] Yes | [b]PHP SU:[/b] Yes | [b]Potential Ownership Issues:[/b] [color=Green]No[/color] [/size][/quote][quote="Folder Permissions ::"][size=85][b]Core Folders :: [/b]images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |

[b]Elevated Permissions[/b] [i](First 10)[/i][b] :: [/b][/size][/quote][quote="Database Information ::"][size=85][b]Database statistics :: [/b][b]Uptime:[/b] 2891911 | [b]Threads:[/b] 5 | [b]Questions:[/b] 722076769 | [b]Slow queries:[/b] 0 | [b]Opens:[/b] 39129603 | [b]Flush tables:[/b] 1 | [b]Open tables:[/b] 944 | [b]Queries per second avg:[/b] 249.688 | [/size][/quote][quote="Extensions Discovered ::"][size=85][b]Components :: Site :: [/b] [b] Core :: [/b][color=Blue][/color] [b]3rd Party:: [/b][color=Brown]WF_FILESYSTEM_JOOMLA_TITLE (2.9.36) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.36) ? | WF_LINK_SEARCH_TITLE (2.9.36) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.36) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.36) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.36) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.36) ? | WF_AGGREGATOR_YOUTUBE_TITLE (2.9.36) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.36) ? | WF_SPELLCHECKER_TITLE (2.9.36) ? | WF_VISUALCHARS_TITLE (2.9.36) ? | WF_FILEMANAGER_TITLE (2.9.36) ? | WF_FORMATSELECT_TITLE (2.9.36) ? | WF_IMGMANAGER_EXT_TITLE (2.9.36) ? | WF_DIRECTIONALITY_TITLE (2.9.36) ? | WF_MEDIA_TITLE (2.9.36) ? | WF_KITCHENSINK_TITLE (2.9.36) ? | WF_PREVIEW_TITLE (2.9.36) ? | WF_LANGCODE_TITLE (2.9.36) ? | WF_EMOTIONS_TITLE (2.9.36) ? | WF_SEARCHREPLACE_TITLE (2.9.36) ? | WF_VISUALBLOCKS_TITLE (2.9.36) ? | WF_WORDCOUNT_TITLE (2.9.36) ? | WF_STYLESELECT_TITLE (2.9.36) ? | WF_ARTICLE_TITLE (2.9.36) ? | WF_CHARMAP_TITLE (2.9.36) ? | WF_FONTCOLOR_TITLE (2.9.36) ? | JCE - Columns (1.0.0) ? | WF_SOURCE_TITLE (2.9.36) ? | WF_CLIPBOARD_TITLE (2.9.36) ? | WF_AUTOSAVE_TITLE (2.9.36) ? | WF_TEMPLATEMANAGER_TITLE (2.9.36) ? | WF_LISTS_TITLE (2.9.36) ? | WF_HR_TITLE (2.9.36) ? | WF_PRINT_TITLE (2.9.36) ? | WF_TEXTCASE_TITLE (2.9.36) ? | WF_TABLE_TITLE (2.9.36) ? | WF_ATTRIBUTES_TITLE (2.9.36) ? | WF_HELP_TITLE (2.9.36) ? | WF_MEDIAMANAGER_TITLE (2.9.36) ? | WF_CAPTION_TITLE (2.9.36) ? | WF_STYLE_TITLE (2.9.36) ? | WF_TEXTPATTERN_TITLE (2.9.36) ? | WF_REFERENCE_TITLE (2.9.36) ? | WF_FULLSCREEN_TITLE (2.9.36) ? | WF_MICRODATA_TITLE (2.9.36) ? | WF_ANCHOR_TITLE (2.9.36) ? | WF_BROWSER_TITLE (2.9.36) ? | WF_IFRAME_TITLE (2.9.36) ? | WF_NONBREAKING_TITLE (2.9.36) ? | WF_IMGMANAGER_TITLE (2.9.36) ? | WF_LINK_TITLE (2.9.36) ? | WF_FONTSELECT_TITLE (2.9.36) ? | WF_XHTMLXTRAS_TITLE (2.9.30) ? | WF_CLEANUP_TITLE (2.9.36) ? | JCE - Noneditable (1.0.0) ? | WF_FONTSIZESELECT_TITLE (2.9.36) ? | WF_CONTEXTMENU_TITLE (2.9.36) ? | [/color]

[b]Components :: Admin :: [/b] [b] Core :: [/b][color=Blue]com_modules (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_media (3.0.0) 1 | com_login (4.0.0) 1 | com_privacy (3.9.0) 1 | com_banners (4.0.0) 1 | com_languages (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_cache (4.0.0) 1 | com_checkin (4.0.0) 1 | com_finder (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_content (4.0.0) 1 | com_admin (4.0.0) 1 | com_config (4.0.0) 1 | com_mails (4.0.0) 1 | com_messages (4.0.0) 1 | com_menus (4.0.0) 1 | com_associations (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_ajax (4.0.0) 1 | com_categories (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_workflow (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_users (4.0.0) 1 | com_plugins (4.0.0) 1 | com_guidedtours (4.3.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_redirect (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | [/color] [b]3rd Party:: [/b][color=Brown]COM_JCE (2.9.36) 1 | HikaShop (4.6.2) 1 | Hikashop Check Payment Plugin (4.6.2) ? | Hikashop Alipay Payment Plugin (4.6.2) ? | Hikashop FirstData Payment Plugin (4.6.2) ? | Hikashop History Plugin (4.6.2) ? | Hikashop Paypal Payment Plugin (4.6.2) ? | Hikashop FedEx Shipping Plugin (4.6.2) ? | Hikashop - Redshop Fallback Redirec (4.6.2) ? | Hikashop Geolocation Plugin (4.6.2) ? | Hikashop - Mijoshop Fallback Redire (4.6.2) ? | Hikashop Paygate Payment Plugin (4.6.2) ? | Hikashop PayU India Payment Plugin (4.6.2) ? | Hikashop Orders Automatic Cancel Pl (4.6.2) ? | Hikashop Nets NETAXEPT Payment Plug (4.6.2) ? | HikaShopCustom Price plugin (4.6.2) ? | Hikashop Borgun payment plugin (4.6.2) ? | Hikashop Collect On Delivery Paymen (4.6.2) ? | Hikashop Registration Redirect Plug (4.6.2) ? | Hikashop Massaction User Plugin (4.6.2) 1 | User - HikaShop (4.6.2) ? | Hikashop Paypal Pro Payment Plugin (4.6.2) ? | HikaShop Payment Notification plugi (4.6.2) ? | Hikashop Virtual Merchant (Elavon) (4.6.2) ? | Hikashop Paypal Express Checkout Pa (4.6.2) ? | Hikashop Paybox Plugin (4.6.2) ? | Hikashop Currency Switcher Module (4.6.2) ? | Hikashop CyberMuth CIC Payment Plug (4.6.2) ? | Hikashop Massaction Order Plugin (4.6.2) 1 | Hikashop Authorize.net Payment Plug (4.6.2) ? | Hikashop Filtering Module (4.6.2) ? | Hikashop Western Union Payment Plug (4.6.2) ? | Hikashop Product Tag (4.6.2) ? | Hikashop UPS Shipping Plugin (4.6.2) ? | Hikashop Credit Card Payment Plugin (4.6.2) ? | Hikashop Content Parser - Markdown (4.6.2) ? | Hikashop Paypal Checkout Payment Pl (4.6.2) ? | Hikashop out of order notification (4.6.2) ? | HikaShop: Date Picker Custom Field (4.6.2) ? | Smart Search - HikaShop Products (4.6.2) 1 | Hikashop Massaction Address Plugin (4.6.2) 1 | Hikashop PayPlug v2 payment plugin (4.6.2) ? | Hikashop - Kashflow invoice synchro (4.6.2) ? | Hikashop Monetico Payment Plugin (4.6.2) ? | Hikashop CardSave Payment Plugin (4.6.2) ? | Hikashop eSelect Payment Plugin (4.6.2) ? | Hikashop CANPAR Shipping Plugin (1.0.0) ? | Hikashop Australia Post eDeliver Sh (4.6.2) ? | Hikashop Payment Express Payment Pl (4.6.2) ? | Hikashop iPayDNA Payment Plugin (4.6.2) ? | Hikashop Servired Payment Plugin (4.6.2) ? | Hikashop Payza Payment Plugin (4.6.2) ? | Hikashop ATOS SIPS 2.0 Payment Plug (4.6.2) ? | Hikashop Paypal Advanced payment pl (4.6.2) ? | AcyMailing Tag : HikaShop content (4.6.2) ? | Hikashop SIPS ATOS Payment Plugin (4.6.2) ? | Hikashop Google Analytics Plugin (4.6.2) ? | Hikashop Massaction Product Plugin (4.6.2) 1 | Ogone Payment Plugin (4.6.2) ? | Hikashop Google Products Plugin (4.6.2) 1 | Hikashop Cart Module (4.6.2) ? | Hikashop UserPoints Plugin (4.6.2) ? | Hikashop USPS Shipping Plugin (4.6.2) ? | Hikashop Postfinance Payment Plugin (4.6.2) ? | Search - Hikashop Categories/Manufa (4.6.2) ? | Hikashop Beanstream Payment Plugin (4.6.2) ? | Search - Hikashop Products (4.6.2) ? | Hikashop Cart notification Plugin (4.6.2) ? | Hikashop iVeri Payment Plugin (4.6.2) ? | Hikashop westpacapi Payment Plugin (1.0) ? | Hikashop User account Plugin (4.6.2) ? | Hikashop PaymentExpress (PxPay) Plu (4.6.2) ? | Hikashop Module (4.6.2) ? | Hikashop Manual Shipping Plugin (4.6.2) ? | Hikashop Shop Close Hours Plugin (4.6.2) ? | HikaShop Product TAG insertion (4.6.2) ? | Hikashop TaxCloud Plugin (1.2.3) 0 | Hikashop Wishlist Module (4.6.2) ? | Hikashop eWAY Payment Plugin (4.6.2) ? | Hikashop MasterCard Internet Gatewa (4.6.2) ? | Hikashop - VirtueMart Fallback Redi (4.6.2) ? | Hikashop WaitList notification Plug (4.6.2) ? | Hikashop Validate free order Plugin (4.6.2) ? | Hikashop Massaction Category Plugin (4.6.2) 1 | Hikashop PayJunction Payment Plugin (4.6.2) ? | Hikashop - Product Cron Update (4.6.2) ? | Hikashop Common Joomla Payment API (4.6.2) ? | System - HikaShop Mass Action (4.6.2) ? | Hikashop no SSL outside checkout Pl (4.6.2) ? | Hikashop Purchase Order Payment Plu (4.6.2) ? | HikaShop Quick Icon (4.6.2) ? | System - Hikashop Social Plugin (4.6.2) ? | Hikashop WorldNetTPS Payment Plugin (4.6.2) ? | Hikashop Paypal Website Payments Pr (4.6.2) ? | Hikashop ePay Payment Plugin (4.6.2) ? | Hikashop Moneybookers Payment Plugi (4.6.2) ? | Hikashop Group Plugin (4.6.2) ? | Hikashop Email History Plugin (4.6.2) 1 | Hikashop PayPlug payment plugin (4.6.2) ? | HikaShop Dashboard (4.6.2) 1 | Hikashop Currency Rates Plugin (4.6.2) ? | Hikashop Be2Bill Payment Plugin (4.6.2) ? | System - HikaShop Affiliate (4.6.2) ? | HikaShop Shipping Manual - Price pe (4.6.2) ? | Hikashop AcyMailing Plugin (4.6.2) ? | Hikashop HSBC Payment Plugin (4.6.2) ? | HikaShop Google Dynamic Remarketing (4.6.2) ? | Hikashop Bank Transfer Payment Plug (4.6.2) ? | Hikashop Bluepaid Payment Plugin (4.6.2) ? | Hikashop UserPoints Payment Plugin (4.6.2) ? | HikaShop Product TAG translation (4.6.2) ? | [/color]

[b]Modules :: Site :: [/b] [b] Core :: [/b][color=Blue]mod_menu (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_news (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_articles_categories (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_login (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_category (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_users_latest (3.0.0) 1 | [/color] [b]3rd Party:: [/b][color=Brown]Hikashop Currency Switcher Module (4.6.2) ? | Hikashop Filtering Module (4.6.2) ? | Hikashop Cart Module (4.6.2) ? | Hikashop Module (4.6.2) ? | Hikashop Wishlist Module (4.6.2) ? | MOD_SEXYPOLLING_NAME (4.1.7) 1 | [/color]

[b]Modules :: Admin :: [/b] [b] Core :: [/b][color=Blue]mod_menu (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_loginsupport (4.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_quickicon (3.0.0) 1 | mod_login (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_feed (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_user (4.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_version (3.0.0) 1 | mod_title (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_latest (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_guidedtours (4.3.0) 1 | mod_popular (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_privacy_status (4.0.0) 1 | [/color] [b]3rd Party:: [/b][color=Brown]Import Content (1.0) 1 | Reset Hits module (4.0.2) 1 | HikaShop Dashboard (4.6.2) 1 | [/color]

[b]Libraries :: [/b] [b] Core :: [/b][color=Blue][/color] [b]3rd Party:: [/b][color=Brown][/color]

[/size][/quote][quote="Templates Discovered ::"][size=85][b]Templates :: Site :: [/b][color=Blue]mod_search (1.7.0)[/color] ? | [color=Brown]CLANSorg (1.0)[/color] 1 | [color=Blue]cassiopeia (1.0)[/color] 1 | [b]Templates :: Admin :: [/b][color=Blue][b][u]atum (1.0)[/u][/b][/color] 1 | [/size][/quote][/quote]

SECOND RUN - ONLY PLUGINS

[quote="Forum Post Assistant (v1.6.6) : 24-Apr-2023"][quote="Basic Environment ::"][size=85][b]Joomla! Instance :: [/b][color=Blue]Joomla! [b]4.3.0[/b]-Stable (Bora) 18-April-2023[/color] [b]Joomla! Configured :: [/b][color=Green]Yes[/color] | Read-Only ([color=Green]444[/color]) | [b]Configuration Options :: Offline:[/b] false | [b]SEF:[/b] true | [b]SEF Suffix:[/b] false | [b]SEF ReWrite:[/b] false | [b].htaccess/web.config:[/b] [color=orange]No[/color] | [b]GZip:[/b] false | [b]Cache:[/b] false | [b]CacheTime:[/b] 15 | [b]CacheHandler:[/b] file | [b]CachePlatformPrefix:[/b] false | [b]FTP Layer:[/b] N/A | [b]Proxy:[/b] false | [b]LiveSite:[/b] | [b]Session lifetime:[/b] 999 | [b]Session handler:[/b] database | [b]Shared sessions:[/b] false | [b]SSL:[/b] 0 | [b]Error Reporting:[/b] default | [b]Site Debug:[/b] true | [b]Language Debug:[/b] false | [b]Default Access:[/b] Public | [b]Unicode Slugs:[/b] false | [b]dbConnection Type:[/b] mysqli | [b]PHP Supports J! 4.3.0: [/b][color=Green]Yes[/color] | [b]Database Supports J! 4.3.0: [/b][color=Green]Yes[/color] | [b]Database Credentials Present:[/b] [color=Green]Yes[/color] |

[b]Host Configuration :: OS:[/b] Linux | [b]OS Version:[/b] 4.19.150-76.ELK.el7.x86_64 | [b]Technology:[/b] x86_64 | [b]Web Server:[/b] Apache | [b]Encoding:[/b] gzip, deflate | [b]System TMP Writable:[/b] [color=Green]Yes[/color] | [b] Free Disk Space :[/b] 665.73 GiB |

[b]PHP Configuration :: Version:[/b] [b]8.0.28[/b] | [b]PHP API:[/b] [b]cgi-fcgi[/b] | [b]Session Path Writable:[/b] [color=Green]Yes[/color] | [b]Display Errors:[/b] 0 | [b]Error Reporting:[/b] 22519 | [b]Log Errors To:[/b] error_log | [b]Last Known Error:[/b] 15th October 2022 14:42:19. | [b]Register Globals:[/b] | [b]Magic Quotes:[/b] | [b]Safe Mode:[/b] | [b]Allow url fopen:[/b] 1 | [b]Open Base:[/b] | [b]Uploads:[/b] 1 | [b]Max. Upload Size:[/b] 512M | [b]Max. POST Size:[/b] 516M | [b]Max. Input Time:[/b] 60 | [b]Max. Execution Time:[/b] 30 | [b]Memory Limit:[/b] 256M

[b]Database Configuration :: [/b] [b]Version:[/b] [b]5.7.23-23[/b] (Client:mysqlnd 8.0.28) | [b]Database Size:[/b] 21.91 MiB | [b]#of Tables with config prefix: [/b] 117 | [b]#of other Tables: [/b] 0 | [b]User Privileges : [/b]GRANT ALL[/size][/quote][quote="Detailed Environment ::"][size=85][b]PHP Extensions :: [/b]Core (8.0.28) | date (8.0.28) | [color=Green][b]libxml[/b][/color] (8.0.28) | [color=Green][b]openssl[/b][/color] (8.0.28) | pcre (8.0.28) | [color=Green][b]zlib[/b][/color] (8.0.28) | filter (8.0.28) | hash (8.0.28) | json (8.0.28) | pcntl (8.0.28) | readline (8.0.28) | Reflection (8.0.28) | SPL (8.0.28) | session (8.0.28) | standard (8.0.28) | [color=Green][b]cgi-fcgi[/b][/color] (8.0.28) | bcmath (8.0.28) | bz2 (8.0.28) | calendar (8.0.28) | ctype (8.0.28) | [color=Green][b]curl[/b][/color] (8.0.28) | dom (20031129) | [color=Green][b]mbstring[/b][/color] (8.0.28) | [color=Green][b]fileinfo[/b][/color] (8.0.28) | ftp (8.0.28) | [color=Green][b]gd[/b][/color] (8.0.28) | gettext (8.0.28) | gmp (8.0.28) | [color=Green][b]iconv[/b][/color] (8.0.28) | imap (8.0.28) | intl (8.0.28) | exif (8.0.28) | mysqlnd (mysqlnd 8.0.28) | odbc (8.0.28) | PDO (8.0.28) | pgsql (8.0.28) | Phar (8.0.28) | posix (8.0.28) | pspell (8.0.28) | SimpleXML (8.0.28) | soap (8.0.28) | sockets (8.0.28) | sodium (8.0.28) | sqlite3 (8.0.28) | tidy (8.0.28) | tokenizer (8.0.28) | [color=Green][b]xml[/b][/color] (8.0.28) | xmlwriter (8.0.28) | xsl (8.0.28) | [color=Green][b]zip[/b][/color] (1.19.5) | [color=Green][b]mysqli[/b][/color] (8.0.28) | [color=Green][b]pdo_mysql[/b][/color] (8.0.28) | PDO_ODBC (8.0.28) | pdo_pgsql (8.0.28) | pdo_sqlite (8.0.28) | xmlreader (8.0.28) | imagick (3.5.0) | SourceGuardian (14.0.2) | Zend Engine (4.0.28) | [b]Potential Missing Extensions :: [/b]

[b]Switch User Environment :: PHP CGI:[/b] Yes | [b]Server SU:[/b] Yes | [b]PHP SU:[/b] Yes | [b]Potential Ownership Issues:[/b] [color=Green]No[/color] [/size][/quote][quote="Folder Permissions ::"][size=85][b]Core Folders :: [/b]images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) | [/size][/quote][quote="Extensions Discovered ::"][size=85]

[b]Plugins :: [/b] [b]3rd Party:: [/b][color=Brown]Hikashop Google Analytics Plugin (4.6.2) ? | PLG_SEXYPOLLING_NAME (4.1.7) 1 | Hikashop Geolocation Plugin (4.6.2) ? | User - HikaShop (4.6.2) ? | HikaShop Payment Notification plugi (4.6.2) ? | System - HikaShop Mass Action (4.6.2) ? | Hikashop Product Tag (4.6.2) ? | plg_system_jce (2.9.36) 1 | Hikashop - VirtueMart Fallback Redi (4.6.2) ? | System - HikaShop Affiliate (4.6.2) ? | HikaShop Google Dynamic Remarketing (4.6.2) ? | Hikashop - Redshop Fallback Redirec (4.6.2) ? | System - Hikashop Social Plugin (4.6.2) ? | HikaShop Product TAG translation (4.6.2) ? | Hikashop - Mijoshop Fallback Redire (4.6.2) ? | Hikashop no SSL outside checkout Pl (4.6.2) ? | HikaShopCustom Price plugin (4.6.2) ? | Hikashop Registration Redirect Plug (4.6.2) ? | plg_extension_jce (2.9.36) 1 | Hikashop UserPoints Payment Plugin (4.6.2) ? | Hikashop Borgun payment plugin (4.6.2) ? | Hikashop Virtual Merchant (Elavon) (4.6.2) ? | Hikashop Purchase Order Payment Plu (4.6.2) ? | Hikashop Collect On Delivery Paymen (4.6.2) ? | Hikashop Paypal Website Payments Pr (4.6.2) ? | Hikashop WorldNetTPS Payment Plugin (4.6.2) ? | Hikashop Paypal Express Checkout Pa (4.6.2) ? | Hikashop eWAY Payment Plugin (4.6.2) ? | Hikashop ePay Payment Plugin (4.6.2) ? | Hikashop Paypal Advanced payment pl (4.6.2) ? | Hikashop Western Union Payment Plug (4.6.2) ? | Hikashop iPayDNA Payment Plugin (4.6.2) ? | Hikashop Payment Express Payment Pl (4.6.2) ? | Hikashop Moneybookers Payment Plugi (4.6.2) ? | Hikashop Credit Card Payment Plugin (4.6.2) ? | Hikashop Paypal Payment Plugin (4.6.2) ? | Hikashop westpacapi Payment Plugin (1.0) ? | Hikashop Paygate Payment Plugin (4.6.2) ? | Hikashop eSelect Payment Plugin (4.6.2) ? | Hikashop MasterCard Internet Gatewa (4.6.2) ? | Hikashop Nets NETAXEPT Payment Plug (4.6.2) ? | Hikashop Beanstream Payment Plugin (4.6.2) ? | Hikashop ATOS SIPS 2.0 Payment Plug (4.6.2) ? | Hikashop CardSave Payment Plugin (4.6.2) ? | Hikashop Common Joomla Payment API (4.6.2) ? | Hikashop Payza Payment Plugin (4.6.2) ? | Hikashop Bluepaid Payment Plugin (4.6.2) ? | Hikashop HSBC Payment Plugin (4.6.2) ? | Hikashop PayU India Payment Plugin (4.6.2) ? | Hikashop CyberMuth CIC Payment Plug (4.6.2) ? | Ogone Payment Plugin (4.6.2) ? | Hikashop Postfinance Payment Plugin (4.6.2) ? | Hikashop Alipay Payment Plugin (4.6.2) ? | Hikashop Bank Transfer Payment Plug (4.6.2) ? | Hikashop Servired Payment Plugin (4.6.2) ? | Hikashop PayJunction Payment Plugin (4.6.2) ? | Hikashop PayPlug v2 payment plugin (4.6.2) ? | Hikashop Paybox Plugin (4.6.2) ? | Hikashop Paypal Pro Payment Plugin (4.6.2) ? | Hikashop Authorize.net Payment Plug (4.6.2) ? | Hikashop PaymentExpress (PxPay) Plu (4.6.2) ? | Hikashop Be2Bill Payment Plugin (4.6.2) ? | Hikashop Monetico Payment Plugin (4.6.2) ? | Hikashop Paypal Checkout Payment Pl (4.6.2) ? | Hikashop Check Payment Plugin (4.6.2) ? | Hikashop PayPlug payment plugin (4.6.2) ? | Hikashop FirstData Payment Plugin (4.6.2) ? | Hikashop SIPS ATOS Payment Plugin (4.6.2) ? | Hikashop iVeri Payment Plugin (4.6.2) ? | plg_editors_jce (2.9.36) 1 | plg_editors_codemirror (5.65.12) 1 | plg_editors_tinymce (5.10.7) 1 | plg_quickicon_jce (2.9.36) 1 | HikaShop Quick Icon (4.6.2) ? | Editor Button Addon for RC Justifie (5.2.3) ? | HikaShop Product TAG insertion (4.6.2) ? | Search - Hikashop Categories/Manufa (4.6.2) ? | Search - Hikashop Products (4.6.2) ? | plg_fields_mediajce (2.9.36) 1 | AcyMailing Tag : HikaShop content (4.6.2) ? | Hikashop UserPoints Plugin (4.6.2) ? | Hikashop Orders Automatic Cancel Pl (4.6.2) ? | Hikashop - Kashflow invoice synchro (4.6.2) ? | Hikashop Google Products Plugin (4.6.2) 1 | HikaShop Shipping Manual - Price pe (4.6.2) ? | Hikashop WaitList notification Plug (4.6.2) ? | Hikashop out of order notification (4.6.2) ? | Hikashop TaxCloud Plugin (1.2.3) 0 | Hikashop Shop Close Hours Plugin (4.6.2) ? | HikaShop: Date Picker Custom Field (4.6.2) ? | Hikashop - Product Cron Update (4.6.2) ? | Hikashop User account Plugin (4.6.2) ? | Hikashop Group Plugin (4.6.2) ? | Hikashop Massaction Category Plugin (4.6.2) 1 | Hikashop Email History Plugin (4.6.2) 1 | Hikashop Validate free order Plugin (4.6.2) ? | Hikashop Massaction User Plugin (4.6.2) 1 | Hikashop Currency Rates Plugin (4.6.2) ? | Hikashop Massaction Address Plugin (4.6.2) 1 | Hikashop AcyMailing Plugin (4.6.2) ? | Hikashop History Plugin (4.6.2) ? | Hikashop Content Parser - Markdown (4.6.2) ? | Hikashop Massaction Product Plugin (4.6.2) 1 | Hikashop Massaction Order Plugin (4.6.2) 1 | Hikashop Cart notification Plugin (4.6.2) ? | Hikashop Manual Shipping Plugin (4.6.2) ? | Hikashop FedEx Shipping Plugin (4.6.2) ? | Hikashop Australia Post eDeliver Sh (4.6.2) ? | Hikashop USPS Shipping Plugin (4.6.2) ? | Hikashop UPS Shipping Plugin (4.6.2) ? | Hikashop CANPAR Shipping Plugin (1.0.0) ? | plg_installer_jce (2.9.36) 1 | Smart Search - HikaShop Products (4.6.2) 1 | PLG_CONTENT_TTMENUSTYLE (1.0.0) 1 | RC Gallery Layouts (1.1.1) 1 | plg_content_jce (2.9.36) 1 | RC Gallery (4.5.6) 1 | [/color][/size][/quote][quote="Templates Discovered ::"][size=85][b]Templates :: Site :: [/b][color=Brown]CLANSorg (1.0)[/color] 1 | [b]Templates :: Admin :: [/b][/size][/quote][/quote]

MacNaught0n commented 1 year ago

Just realized I missed one of the screen shots

Mac

From: Jefferson49 @.> Sent: Sunday, April 23, 2023 17:03 To: Jefferson49/Joomla_plugin_sexypolling_reloaded @.> Cc: MacNaught0n @.>; Author @.> Subject: Re: [Jefferson49/Joomla_plugin_sexypolling_reloaded] Error installing component (Issue #46)

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

Additional questions:

— Reply to this email directly, view it on GitHub https://github.com/Jefferson49/Joomla_plugin_sexypolling_reloaded/issues/46#issuecomment-1519167551 , or unsubscribe https://github.com/notifications/unsubscribe-auth/A3TZQABXJQ6VO4LGAJFV2IDXCWKJHANCNFSM6AAAAAAXIWADXU . You are receiving this because you authored the thread. https://github.com/notifications/beacon/A3TZQAEFJXGMWJYEY77MV2DXCWKJHA5CNFSM6AAAAAAXIWADXWWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTS2RSUD6.gif Message ID: @. @.> >

-- This email has been checked for viruses by AVG antivirus software. www.avg.com

Jefferson49 commented 1 year ago

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:

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:

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.

Gimopa commented 11 months ago

it is not possible to install plugin on joomla 4.3.4

image

image

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 11 months ago

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

Gimopa commented 11 months ago

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?

Jefferson49 commented 11 months ago

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?

Gimopa commented 11 months ago

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

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 11 months ago

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.

Gimopa commented 11 months ago

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

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 11 months ago

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

Gimopa commented 11 months ago

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

Gimopa commented 11 months ago

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

Jefferson49 commented 11 months ago

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?

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 11 months ago

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.

Jefferson49 commented 10 months ago

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.

Jefferson49 commented 10 months ago

Hopefully fixed with v5.0.0