1. Home
2. Activity Log – Monitor & Record User Changes
3. 2.3.4

Activity Log 2.3.4

Does Activity Log work with WordPress 4.8.2 and PHP 7.0.16? A smoke test was performed on 2017-09-20 17:05:31 UTC.

Summary

Pages 4

Plugins ‹ Test site — WordPress

Activity Log

Activity Log → Settings

Test site – Just another WordPress site

Benchmark

URL	Load time			Memory usage
	Inactive	Active	Change	Inactive	Active	Change
/wp-admin/index.php	0.096 s	0.038 s	-0.058 s	2.9 MiB	3.09 MiB	+ 194.16 KiB
/wp-admin/edit.php	0.095 s	0.107 s	+0.012 s	2.91 MiB	3.11 MiB	+ 201.6 KiB
/wp-admin/post-new.php	0.151 s	0.063 s	-0.088 s	2.99 MiB	3.18 MiB	+ 200.12 KiB
/wp-admin/upload.php	0.073 s	0.107 s	+0.034 s	2.82 MiB	2.94 MiB	+ 129.2 KiB
/wp-admin/options-writing.php	0.063 s	0.078 s	+0.015 s	2.81 MiB	2.93 MiB	+ 128.84 KiB
/wp-admin/media-new.php	0.039 s	0.064 s	+0.025 s	2.8 MiB	2.93 MiB	+ 129.2 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.067 s	0.086 s	+0.019 s	2.84 MiB	3.03 MiB	+ 192.89 KiB
/wp-admin/post-new.php?post_type=page	0.055 s	0.173 s	+0.118 s	2.98 MiB	3.16 MiB	+ 192.89 KiB
/wp-admin/options-discussion.php	0.079 s	0.092 s	+0.013 s	2.8 MiB	2.93 MiB	+ 129.47 KiB
/wp-admin/edit-comments.php	0.072 s	0.089 s	+0.017 s	2.84 MiB	3.03 MiB	+ 192.93 KiB
/	0.064 s	0.062 s	-0.002 s	2.59 MiB	2.77 MiB	+ 178.22 KiB
Average	0.078 s	0.087 s	+0.010 s	2.84 MiB	3.01 MiB	+ 169.96 KiB

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 1

• wp_aryo_activity_log

Options wp_options 2

• activity_log_db_version
• activity-log-settings

Capabilities 1

• view_all_aryo_activity_log

PHP Error Log 60 lines

[20-Sep-2017 17:05:37 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 '%1$s
					WHERE `user_caps` = '%2$s'
						AND `action` = '%3$s'
						AND `obje' at line 1 for query SELECT `histid` FROM %1$s
					WHERE `user_caps` = '%2$s'
						AND `action` = '%3$s'
						AND `object_type` = '%4$s'
						AND `object_subtype` = '%5$s'
						AND `object_name` = '%6$s'
						AND `user_id` = '%7$s'
						AND `hist_ip` = '%8$s'
						AND `hist_time` = '%9$s'
				; made by activate_plugin, do_action('activated_plugin'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Hook_Plugins->hooks_activated_plugin, AAL_Hook_Plugins->_add_log_plugin, aal_insert_log, AAL_API->insert
[20-Sep-2017 17:05:37 UTC] WordPress database error Table 'wordpress.%1$s' doesn't exist for query SELECT COUNT(`histid`) FROM `%1$s`
				 WHERE 1=1
					AND (`object_type` = 'Core' OR `object_type` = 'Export' OR `object_type` = 'Post' OR `object_type` = 'Taxonomy' OR `object_type` = 'User' OR `object_type` = 'Options' OR `object_type` = 'Attachment' OR `object_type` = 'Plugin' OR `object_type` = 'Widget' OR `object_type` = 'Theme' OR `object_type` = 'Menu' OR `object_type` = 'Comments') AND (`user_caps` = 'administrator' OR `user_caps` = 'editor' OR `user_caps` = 'author' OR `user_caps` = 'guest') made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Admin_Ui->activity_log_page_func, AAL_Activity_Log_List_Table->prepare_items
[20-Sep-2017 17:05:37 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 '%4$d, %5$d' at line 5 for query SELECT * FROM `%1$s`
				 WHERE 1=1
					AND (`object_type` = 'Core' OR `object_type` = 'Export' OR `object_type` = 'Post' OR `object_type` = 'Taxonomy' OR `object_type` = 'User' OR `object_type` = 'Options' OR `object_type` = 'Attachment' OR `object_type` = 'Plugin' OR `object_type` = 'Widget' OR `object_type` = 'Theme' OR `object_type` = 'Menu' OR `object_type` = 'Comments') AND (`user_caps` = 'administrator' OR `user_caps` = 'editor' OR `user_caps` = 'author' OR `user_caps` = 'guest')
					ORDER BY `%2$s` %3$s
					LIMIT %4$d, %5$d; made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Admin_Ui->activity_log_page_func, AAL_Activity_Log_List_Table->prepare_items
[20-Sep-2017 17:05:37 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 '%1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type' at line 1 for query SELECT DISTINCT %1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type` = 'Export' OR `object_type` = 'Post' OR `object_type` = 'Taxonomy' OR `object_type` = 'User' OR `object_type` = 'Options' OR `object_type` = 'Attachment' OR `object_type` = 'Plugin' OR `object_type` = 'Widget' OR `object_type` = 'Theme' OR `object_type` = 'Menu' OR `object_type` = 'Comments') AND (`user_caps` = 'administrator' OR `user_caps` = 'editor' OR `user_caps` = 'author' OR `user_caps` = 'guest')
				GROUP BY `%1$s`
				ORDER BY `%1$s`
			; made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Admin_Ui->activity_log_page_func, WP_List_Table->display, AAL_Activity_Log_List_Table->display_tablenav, AAL_Activity_Log_List_Table->extra_tablenav
