×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× 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

More
8 years 4 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.089 seconds