SEMA API 4.15

Does SEMA API work with WordPress 6.1.1 and PHP 8.1.12? A smoke test was performed on .

Summary

Errors
1,523PHP warnings
2PHP notices
1,119PHP deprecation warnings
431Database errors
No JavaScript exceptions
2Pages failed to load
  • 2 0
No resource errors
Performance

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

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

Environment
WordPress version6.1.1
PHP version8.1.12
MySQL version10.6.10
PHP memory limit512M
Plugin Info
Last updated
Active installs 20+
WordPress.org page https://wordpress.org/plugins/sema-api/
Badges

WordPress compatibility badge PHP compatibility badge

Get badge code

Pages 7

Plugins ‹ Test site — WordPress

Page screenshot: 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=34641365b3
Aspect after-activation
HTTP status 200
Load time 0.631 s
Memory usage 3.04 MiB
JS errors None
Resource errors None

Settings → SEMA Setting

Page screenshot: Settings → SEMA Setting
URL /wp-admin/options-general.php?page=sema_setting
Aspect menu-item
HTTP status 200
Load time 0.339 s
Memory usage 3.03 MiB
JS errors None
Resource errors None

Settings → SEMA Setting → Fitment

Page screenshot: 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.286 s
Memory usage 3.11 MiB
JS errors None
Resource errors None

Settings → SEMA Setting → Join SEMA Data Co-op

Screenshot not available
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

Page screenshot: Settings → SEMA Import
URL /wp-admin/options-general.php?page=sema_import
Aspect menu-item
HTTP status 200
Load time 0.593 s
Memory usage 3.01 MiB
JS errors None
Resource errors None

Settings → SEMA Import → Join SEMA Data Co-op

Screenshot not available
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

Page screenshot: Test site – Just another WordPress site
URL /
Aspect front-page
HTTP status 200
Load time 0.504 s
Memory usage 3.14 MiB
JS errors None
Resource errors None

Benchmark

URL Load time Memory usage
Inactive Active Change Inactive Active Change
/wp-admin/index.php0.297 s0.753 s+0.456 s3.05 MiB3.1 MiB+ 55.34 KiB
/wp-admin/edit.php0.219 s0.377 s+0.158 s3.07 MiB3.13 MiB+ 54.26 KiB
/wp-admin/post-new.php0.810 s1.191 s+0.381 s4.97 MiB5.02 MiB+ 55.37 KiB
/wp-admin/upload.php0.604 s0.506 s-0.098 s2.99 MiB3.03 MiB+ 40.27 KiB
/wp-admin/options-writing.php0.157 s0.345 s+0.188 s2.99 MiB3.02 MiB+ 29.93 KiB
/wp-admin/media-new.php0.365 s0.698 s+0.333 s2.97 MiB3.02 MiB+ 56.78 KiB
/wp-admin/edit-tags.php?taxonomy=category0.181 s0.376 s+0.195 s2.98 MiB3.04 MiB+ 58.88 KiB
/wp-admin/post-new.php?post_type=page0.693 s0.799 s+0.106 s4.96 MiB5.01 MiB+ 55.38 KiB
/wp-admin/options-discussion.php0.209 s0.483 s+0.274 s2.98 MiB3.02 MiB+ 44.09 KiB
/wp-admin/edit-comments.php0.197 s0.371 s+0.174 s3 MiB3.04 MiB+ 40.57 KiB
/0.306 s0.302 s-0.004 s2.94 MiB3.14 MiB+ 197.06 KiB
Average 0.367 s0.564 s+0.197 s3.35 MiB3.42 MiB+ 62.54 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
JavaScript66.6%18,0094,8505
PHP18.6%5,0321,18211
CSS14.7%3,9861389
Total 27,027 6,170 25

PHP Code Analysis | More results »

Lines of code 4,010
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

Options wp_options 2

PHP Error Log 3175 lines

[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  Automatic conversion of false to array is deprecated in /wp-content/plugins/sema-api/sema-api.php on line 774
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "sema_token" in /wp-content/plugins/sema-api/sema-api.php on line 778
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "sema_aaia" in /wp-content/plugins/sema-api/sema-api.php on line 779
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_type" in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2868
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_name" in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2874
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "index_columns" in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in /wp-admin/includes/upgrade.php on line 2877
[22-Nov-2022 06:49:26 UTC] PHP Warning:  Undefined array key "column_name" in /wp-admin/includes/upgrade.php on line 2908
[22-Nov-2022 06:49:26 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
[22-Nov-2022 06:49:26 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

(+3075 more lines)
See also: All tests for this plugin, How to Hide SEMA API Admin Menus