Keyword

Advanced Search

Search Results (Searched for: extra field order)

  • Johann Scharfetter
  • Johann Scharfetter's Avatar
29 Dec 2012 07:40 - 29 Dec 2012 07:46
Replied by Johann Scharfetter on topic SOLVED:K2 item save button doesn't work, cancel ok

SOLVED:K2 item save button doesn't work, cancel ok

Category: English K2 Community

SOLVED!!!

I were using extra fields wich were required fields.
And I didn't fill out these fields, therefore I could not save the item.

Fill in all required extra fields in order to save correctly.

Thank you.
  • Panos
  • Panos's Avatar
26 Nov 2012 14:28 - 26 Nov 2012 14:29

Display certain extra fields in search results

Category: English K2 Community

Hey guys!

I've been using K2 for quite some time now and on a new website I'm building there is a small problem which is displaying certain extra fields (not all) at the search results page of Joomla. Not being able to show them by default I decided to write my own code that does the trick.

What I did is to write some code that queries the database -using the result's id- and gets all the extra fields using json decoding to display them in a readable format. My problem there, is that each item has 100 extra fields and json takes ages to decode them all when I have let's say 20 items per page. So I was wondering if there is a way to speed up the results?

Below you can see a snippet of the code to see if you can help a little:
SELECT e.id AS extra_id, e.name, e.type, i.extra_fields, g.name AS group_name FROM jos_k2_extra_fields e, jos_k2_categories c, jos_k2_items i, jos_k2_extra_fields_groups g WHERE i.catid = c.id AND g.id = c.extraFieldsGroup AND g.id = e.group AND e.published=1 AND i.id = ".$result->id." ORDER BY e.ordering ASC LIMIT 0, 16
This brings the first 16 extra fields of the item and then I decode the extra_fields column using json which has all the extra fields and their values, so I can display them at the search results page. I think I need to optimize my SQL code, so if anyone has a clue please help. I'm sure some other guys will need to do that, so I guess it will be helpful for the community.

Thanks in advance!
  • william white
  • william white's Avatar
25 Nov 2012 12:19
Replied by william white on topic latest K2 extra fields additions?

latest K2 extra fields additions?

Category: English K2 Community

Create a new xtra field "header" type and look at it in the back end of the item. Change the order around to get it to serve as a title for a subgroup of extra fields

create an new img type extra field and place an image in it
edit in an override item.php and put just under where it displays title
<?php echo $this->item->extraFields->EXTRAFIELDALIASHERE->value ;?>
you should see the image beside the title
  • bassem
  • bassem's Avatar
23 Nov 2012 20:16

Styling Extra fields Output as Unordered List

Category: English K2 Community

too bad! I wish I can hack it, but I'm not a programmer, but anyway, it's just an idea that someone may like and create a plugin for this.

Thanks anyway.
  • Lefteris
  • Lefteris's Avatar
23 Nov 2012 12:02
Replied by Lefteris on topic Styling Extra fields Output as Unordered List

Styling Extra fields Output as Unordered List

Category: English K2 Community

Hi. Unfortunately this cannot be done without hacking K2. The file which is generating this is /components/com_k2/models/item.php ( function getItemExtraFields).
  • bassem
  • bassem's Avatar
21 Nov 2012 17:45

Styling Extra fields Output as Unordered List

Category: English K2 Community

Hello,

Do any body have an idea on how to Style Extra fields Output Values as Unordered List, or how to style that output in any way?
without having that comma , separating each word?

I have attached 2 images, one of the values in backend, and another of how they appear in the frontend.
Actually I want the output values listed each one alone,

Please have a look at the images to get what I mean.

Thanks for all.

Attachment not found



Attachment not found

  • Andrew Paterson
  • Andrew Paterson's Avatar
20 Nov 2012 11:47 - 20 Nov 2012 11:50
Add extra field to k2 store php file was created by Andrew Paterson

Add extra field to k2 store php file

Category: English K2 Community

Hi All

I haven't had much luck with this issue in the k2 Store forum. The K2 store system sends an email to the site owner, when an order is submitted. The email fetches the title etc of the relevant items.

I've been trying to get it to add an extra field for each item- I've been trying to use this method: getk2.org/documentation/tips-a-tricks/item/221-custom-admin-templates-and-calling-specific-extra-field-data , but no luck.

