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

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

4 years 8 months ago #9678 by Simon Beekman
Replied by Simon Beekman on topic Unknown column 'a.ordering' in 'order clause'
I have forwarded this to our technical department and will get back to you soon!

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

4 years 8 months ago #9679 by Simon Beekman
Replied by Simon Beekman on topic Unknown column 'a.ordering' in 'order clause'
We are not able to replicate your issue.

If this issue persists, please submit this as an issue on Github

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

4 years 8 months ago #9680 by JAYESH RAUT
Replied by JAYESH RAUT on topic Unknown column 'a.ordering' in 'order clause'
I already figured out the solution, it requires us to add the default "order" column in the table.

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

4 years 8 months ago #9690 by Márton Feövenyessy
Replied by Márton Feövenyessy on topic Unknown column 'a.ordering' in 'order clause'
I had the same issue.
The problem was not the missing ordering field in my table.
I also had a foreign key field in my table, that was linked to Joomla users table.
This field had the checkbox 'Allow custom ordering' checked in Component Creator website, so after installation, joomla looked for the ordering field in its 'users' table, which does not have this field, thus it threw an error.
So I cleared the allow custom ordering checkbox, rebuilt the table, and everything was fine.
It took me half an hour, but finally found it by enabling site debugging in joomla control panel, so I could trace where the call is coming from.
I hope it helps someone. :)
The following user(s) said Thank You: Simon Beekman

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

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