I got this error after installing this module on a new drupal 6.4 system running mysql 4.1.22 and php5.4
# Server version: 4.1.22-standard
# Protocol version: 10
# Server: Localhost via UNIX socket
the module is:
; Information added by drupal.org packaging script on 2008-08-21
version = "6.x-1.x-dev"
core = "6.x"
project = "domain_geolocalization"
datestamp = "1219277001"

I got this error after installing the module:

user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 0 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.

Comments

irishgringo’s picture

irishgringo commented

also, after doing a DB update... to see what would happen, I got this error:

* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 0 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.
* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 1 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.
* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 2 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.
* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 3 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.
* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 4 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.
* user warning: Column 'domain_id' in where clause is ambiguous query: SELECT * FROM domain_geolocalization LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location USING (dglid) WHERE domain_id = 5 in /home/ajajacom/public_html/sites/all/modules/domain_geolocalization/domain_geolocalization.module on line 213.

jhedstrom’s picture

jhedstrom
Primary language English
Location Portland, OR
commented
Status: Active » Fixed

This is fixed in HEAD, and will be available from the download page once the packaging scripts run.

Thanks for the report.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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