Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

monicahu
Member
From: Sydney NSW
Registered: 2009-03-07
Posts: 69

site error after upgrade 4.6.1

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


Monica
Life with God is the purpose.

Offline

#2 2016-10-16 08:00:04

monicahu
Member
From: Sydney NSW
Registered: 2009-03-07
Posts: 69

Re: site error after upgrade 4.6.1

Is the PHP version too low to support TXP 4.6.1 ?


Monica
Life with God is the purpose.

Offline

#3 2016-10-16 10:25:32

etc
Developer
Registered: 2010-11-11
Posts: 5,028
Website GitHub

Re: site error after upgrade 4.6.1

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.

Offline

#4 2016-10-16 10:44:50

monicahu
Member
From: Sydney NSW
Registered: 2009-03-07
Posts: 69

Re: site error after upgrade 4.6.1

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)


Monica
Life with God is the purpose.

Offline

#5 2016-10-16 10:57:12

etc
Developer
Registered: 2010-11-11
Posts: 5,028
Website GitHub

Re: site error after upgrade 4.6.1

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

Offline

#6 2016-10-16 11:30:52

monicahu
Member
From: Sydney NSW
Registered: 2009-03-07
Posts: 69

Re: site error after upgrade 4.6.1

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?


Monica
Life with God is the purpose.

Offline

#7 2016-10-16 11:41:39

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: site error after upgrade 4.6.1

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.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#8 2016-10-18 10:04:48

monicahu
Member
From: Sydney NSW
Registered: 2009-03-07
Posts: 69

Re: site error after upgrade 4.6.1

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


Monica
Life with God is the purpose.

Offline

#9 2016-10-18 10:29:20

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: site error after upgrade 4.6.1

monicahu wrote #302274:

Warning: phpinfo() has been disabled for security reasons

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


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#10 2016-10-18 11:04:06

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: site error after upgrade 4.6.1

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.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#11 2016-10-18 11:25:21

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: site error after upgrade 4.6.1

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.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#12 2016-10-18 16:14:05

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: site error after upgrade 4.6.1

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.

Offline

Board footer

Powered by FluxBB