I have been using k2 alot recently andrealsied that once more than three attachments get added you soon want to stat controlling the order of themI am working on a temlate solution for sorting thru the array but the database structure does not support ordering. Best a template will give is alphabetical ordering which is no good for documents named by month.......2.3beta doesnt have it either. This is a common feature in the Joomla interface - i guess it might be more work to add specific ordering and require database field addition not to mention some more view manipulation and extra db work...

Hi,I've added new fields to user form like age, city, interest etc. but when I logged in and display the user edit page, new added fields not shown but when I refresh they show up, what might be the problem? please help. code is below. by the way, I am using tabs to display the form. </div>    <div class="simpleTabsContent">    <table cellpadding="0" cellspacing="4" border="0" width="100%">    <tr>      <td><label for="username"> <?php echo JText::_( 'User Name' ); ?>: </label></td>      <td><span style="font-weight:bold"><?php echo $this->user->get('username');?></span></td>    </tr>    <tr>      <td  width="12%" height="40"><label id="imagemsg" for="image"> <?php echo JText::_( 'Avatar' ); ?>:</label></td>      <td  height="40"><div class="spec">                <?php if ($this->K2User->image):?>        <img class="small" src="<?php echo JURI::root().'media/k2/users/'.$this->K2User->image;?>" alt="<?php echo $this->user->name; ?>" />        <input  type="checkbox" name="del_image" id="del_image" />        <label for="del_image"><?php echo JText::_('Upload new image to replace existing avatar or check this box to delete user avatar');?></label>        <?php endif;?>                <?php if (!$this->K2User->image): ?>                <img class="small" src="<?php echo JURI::root().'media/k2/users/user.png'.$this->K2User->image;?>" alt="<?php echo $this->user->name; ?>" />              <?php endif;?>           <br />       <input class="inp" type="file" id="image" name="image"/></td></div>    </tr>        <tr height="5">    <tr>          <td width="120"><label for="name"> <?php echo JText::_( 'Your Name' ); ?>: </label></td>      <td><input class="inputbox required" type="text" id="name" name="name" value="<?php echo ucwords($this->escape($this->user->get('name')));?>" size="30"/></td>    </tr>    <tr>      <td><label for="email"> <?php echo JText::_( 'email' ); ?>: </label></td>      <td><input class="inputbox required validate-email" type="text" id="email" name="email" value="<?php echo $this->escape($this->user->get('email'));?>" size="30" /></td>    </tr>        <?php if($this->user->get('password')) : ?>    <tr>      <td><label for="password"> <?php echo JText::_( 'Password' ); ?>: </label></td>      <td><input class="inputbox validate-password" type="password" id="password" name="password" value="" size="30" /></td>    </tr>    <tr>      <td><label for="password2"> <?php echo JText::_( 'Verify Password' ); ?>: </label></td>      <td><input class="inputbox validate-passverify" type="password" id="password2" name="password2" size="30" /></td>      <?php endif; ?>    </tr>    <tr>    <td><label for="age"><?php echo Jtext::_( 'age' ); ?>: </label></td>    <td><input class="validate-integer" type="text" id="age" name="age" value="<?php echo $this->user->profile->age;?>" size="1"/></td></tr>        <tr>      <td height="20"><label id="gendermsg" for="gender"> <?php echo JText::_( 'Gender' ); ?>: </label></td>      <td><?php echo $this->lists; ?>      </td>    </tr>    <tr>    <td><label id="urlmsg" for="city"><?php echo Jtext::_( 'city' ); ?>: </label></td>    <td width="10"><input type="text" id="city" name="city" value="<?php echo ucwords($this->user->profile->city);?>" size="30"/></td>    </tr>            <tr style="margin-top:3px">    <td valign="top"><label for="about"><?php echo Jtext::_( 'about' ); ?>: </label></td>        <td width="10"><textarea class="desc" style="" type="fulltext" id="about" name="about" size="50"><?php echo $this->user->profile->about;?></textarea></td><td><span class="editlinktip hasTip" title="Tooltip title::This is the tooltip text"><img src="<?php echo JURI::root().'images/M_images/con_info.png';?>" border="0" alt="Tooltip"/></span></td>    </tr>                <tr>      <td height="28"><label id="urlmsg" for="url"> <?php echo JText::_( 'Url' ); ?>: </label></td>      <td  width="10" style="padding:0"><input type="text" size="56" value="<?php echo $this->K2User->url; ?>" name="url" id="url"/>       </td>        <td valign="middle" width="123"><span class="hasTip" title="Tooltip title::This is the tooltip text" ><img src="<?php echo JURI::root().'images/M_images/con_info.png';?>" border="0" alt="Tooltip"/></span></td>    </tr>        <tr>      <td valign="top" height="15"><label for="interest"> <?php echo JText::_( 'interest' ); ?>: </label></td>      <td  width="10"><textarea class="desc" type="fulltext" name="interest" id="interest"/><?php echo $this->user->profile->interest; ?></textarea>       </td>        <td valign="middle" width="123"><span class="hasTip" title="Tooltip title::This is the tooltip text" ><img src="<?php echo JURI::root().'images/M_images/con_info.png';?>" border="0" alt="Tooltip"/></span></td>    </tr>        <?php if (count($this->K2Plugins)):?>    <?php foreach ($this->K2Plugins as $K2Plugin) : ?>    <tr>      <td colspan="2"><?php echo $K2Plugin->fields;?></td>    </tr>    <?php endforeach; ?>    <?php endif;?>      </table>  </div>  <button class="button validate" type="submit" onclick="submitbutton( this.form );return false;"><?php echo JText::_('Save'); ?></button>  <input type="hidden" name="username" value="<?php echo $this->user->get('username');?>" />  <input type="hidden" name="id" value="<?php echo $this->user->get('id');?>" />  <input type="hidden" name="gid" value="<?php echo $this->user->get('gid');?>" />  <input type="hidden" name="option" value="com_user" />  <input type="hidden" name="task" value="save" />  <input type="hidden" name="K2UserForm" value="1" />  <?php echo JHTML::_( 'form.token' ); ?>    </div></div>

