Textpattern CMS

#1 2022-06-03 10:02:05

Vienuolis

Member

From: Vilnius, Lithuania

Registered: 2009-06-14

Posts: 307

Website GitHub GitLab Twitter

Relocation failure

I made all backups and moved my live website (Textpattern 4.8.8 with MySQL 5.7, PHP 8.1.5) to another computer. The site looks and works correctly in a new location now, but on a public front-end only. The back-end responded by an error message:

PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user ‘az’@‘localhost’ (using password: YES) in /usr/home/vlap/6v/az/textpattern/lib/txplib_db.php:247|Stack trace:|#0 /usr/home/vlap/6v/az/textpattern/lib/txplib_db.php(247): mysqli_real_connect()|#1 /usr/home/vlap/6v/az/textpattern/lib/txplib_db.php(288): DB->__construct()|#2 /usr/home/vlap/6v/az/textpattern/index.php(63): include(‘…’)|#3 {main}| thrown in /usr/home/vlap/6v/az/textpattern/lib/txplib_db.php on line 247

/usr/home/vlap/6v/az/ is a webroot there (alt. html_public). A changed database user’s password in both Adminer and Textpattern setup.php did not help. Then I removed config.php and uploaded a new setup directory from 4.8.8 distribution to start in a browser for fresh installation:

Fatal error: Uncaught Error: Call to undefined function filter_var() in /usr/home/vlap/6v/az/textpattern/lib/txplib_html.php:1188 Stack trace: #0 /usr/home/vlap/6v/az/textpattern/lib/txplib_html.php(881): popHelp() #1 /usr/home/vlap/6v/az/textpattern/setup/index.php(322): inputLabel() #2 /usr/home/vlap/6v/az/textpattern/setup/index.php(145): step_getDbInfo() #3 {main} thrown in /usr/home/vlap/6v/az/textpattern/lib/txplib_html.php on line 1188

Maybe some PHP modules are missing? I have installed (and enabled) json, intl, mbstring, mysqli, xml, simplexml, zip and zlib — mentioned in system requirements.

#2 2022-06-03 11:33:01

etc

Developer

Registered: 2010-11-11

Posts: 5,053

Website GitHub

Re: Relocation failure

Could it be that filter extension is disabled?

---

bloatware

#3 2022-06-03 12:04:53

gaekwad

Server grease monkey

From: People's Republic of Cornwall

Registered: 2005-11-19

Posts: 4,137

GitHub

Re: Relocation failure

etc wrote #333519:

Could it be that filter extension is disabled?

In the absence of a doc (also known as 202 on the issues list), make a file in your web root called checkforfilter.php, with the following:

<?php phpinfo( ); ?>

…and access it from your browser. It will show diagnostics for PHP, and you are checking for a heading called filter. It has a setting – “Input Validation and Filtering” – which will be enabled or disabled.

Edit: delete the checkforfilter.php when you’re done.

Last edited by gaekwad (2022-06-03 12:18:05)

---

Textpattern CMS demo – tech updates

#4 2022-06-03 15:59:04

Vienuolis

Member

From: Vilnius, Lithuania

Registered: 2009-06-14

Posts: 307

Website GitHub GitLab Twitter

Re: Relocation failure

Neither ‘filtering’ nor ‘validation’ words exists in phpinfo() report, although ‘Input Filter’ mentioned at the bottom of a page as a credit to its authors, thank you for the hint.

How could I add this extension (FreeBSD 13.1-RELEASE amd64)?

#5 2022-06-03 16:05:38

Vienuolis

Member

From: Vilnius, Lithuania

Registered: 2009-06-14

Posts: 307

Website GitHub GitLab Twitter

Re: Relocation failure

pkg install php81-filter

Installed successfully, it works, thank you very much!