Report - Enterprise Shipping for Pitney Bowes 3.1.0

Does "Enterprise Shipping for Pitney Bowes" work with WordPress 6.0 and PHP 7.4.8? A smoke test was performed on 2022-07-01 23:10:39 UTC.

Summary

Errors

1	PHP notices
1	Database errors
	No JavaScript exceptions
	All test pages loaded successfully
	No resource errors

Performance

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

Page speed impact: insignificant.
The plugin didn't make the site noticeably slower.

Environment

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

Plugin Info

Last updated	2024-04-21T15:58:00+00:00
Active installs	<10
WordPress.org page	https://wordpress.org/plugins/pb-shipping/
Badges	Get badge code

Pages 3

Plugins ‹ Test site — WordPress

URL	/wp-admin/plugins.php?plugin_status=all&paged=1&s
Requested URL	/wp-admin/plugins.php?action=activate&plugin=pb-shipping%2Fpb_functions.php&plugin_status=all&paged=1&s&_wpnonce=f471864faa
Aspect	after-activation
HTTP status	200
Load time	0.292 s
Memory usage	3.94 MiB
JS errors	None
Resource errors	None

Settings → PB Ship Admin

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

Test site – Just another WordPress site

URL	/
Aspect	front-page
HTTP status	200
Load time	0.233 s
Memory usage	3.56 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.311 s	0.227 s	-0.084 s	3.72 MiB	3.73 MiB	+ 10.48 KiB
/wp-admin/edit.php	0.183 s	0.183 s	+0.000 s	3.75 MiB	3.76 MiB	+ 10.09 KiB
/wp-admin/post-new.php	0.716 s	0.897 s	+0.181 s	5.53 MiB	5.55 MiB	+ 19.16 KiB
/wp-admin/upload.php	0.636 s	0.330 s	-0.306 s	3.68 MiB	3.69 MiB	+ 9.66 KiB
/wp-admin/options-writing.php	0.241 s	0.145 s	-0.096 s	3.61 MiB	3.63 MiB	+ 17.65 KiB
/wp-admin/media-new.php	0.324 s	0.185 s	-0.139 s	3.66 MiB	3.67 MiB	+ 9.84 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.176 s	0.175 s	-0.001 s	3.68 MiB	3.69 MiB	+ 10.74 KiB
/wp-admin/post-new.php?post_type=page	0.600 s	0.629 s	+0.029 s	5.53 MiB	5.54 MiB	+ 10.74 KiB
/wp-admin/options-discussion.php	0.205 s	0.312 s	+0.107 s	3.59 MiB	3.6 MiB	+ 10.15 KiB
/wp-admin/edit-comments.php	0.201 s	0.222 s	+0.021 s	3.69 MiB	3.7 MiB	+ 9.65 KiB
/	0.285 s	0.216 s	-0.069 s	3.55 MiB	3.56 MiB	+ 16.94 KiB
Average	0.353 s	0.320 s	-0.032 s	4 MiB	4.01 MiB	+ 12.28 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.

PHP

Language		%	Lines of code	Comment lines	Files
	PHP	100.0%	3,180	100	5
Total			3,180	100	5

PHP Code Analysis | More results »

Lines of code	3,276
Total complexity	968
Median class complexity	0.0
Median method complexity	0.0
Most complex class	—
Most complex function	espb_admin()

Classes	0
Methods	0
Functions	65

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.

Options `wp_options` 1

pb_db_version

PHP Error Log 24 lines

[01-Jul-2022 23:10:53 UTC] WordPress database error Table 'wordpress.wp_d59z13rzdw_posts' doesn't exist for query 
    SELECT o.ID order_id
    ,m.meta_id
    ,DATE_FORMAT(s.meta_value,'%Y-%m-%d')shipped
    ,d.meta_value delivery_est
    ,IFNULL((SELECT meta_value FROM wp_d59z13rzdw_postmeta WHERE meta_key='_shipping_first_name' AND post_id=o.ID),(SELECT meta_value FROM wp_d59z13rzdw_postmeta WHERE meta_key='_billing_first_name' AND post_id=o.ID))fname
    ,(SELECT 1 FROM wp_d59z13rzdw_postmeta JOIN wp_d59z13rzdw_options ON option_name=CONCAT('sms_sb_',meta_value) WHERE meta_key='_billing_phone' AND post_id=o.ID)subscribe
    ,(SELECT meta_value FROM wp_d59z13rzdw_postmeta LEFT JOIN wp_d59z13rzdw_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_phone' AND post_id=o.ID)phone
    ,(SELECT LOWER(meta_value) FROM wp_d59z13rzdw_postmeta LEFT JOIN wp_d59z13rzdw_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_email' AND post_id=o.ID)email
    ,m.meta_key label
    ,m.meta_value label_meta
    FROM wp_d59z13rzdw_posts o
    JOIN wp_d59z13rzdw_postmeta s ON s.post_id=o.ID AND s.meta_key='_last_shipped' AND s.meta_value>=NOW()-INTERVAL 20 DAY
    LEFT JOIN wp_d59z13rzdw_postmeta d ON d.post_id=o.ID AND d.meta_key='delivery_est' AND DATE_FORMAT(d.meta_value,'%Y-%m-%d')>DATE_FORMAT(s.meta_value,'%Y-%m-%d')
    JOIN wp_d59z13rzdw_postmeta m ON m.post_id=o.ID AND m.meta_key LIKE '_pb_label_meta%' AND m.meta_value NOT LIKE '%inbound%' AND m.meta_value NOT LIKE '%cancel%' AND m.meta_value NOT LIKE '%returnToSender%' AND m.meta_value NOT LIKE '%delivered,%'
    WHERE o.post_type='shop_order'
    AND (LENGTH('0')>1 OR (d.post_id IS NULL OR DATE_FORMAT(d.meta_value,'%Y-%m-%d') BETWEEN DATE_FORMAT(NOW()-INTERVAL 3 DAY,'%Y-%m-%d') AND DATE_FORMAT(NOW()+INTERVAL 5 DAY,'%Y-%m-%d')))
    AND o.post_status IN ('wc-refunded','wc-completed')
    
    
    ORDER BY m.meta_id DESC
    LIMIT 50;
   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('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, espb_fetch_delivery_status, espb_r
[01-Jul-2022 23:10:54 UTC] PHP Notice:  Undefined variable: user_id in /wp-content/plugins/pb-shipping/pb_admin.php on line 592

Enterprise Shipping for Pitney Bowes 3.1.0