@anonymous-piwik-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();
Piwik::createConfigObject(PIWIK_INCLUDE_PATH.'config/config.ini.php');
$neededTables = Piwik::getTablesCreateSql();;
foreach($neededTables as $table=>$tableQuery) {
if(!array_key_exists($table,$existingTables)) {
$GLOBALS['TYPO3_DB']->admin_query($tableQuery);
}
}

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:

E:\mowes\www\t3alpha4.3\typo3conf\piwik\piwik\core\Updates\0.2.10.php:
Error trying to execute the query 'CREATE TABLE tx_piwikintegration_option (
option_name VARCHAR( 64 ) NOT NULL ,
option_value LONGTEXT NOT NULL ,
autoload TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY ( option_name )
) DEFAULT CHARSET=utf8
'.
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.

Kay
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:

Piwik::createConfigObject(PIWIK_USER_PATH.'/config/config.ini.php'); 

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

@anonymous-piwik-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. ...

http://forge.typo3.org/repositories/show/extension-piwikintegration
interesting revision is 26607 in the repository

best regards kay

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