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
| Comment | File | Size | Author |
|---|---|---|---|
| Domains.png | 54.58 KB | imDhaval |
Comments
Comment #1
agentrickardThis is a bug in a query from domain_geolocalization. What page does this occur on?
I suspect this is in hook_domainview().
Not sure why the syntax is USING() instead of ON this = that. Looks like an API error.
Comment #2
agentrickardWhat 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:
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.
Comment #3
imDhaval commentedi 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....
Comment #4
agentrickardIt'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?
Comment #5
imDhaval commentedthis error occurs on domain's page at admin/buid/domains.
Comment #6
agentrickardYes, 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.