Report - SEMA API 4.20 - PluginTests.com

Does SEMA API work with WordPress 6.1.1 and PHP 8.1.12? A smoke test was performed on 2022-12-14 18:23:43 UTC.

Summary

Errors

1,520	PHP warnings
2	PHP notices
1,120	PHP deprecation warnings
431	Database errors
	No JavaScript exceptions
2	Pages failed to load 2 0
	No resource errors

Performance

Memory usage: 62.49 KiB
The average PHP memory usage increased by this amount after activating by the plugin.

Page speed impact: 0.182 seconds
The average page load time increased by this amount after activating the plugin.

Environment

WordPress version	6.1.1
PHP version	8.1.12
MySQL version	10.6.10
PHP memory limit	512M

Plugin Info

Last updated	2025-12-05T17:40:00+00:00
Active installs	20+
WordPress.org page	https://wordpress.org/plugins/sema-api/
Badges	Get badge code

Pages 7

Plugins ‹ Test site — WordPress

URL	/wp-admin/plugins.php?plugin_status=all&paged=1&s
Requested URL	/wp-admin/plugins.php?action=activate&plugin=sema-api%2Fsema-api.php&plugin_status=all&paged=1&s&_wpnonce=5574f9d003
Aspect	after-activation
HTTP status	200
Load time	0.670 s
Memory usage	3.04 MiB
JS errors	None
Resource errors	None

Settings → SEMA Setting

URL	/wp-admin/options-general.php?page=sema_setting
Aspect	menu-item
HTTP status	200
Load time	0.358 s
Memory usage	3.03 MiB
JS errors	None
Resource errors	None

Settings → SEMA Setting → Fitment

URL	/wp-admin/options-general.php?page=sema_import&section=fitment
Aspect	menu-item-tab
HTTP status	200
Load time	0.695 s
Memory usage	3.13 MiB
JS errors	None
Resource errors	None

Settings → SEMA Setting → Join SEMA Data Co-op

URL
Aspect	menu-item-tab
HTTP status	0
Load time	-0.001 s
Memory usage	N/A
JS errors	None
Resource errors	None

Settings → SEMA Import

URL	/wp-admin/options-general.php?page=sema_import
Aspect	menu-item
HTTP status	200
Load time	0.595 s
Memory usage	3.01 MiB
JS errors	None
Resource errors	None

Settings → SEMA Import → Join SEMA Data Co-op

URL
Aspect	menu-item-tab
HTTP status	0
Load time	-0.001 s
Memory usage	N/A
JS errors	None
Resource errors	None

Test site – Just another WordPress site

URL	/
Aspect	front-page
HTTP status	200
Load time	0.509 s
Memory usage	3.14 MiB
JS errors	None
Resource errors	None

Benchmark

URL	Load time			Memory usage
URL	Inactive	Active	Change	Inactive	Active	Change
/wp-admin/index.php	0.285 s	0.683 s	+0.398 s	3.05 MiB	3.1 MiB	+ 55.29 KiB
/wp-admin/edit.php	0.183 s	0.363 s	+0.180 s	3.07 MiB	3.13 MiB	+ 54.21 KiB
/wp-admin/post-new.php	0.766 s	1.146 s	+0.380 s	4.97 MiB	5.02 MiB	+ 55.32 KiB
/wp-admin/upload.php	0.551 s	0.478 s	-0.073 s	2.99 MiB	3.03 MiB	+ 40.23 KiB
/wp-admin/options-writing.php	0.171 s	0.336 s	+0.165 s	2.99 MiB	3.02 MiB	+ 29.88 KiB
/wp-admin/media-new.php	0.266 s	0.410 s	+0.144 s	2.97 MiB	3.02 MiB	+ 56.73 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.246 s	0.354 s	+0.108 s	2.98 MiB	3.04 MiB	+ 58.84 KiB
/wp-admin/post-new.php?post_type=page	0.631 s	0.938 s	+0.307 s	4.96 MiB	5.01 MiB	+ 55.33 KiB
/wp-admin/options-discussion.php	0.208 s	0.430 s	+0.222 s	2.97 MiB	3.02 MiB	+ 44.04 KiB
/wp-admin/edit-comments.php	0.213 s	0.361 s	+0.148 s	3 MiB	3.04 MiB	+ 40.52 KiB
/	0.295 s	0.323 s	+0.028 s	2.94 MiB	3.14 MiB	+ 197.02 KiB
Average	0.347 s	0.529 s	+0.182 s	3.35 MiB	3.41 MiB	+ 62.49 KiB

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.

JavaScript

PHP

CSS

Language		%	Lines of code	Comment lines	Files
	JavaScript	66.2%	18,009	4,850	5
	PHP	19.1%	5,186	1,192	11
	CSS	14.7%	4,005	138	9
Total			27,200	6,180	25

PHP Code Analysis | More results »

Lines of code	4,072
Total complexity	822
Median class complexity	34.0
Median method complexity	2.0
Most complex class	SEMA_Product_Import
Most complex function	sema_getdata_callback()

Classes	4
Methods	48
Functions	29

Additions

Things that the plugin adds to the site. This section is not intended to be comprehensive. The test tool only looks for a few specific types of added content.

Database Tables 5

wp_sema_attr_taxonomy
wp_sema_brands
wp_sema_fitment
wp_sema_parts
wp_sema_products

Options `wp_options` 2

sema_plugin_version
sema_settings

PHP Error Log 3173 lines

[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  Automatic conversion of false to array is deprecated in /wp-content/plugins/sema-api/sema-api.php on line 774
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "sema_token" in /wp-content/plugins/sema-api/sema-api.php on line 778
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "sema_aaia" in /wp-content/plugins/sema-api/sema-api.php on line 779
[14-Dec-2022 18:23:58 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by activate_plugin, do_action('activate_sema-api/sema-api.php'), WP_Hook->do_action, WP_Hook->apply_filters, sema_activation, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[14-Dec-2022 18:23:58 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[14-Dec-2022 18:23:58 UTC] WordPress database error 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 '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[14-Dec-2022 18:23:58 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta

(+3073 more lines)

SEMA API 4.20