This is the code that the php file uses to fetch all the data that is include in the email for each item. Any ideas on how to include an extra field there?
 
  • nibelungen
  • nibelungen's Avatar
03 Nov 2012 19:44
Replied by nibelungen on topic Creating extra fields

Creating extra fields

Category: English K2 Community

Hi

I have a multilingual website. And I need to have certain titles or elements to have a specific class in order to solve the issue of text:uppercase styling. I'm using the class information in my javascript file to make it work.

Well, your solution might do the trick. I will look into it. Thank you.
  • Hermann Spörl
  • Hermann Spörl's Avatar
30 Oct 2012 09:53 - 30 Oct 2012 10:02
Slow Queriey using K2 was created by Hermann Spörl

Slow Queriey using K2

Category: English K2 Community

Hey!

We are using K2 with Joomla 2.5.7 on our rock-webportal www.legacy.de
Our website sometimes runs out of service while we are editing items with K2.

The server log shows some slow queries caused by K2 that push our MySQL-Server to 100% which kills our website for some minutes. The queries often last for about 2-3 minutes.

Any ideas, what can cause this slow queries and how to avoid these embarrassing downtimes?

Thank you for your support in advance!

Regards
Ingo

Here's the server-log for that slow queries:

# Time: 120815 10:21:26
# User@Host: legacy[legacy] @ localhost []
# Query_time: 112.302907 Lock_time: 108.990503 Rows_sent: 10 Rows_examined: 15645
SET timestamp=1345018886;
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM legacy_k2_items as i LEFT JOIN legacy_k2_categories AS c ON FIND_IN_SET( c.id , i.catid ) WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-08-15 08:19:34' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-08-15 08:19:34' ) 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 ('secrets* of* the* m*' IN BOOLEAN MODE) AND i.catid IN (20) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 10;
  • Johann Scharfetter
  • Johann Scharfetter's Avatar
22 Oct 2012 20:47 - 22 Oct 2012 21:39
K2 + extra fields in falang OR Joomfish was created by Johann Scharfetter

K2 + extra fields in falang OR Joomfish

Category: English K2 Community

Hello,

I'd like to translate my extra fields with Falang (I think it is practicly the same as with joomfish).
How to I do this? I imagin I have to modify k2_items_xml - file, right?

Or do I have to create a extra xml-file. I wonder how it works with several Extra Fields Groups.

This is the content of k2_items.xml - file. I tried to add extra fields, but without success.
 No valid database connection: DB function failed with error number 1054
Unknown column 'c.fulltextaaa' in 'field list' SQL=SELECT c.id, c.title, c.introtext, c.fulltext, c.fulltextaaa, c.image_caption, c.image_credits, c.video_caption, c.video_creditsss, c.extra_fields, c.extra_fields_search, c.metakey, c.metadesc, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM mare_k2_items as c LEFT JOIN mare_falang_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='k2_items' AND jfc.language_id=4 LEFT JOIN mare_languages as jfl ON jfc.language_id=jfl.lang_id ORDER BY c.title LIMIT 0, 20

Help is very appreciated.

Thank you!
  • william white
  • william white's Avatar
19 Oct 2012 20:41
Replied by william white on topic extra field variables called from item editor?

extra field variables called from item editor?

Category: English K2 Community

Im wondering if it can really be true that it's not possible in any way to change how your item is presented, without having to fiddle with code that, to be honest, i started to use joomla to prevent entirely.

There are many paramaters in both the item and category view that will "change" the way the item is presented.
The k2 templates or overrides control the order in which they are presented, and you can move that around, insert tabs, and other things by working with the appropriate blocks of code in item.php and category_item.php You also have the text field where you can do just as any normal j article

To me being able to decide how all the items information is displayed on the site is an absolutely fundamental feature, but in K2 i seem to be limited to "Extra fields - hide/show"...

The default behavior is for all the fields to show along with the field names, and if there empty they dont display. You can hide all of them. Many times you will need to use the overrides to display extra fields in a custom place. this requires php

A good example of cars with k2 is at joomcar.net/k2ef-demo using a custom module with k2
  • Judah Raine
  • Judah Raine's Avatar
15 Oct 2012 10:34
Pre-purchase questions for K2 add ons was created by Judah Raine

