In some settings MySQL / MariaDB treats empty or null ‘datetime’ and ‘timestamp’ fields/columns as simply null, in others it writes out zeros (0s) like 0000-00-00 00:00:00. If you designed your own database, you probably know what you’re dealing with, already. But if you are working on someone else’s database, like migrating data to or from, or just doing development for it, for example, you may encounter the error “Incorrect datetime value: ‘0000-00-00 00:00:00’ for …
In version 5.6 of MySQL, you might get errors regarding InnoDB tables mysql/slave_master_info,mysql/slave_worker_info, and mysql/slave_relay_log_info like the following when the server was not gracefully shut down, and the InnoDB tables in question become eventually corrupt. This article will present detailed instructions to fix the problem.
BO Administrators will be faced with many choices when installing SAP BusinessObjects Enterprise. This guide helps BO admins to make the right decisions and create a reliable and powerful business intelligence reporting system for the organization.
MySQL Management and Administration with Navicat I was pleased to announce my book’s give-away campaign with Packt Publishing back on November 30th, 2012. All we asked the website visitors to do was just comment about the book below this post, and win a free e-copy of MySQL Management and Administration with Navicat. Three lucky winners got the chance to win free copies of the e-book. You could have been one of the Lucky Ones if you visited this …
In this part (4) of the tutorial we will correct the bugs inherent in version 2.2 of Seam-gen and we will add some code to spice up our blog CMS. First of all, our PostEdit.seam page is not working at all as it is. We shall fix this: Open PostEdit.xhtml from the WebContent folder and find the <rich:tabPanel switchType=”ajax”> block. This is what’s causing the problem, because it has more than one tab – one …