This was indeed a problem but it has been fixed in 5.4.12.
Thanx for the report.
Hello i updated wp photo album to version 5.5.0. and problem is still there with session this is the error from lo. file:
WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_wppa_session (
session,
timestamp,
user,
ip,
status,
data,
count
)
VALUES ( ‘26177898f3ce6e458f94155ec1900546’, ‘1423641948’, ‘admin’, ‘92.223.169.82’, ‘valid’, ”, ‘1’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wppa_session_start, wppa_create_session_entry
Manually inspect the db table wp_wppa_session and make sure the column ‘id’ has the attribute AUTO_INCREMENT
Jacob hi, I have version 6.3.6 installed and I still have the problem. I installed Query Monitor plugin and I can see that the query
UPDATE wp_wppa_session is a slow query. I checked table wp_wppa_session in my database and the “id” column has the attribute AUTO INCREMENT. Any other ideas on how to fix this?
The session table is heavily updated. It contains records that stay one hour active for each user accessing the site, logged in or not.
After 1 hour the record is removed.
This may result in a scattered table after some time.
You may truncate the table manually on the server sql admin ( TRUNCATE TABLE wp_wppa_session ).
This will only affect data like last selection and view count info for the users that currently access the site. No big deal, but it will clean up the table.
Try this, and if it works, i will add this action at plugin update and on the settings page in Table VIII-A1: Setup, so you can do it on a regular basis.
If the disorder of the table is the cause of the issue, you could alternatively install plugin wp-optimize and let it re-organize that plugin all the tables on a regular basis.
