Search Postgresql Archives

Re: [OT] Postgresql and PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/23/2016 08:03 AM, Alessandro Baggi wrote:
Il 23/12/2016 16:52, David G. Johnston ha scritto:
On Fri, Dec 23, 2016 at 8:44 AM, Alessandro Baggi
<alessandro.baggi@xxxxxxxxx <mailto:alessandro.baggi@xxxxxxxxx>>wrote:

    $query = pg_query_params($dbcon, "SELECT count(*) from bs_ipsource
    where srcaddr = $1", array($ipsrc));
    if(!$query) { print error...}

    I don't understand why this query fails without error. I have
    searched error in httpd logs and postgresql log without success.

    from postgresql logs i get:

    LOG:  execute <unnamed>: SELECT count(*) from bs_ipsource where
    srcaddr = $1
    DETAIL:  parameters: $1 = '192.168.1.1'


​You might wish to explain how you've defined "fail" since there is no
actual error.

One common explanation is that the database psql is talking to, which
has the relevant data, is not the same database that PHP is talking to,
and which lacks matching data.

You might want to fire off one or more "host machine identification"​
queries in both just to confirm whether this is the case.

David J.


Hi David,
thanks for your answer.
I don't think that this is the problem.
Before the reported query I've other queries to the same db on other
tables and works without problem.

Then I've only this db and only this host.

Another thought, do you have this table in more then one schema and maybe you are running into a search_path issue:

https://www.postgresql.org/docs/9.5/static/runtime-config-client.html









--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux