Never mind.

I got the right version now.

Thanks,
Peter


abhijeet said:Hello my friend , Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.

This plugin not working, see error:
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' FROM #__k2_items AS i LEFT JOIN #__jf_content as jfc ON reference_id =' at line 14 SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, jfl.code AS jflang, jfl.name AS jflname' FROM #__k2_items AS i LEFT JOIN #__jf_content as jfc ON reference_id = i.id LEFT JOIN #__languages as jfl ON jfc.language_id = jfl.id INNER JOIN #__k2_categories AS c ON c.id=i.catid AND c.access <= 0 WHERE ((LOWER(jfc.value) LIKE '%search..%')) AND i.trash = 0 AND i.published = 1 AND i.access <= 0 AND c.published = 1 AND c.access <= 0 AND c.trash = 0 AND jfc.reference_table = 'k2_items' AND jfl.code = '' GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

I share the same problem. When trying to install K2 Component, it shows me this error:


* JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

* Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

* Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

Hi, I'm using Joomla 1.5.21 Stable,
PHP version is: 5.2.14
Mysql version is: 5.0.91

I use the latest version of K2 - 2.4.1. When I add a new item, after i add the title, tag and the content itself, when i go to image tab to add or select a local image from my server, after i choose to save the article, it takes me to a blank page without any succes, if i chose to save that article without an image, it works perfectly. The same problem appears when i choose to upload a video, only this options is not taking me to a blank page, it's taking me to a 500 page error.

I've check if i got permision to the media directories and I do, the k2 information options seems to be right.

What should I do ? My website is www. peacock .ro if anybody needs to see the backend shoud anounce me and i'll create an account.

Hello, i have use k2 component many times, and i haven't the problems with k2. But now, i have same problems with k2, i have error when i create more than 7 items in category.See error: No valid database connection MySQL server has gone away SQL=SELECT id,
title, module, position, content, showtitle, control, params FROM
svs_modules AS m LEFT JOIN svs_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND (
mm.menuid = 330 OR mm.menuid = 0 ) ORDER BY position, ordering.When i create the 8td item, i have this error. When i unpublish the 8td item, the k2 component work without errors. How i can create more than 7 items? ;) This error is appears in all module places. I have use last Version 1.5.21 and last k2 version, and i use xampp platform.

Can any body help me? ;)

On 2 different sites I have problems Upgrading K2. All other components and plugins can be upgraded simply. This is the error in Dutch "Er is een fout opgetreden" in English "There is an error"FTP layer is enabled. Can't figure out why it's not working.Domain is on a 92.xx.xxx.xx/~name right now, is that causing problems??PHP versie:


5.2.12 Mysql: 5.0.67-I saw some other posts with te similar problem but no solution. Who has the answer?

Hi. What do you mean by no siet available? Do you get any error?



Mats Arvendal said:I deleted my non-working dummy and created a new one by these steps:
1. Uploaded a total copy of all files the live Joomla/K2 website to the folder of my dummy
2. Changed the configuration.php file to the new variables
3. Imported a MySQL dump of the live site's db to a specific dummy database
4. Checked that the dummy worked (which it did)
5. I installed the K2 v 2.4.1 over the v 2.2 in the dummy
6. No website available!!!

I have no hacks in K2 core files. I have only added more templates to the folders modules/mod_k2_content and templates/html/com_k2.

Has anyone experienced any problems like this? I don't dare to upgrade the live site until I know what's wrong.

Rgds

I deleted my non-working dummy and created a new one by these steps:

1. Uploaded a total copy of all files the live Joomla/K2 website to the folder of my dummy
2. Changed the configuration.php file to the new variables
3. Imported a MySQL dump of the live site's db to a specific dummy database
4. Checked that the dummy worked (which it did)
5. I installed the K2 v 2.4.1 over the v 2.2 in the dummy
6. No website available!!!

I have no hacks in K2 core files. I have only added more templates to the folders modules/mod_k2_content and templates/html/com_k2.

Has anyone experienced any problems like this? I don't dare to upgrade the live site until I know what's wrong.

Rgds

Hi, I've just installed the K2 extension but I keep getting these errors right after the installation:


