Tags:

Viewing 4 posts - 1 through 4 (of 4 total)
Author
Posts
  • #10939

    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
  • #10942

    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
  • #10943

    As far as I know it is MySQL.

  • #10944

    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.
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.