× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

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

5 years 11 months ago #1927 by Jaime Arevalo
Unknown column 'a.ordering' in 'order clause' was created 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.

5 years 11 months ago #1928 by Jaime Arevalo
Replied by Jaime Arevalo on topic Unknown column 'a.ordering' in 'order clause'
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.

5 years 10 months ago #2002 by David Romero
Replied by David Romero on topic Unknown column 'a.ordering' in 'order clause'
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.

5 years 10 months ago - 5 years 10 months 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');
Last edit: 5 years 10 months ago by Yetis.

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

5 years 4 months ago #2137 by JAYESH RAUT
Replied by JAYESH RAUT on topic Unknown column 'a.ordering' in 'order clause'
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.

4 years 9 months ago #9677 by Flips79
Replied by Flips79 on topic Unknown column 'a.ordering' in 'order clause'
I have the same problem, the solution here does not help!

Attachment CCAA233F-BD0C-4724-9093-1CFA78DAF5EC.png not found

Attachment 8A3F9ACF-A37B-4992-86A8-BD7788F44DB6.png not found

Attachments:

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

Time to create page: 0.056 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.