Title: Database error without image Last modified: January 6, 2020 --- # Database error without image * Resolved [flobogo](https://wordpress.org/support/users/flobogo/) * (@flobogo) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/) * Hello, * I love this plugin that I use for family birthdays, on a private site. * But i have a probleme: I can no longer modify or add events without a picture. Only events with an image are accepted (for addition or modification). When there is no image, I get an error message that indicates a problem with the database: Incorrect integer value. * I didn’t have this problem previously. Updating the plugin hasn’t changed anything! * What do you think about that? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-without-image%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12297838) * Can you provide a screenshot showing the error? * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12297842) * Also, can you try again with all other plugins disabled to rule out a conflict of some sort? * Thread Starter [flobogo](https://wordpress.org/support/users/flobogo/) * (@flobogo) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302249) * Hi, * Thanks for your interest to my problem. * I tried with all plugins disabled (only Akismet was actived) … but the problem is still the same. * Here are 2 screenshots: * [event with or without image](https://nsm09.casimages.com/img/2020/01/07//20010711024225184516592100.jpg) * [error message when saving event without image](https://nsm09.casimages.com/img/2020/01/07//20010711024325184516592101.jpg) * About my configuration: – Version of WordPress : 5.3.2 – Version of PHP/MySQL: 7.1.32 / 5.5.30 * I don’t understand, it worked very well a few months ago. * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302257) * Can you create a new event with no image? * Thread Starter [flobogo](https://wordpress.org/support/users/flobogo/) * (@flobogo) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302319) * No, it’s the same bug: I get the same error message. * To be sure, I also tried to create an event with image, and I don’t get error message: the event is well created. And if I try to create again an event without image, I still get the error. * It is really the variable “image” which causes the error, either when creating or modifying an event. - This reply was modified 6 years, 4 months ago by [flobogo](https://wordpress.org/support/users/flobogo/). * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302340) * It seems your DB is not allowing a blank stored image number. This is the first I have heard of this problem, but a fix should be easy enough. * Can you contact me [here ](https://spiffycalendar.spiffyplugins.ca/contact/)so I can arrange to send you a new version to test when it is ready? * [https://spiffycalendar.spiffyplugins.ca/contact/](https://spiffycalendar.spiffyplugins.ca/contact/) - This reply was modified 6 years, 4 months ago by [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/). * Thread Starter [flobogo](https://wordpress.org/support/users/flobogo/) * (@flobogo) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302363) * OK, I sent you a message. * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12302477) * Acutally the fix was quite small so I made a release, 4.4.1. Please let me know if this fixes your issue. * Plugin Author [Spiffy Plugins](https://wordpress.org/support/users/spiffyplugins/) * (@spiffyplugins) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12304668) * Just a correction to my previous comment. * On my system a blank image id is converted to zero when saving the event into the DB. On your system it throws an error instead. I have now changed it to specify zero instead of blank so that the save doesn’t fail on your system. * Thread Starter [flobogo](https://wordpress.org/support/users/flobogo/) * (@flobogo) * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12305695) * Great, that’s it! It works well with or without image, to create or modify an event. I will be able to update family birthdays. 😉 **A lot of thanks for the work done.** Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Database error without image’ is closed to new replies. * ![](https://ps.w.org/spiffy-calendar/assets/icon-256x256.png?rev=2398731) * [Spiffy Calendar](https://wordpress.org/plugins/spiffy-calendar/) * [Frequently Asked Questions](https://wordpress.org/plugins/spiffy-calendar/#faq) * [Support Threads](https://wordpress.org/support/plugin/spiffy-calendar/) * [Active Topics](https://wordpress.org/support/plugin/spiffy-calendar/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/spiffy-calendar/unresolved/) * [Reviews](https://wordpress.org/support/plugin/spiffy-calendar/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * 10 replies * 2 participants * Last reply from: [flobogo](https://wordpress.org/support/users/flobogo/) * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-without-image/#post-12305695) * Status: resolved