1. Home
  2. Community
  3. General Questions
  4. Content module and TAG content

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Content module and TAG content

General Questions 916 This topic was started by ,


avatar
Rushian 0
From: -
Content module and TAG content

I don't know if it's just me (ie. the data in my database), but when I click the Content link I get an error:

Query: SELECT content_id, content_seo, content_title, content_description, content_keywords, content_text, content_tags, content_html, content_smilies, content_code, content_status, content_password, content_form, content_date, content_author, content_category FROM ct_esselbach_ct_content WHERE content_frontpage = '1' AND (content_status = '0' OR content_status = '3') AND (content_website = '0' OR content_website = '1') ORDER BY content_date DESC LIMIT 1

Error: 1054 Unknown column 'content_tags' in 'field list'

I don't know if it's related (the error does mention 'content_tags'), but all the tags return an empty page when I click on one.

Both of these had been in Preview 3, but I didn't have time to post about it.

I updated Preview 3 over Preview 2, and updated Preview 4 over Preview 3. I also used the Acquire function to pull in news and comments from my CT install (which worked fine.. I'm guessing.. ie. no errors were reported during/after the import )

Update: I also get an error in the admin CP when I try to manage the content:
Query: SELECT content_website, content_category, content_frontpage, content_title, content_seo, content_description, content_keywords, content_tags, content_rawtext, content_html, content_smilies, content_code, content_status, content_password, content_form FROM ct_esselbach_ct_content WHERE content_id = '1'

Error: 1054 Unknown column 'content_tags' in 'field list'

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Content module and TAG content
avatar
OP 0
From: -
Content module and TAG content

Originally posted by Philipp:
I made the change, and clicking on the link from the front end "works", but it comes back "Error: This page is empty or not available", but it I go to manage content from the Admin CP, I can see the page and can edit/preview it.

You need to check "Make this my new front page" to show a page as front page.

I don't want it as my front page, just to be able to access it when I follow the links without an error..


One more thing, I can see raw HTML in the Overview preview, which I can manually edit to fix, but was auto-inserted by CT the first time the article was added I guess...

Did you used HTML tags on that page?

Yes, I used raw HTML in the document.


Also, is there a way to rebuild my tags pages? They all still come up blank. I can edit the actual tag text, but nothing else. Dunno if it matters, but I have a lot of tags (over 600) that CT auto-generated. Interestingly too, the first tag has ID #467 and it goes up to #1080.. Dunno if that matters..

This is a bug that I catched yesterday as well. Both the content and news tags pages are calling a function that is no longer there. This is fixed in the next release.

Ok, good to know.
1 Re: Content module and TAG content
avatar
Administrator
1340
From: Vienna, Austria
Content module and TAG content

I made the change, and clicking on the link from the front end "works", but it comes back "Error: This page is empty or not available", but it I go to manage content from the Admin CP, I can see the page and can edit/preview it.

You need to check "Make this my new front page" to show a page as front page.

One more thing, I can see raw HTML in the Overview preview, which I can manually edit to fix, but was auto-inserted by CT the first time the article was added I guess...

Did you used HTML tags on that page?

Also, is there a way to rebuild my tags pages? They all still come up blank. I can edit the actual tag text, but nothing else. Dunno if it matters, but I have a lot of tags (over 600) that CT auto-generated. Interestingly too, the first tag has ID #467 and it goes up to #1080.. Dunno if that matters..

This is a bug that I catched yesterday as well. Both the content and news tags pages are calling a function that is no longer there. This is fixed in the next release.
1 Re: Content module and TAG content
avatar
OP 0
From: -
Content module and TAG content

I made the change, and clicking on the link from the front end "works", but it comes back "Error: This page is empty or not available", but it I go to manage content from the Admin CP, I can see the page and can edit/preview it.

If I click on the Overview link from the breadcrumb trail, I then get the article title, which I can click and it will display the content.

One more thing, I can see raw HTML in the Overview preview, which I can manually edit to fix, but was auto-inserted by CT the first time the article was added I guess...

Also, is there a way to rebuild my tags pages? They all still come up blank. I can edit the actual tag text, but nothing else. Dunno if it matters, but I have a lot of tags (over 600) that CT auto-generated. Interestingly too, the first tag has ID #467 and it goes up to #1080.. Dunno if that matters..
1 Re: Content module and TAG content
avatar
Administrator
1340
From: Vienna, Austria
Content module and TAG content

Yes, this was a problem in the upgrade script.

Run the following query in phpMyAdmin to fix this problem:
ALTER TABLE ct_esselbach_ct_content ADD content_tags text AFTER content_keywords;

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.