Yes :-/

this is what i've found out while trying to troubleshoot on my Virtual machine with xampp...
after updating to the k2_dev_build i get back the following SQL error, i am sorry, that's all i can deal with :-/

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 j3_k2_items as i LEFT JOIN j3_k2_categories AS c ON c.id = i.catid' at line 1 SQL=SELECT i.*, v.name AS author, (SELECT COUNT(*) FROM j3_k2_comments WHERE itemID = i.id) AS numOfComments, FROM j3_k2_items as i LEFT JOIN j3_k2_categories AS c ON c.id = i.catid LEFT JOIN j3_users AS v ON v.id = i.created_by WHERE i.trash = 0 AND c.trash = 0 ORDER BY numOfComments DESC LIMIT 0, 10

I found 4 files in the Discover list and installed them, then reinstalled K2 v2.6.8 (Dev Build).

Created a new item and saved it. Then saved it again and the create date and publish date both advanced by 8 hours each time I click save.

Sorry, it didn't work. :( What's next? ;)

EDITED to add:
Also I have the following error on the Control panel page now:
An error has occurred.
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 'FROM ulrw_k2_items as i LEFT JOIN ulrw_k2_categories AS c ON c.id = i.c' at line 1 SQL=SELECT i.*, v.name AS author, (SELECT COUNT(*) FROM ulrw_k2_comments WHERE itemID = i.id) AS numOfComments, FROM ulrw_k2_items as i LEFT JOIN ulrw_k2_categories AS c ON c.id = i.catid LEFT JOIN ulrw_users AS v ON v.id = i.created_by WHERE i.trash = 0 AND c.trash = 0 ORDER BY numOfComments DESC LIMIT 0, 10

You are correct, I am using Joomla v3.2.1.

I updated K2 to the SVN version:
K2 v2.6.8 (Dev Build) | Copyright © 2006-2014 JoomlaWorks Ltd.

But I am still getting the error message:
An error has occurred.
1136 Column count doesn't match value count at row 1 SQL=INSERT INTO g83da_k2_users VALUES ('', 802, 'alpha', '', '', '', '', 1, '')

Hi.

I just installed Akeeba Admin Tools on Joomla 2.5.18. I have K2 2.6.7 installed.

If I enable the Akeeba System Admin Tool Plugin, I get a blank white screen in the front end and also in the backend.

If I ftp to site and delete the plugin, the site starts working again.

I tried setting Joomla error reoprting to max and now I get this error msg in front and backend:

Fatal error: Cannot make static method JModel::addIncludePath() non static in class K2Model in /var/www/vhosts/nmcexquisite.com/httpdocs/administrator/components/com_k2/models/model.php on line 0


The Akeeba team feels the K2 code needs fixing.

Can anyone please help.

Regards

Basheer

Joomla! version (in x.y.z format)
2.5.18rc
PHP version (in x.y.z format)
5.2.17
MySQL version
5.1.56

Hello,

I followed this guide here:
Allowing users to submit content
getk2.org/documentation/tips-a-tricks/201-allowing-users-to-submit-content

When I got to the Move your existing users to the k2 user group, I got this error message when I click on Save:

An error has occurred.
1136 Column count doesn't match value count at row 1 SQL=INSERT INTO g83da_k2_users VALUES ('', 802, 'alpha', '', '', '', '', 1, '')


and no user were moved.

I am using the latest joomla and k2.

Thanks

I have exactly the same issue. As soon as I tried to list the users by Joomla user group I got

Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM j25_users as juser LEFT JOIN j25_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN j25_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN j25_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, 20

I've tried the stuff listed here but none of it worked and I now can't get into the user list in the back end. I'm using Joomla 3.1 and have tried installing the developer release of K2 as suggested.

1146 - An error has occurred.

Table 's562559db0.cgn5u_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `cgn5u_k2_categories`

Please how to fix it?

I forgot another error seen when I head into the K2 parameters section:

Table 'xxxxxxxxxxxx.j25_k2_user_groups' doesn't exist SQL=SELECT id AS value, name AS K2UserGroup FROM j25_k2_user_groups

Bryan

I think I have the same problem. I get this error after attempting to create a new user group:

Error after attempting to create new group:
TableK2UserGroup: :store failed
Table 'xxxxxxxxxxxx.j25_k2_user_groups' doesn't exist SQL=INSERT INTO `j25_k2_user_groups` .... (plus details of the user group it was trying to insert into a table that doesn't seem to exist)