I see from the debug consol that it appears to be quereing all relevant fields you would want/expect, but still the results seem limited to item name.

#
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-05-25 00:29:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-05-25 00:29:37' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('terrain')
ORDER BY i.id DESC
LIMIT 0, 10

Gamal Andrews said:You are correct case. It seems only to be searching the items name. How do you broaden it to everything? Thanks again William, you got me this far.

Looking at the debug report it looks like it is trying to pull from all relevant tables - anyone have any idea why it is not pulling the results a user would expect.


#
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-05-25 00:29:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-05-25 00:29:37' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('terrain')
ORDER BY i.id DESC
LIMIT 0, 10

Using the same extra field in different groups may be ok and may work (i havent tested it) but, it may affect the order the xtra fields show up in the front end and that could be more difficult to overcome because of the way item.php loops thru the xtra fields when displaying them.

Hello folks I want to change the generic view for item list in order to get an identical look as the category item list view. As I have made some hacks to the core files to be able to display some extra fields added to user profile, I have played with ../models/item.php, itemlist.php and so on. But the problem is that I don't know how to display them in the generic view. Could you please give me some tips which files should I look into? Or, which files have supplied the data used in generic.php? Thanks in advance.

Where we can find a manual in order we can manage to create a template that can achieve what we want

Whe want to achive something like add some subtibles to ours main titles of the articles so we can manage to put the subtitle in a new extra field

there going to be something like

THE NEW SUBTITLE
The main title of the content
content
other things and plugins

Please

thanks in advance

Roll Up, Roll Up, buy your tickets here ;)

OK, form an orderly queue.
What specifics do you have?
Would it be better with a plugin that links to a calendar popup selection?

Lets see what we can do.

Simon
K2 Support.

Hi Giorgio,

OK, there is a lot to cover here ;)

Looking at your screenshot, I would say that Modules A, B, C are going to be your leading, primary and secondary, these can be used on the frontpage. These items can be added to a Frontpage category, which uses its own K2 template as it will differ from all the others.
Changes will of course be needed to the php and css files to achieve this. No Modules used needed to achieve this as it just uses the content position.

Modules (D, E, F) and (H, I, J) and (K, L, M, N, O) can be done using the Tabs and Slides module from Joomlaworks or any other that supports K2. So instead of 11 modules, you now have 3

Thats leaves just Module P and G so a total of 5 modules.

I would recommend to setup in the following order, some users will of course do this differently.

Install Joomla
Install Joomla template
Install K2
Create Categories
Create some demo items.
Set Category Options
Add in some modules for structure
Create Extra Field Groups (if needed)
Create Extra Fields
Create k2 template over ride from default
Modify K2 template over ride
Setup User groups

