same here. please help.

Hi there,

I have serious issues installing K2 on joomla platform version 3.1.1 :(
when i try to install K2 i'm getting a error code like this:

[1146] Table 'username_jos1.jos_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `jos_k2_categories`

can someone help me resolve this problem please?

thanks in advance!

Spiros wrote: Hello....

When i try to upload to my site tha K2 pluggin ... i have the error :

0 SQL=SHOW FULL COLUMNS FROM `jos_k2_categories`

Could you tell me plz why...?

Thanks in advance

Spiros, did you ever get a resolution to this? Same thing is happening with me.

hello,
I have to customize the page of K2 that allows users to post "K2 Item" from frontend.

In particular:
issue n.1:
I want only the fields i'm interested in to be shown:
- title
- tags
- image
- The extrafields that I associated with the particular category.

issue n.2:
for the image ExtraField type: from frontend it lets you select images from the server, not from local pc (i want select the file from local pc)

possible solution of issue n.1:
I tried to hide the code from the file itemform.php inserting the <! ----> but should not be: hide the parts that I do not want to appear, I get the result, but when I load the image gives me error (sql something. ..).

solution of issue n.2:
i've no clue!!!

please help!

ciao,
devo personalizzare la pagina di K2 che permette agli utenti di inserire da frontend i "K2 item".
In particolare:
voglio che vengano visualizzati solo i campi da immettere che a me interessano quindi:
- titolo
- tags
- image
- gli extrafields che ho associato alla particolare categoria.

inoltre: per gli extrafield del tipo immagine: quando da frontend fanno selezionare l'immagine la fanno scegliere tra quelle presenti nel server, mentre io vorrei scegliere una immagine dal pc (come succede per inserire l'immagine del campo "image").

ho provato a nascondere del codice dal file itemform.php inserendo i tag <!-- --> ma non va: nascondo le parti che non voglio vengano visualizzate, ottengo il risultato ma quando carico l'immagine mi da errore (sql qualcosa...).

please help!!!

I went to add some more items in the K2 component today but when I clicked on Components -> K2 -> Items, I got the following messages:


So, I figured I'd reinstall K2 and then I got the following errors

Warning: Invalid argument supplied for foreach() in
The thing is, on the front end - the website views fine and it shows the K2 articles. But in the admin end, is where I get these errors and can't see previous items.

Joomla Version: 2.5.11
PHP Version: 5.2.17
K2 Version: 2.6.6

Hello Rene,

You should read this post

HI! i have error 500 when trying to add new K2 content.. please help:

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=UPDATE `laregion_finder_taxonomy_map` SET `link_id`='2837',`node_id`='3' WHERE

Your support was very helpful to me. I managed to solve the problem.
Thank you very much for your help.

You will have to check what is different between the category.php of the default template inside the component and the one you have in your template override.

What is in the line the error points to in your templates category.php file?

If i disable K2 override in my template (as you suggested), error dissapear.
My question now is, should I use default template or how can I fix the error in custom template.
What do you suggest?

Thank you very much for your help.

The path to the error is to the category.php file that is located in your template's folder. Just rename the folder of the com_k2 inside templates/YOUR_TEMPLATE/html/com_k2 with adding an underscore to the folder name, like com_k2_. This way the override of the template will not run and the default from the K2 component will.

This way we will make sure that the error is in fact to the K2 template override and not the component itself.

The option you are disabling through the K2 parameters has to do only with CSS and Javascript as it states.

Yes I did. I try both options, but the result is still the same.

Have you tried to disable the K2 override in your template and see if the error remains with the default component's template?

Hi,

On my web page I would like to show Category and all its Subcategories without any item. I have main Category and 8 Subcategories.
I use Joomla! 3.1.1 Stable and K2 v2.6.6.

My problem is when I set "Sub-category blocks" to Show i get an error in log and blank web page with only Title and description of the first subcategory.

Here is the error in the log file:
in attachments are screen-shots of K2 category settings







Please help.

Thank you.

I got it to work! I logged into cpanel and then under MySQL Databases / modify Databases, I selected the database I am using for this instance of Joomla and clicked on "Repair DB" and it appears to be working fine!

I am backing everything up now and hopefully I can figure out what caused this.

I hope this is helpful.

I am getting some errors in K2. I would greatly appreciate some help

FRONT END ERRORS:
Error: No articles to display

DB function failed with error number 145
Table '/forum/libpost_joomla/tn5zh_k2_items' is marked as crashed and should be repaired SQL=SELECT COUNT(*) FROM tn5zh_k2_items WHERE YEAR(created)=2013 AND MONTH(created)=5 AND DAY(created)=1 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-20 02:23:42' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-20 02:23:42' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM tn5zh_k2_categories WHERE id= tn5zh_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) )

Blogs + Columns:
Warning: Invalid argument supplied for foreach() in templates/gk_news/html/com_k2/templates/default/latest.php on line 102


ADMIN PANEL ERRORS:

Control Panel:
Warning: Invalid argument supplied for foreach() in administrator/modules/mod_k2_stats/tmpl/default.php on line 52

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

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

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

Here is the current configuration:

Joomla! setup:
Joomla! 2.5.11
K2 Version 2.6.5
Gavick Pro Template NEWS
RSS Feed Aggregators - We need to select one:
Feedgator 2.3.6 (most recent version)
Ob Grabber - Alternative rss reader & more

System Information:
Web Server Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP version 5.3.19
MySQL version 5.1.68-cll

Please contact me should you have any ideas.

Joomla 3.0 with K2 2.6.6 on Linux
Upgraded to Joomla 3.1

Now when i try to add a new K2 item I get this:

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 jml_k2_additional_categories WHERE `itemID` = {intval()}

Tried reinstalling K2 but have not been able to get round the error.

Any suggestions please?

TIA
Duncan

Hello!

It's a clash between J2.5 default smart search plugin and K2 smart search plugin respectively.

I've stumbled upon the same problem but the simplest and fastest way to get rid of this issue is to disable default J2.5 'Content - Smart Search' plugin (I reckon You'll b using K2 for publishing articles etc.).

I'm sorry I can't do better at the moment but I'm also new to J2.5 and am still working out all the quirks. If I find a better solution I'll let u know soon enough.

P.S.
Would also b nice if You were to opt Your DB tables and so forth. Especially if You were doing a migration from a previous version of Joomla. Might b u have some 'cracked' tables or entries that've misbehaved. Try turning on Joomla error reporting and debug and see what they have to say about it.

Seems you are using a K2 plugin and it is not configured properly.

k2_additional_categories is not core k2 table!