Search
Forums
Topic Information
ForumBug reporting
Authorgrebjiem
Last activity2 months, 3 weeks ago
StatusOpen
Replies3
Voices2
Participantsgrebjiem, kiwi
Actions
Tags

burial, nickname, new feature, styles, Php 7.1, internal messaging, research tasks, 3.1, tools, My Page, 3.2.2, ckeditor, event, Favourites, special character, support, logs, simpl_grey, Export/Import, drag, sitemap, help, search, individual resource, kiwitrees 2.0.2, age, fancy tree view, 3.2.3, googlemap. modified, feedback, Georgian, sanity checker, backup, Fancy imagebar, update, re-order, webtrees 1.4.4.1, data errors, media, Google Maps, ID notes, gettext, blank, merge, name, 500, mobile, github, lists individuals families, ASSO, calendar.php issue, blocks, theme, wish, place, slideshow, access level, colors, 7.1, dates

Kiwitrees on Twitter

    Tagged: , ,

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

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

      123 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}

      #10942
      kiwikiwi
      Keymaster

      1849 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

      123 posts

      As far as I know it is MySQL.

      #10944
      kiwikiwi
      Keymaster

      1849 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.