Cannot update to 1.5


#1

Hello,

when trying to upgrade from 1.4 to 1.5, Piwik fails before the database upgrade with

Table usr_web35_2.piwik_session doesn`t exist.


#2

Is there a solution?


#3

i been tryin to update to 1.5 also http://forum.piwik.org/read.php?2,78025, but not had any support, very strange as i have never had a problem with pwik support before or updating.


#4

I reported this bug already during the RC stage. Obviously, it was not taken serious.


(Peterbo) #5

Please create the table manually. This is obviously a bug out of an early RC stage.


CREATE TABLE `piwik_session` (
								id CHAR(32) NOT NULL,
								modified INTEGER,
								lifetime INTEGER,
								data TEXT,
								PRIMARY KEY ( id )
								)  DEFAULT CHARSET=utf8

If “piwik” is not your table prefix, please edit it to yours.

~Peter


#6

Ok, did that, looked fine at first. However, when logging in, now I get:

The requested website id = 1 couldn’t be found

The site table contains a site though with idSite = 1.

What now?


(Peterbo) #7

Please execute the single database update steps. The steps can be found in the files core/Updates/1.5-xx.php

The creat table / alter table statements must be executed in (e.g.) phpMyAdmin or some other DB tool.

~Peter


#8

[quote=mediaproweb]
Please execute the single database update steps. The steps can be found in the files core/Updates/1.5-xx.php

The creat table / alter table statements must be executed in (e.g.) phpMyAdmin or some other DB tool.

~Peter[/quote]

yes but with mine, please look at the last line od code,

'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


(Peterbo) #9

Yes this is OK. This only means, that this step was finished correctly by the Update or you have already executed that code. Get over to the next Statement.


#10

[quote=mediaproweb]
Yes this is OK. This only means, that this step was finished correctly by the Update or you have already executed that code. Get over to the next Statement.[/quote]

then why do i get the error page, and why will is not let me pass the update page?


(Peterbo) #11

You have 6 1.5-xx.php’s in the core/Updates directory. Start action in 1.5-b1 until you executed all statements including 1.5-b5. Then it should run correctly.


#12

[quote=mediaproweb]
You have 6 1.5-xx.php’s in the core/Updates directory. Start action in 1.5-b1 until you executed all statements including 1.5-b5. Then it should run correctly.[/quote]

now i get this?

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘revenue_subtotal’ in ‘field list’


(Peterbo) #13

Execute the last statement in core/updates/1.5-b1:


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


#14

i GET THIS ERROR #1054 - Unknown column ‘buster’ in ‘piwik_log_conversion’


(Peterbo) #15

Then you have to search the statement, where the buster column is added. "The steps can be found in the files core/Updates/1.5-xx.php "


#16

can you explan in more detail please as i have no idea what you mean?


#17

[quote=budgierless]

i GET THIS ERROR #1054 - Unknown column ‘buster’ in ‘piwik_log_conversion’[/quote]
check again column ‘buster’ or insert data to this column


#18

[quote=johnlennon9687]

[quote=budgierless]

i GET THIS ERROR #1054 - Unknown column ‘buster’ in ‘piwik_log_conversion’[/quote]
check again column ‘buster’ or insert data to this column[/quote]

Thanks it worked, the buster column was missing, so i just made the table up with random settings. Can you tell me the correct settings for the buster column in piwik_log_conversion table please so i can make it work right the way it should, for example, INT(11) etc…?


(Peterbo) #19

buster int(10) unsigned NOT NULL


#20

[quote=mediaproweb]
buster int(10) unsigned NOT NULL[/quote]

Thanks, i now have a working 1.5 updated vsersion :slight_smile: