i am using domain 6.x-2.6.
& i got these errors

user warning: Column 'domain_id' in from clause is ambiguous query: pager_query /* dhaval : pager_query */ SELECT COUNT(*) FROM domain d LEFT JOIN domain_user du ON du.domain_id = d.domain_id LEFT JOIN domain_toggle dt ON d.domain_id = dt.domain_id LEFT JOIN domain_geolocalization dg USING (domain_id) LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location dgl USING (dglid) in C:\xampp\htdocs\vivid\sites\all\modules\domain\domain.admin.inc on line 53.
user warning: Column 'domain_id' in from clause is ambiguous query: pager_query /* dhaval : pager_query */ SELECT d.*, du.uid, dt.open, dgl.latitude, dgl.longitude, dgl.radius, dg.gmap_key, dg.state_default, dgl.state, dgl.zipcode FROM domain d LEFT JOIN domain_user du ON du.domain_id = d.domain_id LEFT JOIN domain_toggle dt ON d.domain_id = dt.domain_id LEFT JOIN domain_geolocalization dg USING (domain_id) LEFT JOIN domain_geolocalization_location_instance USING (domain_id) LEFT JOIN domain_geolocalization_location dgl USING (dglid) ORDER BY d.domain_id ASC LIMIT 0, 25 in C:\xampp\htdocs\vivid\sites\all\modules\domain\domain.admin.inc on line 53.

i am using windows 7 & xampp,
my drupal setup is at C:\xampp\htdocs\vivid

### my setup for domain module ###
1.in my settings.php file i added this lines

/**
 * Add the domain module setup routine.
 */
include './sites/all/modules/domain/settings.inc';

2.in my hosts file (C:\Windows\System32\drivers\etc\hosts)
i added this lines

127.0.0.1 localhost
127.0.0.1 lab1.localhost
127.0.0.1 lab2.localhost

3.in my httpd-vhosts.conf file(C:\xampp\apache\conf\extra\httpd-vhosts.conf)
i added this lines


NameVirtualHost *
  <VirtualHost *>
    DocumentRoot "C:\xampp\htdocs"
    ServerName localhost
  </VirtualHost>
  
  <VirtualHost *>
    DocumentRoot "C:\xampp\htdocs"
    ServerName lab1.localhost
  <Directory "C:\xampp\htdocs">
    Order allow,deny
    Allow from all
  </Directory>
</VirtualHost>

<VirtualHost *>
    DocumentRoot "C:\xampp\htdocs"
    ServerName lab2.localhost
  <Directory "C:\xampp\htdocs">
    Order allow,deny
    Allow from all
  </Directory>
</VirtualHost>

----- so that's all what i did for domain module
is anything wrong that i diid or am i forgot something ?
plz tell me..
need help

CommentFileSizeAuthor
Domains.png54.58 KBimDhaval

Comments

agentrickard’s picture

Project: Domain » Domain GeoLocalization
Version: 6.x-2.6 » 6.x-1.2
Category: support » bug

This is a bug in a query from domain_geolocalization. What page does this occur on?

I suspect this is in hook_domainview().

      return "LEFT JOIN {domain_geolocalization} dg USING (domain_id) LEFT JOIN {domain_geolocalization_location_instance} USING (domain_id) LEFT JOIN {domain_geolocalization_location} dgl USING (dglid)";

Not sure why the syntax is USING() instead of ON this = that. Looks like an API error.

agentrickard’s picture

What database engine are you using? What version?

I'm specifically looking at this from http://dev.mysql.com/doc/refman/5.0/en/join.html:

 Join Processing Changes in MySQL 5.0.12

Beginning with MySQL 5.0.12, natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard. The goal was to align the syntax and semantics of MySQL with respect to NATURAL JOIN and JOIN ... USING according to SQL:2003. However, these changes in join processing can result in different output columns for some joins. Also, some queries that appeared to work correctly in older versions must be rewritten to comply with the standard. 

Note that Drupal core never uses the USING() syntax, which I suspect is for database portability. The hook_domainview() documentation sample clearly shows the proper use of ON.

imDhaval’s picture

i am using MySQL 5.0.51a

well i am new in drupal so one question that i want to ask u is ,
am i done proper settings for domain module? is anything missing?
plz tell me....

agentrickard’s picture

It's not anything you're doing wrong. It's a bug in one of the module's you are using.

Again, on what page does this error occur?

imDhaval’s picture

this error occurs on domain's page at admin/buid/domains.

agentrickard’s picture

Yes, then the line of code I have indicated is the cause of the problem. USING() is not supported syntax and should not be used here.

This is not a core Domain Access issue and needs to be fixed in Domain Geolocalization.