I am using postgres 9.0.3 and drupal-6.22.
After installing the services module, clicking on Administration is showing me the following error message.

warning: pg_query(): Query failed: ERROR: column "%services%" does not exist LINE 1: ...s_endpoint AS se WHERE se.authentication NOT LIKE "%services... ^ in D:\ms4w\Apache\htdocs\drupal6\includes\database.pgsql.inc on line 138.
user warning: query: SELECT * FROM services_endpoint AS se WHERE se.authentication NOT LIKE "%services%" in D:\ms4w\Apache\htdocs\drupal6\sites\all\modules\services\services.install on line 100.

I see a php error being reported in the Reports -> Recent log entries

Comments

kylebrowning’s picture

kylebrowning commented
Priority: Normal » Minor

THis seems to be an issue with the SQL I wrote, its not postgres friendly. :(

however its just a checking to see if you have authentication enabled for services or not, So nothing should be messed up with your Services Site.

kylebrowning’s picture

kylebrowning commented

I think this just needs single quotes instead of double, but I havnt checked. as I don't have postgress setup. On services.install on line 100. can you change the "services" to 'services' and let me know if that works.

kylebrowning’s picture

kylebrowning commented
Version: 6.x-3.0-rc2 » 6.x-3.x-dev
Status: Active » Closed (fixed)

This should be fixed in rc3