Report - PayGreen WooCommerce 4.1.2

Does PayGreen WooCommerce work with WordPress 5.7.1 and PHP 7.4.8? A smoke test was performed on 2021-04-18 13:08:48 UTC.

Summary

Errors

	The plugin could not be activated
3	PHP fatal errors
3	Database errors
3	Unrecognized messages in the PHP error log
	No JavaScript exceptions
	No resource errors

Performance

No data available.

Environment

WordPress version	5.7.1
PHP version	7.4.8
MySQL version	8.0.21
PHP memory limit	256M

Plugin Info

Last updated	2023-02-10T14:18:00+00:00
Active installs	500+
WordPress.org page	https://wordpress.org/plugins/paygreen-woocommerce/
Badges	Get badge code

Pages 1

Plugins ‹ Test site — WordPress

URL	/wp-admin/plugins.php?plugin=paygreen-woocommerce%2Fpaygreen-woocommerce.php
Requested URL	/wp-admin/plugins.php?action=activate&plugin=paygreen-woocommerce%2Fpaygreen-woocommerce.php&plugin_status=all&paged=1&s&_wpnonce=6cc450805a
Aspect	after-activation
HTTP status	200
Load time	0.422 s
Memory usage	2.71 MiB
JS errors	None
Resource errors	None

Benchmark

No benchmark data available.

Code Statistics

Note: Third-party libraries and minified JS/CSS files are excluded from these statistics where possible, so the numbers you see here may be lower than those reported by other tools.

PHP

Language		%	Lines of code	Comment lines	Files
	PHP	92.5%	54,883	36,493	775
	JSON	6.5%	3,833	0	202
	SQL	0.5%	292	0	19
	JavaScript	0.2%	142	284	8
	SVG	0.2%	111	0	2
	Markdown	0.1%	57	0	2
	CSS	0.0%	2	38	2
Total			59,320	36,815	1,010

PHP Code Analysis | More results »

Lines of code	40,711
Total complexity	8,228
Median class complexity	5.0
Median method complexity	1.0
Most complex class	Smarty_Internal_Templateparser
Most complex function	smarty_function_html_select_time()

Classes	647
Methods	2,956
Functions	59

Additions

No data available.

PHP Error Log 87 lines

[18-Apr-2021 13:09:03 UTC] WordPress database error BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value for query CREATE TABLE `wp_paygreen_buttons`
(
  `id`               INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `paymentType`      VARCHAR(50)               DEFAULT 'CB',
  `image`            VARCHAR(250)              DEFAULT NULL,
  `height`           INT              NULL,
  `position`         INT              NULL     DEFAULT 1,
  `displayType`      VARCHAR(10)      NOT NULL DEFAULT 'DEFAULT',
  `integration`      VARCHAR(10)      NOT NULL DEFAULT 'EXTERNAL',
  `paymentNumber`    INT(5) UNSIGNED  NOT NULL DEFAULT 1,
  `firstPaymentPart` INT(5) UNSIGNED           DEFAULT NULL,
  `orderRepeated`    INT(1) UNSIGNED           DEFAULT 0,
  `discount`         INT(11) UNSIGNED NOT NULL DEFAULT 0,
  `minAmount`        DECIMAL(10, 2)   NULL,
  `maxAmount`        DECIMAL(10, 2)   NULL,
  `filtered_category_mode` VARCHAR(10) DEFAULT 'NONE',
  `filtered_category_primaries` TEXT DEFAULT 'a:0:{}',
  `paymentMode`      VARCHAR(10)      NOT NULL DEFAULT 'CASH',
  `paymentReport`    VARCHAR(15)               DEFAULT NULL,
  `id_shop`          int(11)              UNSIGNED NOT NULL
) ENGINE = `InnoDB`
  DEFAULT CHARSET = `utf8` made by activate_plugin, include_once('/plugins/paygreen-woocommerce/paygreen-woocommerce.php'), require_once('/plugins/paygreen-woocommerce/bootstrap.php'), PGSystemBootstrap->setup, PGModuleServicesHandlersSetup->run, PGModuleServicesHandlersSetup->runInstall, PGModuleServicesHandlersSetup->install, PGModuleServicesHandlersSetup->fire, PGModuleServicesBroadcaster->fire, PGModuleServicesBroadcaster->callListener, PGWooPaymentServicesListenersSetupDatabase->install, PGDatabaseServicesDatabaseHandler->runScript, PGDatabaseServicesDatabaseHandler->execute, PGWordPressServicesOfficersDatabase->execute
