here's some test code, it is not smart, but i just wanted to print out all links alphabetical from all items in the database.

You'd need to be able to refine the category, and link to a new list view which would be articles, with pagination.

I may need to send this to odesk or similar, unless someone can make a simple plugin for the community.

heres some test code if anyone wants to print out results

yes yes yes, i know this is not how you create plugins/modules, nor use the MVC, so i put this into components/com_ks/templates/default/item.php just to view.

I'm getting this. I used JUpgrade. Latest Joomla and K2, downloaded two days ago.

update: solution! after you set all your items to public, special or registered, you also have to do this to the categories.

Hi,

Using phpmyadmin, I just transferred K2 content from my Joomla1.5/K2 site to a Joomla 2.5/K2 site.

• In the J1.5 site, K2 version 2.4.1 is installed.
• In the J2.5 site, K2 version 2.5.7 is installed.

Everything transferred well except for items. They llok okay, but the Access level field is blank.

If I try to change the Access Level to Public I get the following:-

TableK2Item: :store failed
Unknown column 'language' in 'field list' SQL=UPDATE `jos_k2_items` SET `title`='An Introduction To Felting',`alias`='an-introduction-to-felting',`catid`='24',`published`='1',`introtext`='

ITEM CONTENT WENT HERE BUT DELETED IT TO SHORTEN ERROR MESSAGE

',`fulltext`='',`image_caption`='',`image_credits`='',`video_caption`='',`video_credits`='',`created`='2011-04-25 12:19:07',`created_by`='62',`created_by_alias`='',`modified`='2012-06-09 11:07:47',`modified_by`='37',`publish_up`='2011-04-25 12:19:07',`publish_down`='0000-00-00 00:00:00',`access`='1',`featured`='0',`metadata`='robots=\nauthor=',`metadesc`='',`metakey`='',`params`='{\"catItemTitle\":\"\",\"catItemTitleLinked\":\"\",\"catItemFeaturedNotice\":\"\",\"catItemAuthor\":\"\",\"catItemDateCreated\":\"\",\"catItemRating\":\"\",\"catItemImage\":\"\",\"catItemIntroText\":\"\",\"catItemExtraFields\":\"\",\"catItemHits\":\"\",\"catItemCategory\":\"\",\"catItemTags\":\"\",\"catItemAttachments\":\"\",\"catItemAttachmentsCounter\":\"\",\"catItemVideo\":\"\",\"catItemVideoWidth\":\"\",\"catItemVideoHeight\":\"\",\"catItemAudioWidth\":\"\",\"catItemAudioHeight\":\"\",\"catItemVideoAutoPlay\":\"\",\"catItemImageGallery\":\"\",\"catItemDateModified\":\"\",\"catItemReadMore\":\"\",\"catItemCommentsAnchor\":\"\",\"catItemK2Plugins\":\"\",\"itemDateCreated\":\"\",\"itemTitle\":\"\",\"itemFeaturedNotice\":\"\",\"itemAuthor\":\"\",\"itemFontResizer\":\"\",\"itemPrintButton\":\"\",\"itemEmailButton\":\"\",\"itemSocialButton\":\"\",\"itemVideoAnchor\":\"\",\"itemImageGalleryAnchor\":\"\",\"itemCommentsAnchor\":\"\",\"itemRating\":\"\",\"itemImage\":\"\",\"itemImgSize\":\"\",\"itemImageMainCaption\":\"\",\"itemImageMainCredits\":\"\",\"itemIntroText\":\"\",\"itemFullText\":\"\",\"itemExtraFields\":\"\",\"itemDateModified\":\"\",\"itemHits\":\"\",\"itemCategory\":\"\",\"itemTags\":\"\",\"itemAttachments\":\"\",\"itemAttachmentsCounter\":\"\",\"itemVideo\":\"\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemAudioWidth\":\"\",\"itemAudioHeight\":\"\",\"itemVideoAutoPlay\":\"\",\"itemVideoCaption\":\"\",\"itemVideoCredits\":\"\",\"itemImageGallery\":\"\",\"itemNavigation\":\"\",\"itemComments\":\"\",\"itemTwitterButton\":\"\",\"itemFacebookButton\":\"\",\"itemGooglePlusOneButton\":\"\",\"itemAuthorBlock\":\"\",\"itemAuthorImage\":\"\",\"itemAuthorDescription\":\"\",\"itemAuthorURL\":\"\",\"itemAuthorEmail\":\"\",\"itemAuthorLatest\":\"\",\"itemAuthorLatestLimit\":\"\",\"itemRelated\":\"\",\"itemRelatedLimit\":\"\",\"itemRelatedTitle\":\"\",\"itemRelatedCategory\":\"\",\"itemRelatedImageSize\":\"\",\"itemRelatedIntrotext\":\"\",\"itemRelatedFulltext\":\"\",\"itemRelatedAuthor\":\"\",\"itemRelatedMedia\":\"\",\"itemRelatedImageGallery\":\"\",\"itemK2Plugins\":\"\"}',`language`='*' WHERE `id`='18'

If I try to create a new article, when I save it I get a similar message.

Can anyone tell me how to fix this? I'm not a coder so layman terms would be brilliant.

Thanks,
Dom

When I try using this module on my localhost copy of my site, I receive the following error message:

importing items, please stand by
items were successful imported
Row: 10 / memory peak: 13.5 MB
importing items, please stand by
items were imported, but with some problems:

cannot open file: C:\xampp\htdocs\onthego/tmp\

Row: undefined / memory peak: 7.75 MB
Import finished


I tried increasing the memory_limit in xampp's php.ini file from 648MB to 1648MB and restarting Apache and MySQL, but it still fails at the same spot (row 10). It works fine if I split up my spreadsheet, but who wants to do that? ;)

Any ideas on how I can fix this?

Hello everyone, bit of a problem here I've been working on for about 40 hours. I'm trying to import our site's content over to K2 from the standard Joomla content. At first it was timing out throwing a fatal error, most likely due to the amount of articles. We fixed this up increasing the PHP timeout limit.

However now it is throwing a 500 error and after my tech support team took a deep look into everything the import script is itself is making a bad SQL call while trying to import the articles. I haven't submitted a bug tracker yet since I wanted to see if anyone had a solution to this problem. If need be I can post the error log.

Any help would be appreciated as I would like to use K2 and it would suck if we couldn't. We currently run Joomla 2.5.4 and it is a pretty fresh install

Hello,

I am a new user of Joomla (1.5.25), and just installed the frontage slideshow. Everything went OK with the installation, but i cannot upload any image to the slides, because i get the the message "File error...". All files are writable, so i cannot figure out why... I also see that when i choose an image, it doesn't show it in the preview, it only adjusts to its size, and shows a small question mark in the middle.

Please help, i am really confused!

Theodoros


My system:

Web server Apache/2.0.63
PHP version 5.2.6
MySQL version 5.0.92-community
GD Image library bundled (2.0.34 compatible)
Upload limit 2M
Memory limit 32M

Hi there, I run a joomla 1.5.23 website and I recently upgraded my k2 extension from version 2.4.1 to 2.5.6. After upgrading, the main page for k2 displays fine, but whenever you click on any item (to go to details view), the page loads as blank. This does not happen for items created after the upgrade. I tried repair the mysql table, but that did not help. I also tried turning on error reporting, but nothing came up. Does anyone have any ideas about what may be causing this issue and how to fix it? Will I have to recreate every item?

thanks

Hi,

When I create a new K2 item (put against an imported category or a newly created category) and create a menu item for it, the menu item appears, but when I click on the menu item, I get a 404 error.

The same doesn't happen with new Article Manager topics.

1. Web Provider: Hostgator
2. PHP 5.2.17
3. Apache 2.2.21
4. MySQL 5.1.52
5. Fresh Joomla 2.54 install
6. Updated K2 component
8. Joomla .htaccess saved
9. RewriteBase uncommented in .htaccess - set to /
10. .htaccess checked to be working
11. Joomla SEF URLS enabled
12. Joomla URL Rewriting enabled
13. Joomla add suffixes disabled
14. Jooma Cache cleared

I've created new K2 menu items using new K2 topics created in new K2 categories after uninstalling and reinstalling the latest version of K2 - same result.

I'd be grateful for any advice on where to go from here.

Thanks very much.

Gary

I have a live website, LAMP hosted, under Joomla ver 1.5 using K2 ver 2.1 - I need to upgrade these versions.

As a first step, I am recreating the live website on my development computer. My dev computer is LAMP, and I have copied all the live website files and mysql database to it.

The dev website looks OK for the simple Joomla pages, but the one K2 page (a very simple, article-displaying blog) only displays a "Subscribe to this RSS feed" link. I have set all directory permissions to 777, but this didn't help. Everything within the Joomla/K2 administrator seems to be OK (I can see the page category, items, etc - everything is published and not checked out.)

There is one other clue: the home page displays the beginning of the first article of the blog, and has a "read more" link. If I click on this, I get a 404 error page.

Any suggestions on what my problem is?

Thanks in advance for your time!

I have sent my details to Katia.  However, I would imagine that due to the amount of people suffering this issue, she has not got back to me yet.  I have decided to "hack" around this issue to see where the problem lies.

Realising that the image galleries WERE being bought in from flickr (visible in the back-end) I realised that this is a database call issue.  I have played with EVERY setting imaginable within K2 and nothing shows.  I have accessed my db through phpmyadmin (HeidiSQL interface) and all the values are sitting there correctly.  So, I simply added the

into the full-text of the item and....the gallery displays.  The issue here is with the call to the database.  Sadly I am falling short here.  All my read-throughs are showing that the calls are correct.  However I am noting that from the beginning of the rendering this is not showing as being called.  Even though I have ALL the settings on I am NOT seeing an anchor link being rendered into my page.

My knowledge of K2 calls runs out here.  Katia, I think this is the problem.  Potentially a K2 issue, but one that is in your best interest to get a grip on.  Your SIGPro is working fine, but the calls to the db to get the image galleries back is doing nothing.  Over to you.  I suspect this is going to be as simple as you providing us with a "replace this code with this code" answer then pinging your results over to the K2 dev team for 2.5.7 (I will not touch 2.5.6 with a barge-pole after it chewed up 2 of my sites and produce memory limit errors on one of the finest servers I have ever known).

Looking forward to this resolution.

Same problem here
Blank Page on K2 Items in Backend (latest joomla 2.5 with latest k2)
temporary the problem solved if i logout and login back to joomla or if i empty cache and cookies from browser. but returns after few minutes
Server error log (latest PLESK):mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 3898 bytes) in /var/www/vhosts/develsites/httpdocs/libraries/joomla/database/database/mysqli.php on line 498, referer: http://........./administrator/index.php (every time i reload this blank page i got the same error)
same problem with 256Mb or more in php
Dedicated server with 32Gb Ram with centos & Plesk (the 2 other of my sites works perfect in joomla without k2 and wordpress with extremly low cpu utilization)
I tested the site with several server configuration on local machines (xampp, lampp, mampp, plesk,cpanel, centos debian windows) and various host providers WITH THE SAME RESOLTS. I also notice extreme high cpu usage on k2 items (on frontend) with only few users