Pre-purchase questions for K2 add ons

Category: English K2 Community

Hi there, I've downloaded the component and started working through the training video's, and must say I like the look of K2 enough to want to purchase both the story and multi-category components. Before I do, however, I would like to make sure that these will in fact do what I need as per my questions below:


a) I need to be able to create custom form and article layouts for users to submit articles in the frontend. These articles (in various categories) will not be available for the original authors to edit so I'm looking for
Article in Category A to have a specific layout, B a specific layout, C.... The form should simply be the means to capture the information I need displayed in a pre-specified layout as a Joomla / K2 article.

b) I have a specific need for a review site that works as follows: Authors / publishers submit a review request (specific form) together with upload of their e-book. Public can submit request in the frontend.
These are then saved to articles with a download file (which only allows one download, and hopefully can record who downloaded). Reviewers log in on front end and access article management, can then edit the article to add their review and rating (two extra fields needed here). The finished article then displays in the relevant categories (need multiple categories for the reviews). ONLY reviewers have access to view and edit the articles in the middle step. Thereafter only admin can edit or delete, once review is finally posted, but the articles are available for public view.

c) categories and multiple categories. I realise that there are going to be overlaps in categories. e.g. The reviews section will have the same sub-categories as the bookstore section, e.g historical, western. and books will also belong to more than one category e.g. both historical and western. I'm concerned that same sub categories will cause conflicts, or that searches in bookstore categories will bring up review categories. This might not necessarily be an issue (if reviews are available for books in the bookstore) but could be a problem if the search brings up review requests which are in the "middle phase". It is imperative that only reviewers (and only one reviewer per book) may download these books in order to review them.

These are my basic queries and I would be most grateful if someone could assist. I am desperately trying to complete the site as soon as possible and would like to purchase what I need today if possible.

Many thanks
Jude
  • Eduardo
  • Eduardo's Avatar
12 Oct 2012 00:19

2.6.0 update: Fatal error (...) models/item.php

Category: English K2 Community

Eduardo wrote: 2.6.1 update:


1) Problem remains when saving an article in frontend:
Fatal error: Call to a member function getSearchValue() on a non-object in /home/.../public_html/administrator/components/com_k2/models/item.php on line 721

2) Extra-fields are not showing when the Category is selected - SOLVED

3) Cpanel.php problems (error on backend, can't change order ir the file is deleted). The error is gone. I don't know if the change order being blocked (grey) is indeed an error, because you can activate it by clicking in "Order", but for people who have lots of items, this is not easy at all to modify.

4) Facebook problems, HTML as it was text, still the same: See Post Problem remains


5) Extra fields simply don't work anymore.
  • Eduardo
  • Eduardo's Avatar
11 Oct 2012 15:16

2.6.0 update: Fatal error (...) models/item.php

Category: English K2 Community

2.6.1 update:


1) Problem remains when saving an article in frontend:
Fatal error: Call to a member function getSearchValue() on a non-object in /home/.../public_html/administrator/components/com_k2/models/item.php on line 721

2) Extra-fields are not showing when the Category is selected - SOLVED

3) Cpanel.php problems (error on backend, can't change order ir the file is deleted). The error is gone. I don't know if the change order being blocked (grey) is indeed an error, because you can activate it by clicking in "Order", but for people who have lots of items, this is not easy at all to modify.

4) Facebook problems, HTML as it was text, still the same: See Post Problem remains
  • Eduardo Santos
  • Eduardo Santos's Avatar
10 Oct 2012 10:42 - 10 Oct 2012 11:07
2.6.0 update: Fatal error (...) models/item.php was created by Eduardo Santos

2.6.0 update: Fatal error (...) models/item.php

Category: English K2 Community

Edit: Ok, I'll compile 2.6.0 erros so far:


1)
Fatal error: Call to a member function getSearchValue() on a non-object in /home/l ... /public_html/administrator/components/com_k2/models/item.php on line 721

I get this error every time I try to edit an article (when saving it). It's very frustrating...

2) Extra-fields are not showing when the Category is selected.Only when the article is saved, but as stated, then you can't edit it anymore.

3) Cpanel.php problems (error on backend, can't change order ir the file is deleted): See post

4) Facebook problems. See post


I would say everyone to DO NOT UPGRADE YET! It was a lot of issues.