[18-Apr-2021 13:09:03 UTC] Error during Paygreen module execution (/wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php#92) : An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value
[18-Apr-2021 13:09:03 UTC] PHP Fatal error:  Uncaught Exception: An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php:92
Stack trace:
#0 /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php(37): PGWordPressServicesOfficersDatabase->verifyErrors()
#1 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(147): PGWordPressServicesOfficersDatabase->execute()
#2 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(70): PGDatabaseServicesDatabaseHandler->execute()
#3 /wp-content/plugins/paygreen-woocommerce/bundles/PGWooPayment/Services/Listeners/SetupDatabase.php(47): PGDatabaseServicesDatabaseHandler-> in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php on line 92
[18-Apr-2021 13:09:03 UTC] WordPress database error BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value for query CREATE TABLE `wp_paygreen_buttons`
(
  `id`               INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `paymentType`      VARCHAR(50)               DEFAULT 'CB',
  `image`            VARCHAR(250)              DEFAULT NULL,
  `height`           INT              NULL,
  `position`         INT              NULL     DEFAULT 1,
  `displayType`      VARCHAR(10)      NOT NULL DEFAULT 'DEFAULT',
  `integration`      VARCHAR(10)      NOT NULL DEFAULT 'EXTERNAL',
  `paymentNumber`    INT(5) UNSIGNED  NOT NULL DEFAULT 1,
  `firstPaymentPart` INT(5) UNSIGNED           DEFAULT NULL,
  `orderRepeated`    INT(1) UNSIGNED           DEFAULT 0,
  `discount`         INT(11) UNSIGNED NOT NULL DEFAULT 0,
  `minAmount`        DECIMAL(10, 2)   NULL,
  `maxAmount`        DECIMAL(10, 2)   NULL,
  `filtered_category_mode` VARCHAR(10) DEFAULT 'NONE',
  `filtered_category_primaries` TEXT DEFAULT 'a:0:{}',
  `paymentMode`      VARCHAR(10)      NOT NULL DEFAULT 'CASH',
  `paymentReport`    VARCHAR(15)               DEFAULT NULL,
  `id_shop`          int(11)              UNSIGNED NOT NULL
) ENGINE = `InnoDB`
  DEFAULT CHARSET = `utf8` made by plugin_sandbox_scrape, include('/plugins/paygreen-woocommerce/paygreen-woocommerce.php'), require_once('/plugins/paygreen-woocommerce/bootstrap.php'), PGSystemBootstrap->setup, PGModuleServicesHandlersSetup->run, PGModuleServicesHandlersSetup->runInstall, PGModuleServicesHandlersSetup->install, PGModuleServicesHandlersSetup->fire, PGModuleServicesBroadcaster->fire, PGModuleServicesBroadcaster->callListener, PGWooPaymentServicesListenersSetupDatabase->install, PGDatabaseServicesDatabaseHandler->runScript, PGDatabaseServicesDatabaseHandler->execute, PGWordPressServicesOfficersDatabase->execute
[18-Apr-2021 13:09:03 UTC] Error during Paygreen module execution (/wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php#92) : An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value
[18-Apr-2021 13:09:03 UTC] PHP Fatal error:  Uncaught Exception: An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php:92
Stack trace:
#0 /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php(37): PGWordPressServicesOfficersDatabase->verifyErrors()
#1 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(147): PGWordPressServicesOfficersDatabase->execute()
#2 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(70): PGDatabaseServicesDatabaseHandler->execute()
#3 /wp-content/plugins/paygreen-woocommerce/bundles/PGWooPayment/Services/Listeners/SetupDatabase.php(47): PGDatabaseServicesDatabaseHandler-> in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php on line 92
[18-Apr-2021 13:09:04 UTC] WordPress database error BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value for query CREATE TABLE `wp_paygreen_buttons`
(
  `id`               INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `paymentType`      VARCHAR(50)               DEFAULT 'CB',
  `image`            VARCHAR(250)              DEFAULT NULL,
  `height`           INT              NULL,
  `position`         INT              NULL     DEFAULT 1,
  `displayType`      VARCHAR(10)      NOT NULL DEFAULT 'DEFAULT',
  `integration`      VARCHAR(10)      NOT NULL DEFAULT 'EXTERNAL',
  `paymentNumber`    INT(5) UNSIGNED  NOT NULL DEFAULT 1,
  `firstPaymentPart` INT(5) UNSIGNED           DEFAULT NULL,
  `orderRepeated`    INT(1) UNSIGNED           DEFAULT 0,
  `discount`         INT(11) UNSIGNED NOT NULL DEFAULT 0,
  `minAmount`        DECIMAL(10, 2)   NULL,
  `maxAmount`        DECIMAL(10, 2)   NULL,
  `filtered_category_mode` VARCHAR(10) DEFAULT 'NONE',
  `filtered_category_primaries` TEXT DEFAULT 'a:0:{}',
  `paymentMode`      VARCHAR(10)      NOT NULL DEFAULT 'CASH',
  `paymentReport`    VARCHAR(15)               DEFAULT NULL,
  `id_shop`          int(11)              UNSIGNED NOT NULL
) ENGINE = `InnoDB`
  DEFAULT CHARSET = `utf8` made by plugin_sandbox_scrape, include('/plugins/paygreen-woocommerce/paygreen-woocommerce.php'), require_once('/plugins/paygreen-woocommerce/bootstrap.php'), PGSystemBootstrap->setup, PGModuleServicesHandlersSetup->run, PGModuleServicesHandlersSetup->runInstall, PGModuleServicesHandlersSetup->install, PGModuleServicesHandlersSetup->fire, PGModuleServicesBroadcaster->fire, PGModuleServicesBroadcaster->callListener, PGWooPaymentServicesListenersSetupDatabase->install, PGDatabaseServicesDatabaseHandler->runScript, PGDatabaseServicesDatabaseHandler->execute, PGWordPressServicesOfficersDatabase->execute
[18-Apr-2021 13:09:04 UTC] Error during Paygreen module execution (/wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php#92) : An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value
[18-Apr-2021 13:09:04 UTC] PHP Fatal error:  Uncaught Exception: An error occurred during execute sql statement : BLOB, TEXT, GEOMETRY or JSON column 'filtered_category_primaries' can't have a default value in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php:92
Stack trace:
#0 /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php(37): PGWordPressServicesOfficersDatabase->verifyErrors()
#1 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(147): PGWordPressServicesOfficersDatabase->execute()
#2 /wp-content/plugins/paygreen-woocommerce/bundles/PGDatabase/Services/DatabaseHandler.php(70): PGDatabaseServicesDatabaseHandler->execute()
#3 /wp-content/plugins/paygreen-woocommerce/bundles/PGWooPayment/Services/Listeners/SetupDatabase.php(47): PGDatabaseServicesDatabaseHandler-> in /wp-content/plugins/paygreen-woocommerce/bundles/PGWordPress/Services/Officers/Database.php on line 92