But, lets take a step back as the errors started with the install (which like the OP I've re-installed multiple times to no avail). Yes, I'm installing the latest version (v 2.6.7), as far as I know.

This is the error I get upon installation on the install page:

Warning: Invalid argument supplied for foreach() in ....//libraries/joomla/database/database/mysql.php on line 375

Line 375 of that mysql.php file looks like this:
I imported the articles and that worked just fine. And I attempt to import the users, and that doesn't work so well. Seen on users K2 page:

Warning: Invalid argument supplied for foreach() in ....//administrator/components/com_k2/views/users/view.html.php on line 130

Warning: Invalid argument supplied for foreach() in ....//administrator/components/com_k2/views/users/tmpl/default.php on line 74

Line 130 of view.html.php looks like this:and line 74 of default.php looks like this:
So, I head over to the K2 user groups page:

Warning: Invalid argument supplied for foreach() in ....//administrator/components/com_k2/views/usergroups/tmpl/default.php on line 52

Line 52 of default.php looks like this:
And, when I click through to add a user group I see this (before attempting to add the user group)

Warning: Invalid argument supplied for foreach() in ....//libraries/joomla/database/database/mysql.php on line 383

Line 383 of that mysql.php file looks like this:
If I head in to the php admin I see that indeed, the "j25_k2_user_groups" does not exist. Nor is there a table for the users.

So, how do I create a table for the K2 users & usergroups? I tried simply copying the j25_usergroups table and renaming it to j25_k2_user_groups but that didn't work out.

So, does anyone have any insight? Dave, did you find somehting that worked?

Some possibly relevant information: PHP Version 5.4.24

Thanks in advance,
Bryan

Hello Lisa,

Glad you located your issue after all. As it turned out this had nothing to do with K2 but a third party extension from Gavick. You can PM them and ask for their support in the matter.

www.gavick.com/supportdesk/

Still not working. I ran the database fix, tried it and got the 1064 error.
Then I disabled the dynamap and tried to make a new item and got the 1064 error


Got a message from my web host this morning who did some debugging.
So I disabled Gk4 module and I still get the 1064 error.

Additionally - here is what he said when he debugged:

I've debugged the code and found the invalid SQL query was being generated by line ~260 in ./modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php. The offending query (pasted below) had an empty WHERE condition.

I've added this code to line 258 to put a '1' in the SQL query if the WHERE condition is empty:
if (empty($second_sql_where))
$second_sql_where = '1';

The site is now loading :)

The job now is finding out why $second_sql_where (generated on line 228) was empty in the first place

Offending query:

SELECT
content.id AS ID,
cats.name AS cat_name,
cats.alias AS cat_alias,
content.catid AS cat_id,
users.name AS author,
users.email AS author_email,
users.id AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROM
j3_k2_items AS content
LEFT JOIN
j3_k2_categories AS cats
ON cats.id = content.catid
LEFT JOIN
j3_users AS users
ON users.id = content.created_by
LEFT JOIN j3_k2_tags_xref AS tx ON content.id = tx.itemID LEFT JOIN j3_k2_tags AS t ON t.id = tx.tagID
LEFT JOIN
j3_k2_rating AS content_rating
ON content.id = content_rating.itemID
WHERE

ORDER BY
content.created DESC

Is there any way I can PM someone and have my site fixed?? This is ridiculous that these problems are persisting and I have businesses depending on the software.

Thanks!

Thank you, Yiouta!

I was hoping that might be possible.

Can the extra fields editors be brought forward instead of being in a tab behind the normal editor? It would be great to create a custom admin template.

I did find this post yesterday:

getk2.org/documentation/tips-a-tricks/221-custom-admin-templates-and-calling-specific-extra-field-data

But when I tried to implement it, I got this error
An error has occurred.
1146 Table 'joomla3.e758z_templates_menu' doesn't exist SQL=SELECT template FROM e758z_templates_menu WHERE client_id = 0 AND menuid = 0

It could be those instructions were for Joomla 2.x as it is about 2 years old. I am using Joomla 3. Also the links in the post gave a 404.

Thanks again!

Please try to Fix your database through the Extension Manager -> Database or repair it through your phpMyAdmin. Also try to Disable the K2 Dynamap and check again.

:(

The problem is still persisting after the update to the development version of K2. The same error I previously posted is occurring.

I also tried to create a new item and got the following 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=DELETE FROM j3_k2_tags_xref WHERE itemID={intval()}

I seriously need help to resolve these issues...

No luck.

I re-downloaded the version a few minutes ago and tried to upload to the site and the same SQL=SHOW FULL COLUMNS FROM `ccl_k2_categories` error came up.

Please update to K2 2.6.8 DEV build -

Let me know if the issue persists. getk2.org/assets/get/

I'm having the same issue and getting the error after upgrading. I have J3.2 and latest version of K2. I am using the K2 Dynamap however it was upgraded to work with J3.x

I'm also having a lot of other error messages and problems like:
looking at MySQL and I see a lot of queries that are taking a long time (this one took 7 seconds) similar to:

SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname
FROM j3_k2_comments as c
LEFT JOIN j3_k2_items as i ON i.id=c.itemID
LEFT JOIN j3_k2_categories as category ON category.id=i.catid
WHERE i.published=1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-08 17:00:22' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-08 17:00:22' )
AND i.trash=0 AND i.access IN(1,1) AND category.published=1 AND category.trash=0 AND category.access IN(1,1) AND c.published=1 AND i.catid IN(53) ORDER BY c.commentDate DESC LIMIT 0, 6

Keep getting an upload error when uploading the package file K2_v2.6.7 in my Joomla 3.2.0 site.

SQL=SHOW FULL COLUMNS FROM `ccl_k2_categories`

I looked and from what I see folders are 755 and files are 644. The config php was 444 which I tried switching to 755 and this did not help.

What exactly did you do? Please help :(

Oh my god. I'm having the same problem! Thank you for this solution! I'm going to try it out.