@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

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