Posts

Wanted to see the DNA-tab, got this error:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘date’ in /home/stambo1q/public_html/kiwitrees/library/KT/DB.php:193 Stack trace: #0 /home/stambo1q/public_html/kiwitrees/library/KT/DB.php(193): PDO->exec(‘CREATE TABLE IF…’) #1 /home/stambo1q/public_html/kiwitrees/modules_v4/tab_dna/db_schema/db_schema_0_1.php(30): KT_DB::exec(‘CREATE TABLE IF…’) #2 /home/stambo1q/public_html/kiwitrees/library/KT/DB.php(253): require(‘/home/stambo1q/…’) #3 /home/stambo1q/public_html/kiwitrees/modules_v4/tab_dna/module.php(495): KT_DB::updateSchema(‘/home/stambo1q/…’, ‘DNA_SCHEMA_VERS…’, 1) #4 /home/stambo1q/public_html/kiwitrees/modules_v4/tab_dna/module.php(416): tab_dna_KT_Module::updateSchema() #5 /home/stambo1q/public_html/kiwitrees/modules_v4/tab_dna/module.php(399): tab_dna_KT_Module->getData() #6 /home/stambo1q/public_html/kiwitrees/individual.php(241): tab_dna_KT_Module->isGrayedOut() #7 {main}

Nigel
My personal kiwitrees site is www.our-families.info

This is an issue I thought was fixed before release. It’s caused by differing database requirements, mainly between MySQL and MariaDB.

What database are you using? I’ll try again to find a common solution.

Nigel
My personal kiwitrees site is www.our-families.info

As far as I know it is MySQL.

Wim

stamboommeijberg.nl

 

 

grebjiem wrote:

As far as I know it is MySQL.

Thanks. That confirms what I expected. But sadly the error was purely mine. I “did” fix it, but the fix missed the creation of the download package 🙁

To fix, replace the file kiwitrees/modules_v4/tab_dna/db_schema/db_schema_0_1.php with the one in the attached zip folder.

Nigel
My personal kiwitrees site is www.our-families.info

2 users thanked author for this post.

jacoline, Wim Meijberg