Column not found: 1054 Unknown column 'json_encoded' in 'field list'

alphaonex86 · October 30, 2019, 2:16pm

Hi, since the last upgrade I have:
30-Oct-2019 14:07:38 UTC] Error in Matomo: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'json_encoded' in 'field list'
[30-Oct-2019 14:07:38 UTC] Error in Matomo: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'json_encoded' in 'field list'
How fix this?

Lukas · October 30, 2019, 4:46pm

Hi,

This column should have been added when updating to 3.5.0:

github.com

matomo-org/matomo/blob/6b4cd1676d524641167ba32776a999e3e37a6a2a/core/Updates/3.5.0-b4.php

<?php
/**
 * Piwik - free/libre analytics platform
 *
 * @link https://matomo.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 *
 */

namespace Piwik\Updates;

use Piwik\Updater;
use Piwik\Updates as PiwikUpdates;
use Piwik\Updater\Migration\Factory as MigrationFactory;

class Updates_3_5_0_b4 extends PiwikUpdates
{
    /**
     * @var MigrationFactory
     */

This file has been truncated. show original

From which version did you update?

alphaonex86 · October 30, 2019, 5:00pm

I update from 3.4, how fix cleanly the database?

Column not found: 1054 Unknown column &#039;json_encoded&#039; in &#039;field list&#039;

Column not found: 1054 Unknown column 'json_encoded' in 'field list'