Finally you say "that is, for example, for a position on the frontpage to
show 2 article columns, then 4, then etc. is not possible?, am I going
to need a position for each column?, "
Within any category you can specify the number of leading items and columns, primary and columns, secondary and column. So you could have Leading as 1 column, Primary as two columns and Secondary as two columns.
If you have sub categories you can also have those displayed as well, or limit it to just the parent category by using the catalogue mode.

Hope that helps and is a good start point for you.

Simon
K2 Support

i love this question but i think maybe sobi2 should also be included in the discussion

IMHO k2 is weak in two ways:

1. tag management
2. search or filtering

in my testing site, when i try to search a value of a custom field, i get a blank page (i did not have sef on yet while doing this).

not so familar with mtree so far, but sobi2 has powerful search.
i think k2 need to get more powerful tag management to become the most powerful CCK.

1. multiple tags menu (link) or tag group
2. tag ordering by id, alpha, number of items associated, etc
3. highly customizable tag cloud templating which allows tag lists or tag group lists displayed as "categories"
4. full content filtering including custom fields and user profile (if made public by the user himself)

a little bit more thoughts -

1. contact owner on item view ( which is key for mtree / sobi2)
2. extra fields on the fly (even for frontend adding)
3. google map

Keep this topic alive...

Hi Line,

Great to hear that it is been useful.
Thanks for letting me know about this issue and I had never used the tag view. Now that I have looked into it you are indeed correct.

But unfortunately whenever the task is tag K2 doesn't seem to load the k2 plugins (which k2fields is) nor call necessary events (which this plugin requires in order to function properly and w/o having K2 core hacks in play). So atm there is not much we can do.

If you wouldn't mind putting a K2 core hack in place I would be able to provide you such modification or if you would like to do it yourself open components/com_k2/models/item.php and look at row # 332 and change one of the clauses currently looking as follows:

($view=='itemlist' && ($task=='' || $task=='category') && $item->params->get('catItemK2Plugins')) ||

to

($view=='itemlist' && ($task=='' || $task=='category' || $task=='tag') && $item->params->get('catItemK2Plugins')) ||

Let me know how this works out for you...

Line Wied said:Thank you very much for this plugin.
Im using it for a date extra field. Works fine in item view and in category lists, but when items are displayed by tag, it shows the "k2f---valid=datetime---Dato" instead of the name.

Hi,I really love this component and i really appreciate all Joomlaworks others extensions.I work with OVH as Web Agency.  I tried many times to make K2 works correctly but i didn't succeed.With Firefox, there is no problem, maybe the Squeezbox that doesn't work each time.If I use Internet Explorer 8, Squeezbox who must use "modal.js" doesn't work. So there is an error Message that appears. Lightbox doesn't have any problem but it is impossible to make a site that display an error...I would like to say to Joomlaworks Team to make a tip to retire the conflict and errors create by modal.js and squeezbox.I have test K2 without Gallery and no errors apear on Internet Explorer 8, so there is a thing to do with Simple Gallery Plugin integration.I think it will be also important to be able to change Extra Fields order on the backoffice of Joomla because, if there is an error of order, we must recreate all fields in the good order.If somebody has succeed in installing K2 and make it work correctly with Internet Explorer 8 using Simple Gallery, i really appreciate to have some lesson to manage to do the same thing.I tried many tips showned in the posts of the K2 forum but no good results and nothing really interested on my search on GoogleThanks EverybodyThis component should have a great future :)

Thanks for solving th bugs in v2.2

We've taken some time to hunt some missing language strings in 2.2
Here are the results:

Missing Language Strings in admin/language/en-GB/en-GB.com_k2.ini

