Upgrading from 3.0.0.8 to 3.0.0.13

[Amenia1999]

Steps to reproduce

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system Linux Web server: LiteSpeed Database: MySQL PHP version: 7.2.34 Teampass version: 3.0.0.13 Teampass configuration file:

Updated from an older Teampass or fresh install: PLEASE attach to this issue the file /includes/config/tp.config.php.

Client configuration

Browser: Firefox Operating system: Linux

Logs

Web server error log

Insert your webserver log here

Log from the web-browser developer console (CTRL + SHIFT + i)

Insert the log here and especially the answer of the query that failed.

TeamPass Upgrade

Database updates The database needs to be adapted. This step can take a very long time depending on the data volume and server performance. An error occurred. Please check and relaunch. 13:41:58 - ERROR: An error appears when adding field Encrypted to table OTV! Table 'onnanoko_pass.teampass_otv' doesn't exist! 13:41:58 - upgrade_run_3.0.0.php - Loop #1

[nilsteampassnet]

Thank you for reporting.

Can you please share the console logs when this occurs? To know how to do this, please read https://teampass.readthedocs.io/en/latest/faq/#how-to-capture-query-error-from-the-browser-console

[Amenia1999]

upgrade_run_3.0.0.php : [{"finish":"1", "msg":"", "error":"An error appears when adding field Encrypted to table OTV! Table 'onnanoko_pass.teampass_otv' doesn't exist!"}]

upgrade_scripts_manager.php : [{"finish":"0", "scriptname":"upgrade_run_3.0.0.php", "parameter":"user_id"}]

[nilsteampassnet]

@Amenia1999 Can you please provide the structure of OTV table you have?

[Amenia1999]

I dont have that table, and I could not find the structure in the doku.

[nilsteampassnet]

In that case how can you upgrade? OTV table is coming from 2.x version. What version are you currently using?

[Amenia1999]

I am upgrading from 3.0.0.8

[nilsteampassnet]

something is wrong. So you have never been used 2.x version? But even, OTV is also created during 3.x installation process. Can you please perform new installation?

[gmontequi]

Change the database engine from mysql to mariaDB and the table will be created without problems. It is a problem with MySQL.

[amafonso]

I'm going through the same problem. I started using it in version 3.0.0.8, when I try to migrate it shows the error: "ERROR: An error appears when adding field Encrypted to table OTV! Table 'teampass.teampass_otv' doesn't exist!"

But in my case I can't use MariaDB, I have MySQL 8. Is there any other way to fix it?

[elmarbransch]

cannot change DB engine in my case as well, same versions 3.0.0.8 to 3.0.0.17 for me. Can we patch some file meanwihle to overcome this issue?

[Amenia1999]

I cannot change it, I am using a Webspace.

Am 14. März 2022, 09:28, um 09:28, gmontequi @.***> schrieb:

Change the database engine from mysql to mariaDB and the table will be created without problems. It is a problem with MySQL.

—
Reply to this email directly, view it on GitHub, or unsubscribe.
Triage notifications on the go with GitHub Mobile for iOS or Android.
You are receiving this because you were mentioned.Message ID: <nilsteampassnet/TeamPass/issues/3074/1066504844@github.com>

@.": "http://schema.org", @.": "EmailMessage",

"potentialAction": { @.": "ViewAction", "target": "https://github.com/nilsteampassnet/TeamPass/issues/3074#issuecomment-1066504844", "url": "https://github.com/nilsteampassnet/TeamPass/issues/3074#issuecomment-1066504844", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.": "Organization", "name": "GitHub", "url": "https://github.com" } } ]