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

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
ccapon
Newcomer
Posts: 7
Joined: Tue Jan 10, 2017 4:02 pm
Canada

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

Post 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
Last edited by ccapon on Thu Feb 22, 2018 3:19 pm, edited 1 time in total.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

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

Post 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
ccapon
Newcomer
Posts: 7
Joined: Tue Jan 10, 2017 4:02 pm
Canada

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

Post 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?
ccapon
Newcomer
Posts: 7
Joined: Tue Jan 10, 2017 4:02 pm
Canada

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

Post 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.
RobertWatson
Newcomer
Posts: 1
Joined: Mon Sep 10, 2018 11:03 pm
Australia

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

Post by RobertWatson »

Thanks @ccapon

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

Many thanks.
dantheperson
Newcomer
Posts: 1
Joined: Sat Apr 18, 2020 8:23 pm
New Zealand

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

Post 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
Post Reply