Hi,

I am using postgresql 8.2.7 version. When I enable the module I am getting these error messages. 

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "s" of relation "system" does not exist LINE 1: UPDATE system s SET s.weight = 86 WHERE s.name = 'ajax_u... ^ in /var/www/drupal_jq_ui/includes/database.pgsql.inc on line 139.
    * user warning: query: UPDATE system s SET s.weight = 86 WHERE s.name = 'ajax_ui' AND s.type = 'module' in /var/www/drupal_jq_ui/sites/all/modules/contrib/ajax/ajax_ui/ajax_ui.install on line 28.

The problem is Update query in postgresql do not accept alias for tables. I just removed alias for the system table in update queries, then it is working. Please find the attachment for this bug fix

CommentFileSizeAuthor
ajax_enable_module_bug_fix.patch1.5 KBpflame

Comments

brendoncrawford’s picture

brendoncrawford commented
Assigned: Unassigned » brendoncrawford
Priority: Critical » Normal
Status: Needs review » Fixed

Prajwala,

Thanks for your help. This has been fixed in 6.x-1.x-dev. Please allow up to 12 hours for dev package to update.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

GaneshDevdas’s picture

GaneshDevdas commented
Version: 6.x-1.9 » 6.x-1.14
Status: Closed (fixed) » Needs review

Hi guys,

Current version 6.x-1.14 from 2009-Apr-27 still have that issue.
I am using Postgres 8.3.7-1.
// there were required the very same changes in ajax/ajax.install and ajax/ajax_ui/ajax_ui.install

brendoncrawford’s picture

brendoncrawford commented

I think the drupal DB API has some way of dealing with this... Anyone have any suggestions?

brendoncrawford’s picture

brendoncrawford commented
Status: Needs review » Fixed

Ok, this should be fixed in dev now. Please allow up to 12 hours for dev to update, and please run "update.php" after installing.

Thanks for your feedback.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.