Notice: K2 Content Elements for Joom!Fish were not copied to the related folder, because Joom!Fish was not found on your sytem.
Installazione componente: eseguita correttamente







Thank you for installing K2 by JoomlaWorks, the powerful content component for Joomla! 1.5.

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.telefilm-central.org/home/libraries/joomla/database/database/mysql.php on line 678Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /web/htdocs/www.telefilm-central.org/home/administrator/components/com_k2/install.k2.php on line 74Warning: Invalid argument supplied for foreach() in /web/htdocs/www.telefilm-central.org/home/administrator/components/com_k2/install.k2.php on line 118Warning: Invalid argument supplied for foreach() in /web/htdocs/www.telefilm-central.org/home/administrator/components/com_k2/install.k2.php on line 138







Please, anyone can help me with this?
Though it says that installation has been successful, whenever I try to add a User Group or any other item in the K2 Dashboard I keep getting one of those errors.

I used K2 for some days and updated to K2 version 2.4.1. Now I am unable to publish articles. The following error appears, if I press the Save or the Apply-Button:Fatal error: Call to undefined function mb_regex_encoding() in /mnt/web1/23/10/52192710/htdocs/administrator/components/com_k2/tables/k2item.php on line 75I am working woth Mac OS X 10.6Webhoster: Strato (I know that's bad, already looking for another one)PHP5mySQL 5.0.67Please help me!ThanksDaniel

phpMyAdmin
click on "jos_k2_items" table and then click on the SQL tab
and run
REPAIR TABLE jos_k2_items

Hi i get this error when i have in k2 nested categories and want to list deeper one .DB function failed with error number 1064You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ': AND published=1
AND trash=0 AND access<=0' at line 1 SQL=SELECT * FROM jos_k2_categories WHERE id=82: AND published=1 AND trash=0 AND
access<=0DB function failed with error number 1064When sh404sef is off, there is no problem, problem is when sh404 sef is ON.where can edit sql qery to fix it?thanksPeter

I don't know whether this is discussed or not, but if someone tries to find a wat to do this, i first imported all of my jcomments comments into k2-jcomments comments. Then i tried to import them into k2-comments and i can do it so. But jcomments is much more complicated then k2 comments. The only thing that made me import all my jcomments to k2 comments is gavick's postnote template has an error for using jcomments plugin that they didn't give any help to fix it. So i imported everything to k2 comments. That is how i did this. (beware to make a backup of everything and know that it needs a medicre mysql usage knowledge) - First i checked my joomla article id's and k2 article id's. I saw that they are the same, that gave me the idea. Also i saw that it uses "com_content" and k2 comments uses "com_k2"- I installed jcomments k2 plugin.- Then entered into phpmyadmin and find jcomments table from mysql. - I exported the table. Then i opened jcomments.sql (or whatevername i give) with wordpad. - I changed "com_comment" to "com_k2" with find and replace function of wordpad.- then i dropped jcomments table from database and imported sql that i changed.- Ta daaa jcomments are all there. :) ( I hope i didn't forget anything)In the second step i imported jcomments to k2 comments. This is much complex.- i exported k2_comments table then opened it in wordpad. Then i copied everything under jcomments under the line "table structure `jos_jcomments". Then copied it under the line "table structure jos_k2_comments`line under k2 comments sql.- i changed "jos_jcomments" to `jos_k2_comments` with change replace function of worpad in k2_comments.sql that i changed.- Then i dropped k2_comments table, and imported the file that i created.- Then i opened the table structure of the new table i created, but now i know that i had to fix it into like k2 comments table structure.- I don't have a table structure before, may be before dropping table, you can take photoshot of every step of k2 comments table structure. I have another joomla site that have k2, so i opened its database and make everychange by looking to this.- i deleted fields that i do not need, and changed the names of jcomments structure as like k2's comments.- Then when i checked my site, every comment is there. :) Now i can use k2 comments with existing jcomments in my site without losing anything.I hope this helps and gives the idea of people like my situation. I'm not an expert or pro. But that is a way that i can succeed and i want to share it with you.Thanks.

