1. Home
  2. SEMA API
  3. 4.07

SEMA API 4.07

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

Summary

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

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

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

Environment
WordPress version6.0.1
PHP version7.4.8
MySQL version8.0.21
PHP memory limit256M
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=ac5f6d5c36
Aspect after-activation
HTTP status 200
Load time 1.406 s
Memory usage 3.75 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.763 s
Memory usage 3.71 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.875 s
Memory usage 3.81 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 1.098 s
Memory usage 3.71 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 1.086 s
Memory usage 3.71 MiB
JS errors None
Resource errors None

Benchmark

URL Load time Memory usage
Inactive Active Change Inactive Active Change
/wp-admin/index.php0.322 s1.259 s+0.937 s3.72 MiB3.78 MiB+ 55.66 KiB
/wp-admin/edit.php0.175 s0.899 s+0.724 s3.75 MiB3.81 MiB+ 53.54 KiB
/wp-admin/post-new.php0.748 s1.778 s+1.030 s5.54 MiB5.6 MiB+ 55.21 KiB
/wp-admin/upload.php0.357 s3.247 s+2.890 s3.68 MiB3.74 MiB+ 53.48 KiB
/wp-admin/options-writing.php0.149 s1.019 s+0.870 s3.62 MiB3.71 MiB+ 100.43 KiB
/wp-admin/media-new.php0.417 s0.802 s+0.385 s3.66 MiB3.72 MiB+ 58.01 KiB
/wp-admin/edit-tags.php?taxonomy=category0.234 s0.828 s+0.594 s3.69 MiB3.74 MiB+ 57.98 KiB
/wp-admin/post-new.php?post_type=page0.826 s1.322 s+0.496 s5.54 MiB5.59 MiB+ 55.21 KiB
/wp-admin/options-discussion.php0.217 s3.033 s+2.816 s3.6 MiB3.71 MiB+ 121.29 KiB
/wp-admin/edit-comments.php0.217 s0.937 s+0.720 s3.69 MiB3.75 MiB+ 56.08 KiB
/0.283 s0.535 s+0.252 s3.6 MiB3.71 MiB+ 107.41 KiB
Average 0.359 s1.424 s+1.065 s4.01 MiB4.08 MiB+ 70.39 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.8%18,0094,8505
PHP18.5%4,9811,14511
CSS14.8%3,9861389
Total 26,976 6,133 25

PHP Code Analysis | More results »

Lines of code 3,953
Total complexity 799
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 28

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 2236 lines

[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: sema_token in /wp-content/plugins/sema-api/sema-api.php on line 778
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: sema_aaia in /wp-content/plugins/sema-api/sema-api.php on line 779
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:50 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:50 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
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:51 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
[19-Jul-2022 23:03:51 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
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:51 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
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:51 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:51 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
[19-Jul-2022 23:03:51 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
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:52 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
[19-Jul-2022 23:03:52 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
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:52 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
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_type in /wp-admin/includes/upgrade.php on line 2879
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_name in /wp-admin/includes/upgrade.php on line 2885
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: index_columns in /wp-admin/includes/upgrade.php on line 2888
[19-Jul-2022 23:03:52 UTC] PHP Notice:  Undefined index: column_name in /wp-admin/includes/upgrade.php on line 2917
[19-Jul-2022 23:03:52 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
[19-Jul-2022 23:03:52 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)
See also: All tests for this plugin, How to Hide SEMA API Admin Menus