Error update 1.4 to 1.5


(Nosferatuvn) #1

hi,

i have 1.4 and want update to 1.5 and make the with automatic funktion but i got now this error …


Kritischer Fehler während der Aktualisierung:

/home/www/piwik/core/Updates/1.5-b1.php:
Error trying to execute the query 'ALTER IGNORE TABLE `piwik_log_conversion`
				 ADD visitor_days_since_order SMALLINT(5) UNSIGNED NOT NULL AFTER visitor_days_since_first,
				 ADD idorder varchar(100) default NULL AFTER buster,
				 ADD items SMALLINT UNSIGNED DEFAULT NULL,
				 ADD revenue_subtotal float default NULL,
				 ADD revenue_tax float default NULL,
				 ADD  revenue_shipping float default NULL,
				 ADD revenue_discount float default NULL,
				 ADD UNIQUE KEY unique_idsite_idorder (idsite, idorder),
				 MODIFY  idgoal int(10) NOT NULL'.
The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'visitor_days_since_first' in 'piwik_log_conversion'

Please can someone help me.

Nsoferatuvn


#2

Same problem.
Critical Error during the update process:

/var/www/vhosts/xxxx/mydomain.com/httpdocs/stats/core/Updates/1.5-b1.php:
Error trying to execute the query 'CREATE TABLE piwik_log_conversion_item (
idsite int(10) UNSIGNED NOT NULL,
idvisitor BINARY(8) NOT NULL,
server_time DATETIME NOT NULL,
idvisit INTEGER(10) UNSIGNED NOT NULL,
idorder varchar(100) NOT NULL,

											  idaction_sku INTEGER(10) UNSIGNED NOT NULL,
											  idaction_name INTEGER(10) UNSIGNED NOT NULL,
											  idaction_category INTEGER(10) UNSIGNED NOT NULL,
											  price FLOAT NOT NULL,
											  quantity INTEGER(10) UNSIGNED NOT NULL,
											  deleted TINYINT(1) UNSIGNED NOT NULL,
											  
											  PRIMARY KEY(idvisit, idorder, idaction_sku),
									          INDEX index_idsite_servertime ( idsite, server_time )
											)  DEFAULT CHARSET=utf8 '.

The error was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘piwik_log_conversion_item’ already exists


(kek0) #3

exactly same problem than this:

[quote=budgierless]
Same problem.
Critical Error during the update process:

/var/www/vhosts/xxxx/mydomain.com/httpdocs/stats/core/Updates/1.5-b1.php:
Error trying to execute the query 'CREATE TABLE piwik_log_conversion_item (
idsite int(10) UNSIGNED NOT NULL,
idvisitor BINARY(8) NOT NULL,
server_time DATETIME NOT NULL,
idvisit INTEGER(10) UNSIGNED NOT NULL,
idorder varchar(100) NOT NULL,

											  idaction_sku INTEGER(10) UNSIGNED NOT NULL,
											  idaction_name INTEGER(10) UNSIGNED NOT NULL,
											  idaction_category INTEGER(10) UNSIGNED NOT NULL,
											  price FLOAT NOT NULL,
											  quantity INTEGER(10) UNSIGNED NOT NULL,
											  deleted TINYINT(1) UNSIGNED NOT NULL,
											  
											  PRIMARY KEY(idvisit, idorder, idaction_sku),
									          INDEX index_idsite_servertime ( idsite, server_time )
											)  DEFAULT CHARSET=utf8 '.

The error was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘piwik_log_conversion_item’ already exists[/quote]


(Matthieu Aubry) #4

Please see this post for some explanations: 301 Moved Permanently