site error after upgrade 4.6.1

monicahu · 2016-10-16 07:52:18

The site has not been accessed for a year and not updated for two years and it had an error after when I login to the admin site after the upgrade ie copying all necessary files over:

Fatal error: Call to undefined function mysqli_init() in /home/stpetesy/public_html/textpattern/lib/txplib_db.php on line 201

My site URL is www.stpetesyouth.org.au

According to the cPanel:
Apache Version 2.2.31
PHP Version 5.5.29
MySQL Version 5.5.52-cll

I don’t have good knowledge with Apache, PHP and MySQL.

Can anyone help?

Thanks,

Monica

monicahu · 2016-10-16 08:00:04

Is the PHP version too low to support TXP 4.6.1 ?

etc · 2016-10-16 10:25:32

monicahu wrote #302220:

Is the PHP version too low to support TXP 4.6.1 ?

No, php 5.5 is ok. It is possible (though uncommon) that mysqli extension is disabled on your server, please check.

monicahu · 2016-10-16 10:44:50

No, php 5.5 is ok. It is possible (though uncommon) that mysqli extension is disabled on your server, please check.

I don’t know how to check this. I have cpanel login and I have access to phpMyAdmin.

The trouble is I don’t have any other access besides the cPanel.

Last edited by monicahu (2016-10-16 10:54:16)

etc · 2016-10-16 10:57:12

Hmm, then we need someone experienced with cPanel… anyone?

monicahu · 2016-10-16 11:30:52

txplib_db.php on TXP 4.5.7 (dated April 2012) does not have msqli calls for database connection, so is this new from 4.6.1?

Bloke · 2016-10-16 11:41:39

Yes, mysqli is new to Txp 4.6.0+. Can you upload a file called serverinfo.php to your site root with this content in it:

<?php
   phpinfo();
?>

Then visit www.stpetesyouth.org.au/serverinfo.php and have a look through the output. You’re looking for the mysqli extension to see if it’s enabled/installed. If not, contact your host and ask if it can be enabled.

And delete the serverinfo.php as soon as you’re done looking, as it’s a potential security leak.

monicahu · 2016-10-18 10:04:48

Bloke wrote #302233:

Yes, mysqli is new to Txp 4.6.0+. Can you upload a file called serverinfo.php to your site root with this content in it:

<?php...

Then visit www.stpetesyouth.org.au/serverinfo.php and have a look through the output. You’re looking for the mysqli extension to see if it’s enabled/installed. If not, contact your host and ask if it can be enabled.

Followed your instruction and got this error:
Warning: phpinfo() has been disabled for security reasons in /home/stpetesy/public_html/serverinfo.php on line 2

Bloke · 2016-10-18 10:29:20

monicahu wrote #302274:

Warning: phpinfo() has been disabled for security reasons

Oh joy! Well that’s me fresh out of ideas. Anyone else?

colak · 2016-10-18 11:04:06

Hi monicahu,

You can your reach your diagnostics and do they reveal anything? Alternatively you could get in touch with your host to send you the phpinfo. Do tell them that you have problems with upgrating your software and you need it to diagnose where the problem might be.

Bloke · 2016-10-18 11:25:21

colak wrote #302276:

You can your reach your diagnostics and do they reveal anything?

I doubt it. If mysqli is not available (as the error messages indicate in this case), that’s pretty fundamental and would just abort any site page, admin or public side. Seems like a paranoid host that has either:

a) Enabled only PDO; or
b) Kept mysql_* only calls and turned off mysqli_ calls (for “security”?!?)

I was hoping to prove one or both of the above via phpinfo(), but it appears even that’s too dangerous for the hosting provider.

gaekwad · 2016-10-18 16:14:05

Bloke wrote #302275:

Oh joy! Well that’s me fresh out of ideas. Anyone else?

Setting the Textpattern Diagnostics to High spits out the loaded PHP and Apache modules.

You’re looking for something like this:

PHP extensions: Core/5.5.9-1ubuntu4.20, date/5.5.9-1ubuntu4.20, ereg, libxml, openssl, pcre, zlib/2.0, bcmath, bz2, calendar, ctype, dba, dom/20031129, hash/1.0, fileinfo/1.0.5-dev, filter/0.11.0, ftp, gettext, SPL/0.2, iconv, mbstring, session, posix, Reflection/$Id: 31d836a7ac92a37b5c580836d91ad4736fe2f376 $, standard/5.5.9-1ubuntu4.20, shmop, SimpleXML/0.1, soap, sockets, Phar/2.0.2, exif/1.4 $Id$, sysvmsg, sysvsem, sysvshm, tokenizer/0.1, wddx, xml, xmlreader/0.1, xmlwriter/0.1, zip/1.11.0, apache2handler, PDO/1.0.4dev, gd, json/1.3.2, mysql/1.0, mysqli/0.1, pdo_mysql/1.0.2, readline/5.5.9-1ubuntu4.20, mhash, Zend OPcache/7.0.3FE

Check the list for mysqli.

Textpattern CMS

Textpattern CMS support forum

#1 2016-10-16 07:52:18