New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Login not possible after upgrade from 1.1.0 to 1.2.2 #1123

Open
Mike162 opened this Issue Feb 19, 2018 · 2 comments

Comments

Projects
None yet
3 participants
@Mike162

Mike162 commented Feb 19, 2018

Hello everybody,

Expected behaviour

I wanted to update from version 1.1.0 to 1.2.0

Actual behaviour

After the update I am out of system. All usernames / passwords do not work anymore.
Even the admin with the password changeme does not work anymore

Steps to reproduce

I have installed the new version over the old version. Then you have set the right netsprechend. The call from the website with installation guide also worked. Database connection was entered. The new database field has been left blank.
Afterwards an error message appears where I could do a DB update, what I did.
I came to the website shortly afterwards, I wanted to change the user. Since then I come with neither user nor with the admin into the system.

Reproducable on demo.kimai.org? [yes|no]

yes

Kimai version [for example: dev 1.1.0.1389|github master|github develop]

1.1.0/1.2.0

Relevant log entries from log file (debug tab or temporary/logfile.txt)

[19.02.2018 09:07:14] -- begin install ----------------------------------
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_users (userID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(160) NOT NULL,alias varchar(160),trash tinyint(1) NOT NULL default '0',$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_preferences (userID int(10) NOT NULL,option varchar(190) NOT NULL,value varchar(255) NOT NULL,PRIMARY KEY (userID,option));] => s:48:"Table '$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_activities (activityID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(255) NOT NULL,comment TEXT NULL,visibleTINYINT(1) NOT NULL DEF$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLEkimai_groups (groupID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(160) NOT NULL,trashTINYINT(1) NOT NULL DEFAULT '0') AUTO_INCREMENT=1;] $ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLEkimai_groups_users (groupID int(10) NOT NULL,userID int(10) NOT NULL,membershipRoleID int(10) NOT NULL,PRIMARY KEY (groupID,userID)) AUTO_INCREMENT$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_groups_customers (groupID INT NOT NULL,customerID INT NOT NULL,UNIQUE (groupID ,customerID));] => s:53:"Table 'kimai_groups_customers' already $ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_groups_projects (groupID INT NOT NULL,projectID INT NOT NULL,UNIQUE (groupID ,projectID));] => s:52:"Table 'kimai_groups_projects' already exis$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_groups_activities (groupID INT NOT NULL,activityID INT NOT NULL,UNIQUE (groupID ,activityID));] => s:54:"Table 'kimai_groups_activities' alread$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_projects_activities (projectID INT NOT NULL,activityID INT NOT NULL,budget DECIMAL( 10, 2 ) NULL DEFAULT '0.00',effort DECIMAL( 10, 2 ) NULL ,$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_customers (customerID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(255) NOT NULL,password varchar(255),passwordResetHash char(32) N$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_projects (projectID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,customerID int(3) NOT NULL,name varchar(255) NOT NULL,comment TEXT NULL,visibl$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_timeSheet (timeEntryID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,start int(10) NOT NULL default '0',end int(10) NOT NULL default '0',duration$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_configuration (option varchar(190) NOT NULL,value varchar(255) NOT NULL,PRIMARY KEY(option));] => s:50:"Table 'kimai_configuration' already exist$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_rates (userID int(10) DEFAULT NULL,projectID int(10) DEFAULT NULL,activityID int(10) DEFAULT NULL,rate decimal(10,2) NOT NULL,UNIQUE KEY(userI$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_fixedRates (projectID int(10) DEFAULT NULL,activityID int(10) DEFAULT NULL,rate decimal(10,2) NOT NULL,UNIQUE KEY(projectID, activityID));] =$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_expenses (expenseID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,timestamp int(10) NOT NULL DEFAULT '0',userID int(10) NOT NULL,projectID int(10$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_statuses (statusID TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,status VARCHAR( 200 ) NOT NULL) ENGINE = InnoDB] => s:45:"Table 'kimai_statuses' alr$
[19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_globalRoles (globalRoleID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR( 255 ) NOT NULL,deb_ext-access TINYINT DEFAULT 0, adminPanel_$ [19.02.2018 09:07:14] [ERROR] in [CREATE TABLE kimai_membershipRoles (membershipRoleID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR( 255 ) NOT NULL,core-customer-addTINYINT DEFAULT 0,$
[19.02.2018 09:07:14] [ERROR] in [ALTER TABLE kimai_globalRoles ADD core-customer-otherGroup-view tinyint DEFAULT 0;] => s:61:"Duplicate column name 'core-customer-otherGroup-view' (#1060)";
[19.02.2018 09:07:15] [ERROR] in [ALTER TABLE kimai_globalRoles ADD core-project-otherGroup-view tinyint DEFAULT 0;] => s:60:"Duplicate column name 'core-project-otherGroup-view' (#1060)";
[19.02.2018 09:07:15] [ERROR] in [ALTER TABLE kimai_globalRoles ADD core-activity-otherGroup-view tinyint DEFAULT 0;] => s:61:"Duplicate column name 'core-activity-otherGroup-view' (#1060)";
[19.02.2018 09:07:15] [ERROR] in [ALTER TABLE kimai_globalRoles ADD core-group-otherGroup-view tinyint DEFAULT 0;] => s:58:"Duplicate column name 'core-group-otherGroup-view' (#1060)";
[19.02.2018 09:07:15] [ERROR] in [ALTER TABLE kimai_globalRoles ADD core-user-otherGroup-view tinyint DEFAULT 0;] => s:57:"Duplicate column name 'core-user-otherGroup-view' (#1060)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_statuses (statusID ,status) VALUES ('1', 'open'), ('2', 'review'), ('3', 'closed');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_activities (activityID, name, comment) VALUES (1, 'testen', '');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_customers (customerID, name, comment, company, vat, contact, street, zipcode, city, phone, fax, mobile, mail, homepage, tim$ [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_projects (projectID, customerID, name, comment) VALUES (1, 1, 'TestProjekt', '');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_users (userID,name,mail,password, globalRoleID) VALUES ('130902034','admin','admin@example.com','ccded795c6eb87dc24b502dd5be69fd4',1);] => s:$ [19.02.2018 09:07:15] [ERROR] in [INSERT INTOkimai_configuration (option, value) VALUES('version', '1.2.2'),('login', '1'),('adminmail', 'admin@example.com'),('loginTries', '3'),('loginBanTime', '900$ [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_activities (groupID, activityID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_customers (groupID, customerID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_projects (groupID, projectID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)"; [19.02.2018 09:07:15] -- showing install error -------------------------- [19.02.2018 09:07:15] -- begin install ---------------------------------- [19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_users (userID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(160) NOT NULL,alias varchar(160),trash tinyint(1) NOT NULL default '0',$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_preferences (userID int(10) NOT NULL,option varchar(190) NOT NULL,value varchar(255) NOT NULL,PRIMARY KEY (userID,option));] => s:48:"Table '$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_activities (activityID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(255) NOT NULL,comment TEXT NULL,visible TINYINT(1) NOT NULL DEF$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_groups (groupID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(160) NOT NULL,trash TINYINT(1) NOT NULL DEFAULT '0') AUTO_INCREMENT=1;] $
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_groups_users (groupID int(10) NOT NULL,userID int(10) NOT NULL,membershipRoleID int(10) NOT NULL,PRIMARY KEY (groupID,userID)) AUTO_INCREMENT$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_groups_customers (groupID INT NOT NULL,customerID INT NOT NULL,UNIQUE (groupID ,customerID));] => s:53:"Table 'kimai_groups_customers' already $
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_groups_projects (groupID INT NOT NULL,projectID INT NOT NULL,UNIQUE (groupID ,projectID));] => s:52:"Table 'kimai_groups_projects' already exis$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_groups_activities (groupID INT NOT NULL,activityID INT NOT NULL,UNIQUE (groupID ,activityID));] => s:54:"Table 'kimai_groups_activities' alread$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_projects_activities (projectID INT NOT NULL,activityID INT NOT NULL,budget DECIMAL( 10, 2 ) NULL DEFAULT '0.00',effort DECIMAL( 10, 2 ) NULL ,$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_customers (customerID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name varchar(255) NOT NULL,password varchar(255),passwordResetHashchar(32) N$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLEkimai_projects (projectID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,customerID int(3) NOT NULL,name varchar(255) NOT NULL,comment TEXT NULL,visibl$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_timeSheet (timeEntryID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,start int(10) NOT NULL default '0',end int(10) NOT NULL default '0',duration$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_configuration (option varchar(190) NOT NULL,value varchar(255) NOT NULL,PRIMARY KEY(option));] => s:50:"Table 'kimai_configuration' already exist$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_rates (userID int(10) DEFAULT NULL,projectID int(10) DEFAULT NULL,activityID int(10) DEFAULT NULL,rate decimal(10,2) NOT NULL,UNIQUE KEY(userI$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_fixedRates (projectID int(10) DEFAULT NULL,activityID int(10) DEFAULT NULL,rate decimal(10,2) NOT NULL,UNIQUE KEY(projectID, activityID));] =$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_expenses (expenseID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,timestamp int(10) NOT NULL DEFAULT '0',userID int(10) NOT NULL,projectIDint(10$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLEkimai_statuses (statusID TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,statusVARCHAR( 200 ) NOT NULL) ENGINE = InnoDB] => s:45:"Table 'kimai_statuses' alr$ [19.02.2018 09:07:15] [ERROR] in [CREATE TABLEkimai_globalRoles (globalRoleID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR( 255 ) NOT NULL,deb_ext-accessTINYINT DEFAULT 0,adminPanel_$
[19.02.2018 09:07:15] [ERROR] in [CREATE TABLE kimai_membershipRoles (membershipRoleID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR( 255 ) NOT NULL,core-customer-add TINYINT DEFAULT 0, $ [19.02.2018 09:07:15] [ERROR] in [ALTER TABLE kimai_globalRolesADDcore-customer-otherGroup-viewtinyint DEFAULT 0;] => s:61:"Duplicate column name 'core-customer-otherGroup-view' (#1060)"; [19.02.2018 09:07:15] [ERROR] in [ALTER TABLEkimai_globalRolesADDcore-project-otherGroup-viewtinyint DEFAULT 0;] => s:60:"Duplicate column name 'core-project-otherGroup-view' (#1060)"; [19.02.2018 09:07:15] [ERROR] in [ALTER TABLEkimai_globalRolesADDcore-activity-otherGroup-viewtinyint DEFAULT 0;] => s:61:"Duplicate column name 'core-activity-otherGroup-view' (#1060)"; [19.02.2018 09:07:15] [ERROR] in [ALTER TABLEkimai_globalRolesADDcore-group-otherGroup-viewtinyint DEFAULT 0;] => s:58:"Duplicate column name 'core-group-otherGroup-view' (#1060)"; [19.02.2018 09:07:15] [ERROR] in [ALTER TABLEkimai_globalRolesADDcore-user-otherGroup-viewtinyint DEFAULT 0;] => s:57:"Duplicate column name 'core-user-otherGroup-view' (#1060)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTOkimai_statuses (statusID ,status) VALUES ('1', 'open'), ('2', 'review'), ('3', 'closed');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_activities (activityID, name, comment) VALUES (1, 'testen', '');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)"; [19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_customers (customerID, name, comment, company, vat, contact, street, zipcode, city, phone, fax, mobile, mail, homepage, tim$
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_projects (projectID, customerID, name, comment) VALUES (1, 1, 'TestProjekt', '');] => s:45:"Duplicate entry '1' for key 'PRIMARY' (#1062)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_users (userID,name,mail,password, globalRoleID ) VALUES ('603373108','admin','admin@example.com','ccded795c6eb87dc24b502dd5be69fd4',1);] => s:$
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_configuration (option, value) VALUES('version', '1.2.2'),('login', '1'),('adminmail', 'admin@example.com'),('loginTries', '3'),('loginBanTime', '900$
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_activities (groupID, activityID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_customers (groupID, customerID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)";
[19.02.2018 09:07:15] [ERROR] in [INSERT INTO kimai_groups_projects (groupID, projectID) VALUES (1, 1);] => s:47:"Duplicate entry '1-1' for key 'groupID' (#1062)";
[19.02.2018 09:07:15] -- showing install error --------------------------
[19.02.2018 09:07:28] login: a as user
[19.02.2018 09:07:41] login: admin as user
[19.02.2018 09:07:49] login: admin as user
[19.02.2018 09:08:47] login: admin as user

@kevinpapst

This comment has been minimized.

Member

kevinpapst commented Feb 19, 2018

Sorry to hear you have troubles.
But as clearly state d in the update docu: https://www.kimai.org/documentation/updates/
You may NOT execute the installer, but ONLY execute the updater.
Can you please use your backup and do an update this time?

@Mike162

This comment has been minimized.

Mike162 commented Feb 19, 2018

I do not know why the routine looks different now.
But it seems to work now.

But I can not work anymore.
Say a time recording has taken place and one would like to change the activity afterwards.
This is no longer accepted.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment