Kunena 5.2.4 and Blue eagle 1.6.4 released (04 Apr 2021)

The Kunena team has announce the arrival of Kunena 5.2.4 [K 5.2.4] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.2 and issues discovered during the development stages of K 5.2.4

Blue Eagle 1.6.x requires Kunena 5.2.x to work with, this template isn't designed to works with Bootstrap 3 and Bootstrap 4.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Question Need help with mysql query

8 years 11 months ago #1 by Baze
I'd appreciate if anyone here keen with mysql help me out.

i need to copy the data from the intro text into the full text in each article except those from one category (id=88)

Basically, I'm trying to copy all data from the "introtext" field into the "fulltext" in the table jos_content but without the contents from catid=88

i was trying with something like this:
UPDATE jos_content
SET `introtext` = `fulltext`, `fulltext` = ''
WHERE `introtext` = '';

but i don't know how to exclude the articles from catid=88 and how to copy and put the data from introtext in front of the fulltext..

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.158 seconds