buongiorno a tutti.
sto provando ad installare K2 v. 2.6.9 su joomla! 3.3.6 ma quando carico il modulo mi da questo errore:


1146 - Si è verificato un errore.
Table '83f9ce525_9fe1ac.dbm_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `dbm_k2_categories`

potete aiutarmi?

grazie.

Buenas tardes,

Al intentar instalar K2 en mi página Joomla, me sale el siguiente error:

1146 Table 'ulmsrcoj_aiesecbellaterra.wykju_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `wykju_k2_categories`

Alquien sabe que puede ser?

Gracias!

EDITO: Solucionado! Buscando por la red, vi que tenía que buscar por las carpetas de: Modulos y Aministrator que no existiera la carpeta de k2. Las vi, las eliminé y ¡solucionado!

I have this problem. No open K2 USER PAGE
ERROR 0 SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM zhlic_users as juser LEFT JOIN zhlic_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN zhlic_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN zhlic_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc LIMIT 0, 50

Hi, actually there is no specific message. The browser simply pop's up a window saying Apache is not responding. Then browser window just says page did not load. There is nothing else in the window. And no error in Apache or SQL log.

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