Cheap Web Space, Domain Name:
Web Space With E-Mail, PHP/MySQL.

What is the reason for „call to undefined function mysql_connect()”?

Question: 

Searching …

 

Unfortunately nothing found on "".

Premium support for Bitpalace web hosting customers only!

 in the United States (Chicago, IL): 1 (815) 526-7037, Fax (in Germany) +49 30 32 70 18 91

service@bitpalace.com 

Skype: bitpalast

One moment please … your browser is loading the page.

 

 

Symptom

When you run a script or install a software among other errors you might see a message „call to undefined function mysql_connect()“. The script stops, the software cannot be installed. This is the case for Piwik installations from the application repository, for example.

 

Cause

In the past, PHP had two MySQL extensions: MySQL and MySQLi. The “I” in “MySQLi” stands for “improved”. MySQLi is the better, faster and more versatile PP extension to communication with MySQL databases. In PHP 7.0 the old MySQL extensions was completely removed. Now only the MySQLi extension is available. The PHP function “mysql_connect()” is unavailable, because your web space is using a PP version newer than 5.6. Many old scripts are still using the outdated MySQL extension. For that reason they will not work with newer PHP versions.

 

Solution

Depending on the situation there are different approaches to resolve the issue:

a) You can downgrade the PHP version in your web space control panel to version 5.6. To downgrade, click on the “PHP settings” icon and choose PHP version 5.6. It does not matter whether you select the FastCGI or FPM interface. FPM is recommended, because it is faster, and it is today’s default. Unfortunately it is less stable, too. After the downgrade it can take up to 15 minutes before the web server applies the changes.

b) When you are using a third-party software that still requires the outdated MySQL extension, ask the manufacturer, if they offer a newer version. Many manufacturers have updated their software so that it works with new PHP versions.

c) When you have developed your script on your own, we recommend to update all MySQL functions with the corresponding MySQL functions. This will ensure that your script will continue to work with future web hosting environments.

Newer PHP versions have big advantages over the old PHP 5.6 in terms of resource management and speed. Whereever possible you should prefer to update your scripts so that they work with new PHP versions instead of downgrading PHP to an old version.

 

Overview of frequently asked questions 

 

 

 


 

Additional Services

Starter Server: Affordable web server from  3.62 US$ () /month with PHP, database and many more 

Online Reservation System: Occupancy & vacancy schedule for any ressources (vehicles, sports facilities …) & guest houses, holiday apartments …  8.64 US$ () /month 

Software development: Development of database applications, programming and revision of computer programs & scripts  42.78 US$ () /hour 

 

FAQ – frequently asked questions 

 

Kiribati

Austria

Cameroon

Guinea

Pakistan

Colombia

Cuba

Antigua and Barbuda

Panama

Papua New Guinea

Jordan

Argentina

Costa Rica

Australia

Germany

Bahamas

Lesotho

Barbados

Belize

Paraguay

Tuvalu

Honduras

Peru

Madagascar

Bolivia

Botswana

Malawi

Chile

Philippines

India

Malta

Puerto Rico

Rwanda

Saint Kitts and Nevis

Samoa

Marshall Islands

Saint Vincent and the Grenadines

Zambia

Jamaica

Mauritius

Saint Lucia

Dominican Republic

Liberia

Switzerland

Mexico

Canada

Dominican Republic

Micronesia, Federated States of

Seychelles

Namibia

Ecuador

Sierra Leone

El Salvador

Fiji

Singapore

Gambia

Solomon Islands

Nauru

Spain

New Zealand

Sudan

Swaziland

Nicaragua

Nigeria

South Africa

Kenya

Ghana

Tanzania, United Republic of

Tonga

Guyana

Trinidad and Tobago

Uganda

Palau

Uruguay

Venezuela

Ireland

Grenada

Guatemala

United Kingdom

Zimbabwe

 

"Cheap Web Space": Affordable web space, cheap web server, low-cost webserver, low-price web servers: fast web server / small web server (cheap web space). Web server for private homepages / small website projects.

 in the United States (Chicago, IL): 1 (815) 526-7037 •  GmbH, Sensburger Allee 27, D-14055 Berlin (Germany)
Your purchase is tax-free, because you order from a non-EU country. © 2024  GmbH. All rights reserved. and the logo are registered trademarks of GmbH. For photo credits see imprint.

Imprint Privacy policy Sitemap