Database update fails

If you aren't speaking german, you can ask for support or post your request here.
Antworten
Rolf_L
Beiträge: 5
Registriert: 12. Jun 2022, 21:05

Database update fails

Beitrag von Rolf_L »

When trying to update from v. 4.0.12 to v. 4.1.12 user credentials are confirmed during database update but the admin user is said not to be a member of the organization (see attachment). There is only one organization on the server, and only one administrator, and the admin account works otherwise and is definitely a member of the organization.
admidio_error.PNG
admidio_error.PNG (17.99 KiB) 3823 mal betrachtet

Is this a known problem? Server is running on Debian 4.19 with PHP 7.3.31 and Postgres 11.13.
Could perhaps the non-ascii letter "ö" in the organization name be an issue here?

/ Rolf
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: Database update fails

Beitrag von fasse »

Hi Rolf,

unfortunaly we don't know this problem until now.

Which version of PHP are you using?

Could you please replace the unzipped file of this message to the folder adm_program/system/classes and perform the update after that again. Does it now work?

Best regards
Fasse
Rolf_L
Beiträge: 5
Registriert: 12. Jun 2022, 21:05

Re: Database update fails

Beitrag von Rolf_L »

Hi Fasse,

Thanks for quick reply!

PHP version is 7.3.31.

Hm, can't see the zip file. Could you please upload again?

Best regards,

Rolf
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: Database update fails

Beitrag von fasse »

Oh sorry :(
Dateianhänge
User.php.zip
(16.98 KiB) 139-mal heruntergeladen
Rolf_L
Beiträge: 5
Registriert: 12. Jun 2022, 21:05

Re: Database update fails

Beitrag von Rolf_L »

Tested now, but unfortunately the same result. Could it be Postgres related? I noticed when I started using the previous version (4.0.12) that member name searches unexpectedly had become case sensitive.

/ Rolf
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: Database update fails

Beitrag von fasse »

Hi Rolf,

it could be a problem with postgreSQL. But in my tests it works.

But anyway you could disable the registration for update bei setting the parameter $gLoginForUpdate in the config.php.
https://www.admidio.org/dokuwiki/doku.p ... config.php

After the update you could remove the parameter.

Fasse
Rolf_L
Beiträge: 5
Registriert: 12. Jun 2022, 21:05

Re: Database update fails

Beitrag von Rolf_L »

Hi Fasse,

After changing registration for update it was possible to continue with database upgrade - thanks for the tip!

Searches remain case sensitive (search for "peter" gives no hits, search for "Peter" gives several hits). Is that intentional?

And one more concerning oddity: Edit lists opens a blank page, so no way to configure lists.

Rolf
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: Database update fails

Beitrag von fasse »

Because of the blank page could you have a look at a php errorpage?
Rolf_L
Beiträge: 5
Registriert: 12. Jun 2022, 21:05

Re: Database update fails

Beitrag von Rolf_L »

Right, I'll see if I can get some time this weekend for that. I'll try the new 4.1.13 release as well and see if it solves the search issue!

/ Rolf
Antworten