You need to check your database table jos_k2_items.

I had this error and all my articles disappeared. :eek:

Line 80 is a foreach() loop trying to pull data from your database. If you have something to interact with your database directly then use it: eg. phpMyAdmin or Navicat. You need permission to run SQL queries against your database.

This is the fix if your table has crashed, when you click to browse it you get the following error:
#145 - Table './jos_k2_items' is marked as crashed and should be repaired

In phpMyAdmin:
1. Select the database in use
2. Click to browse the table "jos_k2_items"
3. Click on "SQL" tab (where you can run a query)
4. Type "REPAIR TABLE jos_k2_items"

I've documented this on my site at www.joellipman.com/articlesdocumentation/web-development/joo...

NOTE: the default prefix for your Joomla! database tables is "jos_". If you changed this during the install of your Joomla! website then you'll need to change the command 'REPAIR TABLE (name of the table with your K2 articles)'

Hi there!I have some errors in articles that show SQL querys regarding K2 tables. I don't know what's the issue and it seems to work properly but how can I do to fix that or, at least, hide that?You can see this here: greensf.es/es/noticias-eventos/item/17-lanzamiento-de-tauro-printing-intelligence%C2%AE-la-tecnolog%C3%ADa-al-servicio-de-un-ahorro-eficiente-y-ecol%C3%B3gicoNo valid database connection You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'SELECT tagID FROM jos_k2_tags_xref WHERE
itemID=17)' at line 1 SQL=SELECT * FROM jos_k2_tags as tags WHERE
tags.published=1 AND tags.id IN (SELECT tagID FROM jos_k2_tags_xref
WHERE itemID=17)

Hi there and thanks for this awesome component!
We are having trouble in one of our sites installing K2.
We installed K2 v2.3 and when we try to add a new category we get the message:

TableK2Category::store failed - Table 'implementaweb.jos_k2_categories' doesn't exist SQL=INSERT INTO `jos_k2_categories` ( `id`,`name`,`alias`,`description`,`parent`,`published`,`access`,`ordering`,`params` ) VALUES ( '','prueba','prueba','','0','1','0','','inheritFrom=0\ntheme=\nnum_leading_items=2\nnum_leading_columns=1\nleadingImgSize=Large\nnum_primary_items=4\nnum_primary_columns=2\nprimaryImgSize=Medium\nnum_secondary_items=4\nnum_secondary_columns=1\nsecondaryImgSize=Small\nnum_links=4\nnum_links_columns=1\nlinksImgSize=XSmall\ncatCatalogMode=0\ncatFeaturedItems=1\ncatOrdering=\ncatPagination=2\ncatPaginationResults=1\ncatTitle=1\ncatTitleItemCounter=1\ncatDescription=1\ncatImage=1\ncatFeedLink=1\nfeedLink=1\nsubCategories=1\nsubCatColumns=2\nsubCatOrdering=\nsubCatTitle=1\nsubCatTitleItemCounter=1\nsubCatDescription=1\nsubCatImage=1\nitemImageXS=\nitemImageS=\nitemImageM=\nitemImageL=\nitemImageXL=\ncatItemTitle=1\ncatItemTitleLinked=1\ncatItemFeaturedNotice=0\ncatItemAuthor=1\ncatItemDateCreated=1\ncatItemRating=0\ncatItemImage=1\ncatItemIntroText=1\ncatItemIntroTextWordLimit=\ncatItemExtraFields=0\ncatItemHits=0\ncatItemCategory=1\ncatItemTags=1\ncatItemAttachments=0\ncatItemAttachmentsCounter=0\ncatItemVideo=0\ncatItemVideoWidth=\ncatItemVideoHeight=\ncatItemVideoAutoPlay=0\ncatItemImageGallery=0\ncatItemDateModified=0\ncatItemReadMore=1\ncatItemCommentsAnchor=1\ncatItemK2Plugins=1\nitemDateCreated=1\nitemTitle=1\nitemFeaturedNotice=1\nitemAuthor=1\nitemFontResizer=1\nitemPrintButton=1\nitemEmailButton=1\nitemSocialButton=1\nitemVideoAnchor=1\nitemImageGalleryAnchor=1\nitemCommentsAnchor=1\nitemRating=1\nitemImage=1\nitemImgSize=Large\nitemImageMainCaption=1\nitemImageMainCredits=1\nitemIntroText=1\nitemFullText=1\nitemExtraFields=1\nitemDateModified=1\nitemHits=1\nitemTwitterLink=1\nitemCategory=1\nitemTags=1\nitemShareLinks=1\nitemAttachments=1\nitemAttachmentsCounter=1\nitemRelated=1\nitemRelatedLimit=5\nitemVideo=1\nitemVideoWidth=\nitemVideoHeight=\nitemVideoAutoPlay=0\nitemVideoCaption=1\nitemVideoCredits=1\nitemImageGallery=1\nitemNavigation=1\nitemComments=1\nitemAuthorBlock=1\nitemAuthorImage=1\nitemAuthorDescription=1\nitemAuthorURL=1\nitemAuthorEmail=0\nitemAuthorLatest=1\nitemAuthorLatestLimit=5\nitemK2Plugins=1\n\n' )