PS: I had to create a new account because I wasn't able to post here with the old one, it always said:

-post-: Category has been locked.
  • fafa
  • fafa's Avatar
09 Oct 2012 22:06
more article fields was created by fafa

more article fields

Category: English K2 Community

hi,im using joomla 2.5 with k2 2.5.7.
and for the question:
is it possible to have more than 1 main field in an article?
i mean i need to have 4 or 5 article fields with different border styles in 1 article.
for example 1 field for a description with a 1px border with red color , the second field for another description with a different border color and so on.its like what zoo cck does,with zoo we can make as many text fields as we want in a single article.
the default k2 gives me only 1 main field for the intro text and 1 for the main text and 1 for extra field.but i want more fields ,thats it, i hope i could tell what i meant.
btw for an example of what i need here is a sample page (in another language and i guess its wordpress).look at the fields :

tafrih.ir/place/padideh-shandiz

thanks for the help in advance.
  • Federico
  • Federico 's Avatar
04 Oct 2012 09:55
Replied by Federico on topic iframes to extra fields

iframes to extra fields

Category: English K2 Community

Jarno Seppänen wrote: Hi!
I try to embedd that code...
<iframe src="rcm.amazon.com/e/cm?t=itstescom-20&o=1&p=8&l=as1&asins=B004M8RPBI&ref=tf_til&fc1=000000&IS2=1<1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="width:120px;height:240px;" scrolling="no" marginwidth="0" marginheight="0" frameborder="0">
it's a picture link to Amazon online store. (affiliate ads).
I can't embed that link, I bought JCE Editor and iframe plugin and I can add iframes everywhere except extra field. Is it possible that K2 allow that iframe tags everywhere but not in extra fields. So can anyone help me.


Hi everybody,
this is my first post...
...no one can help us??
  • Johann Scharfetter
  • Johann Scharfetter's Avatar
28 Sep 2012 17:28 - 28 Sep 2012 17:54
Replied by Johann Scharfetter on topic Category view with several category titel-tags?

Category view with several category titel-tags?

Category: English K2 Community

Hello!

I have to come back to my original problem, beause I could not solve it till now.

What I need is to display a list of items gruped grouped by categories, as you can see below. Using extra fields!

======================================================

<h2> Title of category 1.1 </h2> (order by "default")
..........<h3> Title of Item 1 in this categorie </h3> (order by "title - alphabetical")
....................+ item Body
..........<h3> Title of Item 2 in this categorie </h3>
....................+ item Body


<h2> Title of category 1.2 </h2>
..........<h3> Title of Item 1 in this categorie </h3>
..........<h3> Title of Item 2 in this categorie </h3>

======================================================

What I lerned till now is that the last-item-view can display items grouped by categories,
BUT it can not display extra fields,
and the category-view can display extra fields but can not dispay items grouped by categories.

The best way, I guess, might be to modify the category-view (categories.php), incorporating parts of latest.php. Or may bee it is easier to make extrafields to be displayed in last-items-view?

I understand that it is quite tricky, would be greate if someone could find out how to.

Thank you!
  • Lefteris
  • Lefteris's Avatar
26 Sep 2012 13:50
Replied by Lefteris on topic Sort by Extra-Field-Content?

Sort by Extra-Field-Content?

Category: English K2 Community

@Julian

You cannot do this. The reason we do not offer that functionallity is that we store extra fields in JSON format. This means that in order to sort items, you need to first get all items, then get their extra fields and then sort them using PHP. This is something that is not supported in K2.
  • Julian
  • Julian's Avatar
25 Sep 2012 14:17 - 25 Sep 2012 14:25
Replied by Julian on topic Sort by Extra-Field-Content?

Sort by Extra-Field-Content?

Category: English K2 Community

Hi Piotr,

thanks for your answer and for your efforts.

I looks like this extensions offers the possibilty to select or filter articles of a category according to the content of their extra fields. This is not exactely what I am searching for.

I have got a category containing more than 100 articles. Each article got a extra field called "Postal Code". This field contains the postal code of the association described in the article.

I would like to have a option to display the complete article list of this category sorted/ordered ascending by their postal codes (which are stored in a K2 extra field).

Any ideas?

Kind regards,
Julian
Displaying 301 - 320 out of 529 results.