IMPORT COMPLETED=Import Completed
USER GROUP SAVED=User Group Saved
USER SAVED=User Saved
GROUP SAVED=Group Saved
EXTRA FIELD SAVED=Extra Field Saved
TAG SAVED=Tag Saved
CATEGORY SAVED=Category Saved
NOTICE: PLEASE INSTALL JOOMLAWORKS ALLVIDEOS PLUGIN IF YOU WANT TO USE THE VIDEO FEATURES OF K2!=Notice: Please install JoomlaWorks AllVideos plugin if you want to use the video features of K2!
NOTICE: PLEASE INSTALL JOOMLAWORKS SIMPLE IMAGE GALLERY (FREE/PRO) PLUGIN IF YOU WANT TO USE THE IMAGE GALLERY FEATURES OF K2!=Notice: Please install JoomlaWorks Simple Image Gallery (Free/Pro) plugin if you want to use the image gallery features of K2!
USE THE FORM ABOVE TO REPLACE THE EXISTING VIDEO OR CHECK THIS BOX TO DELETE CURRENT VIDEO=Use the form above to replace the existing video or check this box to delete current video
WRITE A TAG AND PRESS "RETURN" OR "COMMA" TO ADD IT.=Write a tag and press "return" or "comma" to add it.
CHANGES TO ITEM SAVED=Changes to Item saved
CHANGES TO EXTRA FIELD SAVED=Chabges to Extra Field saved
CHANGES TO GROUP SAVED=Changes to Group saved
CHANGES TO USER GROUP SAVED=Changes to User Group saved
CHANGES TO USER SAVED=Changes to User saved
COMMENT SAVED=Comment saved
CHANGES TO TAG SAVED=Changes to Tag saved
CHANGES TO CATEGORY SAVED=Changes to Category saved
DELETE FAILED=Delete failed
SOME OF THE CATEGORIES HAVE NOT BEEN DELETED BECAUSE THEY HAVE ITEMS.=Some of the Categories have not been deleted because they have Items.
SOME OF THE CATEGORIES HAVE NOT BEEN DELETED BECAUSE THEY HAVE CHILD CATEGORIES.=Some of the Categories have not been deleted because they have Child Categories.

Missing language strings in /language/en-GB/en-GB.com_k2.ini

VOTE=Vote
YOU HAVE ALREADY RATED THIS ITEM.=You already have rate this Item.
THANKS FOR RATING!=Thanks for rating!
COMMENT ADDED! REFRESHING PAGE...=Comment added! Refreshing page...
COMMENT ADDED AND WAITING FOR APPROVAL.=Comment added and waiting for approval.
WRITE A TAG AND PRESS "RETURN" OR "COMMA" TO ADD IT.=Write a Tag and press "Return" or "comma' to add it.
THANK YOU. YOUR COMMENT WILL BE PUBLISHED SHORTLY.=Thank you. Your comment will be published shortly.
THE WORDS YOU TYPED DID NOT MATCH THE ONES DISPLAYED. PLEASE TRY AGAIN.=The words you typed did not match the ones displayed. Please try again.
THE NAME OR EMAIL ADDRESS YOU TYPED IS ALREADY IN USE!=The Name or Email Address you typed is already in use!
YOU NEED TO FILL IN ALL REQUIRED FIELDS!=You need to fill in all Required Fields!
ITEM NOT FOUND=Item not found
INVALID E-MAIL ADDRESS!=Invalid Email Address!
NOTICE: PLEASE INSTALL THE ALLVIDEOS PLUGIN IF YOU WANT TO USE THE VIDEO FEATURES OF K2!=Notice: Please install the AllVideos plugin if you want to use the video features of K2!
NOTICE: PLEASE INSTALL THE SIMPLE IMAGE GALLERY (FREE/PRO) PLUGIN IF YOU WANT TO USE THE IMAGE GALLERY FEATURES OF K2!=Notice: Please install the Simple Image Gallery (Free/Pro) plugin if you want to use the image gallery features of K2!
VIDEO SOURCE=Video source
ITEM SAVED=Item saved

Language Strings in install.k2.php not loading and missing in admin/language/en-GB/en-GB.com_k2.ini

To get the language Strings loaded on installing K2 there should be some additions in install.k2.php
after line 66:
JPlugin::loadLanguage( 'com_k2' );
before line 120 :


also in uninstall.k2.php
after line 74


Installations/ Uninstall language strings should be added in admin/language/en-GB/en-GB.com_k2.ini
NOTICE: K2 CONTENT ELEMENTS FOR JOOM!FISH WERE NOT COPIED TO THE RELATED FOLDER, BECAUSE JOOM!FISH WAS NOT FOUND ON YOUR SYSTEM.=Notice: K2 Content Elements for Joom!Fish were not copied to the related folder, because Joom!Fish was not found on your sytem.
K2 INSTALLATION STATUS=K2 Installation Status
EXTENSION=Extension
STATUS=Status
COMPONENT=Component
MODULE=Module
CLIENT=Client
INSTALLED=Installed
NOT INSTALLED=Not Installed
PLUGIN=Plugin
GROUP=Group
K2 REMOVAL STATUS=K2 Removal Status
REMOVED=Removed
NOT REMOVED=Not Removed


Suggestions for updating language files:

In comparence with the previous release the order of the language strings in language files was mixed up. This makes it very hard for translations to get the changes in languagefiles. I almost had to tranlate it al over again. Also in previous release the strings were alphabetical ordered, which makes it easier to find a certain string. I would prefer to restore the alphabetical order and keep that in next releases.

Also there are many language strings for the backend and the frontend language files the same.
My suggestion would be to use 1 languagefile wich is installed on both admin and site languagefolders.

I'm attaching a language bug txt file, some code might not show properly here

TIA

I think Sergey wants what I want!

I have Category A, Item 1, 2 and 3, as well as Category 2, Item 4, 5 and 6.

Items 2 and 5 have an Extra Field of X (whether that be a drop down or radio button, it must be either X or Y).

I want to be able to bring up a list of everything in X (currently Item 2 and Item 5) and order them according to X.

I also want to be able to create a Menu Item to display everything in Extra Field X.

Can anyone do this for us?

Hi, I'm experiencing similar problems. I have several extra fields categories, and in each a set of extra fields. In both instances on different pages there are fields simply not being displayed. I also experienced the ordering problem and agree the fix is to click on the column title.

However I have tried to change the date of items associated with the fields category and it has made no difference. having said that I am displaying four K2 items as tabs. I have updated all item creation dates to see if this is preventing the display but again no difference.

I have also changed the order of the extra fields so the fourth (not being displayed) is in 3rd position, abd again, it is still not displayed. You can see this on: www.move2gozo.com/gozo-and-malta/getting-to-malta-and-gozo.html

Any other ideas gratefully received.

Please take a look at this page:http://www.customgolfsenter.no/index.php?option=com_k2&view=item&layout=item&id=37&Itemid=186There is a table there that is generated from adding a CSV field to an article. But where do I find the styling for this? So far, I have found this section of the K2.css file:87 - /* --- Extra fields: CSV data styling --- */88 - table.csvData {}89 - table.csvData tr th {}90 - table.csvData tr td {}I found another section that might apply:39 - /* --- Zebra rows --- */40 - .even {background:#fffff0;padding:2px;border-bottom:1px dotted #ccc;}41 - .odd {background:#fff;padding:2px;border-bottom:1px dotted #ccc;}I found a section in item.php that relates to the extra fields. The problem is that I kinda get the idea that the display is meant to be different than it looks on my site... Do anyone have any idea how to:1. get more space between each column in the table?2. I think I will make a sub-template to get rid of the name of the table and the h3 heading. I'll fix that on my own.3. And last, it would be nice to get the laternating background going so it is easier to read the results. That would be the zebra rows. But how do I get them to display?

How can I change the order of the tabs, which are displayed in the Add Item window?E.g.: I want Extra Fields on the first place. Already tried to mess with ./views/item/tmpl/form.php around line 351 and shuffle the <li> tags. Doing that I was able to change to tab order, but the content under the tabs did not relocate, so it was a mess.Any thoughts?

Hi. The queries you posted are from the K2 component search not the K2 search plugin. The queries are fine. Maybe providing a link to your site will help us see what's wrong.

cmath said:Hi Lefteris, The following sql query is executed, but there are no errors on the page, although the search is not returning any results:
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('ramakrishna')
ORDER BY i.id DESC
LIMIT 0, 10
SELECT COUNT(*)
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('ramakrishna')

Thanks,

Lefteris Kavadas said:Hi. Are you getting any error? Please enable debug mode and check the query ( or post it here....). cmath said:Lefteris, I have set Enable search in tags to NO, but still have the problem in search. What is the fix for this? Could you provide us the updated search file?

Hi,

 

I am hoping to use K2 to make an events page that lists the events in the order that they will happen rather than the order in which they have been added.  At the moment I am using an Extra Text field for the date.

 

Is there a way to do this with a dedicated date field and sort by that field?

 

Thanks.

Hi Lefteris,
The following sql query is executed, but there are no errors on the page, although the search is not returning any results:
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('ramakrishna')
ORDER BY i.id DESC
LIMIT 0, 10
SELECT COUNT(*)
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 2
AND i.trash = 0
AND c.published = 1
AND c.access <= 2
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-02-17 10:51:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-02-17 10:51:06' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('ramakrishna')

Thanks,

Lefteris Kavadas said:Hi. Are you getting any error? Please enable debug mode and check the query ( or post it here....). cmath said:Lefteris, I have set Enable search in tags to NO, but still have the problem in search. What is the fix for this? Could you provide us the updated search file?