We tried to uninstall and install again but it didn't work, and we don't find any other discussion with the same error so... here we are :)

Thank you very much!

Now I can't even get to Article Manager in Joomla :-( Fatal error indeed.

Fatal error: Out of memory (allocated 103284736) (tried to allocate 46 bytes) in /home/globalpr/public_html/k2gpm/libraries/joomla/database/database/mysql.php on line 462

Tim

William White said:Try on a test environment, but i am pretty sure that k2 import buttion "will" create a copy of the items in k2 if you click it twice. I think that the import joomla was a means to get k2 up and running quickley and not to routinely import items...unless you import once, delete all joomla content, add joomla articles, import into k2, delete them now so as not to duplicate on next import.

I understand that in the Joomla + K2 environment that the way to avoid duplicates of imported articles is to archive those that have already been imported. Maybe someone could work out a way to run a process where joomla content is pulled (and replaced/deleted) in smallish chunks from a pseudo temp archive to build the import to K2 until it's finished without hitting memory allocation errors. I'm not expressing this concept too clearly but hopefully the gist is decipherable:-) Meanwhile I'll try to contact Arthur.

William White said:There may be a simple solution, but tracking it down might be difficult. The environment can have many settings that will affect whats going on. My idea was to "avoid" the Joomla environment and overhead partially by using the server php/mysql environment only at first to get the data. Then let Joomla enviornment with its built in overhead take a smaller piece at a time. I have seen/written desktop apps that run in a database environment where you get an odbc connection to the remote table, then copy it to a local file, process it locally to change the structrure and reorganize it in the needed format, then insert it into the "other" in this case k2 tables to get the desired result.
Arthur @ the link i supplied should probably already know about the limitations of his extension

There may be a simple solution, but tracking it down might be difficult. The environment can have many settings that will affect whats going on. My idea was to "avoid" the Joomla environment and overhead partially by using the server php/mysql environment only at first to get the data. Then let Joomla enviornment with its built in overhead take a smaller piece at a time.
I have seen/written desktop apps that run in a database environment where you get an odbc connection to the remote table, then copy it to a local file, process it locally to change the structrure and reorganize it in the needed format, then insert it into the "other" in this case k2 tables to get the desired result.
Arthur @ the link i supplied should probably already know about the limitations of his extension

Thanks. I follow your suggested method, however, even the compressed Akeeba .gpa backup file is > 350MB for this site. How big do you think the CSV download file might be? Until the K2 Import content feature is improved (automatic forced splitting into manageable chunks?) adding the K2 component to an existing largish Joomla 1.5 site seems, at first sight, impracticable at best.

Tim

William White said:I would try breaking the import into smaller chunks. As there is not a way to do this with default k2, i would first try: phpmyadmin - export to csv, bring the file to local machine
use xcel or local mysql, or other database program to split the file into multiple csv files
then i would use www.individual-it.net/en/Joomla/ to import the articles to items.
If your articles are divided into groups by joomla section and/or category that may be a way to use phpmyadmin to break them into chunks