@anonymous-matomo-user opened this Issue on November 15th 2009

Hello guys,

i do wanna install piwik automated during the installation of piwikintegration plugin of TYPO3.

This referrs to #781.

I used:

$existingTables = $GLOBALS['TYPO3_DB']->admin_get_tables();
$neededTables = Piwik::getTablesCreateSql();;
foreach($neededTables as $table=>$tableQuery) {
if(!array_key_exists($table,$existingTables)) {

To create the tables for piwik.
Directly after the installation i got the following error:
Your Piwik database is out-of-date, and must be upgraded before you can continue.
Piwik database will be upgraded from version 0.2.9 to the new version 0.4.5.

After clicking on update, i got the following error:
Critical Error during the update process:

Error trying to execute the query 'CREATE TABLE tx_piwikintegration_option (
option_name VARCHAR( 64 ) NOT NULL ,
option_value LONGTEXT NOT NULL ,
PRIMARY KEY ( option_name )
The error was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tx_piwikintegration_option' already exists

Please give me a hint, how to tell piwik to create the necessary tables to get started with piwik.

Thanks a lot.

Keywords: Automated Installer

@robocoder commented on November 15th 2009 Contributor

You're missing a slash. You might also want to look at some changes in convention. Try:


Please add your suggestions or patch to #991. Thanks.

@anonymous-matomo-user commented on November 16th 2009

i'm now able to install piwik fully automated ;).
i'll post a link to the TYPO3 classes and to the repository now.
the extension is still under heavy development, but i think it's the right way to use the api as often as possible. ...

interesting revision is 26607 in the repository

best regards kay

This Issue was closed on November 16th 2009
Powered by GitHub Issue Mirror