×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Unknown column 'a.ordering' in 'order clause'
Simon Beekman
Gæst
4 år 9 måneder siden #9678
af Simon Beekman
Besvaret af Simon Beekman på emne Unknown column 'a.ordering' in 'order clause'
I have forwarded this to our technical department and will get back to you soon!
Venligst Log på eller Opret en konto for at deltage i samtalen
Simon Beekman
Gæst
4 år 9 måneder siden #9679
af Simon Beekman
Besvaret af Simon Beekman på emne 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
If this issue persists, please submit this as an issue on Github
Venligst Log på eller Opret en konto for at deltage i samtalen
JAYESH RAUT
New Member
Posts: 1
4 år 9 måneder siden #9680
af JAYESH RAUT
Besvaret af JAYESH RAUT på emne 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.
Venligst Log på eller Opret en konto for at deltage i samtalen
Márton Feövenyessy
New Member
Posts: 1
4 år 9 måneder siden #9690
af Márton Feövenyessy
Besvaret af Márton Feövenyessy på emne 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 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.
Følgende bruger(e) sagde tak: Simon Beekman
Venligst Log på eller Opret en konto for at deltage i samtalen
Tid til at oprette siden: 0.059 sekunder