Sequential ordering donations sometimes fail

Glad you reached out here.

I have not seen that before. I have only come across 2 cases where the sequential order would jump up and we were never able to pinpoint the issue as it happened intermittently.

The sequential number is programmed to go up 1 from the last donation number so it’s exceedingly odd for it to jump like that and lose the prefix.

When Sequential Ordering is disabled, GiveWP uses the next post ID available in the wp_post table to create the donation ID. That table is populated by pretty much all post types in WordPress (posts, pages, attachments, GiveWP payments, GiveWP forms, etc).

My guess is that somehow, for some reason, Sequential Ordering became disabled, this would explain not only why the donation lost the prefix but also the huge difference in the donation number.

That said, what you’re experiencing is not normal behavior. Either your database is corrupt or some third-party code is messing with the post ID numbers.

There are a couple of database commands that can be run to check for database corruption checks and repairs.

The WP-Optimize plugin has a simple interface for checking corruption and runs some basic repairs too. I highly suggest you only perform database tweaks on a staging site first.

If the issue is due to a plugin/theme conflict that might be easier to identify simply by deactivating all plugins and switching to a default theme, then running several test donations until the issue pops up again.

If you can provide a way to reliably replicate this I’ll be happy to test further but without being able to replicate this reliably I’m relatively stuck.