Search
Forums
Topic Information
ForumSupport for kiwitrees
Authorjprause
Last activity1 year, 11 months ago
StatusOpen
Replies6
Voices2
Participantsjprause, kiwi
Actions
Tags

github, Default record, image, custom modules, ASSO, PHP, message contactform, BAPM, edit interface, click, new feature, sanity checker, button, media, 3.0.0. setup, check, error, news module, simpl_grey, upgrade, prison, album, support, blank screem, media_links, order, watermark, googlemap. modified, contact links, 2.0.2, index, cookie, Histo, edit, batch update, Favourites 3.0.0, age, admin, HTML variables, defacto, 3.0.0, ckeditor, themes, seo, fatal error, birth, nickname, performance, request, illegitimate, prefix, last change date, mystyle, fact, places, family facts, 5.6, folder, hover, kiwitrees 2.0.2

Kiwitrees on Twitter

    Topic:   Upgrade to 3.3.0 error  

    This topic contains 6 replies, has 2 voices, and was last updated by Avatar jprause 1 year, 11 months ago.

    Viewing 7 posts - 1 through 7 (of 7 total)
    • Author
      Posts
    • #8257
      Avatar
      jprause
      Participant

      11 posts

      In step 5 of the upgrade process I get this error:

      PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘component’ at row 60 in /var/www/kiwitrees-ps/library/WT/DB.php:193 Stack trace: #0 /var/www/kiwitrees-ps/library/WT/DB.php(193): PDO->exec(‘ALTER TABLE kt...') #1 /var/www/kiwitrees-ps/includes/db_schema/db_schema_32_33.php(63): WT_DB::exec('ALTER TABLEkt…’) #2 /var/www/kiwitrees-ps/library/WT/DB.php(253): require(‘/var/www/kiwitr…’) #3 /var/www/kiwitrees-ps/includes/session.php(263): WT_DB::updateSchema(‘/var/www/kiwitr…’, ‘WT_SCHEMA_VERSI…’, 33) #4 /var/www/kiwitrees-ps/admin.php(26): require(‘/var/www/kiwitr…’) #5 {main}

      PHP version 7.0.
      Thanks for help.

      #8260
      kiwi
      kiwi
      Keymaster

      1704 posts

      That is a MYSQL error, not PHP. What version of MySQL do you use?

      Nigel
      My personal kiwitrees site is www.our-families.info
      #8263
      Avatar
      jprause
      Participant

      11 posts

      MYSQL 5.7.17

      #8265
      kiwi
      kiwi
      Keymaster

      1704 posts

      OK. I have not tested kiwitrees with that version yet, so it might be a problem, perhaps.

      But it’s a minor issue, so should be easy to fix manually.

      All that line does is update the allowed values for the “component” field in the __modules_privacy table in your database. If you look at the structure of that table, the allowed values should be
      ‘block’,’chart’,’list’,’menu’,’report’,’sidebar’,’tab’,’widget’

      Simply change it manually to those.

      Nigel
      My personal kiwitrees site is www.our-families.info
      #8266
      Avatar
      jprause
      Participant

      11 posts

      I do not need change anything as the component field of table _module_privacy value is:

      ‘block’,’chart’,’list’,’menu’,’report’,’sidebar’,’tab’,’widget’,’resource’

      #8268
      kiwi
      kiwi
      Keymaster

      1704 posts

      I do not need change anything as the component field of table _module_privacy value is:

      ‘block’,’chart’,’list’,’menu’,’report’,’sidebar’,’tab’,’widget’,’resource’

      Yes you do. My list is different to yours. Remove ’resource’.

      If it will not permit that change, then an earlier line in the code also failed. If so, change all references to “resource” in that table to ‘report’.

      Nigel
      My personal kiwitrees site is www.our-families.info
      #8270
      Avatar
      jprause
      Participant

      11 posts

      I did so – now it works.
      Thank you Nigel.

    Viewing 7 posts - 1 through 7 (of 7 total)

    You must be logged in to reply to this topic.