upgrade from mysql 5.7 to mariadb 10.6

Hello... I've happily been using Webassist to create my dynamic web page. The databases I've been connecting to are MySql 5.7 and they have worked well. But now everyone is going to either MySql 8.0 or Maria DB 10.6.

Since I have several empty date fields on my pages Mariadb 10.6 will not allow me to update any records because the field is empty and empty string is an "Illegal" date. Everything else seems to work fine!

I know Ray has passed on... but is there someone that can help me with this?

Dan Lewis

Provide as much detail as you can so folks can help. Is there a setting in your db that can affect this? Screen shots of your db table that may shed a clue?

Originally Said By: Patrice

  Provide as much detail as you can so folks can help. Is there a setting in your db that can affect this? Screen shots of your db table that may shed a clue?  

Hello Patrice... when I moved everything over to Ubuntu 24.04 and moved the database too, basically everything seemed to work fine. But when I go to insert a new record or if I try to update an old record the date fields are expecting to have something in them. It seems to me there are so many incompatibilities between MySql 5.7 and Mariadb 10.6 and up that the PHP code I'm using needs to be totally revised.

Hi Dan:

I think I ran into this issue a few years ago too. Attached please see a screen shot of a db table that includes a date. If no date is added by the user, the default of 00000 is entered. Note the NO column. Does your date field look similar? This is a shot in the dark, but worth fiddling with to see if it solves it.

I recently moved to a new dedicated server using MariaDB 10.6.16. I had a problem with my DA update pages if any of the fields were set to use the default value if the post value was empty. In the update behavior I changed all WA_DEFAULT values to WA_IGNORE and that fixed it. Hope this helps but if not, add PHP error reporting to the top of your page, run the Insert behavior and tell us what the error message says:

<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>

As usual, Mags is on it! :-)
Thank you Mags for all you do for our community!

Thanks to both ladies, Patrice & Mags for all of their help.

I opened up a few of the pages of code I had and I can't locate where it says WA_default. It's been so long since I've created these pages I don't even know where the originals are. I thought maybe I could just edit the PHP code directly.

I found
WA_DEFAULT
in both the msqli folder for
rsobj.php
queryobj.php

hth