Problem updaing from version 2.x to 3.3.0

Support & Bugs
1

I’ve had a few issues already trying to upgrade from an older version to the latest one.
I managed to solve everything up until now googling for similar issues.
Can’t find one though from the current problem:

A fatal error occurred

The following error just broke Matomo (v3.3.0):

An exception has been thrown during the rendering of a template ("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'account_name_piwiik3.piwik_site_url' doesn't exist").

in

/home/account_name/public_html/piwik64/plugins/CoreHome/templates/getDefaultIndexView.twig line 7

Should I create the ‘piwik_site_url’ table? Can anyone please point me to a database schema or anything similar?

Thanks!

2

Hi,

I don’t know anything about that error and can’t say if something larger is broken, but if it helps you, that’s the structure of piwik_site_url on my instance:

CREATE TABLE `piwik_site_url` (
  `idsite` int(10) UNSIGNED NOT NULL,
  `url` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `piwik_site_url`
  ADD PRIMARY KEY (`idsite`,`url`);
3

Ok, problem solved thank you!