Unknown column 't_c_title.text_original' in 'order clause
Posted
#1003
(In Topic #214)

Standard member

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)
- 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
My Composr World is here>> https://composr.internetblogger.de
MainBlog>> Internetblogger - Bloggen im Internet
Posted

Site director

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
- 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.
Posted

Standard member

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
My Composr World is here>> https://composr.internetblogger.de
MainBlog>> Internetblogger - Bloggen im Internet
1 guest and 0 members have just viewed this.