×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Unknown column 'a.ordering' in 'order clause'
il y a 4 ans 8 mois #9690
par Márton Feövenyessy
Réponse de Márton Feövenyessy sur le sujet 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.
Connexion ou Créer un compte pour participer à la conversation.
Temps de génération de la page : 0.056 secondes