Database error

Hi @sjogrenco

Thanks for using PublishPress Future.

The reported undefined constant does indeed have a definition; the issue likely arises from its invocation before its declaration or the loading of the file containing it after invocation, resulting in its absence at the time of the call.

The precise trigger for this occurrence remains elusive. Could you please check if there is any pattern on that behavior? Something like:

• Does it occur upon post creation?
• Is it tied to post expiration?
• Could it be linked to scheduled expirations?

Thanks,

I think its linked to scheduled expirations or maybe every time cron is triggered. It seems to occur every 5 min or so and that’s what the task scheduler are set to trigger cron jobs since I’ve disabled that in wp-config.

However in the plugin diagnostics/tools it say “The table _ppfuture_actions_args does not exist” it exclude the table prefix if that matters? it can’t be fixed with the button, but the table DOES exist in the database with a prefix and contains values.

@sjogrenco Are you in a position where you can test by deleting the table?

You can test it in a staging site. Try to delete the table and click the button on diagnostic/tools to add that back.

Thanks,

Yes I’ve got full control over the server and database. I deleted the table and it was recreated without the data, but updating the posts with future exspirations the data was there again so it all works as expected but the plugin still say the table is missing and it still writes a huge amount of errors in the log.

A complete draft from a fresh log below. Look at the time span of the errors. it get’s huge in a short time. Where does the multiple primary keys come from? I’m not a programmer but I can find and correct issues in files if I only know where to look. I have also turned on the debug feature in the plugin to see if it say anything.

[01-Apr-2024 10:25:58 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:27:59 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:28:05 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY 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’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:28:12 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:33:12 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:35:12 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY 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’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:14 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:20 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:29 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:30 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY 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’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:30 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY 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’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:30 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY 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’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:37:32 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:38:13 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:38:33 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:40:34 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta
[01-Apr-2024 10:42:35 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE xxx_postexpirator_debug CHANGE COLUMN id id INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future{closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Core\DI\Container->get, {closure}, PublishPress\Future\Framework\Logger\Logger->__construct, PublishPress\Future\Framework\Logger\Logger->initialize, PublishPress\Future\Framework\Logger\Logger->createDatabaseTable, PublishPress\Future\Framework\WordPress\Facade\DatabaseFacade->modifyStructure, dbDelta

Update: Inactivated all other plugins and cache + security settings on server to test but without any change in the log. Uninstalled the plugin and deleted the related tables from database but still no change after reinstall (maybe I missed some). I installed your plugin on two other sites with the exact same plugins and settings and also server settings without any problems at all, and without errors in the log. I will see if I can wipe out old unused stuff and tables from the db for this site and try again, or else I probably move it to a fresh install. There is nothing wrong with your plugin.

Regards Lennart

@sjogrenco Thanks for your update. That is really helpful information, since we are unable to see this behavior on our environment.

Feel free to let us know if you need any other confirmation from our side.

Thanks,