Search
Forums
Topic Information
ForumBug reporting
Authorgrebjiem
Last activity1 month ago
StatusOpen
Replies3
Voices2
Participantsgrebjiem, kiwi
Actions
Tags

events of close relatives, place, .mo, search, watermark, living, blocks, GDBR, block, missing data, F.A.B., xmas, descendant, pop-ups, family facts, styles, users, batch update, mobile, sanity, access level, HTML variables, latest, Extra menus, 3.2.3, internal messaging, ID notes, I18N, UID, future, 3.2.1, admin, custom text, .po, dead, NCHI, Favourites 3.0.0, event, 500, bug reporting, reports, kiwitrees theme, ASSO, person, theme, server, pages, feedback, HTML block, sitemap, formatting, Add a wife, getClientIp, ID facts, responsive menus, blank screem, language, family fact, slideshow, progress

Kiwitrees on Twitter

    Tagged: , ,

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

    This topic contains 3 replies, has 2 voices, and was last updated by kiwi kiwi 1 month ago.

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

      94 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
      kiwi
      kiwi
      Keymaster

      1749 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
      grebjiem
      grebjiem
      Participant

      94 posts

      As far as I know it is MySQL.

      #10944
      kiwi
      kiwi
      Keymaster

      1749 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:
      1 user thanked author for this post.
    Viewing 4 posts - 1 through 4 (of 4 total)

    You must be logged in to reply to this topic.