[Solved] PostgreSQL issue

[parcela2]

I have been used Tommy server a year and use postgreSQL database under PHP web.

 

Recently i changed my domain from .tk to .red and I'm experiencing problems with functions pgsql in PHP.

 

The principal:

 

After closing a pgsql connection with:

 

pg_close($dbconn);

 

the php die and stops all with this instruction even if the connection with db is successfull.

 

Before change my domain, this issue did not appear.

 

an example:

 

https://www.laparcela.red/control/test.php

 

After "Conectado con éxito" there are a echo "Hola mundo" and not appears.

 

This also happens if the connection is not correct.

$dbconn = pg_connect("host=localhost .. etc)
   or die("No se pudo conectar");
echo "Conectado con éxito";
pg_close($dbconn);
echo '<p>Hola Mundo</p>';

or die not works.

 

 

 

[Luigi123]

Moved to Customer Service.

[Krydos]

Which version of php are you using?

[parcela2]

Php 5.6, the same that the other domain.

 

I think that the problem is the domain change.

Any registry are configured to .tk

 

to vew:

 

https://www.laparcela.red/info.php

 

 

Here is the same script

 

 

http://www.valiantz.es/test.php

with a other info php to compare

http://www.valiantz.es/info.php

Edited December 29, 2017 by parcela2

[Krydos]

What happens when you switch laparcela.red to php 7.1 too?

[parcela2]

The same, ant the last version not have pgsql, i think that the 7.2

 

It is very strange, somethong is wrong since the domain change

[Krydos]

laparcela.red still shows 5.6 for me.

[parcela2]

Yes yes, i say that the 7.2 version not have pgsql and with 7.1 the problem is the same.

 

Today i tested it to change versions

Edited December 29, 2017 by parcela2

[parcela2]

There are any solution possible?

 

I think that is general and if someone change the domain, suffers the same.

 

Maybe restarting the web space will solve the problem.

[Krydos]

I was just waiting for you to change the php of parcela.red to 7.1.

[parcela2]

Executed

[Krydos]

Weird, now it's doing a segmentation fault and dumping cores...

[parcela2]

I see:

core.31616

core.26912

core.25142

 

That is the problem. The system fails for something.

 

Something is wrong.

[parcela2]

The dumping cores are PHP generated or other platform?

[Krydos]

The problem is the pg_close() for some reason. If you comment that out it works https://www.laparcela.red/control/test.php