[20-Sep-2017 17:05:37 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 '%1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type' at line 1 for query SELECT DISTINCT %1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type` = 'Export' OR `object_type` = 'Post' OR `object_type` = 'Taxonomy' OR `object_type` = 'User' OR `object_type` = 'Options' OR `object_type` = 'Attachment' OR `object_type` = 'Plugin' OR `object_type` = 'Widget' OR `object_type` = 'Theme' OR `object_type` = 'Menu' OR `object_type` = 'Comments') AND (`user_caps` = 'administrator' OR `user_caps` = 'editor' OR `user_caps` = 'author' OR `user_caps` = 'guest')
				GROUP BY `%1$s`
				ORDER BY `%1$s`
			; made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Admin_Ui->activity_log_page_func, WP_List_Table->display, AAL_Activity_Log_List_Table->display_tablenav, AAL_Activity_Log_List_Table->extra_tablenav
[20-Sep-2017 17:05:37 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 '%1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type' at line 1 for query SELECT DISTINCT %1$s FROM `%2$s`
				WHERE 1 = 1
				AND (`object_type` = 'Core' OR `object_type` = 'Export' OR `object_type` = 'Post' OR `object_type` = 'Taxonomy' OR `object_type` = 'User' OR `object_type` = 'Options' OR `object_type` = 'Attachment' OR `object_type` = 'Plugin' OR `object_type` = 'Widget' OR `object_type` = 'Theme' OR `object_type` = 'Menu' OR `object_type` = 'Comments') AND (`user_caps` = 'administrator' OR `user_caps` = 'editor' OR `user_caps` = 'author' OR `user_caps` = 'guest')
				GROUP BY `%1$s`
				ORDER BY `%1$s`
			; made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Admin_Ui->activity_log_page_func, WP_List_Table->display, AAL_Activity_Log_List_Table->display_tablenav, AAL_Activity_Log_List_Table->extra_tablenav
[20-Sep-2017 17:05:42 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 '%1$s
					WHERE `user_caps` = '%2$s'
						AND `action` = '%3$s'
						AND `obje' at line 1 for query SELECT `histid` FROM %1$s
					WHERE `user_caps` = '%2$s'
						AND `action` = '%3$s'
						AND `object_type` = '%4$s'
						AND `object_subtype` = '%5$s'
						AND `object_name` = '%6$s'
						AND `user_id` = '%7$s'
						AND `hist_ip` = '%8$s'
						AND `hist_time` = '%9$s'
				; made by deactivate_plugins, do_action('deactivated_plugin'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Hook_Plugins->hooks_deactivated_plugin, AAL_Hook_Plugins->_add_log_plugin, aal_insert_log, AAL_API->insert
[20-Sep-2017 17:05:42 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 '%2$d' at line 2 for query DELETE FROM `%1$s`
					WHERE `hist_time` < %2$d made by deactivate_plugins, do_action('deactivated_plugin'), WP_Hook->do_action, WP_Hook->apply_filters, AAL_Hook_Plugins->hooks_deactivated_plugin, AAL_Hook_Plugins->_add_log_plugin, aal_insert_log, AAL_API->insert, AAL_API->_delete_old_items

---