Unknown column 't_c_title.text_original' in 'order clause

Post

Posted
Rating:
#1003 (In Topic #214)
Avatar
Standard member
Alex L is in the usergroup ‘Fan in action’

I get this error when editing a catalog

Hello Developers,

I have made an update to Composr 10 RC 16 today and wanted to deal with the catalog. 4 catalogs shows me the Composr system, but I can not edit it.

I will receive this error on the Dashboard.

Code (php)

  1. Unfortunately a query has failed [SELECT c.* FROM cms_catalogues c ORDER BY t_c_title.text_original DESC LIMIT 400]  [Unknown column 't_c_title.text_original' in 'order clause'](version: 10 RC16, PHP version: 5.6.23-nmm1, URL: /cms/composr/cms/cms-catalogues/edit_catalogue.htm?keep_gallery_root=root)


Can anyone help to solve the problem myself?

Thanks in advance.

Bloggers, forum administrators, wiki writers, and have fun with OpenSource CMS like the Composr CMS or other OpenSource/FlatFile CMS.
My Composr World is here>> https://composr.internetblogger.de
MainBlog>> Internetblogger - Bloggen im Internet
Online now: No Back to the top

Post

Posted
Rating:
#1004
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Hi,

This file will fix the issue:
https://raw.githubusercontent.com/ocproducts/composr/master/sources/catalogues.php

A new RC will also be out soon.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#1005
Avatar
Standard member
Alex L is in the usergroup ‘Fan in action’
Hi,
simply awesome and it has just worked very well with me. Thank you for your quick help :)

Bloggers, forum administrators, wiki writers, and have fun with OpenSource CMS like the Composr CMS or other OpenSource/FlatFile CMS.
My Composr World is here>> https://composr.internetblogger.de
MainBlog>> Internetblogger - Bloggen im Internet
Online now: No Back to the top
1 guest and 0 members have just viewed this.
Back to Top