Unknown column 'a.ordering' in 'order clause'

Unknown column 'a.ordering' in 'order clause'

10 months 4 weeks ago #1927 by Jaime Arevalo

Hello.
I have made somes updates to my component and I working in the test localhost, the instalation is really fine, no problem, but when I start back end it's not working joomla show me: "Unknown column 'a.ordering' in 'order clause'", it's only with my "component creator" component, and in front end , I have the error 403, it's normal because I can't make the setup for this component.
Could you Help me?
Thank you.
Jaime

Please Log in or Create an account to join the conversation.

10 months 3 weeks ago #1928 by Jaime Arevalo

Sol. I must add to each table field ordering.

The following user(s) said Thank You: JAYESH RAUT

Please Log in or Create an account to join the conversation.

10 months 3 days ago #2002 by David Romero

What did you do to resolved this? I have been running into alot of issues with this tool recently.

Please Log in or Create an account to join the conversation.

9 months 3 weeks ago - 9 months 3 weeks ago #2010 by Yetis

Yo lo e resuelto así
site\models\tuarchivo.php
// parent::populateState('a.ordering', 'asc');
administrator\views\tuarchivo\tmpl\default.php
// $ordering = ($listOrder == 'a.ordering');
administrator\models\tuarchivo.php
// parent::populateState('a.ordering', 'asc');

Please Log in or Create an account to join the conversation.

4 months 2 days ago #2137 by JAYESH RAUT

Solution:
Add to the table a field called "ordering" of type INT with default value '0' and width as 11.

Please Log in or Create an account to join the conversation.

Time to create page: 0.149 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.