I have try to install that extension on Joomla 1.6.0 but I hit into situation with an error

Fatal error: Call to undefined method JDatabaseMySQLi:quoteName() in /home/xxxxxx/public_html/administrator/components/com_fpss/tables/slide.php on line 51

Also admin front page says

Error loading component: com_fpss, 1

and there is not additional menu in the Components section.

Permission to /media/com_fpss/ is set to 777 and GD Image Library for PHP is enabled.

Any idea what can be wrong?

Thanks

Hi Will,

All appears well for all Information settings same as before on both installations. (Listing at end of this message.)

BTW, did a Windows XAMPP installation of Rasa Quickstart with demo and K2 is working fine, including User Groups, Extra Fields, and Extra Field Groups.

What I have seen in the past regarding differences between XAMPP and LAMPP have been issues with PHP, so I checked the error log on this Linux system (for security, substituted mysite, mydomain, and mypath in the following transcript text) and saw:

[Thu Apr 26 12:35:36 2012] [error] [client ip address] PHP Warning: require_once(/mypath/administrator/components/com_k2/controllers/usergroups.php): failed to open stream: No such file or directory in /mypath/administrator/components/com_k2/admin.k2.php on line 119, referer: mymachine.mydomain.com/mysite/administrator/index.php?option=com_k2&view=info
[Thu Apr 26 12:35:36 2012] [error] [client ip address] PHP Fatal error: require_once(): Failed opening required '/mysite/administrator/components/com_k2/controllers/usergroups.php' (include_path='.:/usr/share/pear:/usr/share/php') in /mysite/administrator/components/com_k2/admin.k2.php on line 119, referer: mymachine.mydomain.commysite/administrator/index.php?option=com_k2&view=info

