Hi there,

the autocomplete box for the landing box is not working on my site. When I type in there anything, the blue circle is spinning - and nothing happens. I use i18n with lot's of multilanguage content btw.

I played around with some settings on the Assign from path group. But now I'm getting some error messages when I'm going to the admin/build/modules Site:

user warning: Column 'nid' in field list is ambiguous query: SELECT nid, title FROM node LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'de' WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL OR n.language = 'en' AND i18n.nid IS NULL) AND ( status = 1 AND (LOWER(title) LIKE LOWER('a%') OR nid = '0')) LIMIT 0, 10 in /sites/all/modules/autoassignrole/autoassignrole-admin.inc on line 395.

I think there are at least 10 or more similiar warning following.

I also tried to uninstall the module and activate it again. Does anyone have an idea what the problem is?

CommentFileSizeAuthor
#2 autoassign_error.PNG29.21 KBclashar

Comments

no2x’s picture

no2x commented

Oh, I figured out that at least one of these errors appear on any page - but only immediately after I tried to fill in something into the autocomplete box for the landing page (without saving!). After a refresh the warnings are gone.

clashar’s picture

clashar commented
StatusFileSize
new autoassign_error.PNG29.21 KB

for me the autocomplete for "User Register Node: " also doesn't work, blue circle also tries but finds nothing.

If I type directly the nid like [nid:284], then I get following error:

user warning: Unknown column 'n.language' in 'where clause' query: SELECT DISTINCT nid, title FROM node WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( status = 1 AND (LOWER(title) LIKE LOWER('notre%') OR nid = '0')) LIMIT 0, 10 in /home/bakpayev/public_html/paris.kz/emploi/sites/all/modules/autoassignrole/autoassignrole-admin.inc on line 395.

I tried both versions: 6.x-1.2 and latest 6.x-1.x-dev (2010-Sep-09)

giacinlui80’s picture

giacinlui80 commented

Hello, I also take a similar error, but I do not use i18n but the domain access.

Basically when I insert the path in the autocomplete field, I get the error and it don't save path that i set, how can I do??

Thanks

clashar’s picture

clashar commented

by the way, I do also use domain access and i18, but not sure if it domain access that cause this problem for me

jstrachan’s picture

jstrachan commented

I'm getting the same error as #2 on my site running i18n even though I'm using the 6.x-2.0-beta1 version.

I've delved into the code a bit and found the problem. I'll see if I can figure out how to roll a patch but here's the fix in the meantime:

autoassignrole-admin.inc - line 394
$sql = "SELECT nid, title FROM {node} WHERE status = 1 AND (LOWER(title) LIKE LOWER('%s%%') OR nid = '%d')";
change to:
$sql = "SELECT nid, title FROM {node} n WHERE status = 1 AND (LOWER(title) LIKE LOWER('%s%%') OR nid = '%d')";

This applies to both the 6.x-1.2 and 6.x-2.0-beta1 releases.

jstrachan’s picture

jstrachan commented

Sorry folks. I can't seem to figure out how to make a patch for this. The file in question doesn't appear to exist anymore in the repository. Hopefully someone with more Drupal dev experience can finish this off.

karlitos’s picture

karlitos commented

100000 thx jstrachan I was getting totally nuts with this issue!!