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
Error updating from 2.1.27.36 to #3269
Comments
Thank you for this complete description. I don't understand from what step of the upgrade you can have this error ??? Regarding you second comment, it has nothing to do with ldap. |
Point one I agree, I mixed up the stuff, that I tried during figuring out what I did wrong. Please consider the database-change-attempts as an error from my side. Sorry about that. The second point: The table of users contains with ID 1 the administrator (email address behind it is mine). However, no email is being generated for this user. I guess that makes sense. |
Hello, the same repeatedly happened during my upgrade attempts: One mail was sent, then the WebUI seemed to be stuck. A following install/upgrade.php run (that lasts for hours) just sends the mail for the next user! |
Steps to reproduce
The last step seems necessary, for the upgrade to work. Otherwise some of the checks fail.
After that I tried to update the mysql as stated in the upgrade-notice:
teampass_misc
CHANGEid
increment_id
INT(12) NOT NULL AUTO_INCREMENT;This caused the first error (discribed in Actual behaviour).
I Ignored it and ran the upgrade process by using the /install/upgrade.php
During the process, I made a database dump.
Further I stored the old table into old_* during the UTF8 conversion. Not shure, why this step would be necessary, as I'was anaware, that the database is not already UTF8.
All checks out, starting the conversion. With me it takes about 90min to complete. All good, just the very last step creates a problem:
I get stuck at the mail sending process.
Expected behaviour
SQL-Update runs smoothly.
Mail sending works within a couple of seconds, all should be delivered and the update should complete.
Needless to say, I waited several hours on that last email-sending-step.
Actual behaviour
ERROR 1054 (42S22): Unknown column 'id' in 'teampass_misc'
Confirmed after checking:
show columns from teampass_misc;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| increment_id | int | NO | PRI | NULL | auto_increment |
| type | varchar(50) | NO | | NULL | |
| intitule | varchar(100) | NO | | NULL | |
| valeur | varchar(500) | NO | | none | |
+--------------+--------------+------+-----+---------+----------------+
No column called 'id' present.
The second problem of not sendig the emails: To one of the Users, the new password gets sent (its highly probable that this user is the first in the databank, as its the administrator). No other user are getting the new "temproray password". Although it should not be necessary to receive a message at all, as we are using LDAP as authentification method. Further the upgrade progress gets stuck at following message:
Now sending new users password by email ...
Server configuration
Operating system: Ubuntu Linux Release 20.04.1 LTS (virtual machine on a microsoft server 2012R2)
Web server: Apache 2.4.41
Database: mysql Ver 8.0.30
PHP version: 7.4.3
Teampass version: Starting from 2.1.27.36 upgrading to 3.0.0.18
Teampass configuration file:
tp.config.php.txt
Client configuration
Browser: Firefox 91.4.0esr
Operating system: Windows 10
The text was updated successfully, but these errors were encountered: