Report - SEMA API 4.12 - PluginTests.com

Does SEMA API work with WordPress 6.0.2 and PHP 7.4.8? A smoke test was performed on 2022-09-23 18:10:06 UTC.

Summary

Errors

8	PHP warnings
1,657	PHP notices
471	Database errors
	No JavaScript exceptions
2	Pages failed to load 2 0
	No resource errors

Performance

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

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

Environment

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

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=7d0ffb208e
Aspect	after-activation
HTTP status	200
Load time	1.257 s
Memory usage	3.75 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	1.021 s
Memory usage	3.71 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.706 s
Memory usage	3.81 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	1.107 s
Memory usage	3.71 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	1.051 s
Memory usage	3.71 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.341 s	1.231 s	+0.890 s	3.72 MiB	3.78 MiB	+ 56.03 KiB
/wp-admin/edit.php	0.175 s	0.838 s	+0.663 s	3.76 MiB	3.81 MiB	+ 53.91 KiB
/wp-admin/post-new.php	0.733 s	1.741 s	+1.008 s	5.55 MiB	5.6 MiB	+ 55.58 KiB
/wp-admin/upload.php	0.387 s	3.260 s	+2.873 s	3.69 MiB	3.74 MiB	+ 53.88 KiB
/wp-admin/options-writing.php	0.354 s	1.002 s	+0.648 s	3.62 MiB	3.72 MiB	+ 100.8 KiB
/wp-admin/media-new.php	0.268 s	0.741 s	+0.473 s	3.66 MiB	3.72 MiB	+ 58.38 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.191 s	0.767 s	+0.576 s	3.69 MiB	3.75 MiB	+ 58.34 KiB
/wp-admin/post-new.php?post_type=page	0.605 s	1.194 s	+0.589 s	5.54 MiB	5.6 MiB	+ 55.58 KiB
/wp-admin/options-discussion.php	0.216 s	3.095 s	+2.879 s	3.6 MiB	3.72 MiB	+ 121.69 KiB
/wp-admin/edit-comments.php	0.233 s	0.764 s	+0.531 s	3.7 MiB	3.75 MiB	+ 56.45 KiB
/	0.286 s	0.491 s	+0.205 s	3.55 MiB	3.71 MiB	+ 161.87 KiB
Average	0.344 s	1.375 s	+1.030 s	4.01 MiB	4.08 MiB	+ 75.68 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.6%	18,009	4,850	5
	PHP	18.6%	5,032	1,151	11
	CSS	14.7%	3,986	138	9
Total			27,027	6,139	25

PHP Code Analysis | More results »

Lines of code	4,004
Total complexity	813
Median class complexity	34.5
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 2236 lines

[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: sema_token in /wp-content/plugins/sema-api/sema-api.php on line 778
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: sema_aaia in /wp-content/plugins/sema-api/sema-api.php on line 779
[23-Sep-2022 18:10:21 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
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:21 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
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:21 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:21 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:22 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:22 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:22 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:22 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
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:23 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:23 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:23 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[23-Sep-2022 18:10:23 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[23-Sep-2022 18:10:23 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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
[23-Sep-2022 18:10:23 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,

(+2136 more lines)

SEMA API 4.12