Elxis CMS Forum

Support => Administration => Topic started by: rentasite on January 07, 2009, 02:58:16

Title: mysql Error [1054] on com_login [solved]
Post by: rentasite on January 07, 2009, 02:58:16

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 ]}

Title: Re: mysql Error [1054] on com_login
Post by: datahell on January 07, 2009, 09:12:18

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!

Title: Re: mysql Error [1054] on com_login
Post by: rentasite on September 15, 2009, 10:02:32

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?  :)

Title: Re: mysql Error [1054] on com_login
Post by: rentasite on September 15, 2009, 10:15:09

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]

Title: Re: mysql Error [1054] on com_login
Post by: datahell on September 15, 2009, 14:35:28

I am checking it right now. Please wait.

-- EDIT REMOVED --

Title: Re: mysql Error [1054] on com_login
Post by: rentasite on September 15, 2009, 17:21:38

Quote from: datahell on September 15, 2009, 14:35:28

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!  :-\

Title: Re: mysql Error [1054] on com_login
Post by: datahell on September 15, 2009, 19:42:03

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?

Title: Re: mysql Error [1054] on com_login
Post by: rentasite on September 15, 2009, 21:32:40

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

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!