Search
Forums
Bug filter
Topic Information
ForumBug reporting
Authorkiwi
Last activity9 months, 2 weeks ago
StatusOpen
Replies3
Voices2
Participantskiwi, grebjiem
Tags

album, Install, upload, contact links, stories, 7.1, children, pages, Google Maps, theme, photo, research tasks, fancy tree view, responsive menus, special character, release, add_asso_facts, abbreviate, sidebar, drag, add, help, simpl_research, GDBR, close, URL, re-order, fact, immigration, DNA, nickname, editor, Histo, admin, style, danish, pdf, Php 7.1, menus, husband, test, space, 3.3.0, message contactform, request, logout, contacts, mystyle, ckeditor, autocomplete, event, search, permissions, simpl_pages, CREM, Export/Import, tools, 3.1, ID facts, github

Kiwitrees on Twitter

    Tagged: , ,

    Topic:   Date format error – New DNA Connections Tab   [Fix released]

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

      1894 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
      #10942
      kiwikiwi
      Keymaster

      1894 posts

      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
      grebjiemgrebjiem
      Participant

      121 posts

      As far as I know it is MySQL.

      #10944
      kiwikiwi
      Keymaster

      1894 posts

      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
      Attachments:
      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.