0
Welcome Guest! Login
0 items Join Now

SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    • Helvecio's Avatar
    • Helvecio
    • Jr. Rocketeer
    • Posts: 28
    • Thanks: 0

    SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • In the List Layouts parameters of a menu item, I changed the Article Order to Author Alphabetical.
      After saving, links got to an Error page with 1054 error: Unknown column ‘u.name’ in ‘order clause’ in the title.
      Is there anything that can be done about it?
      I was googling around and noticed this issue has been happening for some years.
      Thank you!
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13481
    • Web Designer/Developer

    Re: SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • Try extensions manager > database > FIX button.

      Regards, Mark.
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    • Helvecio's Avatar
    • Helvecio
    • Jr. Rocketeer
    • Posts: 28
    • Thanks: 0

    Re: SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • It didn't work.

      Thank you!
    • Helvecio's Avatar
    • Helvecio
    • Jr. Rocketeer
    • Posts: 28
    • Thanks: 0

    Re: SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • This issue comes up only when I choose either Author options.
      I enclosed a printscreen of the page when it's OK and when it's not.
      Note that it also loses all its formatting, besides not displaying the content.
      This image is hidden for guests.
      Please log in or register to see it.

      This is the page when it is OK
      This image is hidden for guests.
      Please log in or register to see it.

      This is the page when it is NOT OK
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13481
    • Web Designer/Developer

    Re: SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • Please note that this is a Joomla issue rather than anything RT related so you should report the error to Joomla.

      Regards, Mark.
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    • Helvecio's Avatar
    • Helvecio
    • Jr. Rocketeer
    • Posts: 28
    • Thanks: 0

    Re: SOLVED 1054 error: Unknown column 'u.name' in 'order clause'

    Posted 6 years 11 months ago
    • Thank you!

      I have reported it.

Time to create page: 0.049 seconds