Line 119 in administrator/components/com_k2/admin.k2.php is:

require_once (JPATH_COMPONENT.DS.'controllers'.DS.$controller.'.php');


Thanks again.

Sincerely,
reddeer


Here's the K2 information listing:

Web Server Apache/2.2.15 (CentOS)
PHP version 5.3.3
MySQL version 5.1.61
GD image library bundled (2.0.34 compatible)
Multibyte string support Enabled
Upload limit 100M
Memory limit 256M
Open remote files (allow url fopen) Yes

Directory permissions report result Writable.

All K2 modules display installed.

All K2 Plugins (System, Module, and Search) display Installed - Enabled

Fresh new installation of Rasa Quickstart with demo content and no additional extensions. The problem (blank page for User Groups, Extra Fields, Extra Field Groups, but no Joomla debug or other error message) still occurs. Installed with a new MySQL(i) table just to isolate.

I've not tinkered with any of the permissions on the installed directories or files.

Server is CentOS
Ownership apache.apache for all
Default directory permission is 755
Default file permission is 644

Just for grins, I'll try the installation again on a Windows system to determine if there is any difference.

Will, do you have any ideas?

Hello everyone, I am writing because I have problems with the management of users through K2.


I recently changed servers and then I reloaded all the files from the backup I had made​​, including the database. From some time, however, this problem arises. If I go on K2 in the administration of users and for example decide to change an avatar to a user, when I save I get this error:

TableK2User::store failed - Unknown column 'ip' in 'field list' SQL=UPDATE `jos_k2_users` SET `userID`='467',`userName`='User name',`gender`='m',`description`='',`url`='',`group`='1',`ip`='',`hostname`='',`notes`='' WHERE id='406'

How can I fix? Thanks in advance ;)

Hello!
Joomla 2.5 + K2 2.5.6 Installed

While trying to add Category in K2 the following error appeared:

Error 500
Table 'alkor_rentals.nezyv_finder_types' doesn't exist SQL=SELECT `id` FROM `nezyv_finder_types` WHERE `title` = 'K2 Item'

But tags, additional fields are created with no any problem. What can it be?

After a few installations of the FrontpageSlideshow-v3.0.2 in a shared server with Joomla 1.5 we started having DB errors. So, to save the day we simply uninstalled fpss, erased all dirs, files and tables, and installed again. Only this time we got this error:We recently had an issue on the same server with InnoDB being disabled after a mysql upgrade. So I double checked if InnoDB was enabled:Server info:
mysql: 5.1.61-log
PHP: 5.2.17
So I came here to download the most recent fpss version from the PDS are, but after 5 tries I keep getting timeouts every time I start a new download. Even this topic was a nightmare to post!

Please advice!

If you do not use the K2 Smart Search you can safely disable it to fix the problem.

joomla admin > Extensions > Plugin Manager > Disable "Smart Search - K2" plugin.

I installed the last K2 (2.5.5) for Joomla 2.5 (2.5.3)
When i want to create a new category, if i click save i get a error:

Joomla!
500 - An error has occurred.

Table 'mercur_15.mercur17_finder_types' doesn't exist SQL=SELECT `id` FROM `mercur17_finder_types` WHERE `title` = 'K2 Item'

Return to Control Panel

I'm on localhost wamp+win 7:

PHP Built On Windows NT PENRYN 6.1 build 7601 (Windows 7 Home Premium Edition Service Pack 1) i586
Database Version 5.5.16-log
Database Collation utf8_general_ci
PHP Version 5.3.8
Web Server Apache/2.2.21 (Win32) PHP/5.3.8
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.3 Stable [ Ember ] 15-March-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0

I'm having a table problem with my K2 Items and Categories.

I used jUpgrade to update joomla and k2 and tthen I followed up by upgrading k2 (twice now to 2.5.5)

first problem was that k2 menu items became unwired, open and saving seemed to fix that.

remaining problem is that I can edit/save or create new k2 items. Getting the following error.

Joomla!
500 - An error has occurred.

Table 'datxxx_dbxxx.a86c3_finder_types' doesn't exist SQL=SELECT `id` FROM `a86c3_finder_types` WHERE `title` = 'K2 Item'

Please help, I'm stuck.