mysql Error [1054] on com_login [solved]

[rentasite]

I have created a Link - Component Item and i get this error:

mysql Error [1054] : EXECUTE
URI: index2.php?option=com_menus&menutype=footermenu&task=edit&id=174&hidemainmenu=1&type=component_item_link
Message: Unknown column 'a.link' in 'where clause'
SELECT name FROM elx_menu WHERE a.link = 'index.php?option=com_login'


_{Version     Elxis 2008.1 Stable rev2245 [ Nemesis ]}

[datahell]

OK,
open administrator/components/com_menus/component_item_link/component_item_link.class.php
go to line 49
Change this:
$query = "SELECT name FROM #__menu WHERE a.link = '".$temp[0]."'";
To this:
$query = "SELECT name FROM #__menu WHERE link = '".$temp[0]."'";

Thanks for the bug report!

[rentasite]

I got this error again on a   Elxis 2009.0 Stable rev2437 [ Pandora ]  installation.

Ok i will fix it as said above. Not fixed in the new release Gianni? 

[rentasite]

I think the above fix produces another error.

After that fix, whenever i select to create a new "Link - Component Item" i dont see the Elxis component items, but all the other menu items in which im trying to create the new item. See attachment.


[attachment deleted by admin]

[datahell]

I am checking it right now. Please wait.

-- EDIT REMOVED --

[rentasite]

Is it OK now?

Notice that if you wish to link to a component item there are specific item link menu types to choose from (ie, contact_item_link).

I did the fix but NO. I see Content items (articles) available    -   And yes as you said, i tried before to use straightly the Link - Contact Item but i get this error: https://forum.elxis.org/index.php?topic=3916.0#new

_{Elxis 2009.0 Stable rev2437 [ Pandora ]}

STRANGE! 

[datahell]

I removed the previous change. The script is fine. It shows you elxis components.

File: administrator/components/com_menus/component_item_link/component_item_link.class.php
line: 57
The original line was right:
."\n WHERE published = '1' AND type = 'components' ORDER BY menutype, name";

You confused me, what exactly you want to do?

[rentasite]

Had an idea to do a Fix Language and now its ok.   

today it's not my day, but who cares... going now for a fresh elxis installation (on the subdomain we were talking about yesterday)   

thnx!