pgrouting php problem "pg_fetch_result(): Unable to jump to row 0 on PostgreSQL resul
I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some modification to the PHP script so it can be used for my version. Here are the php code:
I only modified the php code so it matches the postgis 2.x function and my own road network database. When I get into firefox and tried to compute the route, I got this error from Firebug:
pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3Am I missing something?The route ran normally in QGIS DB Manager and pgAdmin.
glad to have a suggestion from you all
regards
UPDATE(3:22 pm GMT+7): I rebuilt my whole system, installing PostgreSQL 8.4, PostGIS 1.5, and pgrouting 1.x, using the original tutorial it still gave me the same error. I'm using openlayers as my map renderer.
أكثر...
I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some modification to the PHP script so it can be used for my version. Here are the php code:
I only modified the php code so it matches the postgis 2.x function and my own road network database. When I get into firefox and tried to compute the route, I got this error from Firebug:
pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3Am I missing something?The route ran normally in QGIS DB Manager and pgAdmin.
glad to have a suggestion from you all
regards
UPDATE(3:22 pm GMT+7): I rebuilt my whole system, installing PostgreSQL 8.4, PostGIS 1.5, and pgrouting 1.x, using the original tutorial it still gave me the same error. I'm using openlayers as my map renderer.
أكثر...