Nach update auf 1.2 Fehler


(dealer) #1

hallo,
bekomme solche SQL-Fehler nach dem update.
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘idvisitor’ in 'field list’
was muss ich tun?

Grüße


#2

Bei mir das gleiche, Daten von heute werden nicht angezeigt

Fehler beim Update:


Error trying to execute the query 'ALTER TABLE `piwik_log_visit` 
			    DROP `visit_server_date`,
			    DROP INDEX `index_idsite_date_config`,
			    DROP INDEX `index_idsite_datetime_config`,
		    	ADD `visit_entry_idaction_name` INT UNSIGNED NOT NULL AFTER `visit_entry_idaction_url`,
			    ADD `visit_exit_idaction_name` INT UNSIGNED NOT NULL AFTER `visit_exit_idaction_url`,
			    CHANGE `visit_exit_idaction_url` `visit_exit_idaction_url` INT UNSIGNED NOT NULL, 
			    CHANGE `visit_entry_idaction_url` `visit_entry_idaction_url` INT UNSIGNED NOT NULL,
			    CHANGE `referer_type` `referer_type` TINYINT UNSIGNED NULL DEFAULT NULL,
			    ADD `idvisitor` BINARY(8) NOT NULL AFTER `idsite`, 
			    ADD visitor_count_visits SMALLINT(5) UNSIGNED NOT NULL AFTER `visitor_returning`,
			    ADD visitor_days_since_last SMALLINT(5) UNSIGNED NOT NULL,
			    ADD visitor_days_since_first SMALLINT(5) UNSIGNED NOT NULL,
			    ADD `config_id` BINARY(8) NOT NULL AFTER `config_md5config`,
			    ADD custom_var_k1 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_v1 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_k2 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_v2 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_k3 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_v3 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_k4 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_v4 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_k5 VARCHAR(50) DEFAULT NULL,
    			ADD custom_var_v5 VARCHAR(50) DEFAULT NULL
			   '.
The error was: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'index_idsite_date_config'; check that column/key exists

Habe dann in der DB options - versions core auf 1.2 gestellt.
Alte Daten vorhanden, aber keine von heute


(Peterbo) #3

Bitte diesen Beitrag dazu lesen.


(dealer) #4

[quote=mediaproweb]
Bitte diesen Beitrag dazu lesen.[/quote]
Vielen Dank
funktioniert wieder.
thread kann geschlossen werden


#5

Ja Danke,
alles wieder gut. Super Support!!