Page 1 of 1

!!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!! [Solved]

Posted: Sun Feb 18, 2018 5:25 pm
by ccapon
I've downloaded, built and installed the Debian build of 0.29 and am getting the above error from MythWEB. The rest of MythTV (backend, frontend) appear to be working properly.

The build created the .deb files and they install with no dependency errors. I've double-checked, and php-mysql is installed as well.

I'm not sure how to interpret the following messages. If anyone can help, I'd appreciate it.


Code: Select all

Warning: Failed to open translation file: modules_path/_shared/lang/English.lang in /usr/share/mythtv/mythweb/classes/Translate.php on line 176
Fatal Error
!!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!

    datetime:  2018-02-18 12:10:18 (EST)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!
    filename:  /usr/share/mythtv/mythweb/includes/php_version_check.php
  error line:  20

==========================================================================

Backtrace: 

    file:  /usr/share/mythtv/mythweb/includes/php_version_check.php
    line:  20
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => You are missing a php extension for mysql interaction. Please install php-mysqli or similar
    [1] => 256
)

    file:  /usr/share/mythtv/mythweb/includes/init.php
    line:  33
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/includes/php_version_check.php
)

    file:  /usr/share/mythtv/mythweb/mythweb.php
    line:  20
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/includes/init.php
)


==========================================================================

$_SESSION: Array
(
    [language] => English
)

==========================================================================

$_SERVER: Array
(
    [REDIRECT_STATUS] => 200
    [db_server] => localhost
    [db_name] => mythconverg
    [db_login] => mythtv
    [db_password] => mythtv
    [HTTP_HOST] => localhost
    [HTTP_CONNECTION] => keep-alive
    [HTTP_CACHE_CONTROL] => max-age=0
    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.119 Safari/537.36
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
    [HTTP_ACCEPT_ENCODING] => gzip, deflate, br
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.9
    [HTTP_COOKIE] => mythweb_id=ien23pm9d8oblquf6si1alvkm5; default-theme=ngax
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.4.29 (Debian) Server at localhost Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.4.29 (Debian)
    [SERVER_NAME] => localhost
    [SERVER_ADDR] => 127.0.0.1
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 127.0.0.1
    [DOCUMENT_ROOT] => /var/www/html
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
    [SERVER_ADMIN] => webmaster@localhost
    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
    [REMOTE_PORT] => 41308
    [REDIRECT_URL] => /mythweb/
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /mythweb/
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PHP_SELF] => /mythweb/mythweb.php
    [REQUEST_TIME_FLOAT] => 1518973817.975
    [REQUEST_TIME] => 1518973817
    [STATUS] => 200
    [URL] => /mythweb/
)

==========================================================================

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
)

Fatal error: Uncaught Error: Call to undefined function t() in /usr/share/mythtv/mythweb/modules/_shared/tmpl/default/footer.php:21 Stack trace: #0 /usr/share/mythtv/mythweb/modules/_shared/tmpl/_errors/fatal.php(43): require() #1 /usr/share/mythtv/mythweb/includes/errors.php(128): require_once('/usr/share/myth...') #2 [internal function]: error_handler(256, '!!NoTrans: You ...', '/usr/share/myth...', 20, Array) #3 /usr/share/mythtv/mythweb/includes/php_version_check.php(20): trigger_error('You are missing...', 256) #4 /usr/share/mythtv/mythweb/includes/init.php(33): require_once('/usr/share/myth...') #5 /usr/share/mythtv/mythweb/mythweb.php(20): require_once('/usr/share/myth...') #6 {main} thrown in /usr/share/mythtv/mythweb/modules/_shared/tmpl/default/footer.php on line 21

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!

Posted: Sun Feb 18, 2018 6:09 pm
by bill6502
Hi,

Assumes the above means: dpkg -l php-mysql leads looks similar to:

Code: Select all

ii  php-mysql          1:7.1+54ubuntu all            MySQL module for PHP [default]
and: locate -b '\mysqli.so' returns something like:

Code: Select all

/usr/lib/php/20160303/mysqli.so
You can also take a look at: #12835

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!

Posted: Sun Feb 18, 2018 8:31 pm
by ccapon

Code: Select all

sudo dpkg -l php-mysql
ii  php-mysql                   1:7.2+60           all                MySQL module for PHP [default]

locate -b '\mysqli.so'
/usr/lib/php/20170718/mysqli.so
Seems all there. Can there be a reason MythWEB doesn't find it?

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!

Posted: Wed Feb 21, 2018 5:29 pm
by bill6502

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!

Posted: Thu Feb 22, 2018 3:18 pm
by ccapon
For those who follow, I managed to get this running again by switching the version of PHP used by Apache2.

First, I constructed a phpinfo page and found my system was using an older version of php. I switched it to the newer version using these commands:

sudo a2dismod php7.0
sudo a2enmod php7.2
sudo systemctl restart apache2

Cheers, and thanks for your help.

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!! [Solved]

Posted: Mon Sep 10, 2018 11:10 pm
by RobertWatson
Thanks @ccapon

Your 3 lines of instructions fixed my problem. I too was running 7.0

Many thanks.

Re: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!! [Solved]

Posted: Sat Apr 18, 2020 8:27 pm
by dantheperson
Just want to add that this fix worked for me too after upgrading ubuntu 19.04 -> 19.10. Thanks

Code: Select all

sudo a2dismod php7.2
sudo a2enmod php7.3
systemctl restart apache2