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.

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

Nigel
My personal kiwitrees site is www.our-families.info

MYSQL 5.7.17

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

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’

jprause wrote:

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

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