OK.

I installed it and it works for existing articles.

But when I want to create a new one I get an error :

" 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 ')}' at line 1 SQL=SELECT `catid` FROM fabu_k2_additional_categories WHERE `itemID` = {intval()}".

Hi,

I'm having two issues with adding Joomla users to K2 groups. I read this page of the K2 documentation but I this doesn't help: getk2.org/documentation/tips-a-tricks/201-allowing-users-to-submit-content

First: I have only one K2 user group, it's called Registered. I want new Joomla users to be added automatically to this user group. In Joomla core user administration they may have different user groups but in K2 they may have the same rights. As I think of it now, I could create different groups in K2 and grant them the same rights. However: the main question is: how can I assign a new Joomla user to a K2 group automatically, as I fail do do so until now.

Second: I already have some Joomla users in my administration. I tried to batch assign them to the K2 user group, as described on the documentation page that's mentioned above. This results in an error message:

1136 Column count doesn't match value count at row 1 SQL=INSERT INTO #__k2_users VALUES ('', 1006, 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '', '', '', '', 1, '')

In which I removed the original prefix of my database and changed the e-mail address of the user.

Joomla 3.3.6, K2 2.6.8

Turn on system debugging under global configuration and look for any SQL errors when you access the items page.

Your site is not loading for me. I get "Error displaying the error page: Application Instantiation Error: Could not connect to MySQL." The message after comment is not supposed to be displayed in a new page. In your case i guess that there are javascript errors in your page however i cannot tell more since your site is not loading.

hi i want to create module for k2 .
i want your help.
when i select from module id 1 from item to show title and fulltext from db.
i want to select multi id from admin e.g Select id : 1, 2

query is this _{$db = JFactory::getDbo();
$query = 'SELECT * FROM #__k2_items WHERE id ='.$params->get('id');
$db->setQuery($query);
$result = $db->LoadObjectList();
return $result;}

loop is this : ^{<div class="nameclas" style="width:200px;">
<?php foreach ($result as $row) :?>
<h1><?php echo $row->title; ?> </h1>
<?php endforeach ; ?>
</div> :(}

if i select id 1 from backend My returns the title one..
if i select id 1, 2 from backend i have this error... 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 '2' at line 1 SQL=SELECT * FROM d1l9y_k2_items WHERE id =1,2..... please help me... sorry for my english sucks :D

​Best regards,
Evanggelos E. Goritsas

After spending about 3 hours to make all content was moved over and installing Joomla 3.3.3 and everything was working correctly, it happened again!

No item images and cannot edit anything in the Category item layout or some of the items in the Item view options in category listing.

The issues include
Layout Grid
Other layout options
Category View Options
and some items in the item view options.

I went ahead and updated to Joomla 3.3.6 and running K2 2.6.8.

I have been digging through the database and code and can't find the issue.

I searched through the error logs and did see this:

[13-Oct-2014 01:26:40 UTC] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

It was recommended to comment out:
;extension=pdo_sqlite.so
;extension=pdo_mysql.so

Even though the error is still there I'm not sure this is the issue.

Any help is greatly appreciated!

Matt D

Hello all!

I have this problem: "Error 1213. Deadlock found when trying to get lock; try restarting transaction SQL=UPDATE `jos_finder_terms` AS t INNER JOIN `jos_finder_links_terms5` AS m ON m.term_id = t.term_id SET t.links = t.links - 1 WHERE `link_id` = 916 AND m.link_id = '916'"

Help me pleaseee!! :woohoo:

PS. Joomla plagins with Smart search I am disabled (all 8 ).

@Michael

The save function gives a 500 status in response which means that probably an SQL query fails. Are you sure you have enabled error reporting under Joomla! configuration? Go to Joomla! global configuration and set error reporting to "maximum" . Also enable system debugger. Then try to add the item again. Report here any printed error messages.

i have the same problem- any ideas??? 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 ' 6661)' at line 1 SQL=INSERT INTO g3qth_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 6661)

Hi. Enable system debugger under Joomla! configuration to see any SQL errors.

You are welcome.

Thank you for your help. I changed k2 search plugin for another. It works perfectly :) thank you.

Hi, I did, and I get this error message:

Regards

Not much else to say. if I had any idea why this is happening, I would have more. I must say that I am having way more issues with K2 than I ever did with vanilla Joomla. How can I uninstall K2 and return/transfer my items to Joomla articles?

1064 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 ')}' at line 1 SQL=SELECT `catid` FROM eo8l4_k2_additional_categories WHERE `itemID` = {intval()}

Hi

When I'm Import database, the following error is displayed:



--

---

--
-- Table structure for table `floyd18_k2_items`
--

CREATE TABLE IF NOT EXISTS `floyd18_k2_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`alias` varchar(255) DEFAULT NULL,
`catid` int(11) NOT NULL,
`published` smallint(6) NOT NULL DEFAULT '0',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`video` text,
`gallery` varchar(255) DEFAULT NULL,
`extra_fields` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`extra_fields_search` text NOT NULL,
`created` datetime NOT NULL,
`created_by` int(11) NOT NULL DEFAULT '0',
`created_by_alias` varchar(255) NOT NULL,
`checked_out` int(10) unsigned NOT NULL,
`checked_out_time` datetime NOT NULL,
`modified` datetime NOT NULL,
`modified_by` int(11) NOT NULL DEFAULT '0',
`publish_up` datetime NOT NULL,
`publish_down` datetime NOT NULL,
`trash` smallint(6) NOT NULL DEFAULT '0',
`access` int(11) NOT N[...]

MySQL said: Documentation
#1214 - The used table type doesn't support FULLTEXT indexes

What should I do?

Hi

Who I'd like to install 2, but after the installation the following error displays:

The used table type doesn't support FULLTEXT indexes SQL=ALTER TABLE floyd18_k2_items ADD FULLTEXT `search` (`title`,`introtext`,`fulltext`,`extra_fields_search`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`metadesc`,`metakey`)

joomla 3.3

What should I do?

thanks

The reason they get parent_id zero is that the asset of the category is not saved correctly. That's why i asked you to edit the category and save it.

The asset category has now been opened and saved.

When slides are saved their asset entries should get as parent the asset id of the category. If that's zero then you have a problem.

I know.

The category's asset entry now should have as parent the id of the component entry. Once again if this is zero there is a problem.

This has been the case the whole time.

How you transferred the slides out of the category? Have you moved them to a different category? Have the assets changed correctly when you moved them? Can you check all the FPSS relevant asset entries? Can you verify that FPSS is indeed inserting zeros while the data is different in the assets table? A dump of the FPSS related entries of your database would be very helpful.

I created a new category called "temp" and opened the slides one by one and set them to this new category. After that did the same transfering them back to the original category. I did not check the database in between the transfers to make sure that the cahnges took place but on the Slides-view they seem to have the correct category.
I opened the assets-table in PHPMyAdmin and searched the name field for fpss with the LIKE %..% search. This resulted in six entries.
One for com_fpss (the component) with parent_id 1, level 1 and id 863.
One for com_fpss_category.2 with parent_id 863 and level 2 and id 2167
One for each com_fpss_slide.5 through 8 with parent_id 0 and level 3 each.
I then manually corrected the parent_ids of the slides to 2167.
This problem has now surfaced two times and these are the only times that slides have been added to FPSS, so I would deem the connection established and causality confirmed but certainly I can try to duplicate it once more.

Here's a FPA generated report on the site:

Part of the message is hidden for the guests. Please log in or register to see it.

Hi Community, yesterday I started a journey with one of my sites, I uograde from 2.5 to 3.3.4. Using the Joomla update (Short Term Support) Everything was fine, no errors.

AFTER I installed everything from Joomlart ja-lens template, then K2 .

Then I tried to import the joomla articles to K2 and here is the error

Displaying 241 - 260 out of 789 results.

1. Forum
3. Search