Just started to put together a new Joomla 3.2 site and installed K2. Have about seven items in K2 and now every time I click on Items I get the following error:
An error has occurred.
1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM w6nbp_k2_items as i LEFT JOIN w6nbp_k2_categories AS c ON c.id = i.catid LEFT JOIN w6nbp_viewlevels AS g ON g.id = i.access LEFT JOIN w6nbp_users AS u ON u.id = i.checked_out LEFT JOIN w6nbp_users AS v ON v.id = i.created_by LEFT JOIN w6nbp_users AS w ON w.id = i.modified_by WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 20
Any ideas on what may be causing this? I have removed and reinstalled K2. I did look through this forum and other looking for answers but being relatively new to this stuff am coming up short. Any help would be appreciated. Thanks.

Error 1. When on the front end site and clicking the add item menu link it opens up a new window (see error 3). It then displays the message: 403

You are not authorized to view this resource .

Category is set to public, created Super Users group and gave it all access.


Error 2. when in the back end I click on comments I get the following error.
1045 - Unknown column 'ip' in 'field list' SQL=SELECT ip FROM nbplm_k2_users WHERE userID = 144

Error 3. when adding the edit form menu link. I click on it on the front end and get taken to a new window. I try and change the setting in the back end menu options target window to open up in Parent. When I press save it defaults to New Window With Navigation every time.

Thanks Alen,

I made sure all of my users belonged to a K2 category and then cleared the Joomla cache and they were gone. I don't know if this will help anyone else but I had transfered alot of those users with SP Upgrade from a Joomla 1.5 site so I just opened then and saved them again and that seem to do the trick.

Cheers

Following error code appears when installing K2 on Joomla 3.1.5

1146 Table 'wigrena_joomla.jom31_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `jom31_k2_categories`

Hi I tried to install K2 but this error message appeared

"Table 'brandyou_canan95.f8uth_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `f8uth_k2_categories"

what does it mean and how do i solve it? please help!

thanks!

Hi can you help me solve this: I get, Error: 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 'ORDER BY content.created DESC' at line 25 SQL=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 gg1qt_k2_items AS content LEFT JOIN gg1qt_k2_categories AS cats ON cats.id = content.catid LEFT JOIN gg1qt_users AS users ON users.id = content.created_by LEFT JOIN gg1qt_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE ORDER BY content.created DESC

I am trying to install K2_v2.6.7 in Joomla 3.1.5.
I get an error that table prefix_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `prefix_k2_categories`

Any suggestions? I have successfully installed Akeeba Admin Tools, Akeeba backup, and JCE.

Thanks!

Hi,

I did purge but the problem continues.

Beside i have the site offline and development and therefore the Smart search should not have the need to be purged.

I spoke with the hosting service and they indicated me the following error message which, according to them refers to a problem of conflict with k2.
"Premature end of script headers: index.php, referer: www.sophiealgarvevillas.com/administrator/index.php?option=com_k2&view=item&cid=54"

To better illustrate the problem place the following link from a video I sent to the hosting service with a test in which the error appears.
screencast-o-matic.com/watch/cI6UDQVMJo

Text error:

An error has occurred.
1114 The table 'snsp2_finder_tokens' is full SQL=INSERT INTO `snsp2_finder_tokens` (`term`,`stem`,`common`,`phrase`,`weight`,`context`,`language`) VALUES ('webtuga', 'webtuga', 0, 0, 0.4667, 3, '*')

Hi,

After activating the error message in the global settings the system started to indentificar the error as "error 1114 The table 'snsp2_finder_tokens' is full ". I searched the net and saw this error is related to the MySQL base.

Can you give me some suggestions.

sorry for bumping old topic but still nobody find a solution for this

so I'm using j3.1.5 and I want to move K2 items to joomla content
I'm unsuccessfully using this sql query command but no luck, what am I doing wrong?

insert into `ZZZ_content` (id, title, alias, catid, introtext, fulltext, created, created_by, created_by_alias, checked_out, checked_out_time, modified, modified_by, publish_up, publish_down, access, featured, hits, language) select id, title, alias, catid, introtext, fulltext, created, created_by, created_by_alias, checked_out, checked_out_time, modified, modified_by, publish_up, publish_down, access, featured, hits, language from `ZZZ_k2_items`

- where ZZZ is prefix
- error I get: #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 'fulltext, created, created_by, created_by_alias, checked_out, checked_out_time, ' at line 1

Hola.
Cuando escribo un artículo en K2 y lo guardo, aparece el siguiente error:

500 - Ha ocurrido un 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=UPDATE `ynokj_finder_taxonomy_map` SET `link_id`='18',`node_id`='3' WHERE

¿Cómo puedo solucionarlo?.
Gracias.

Since web hosting is a delicate issue, I suggest you take a look at your server analytics and error logs.

And a spike in traffic can affect mySQL and if it crashes (due to traffic) it can lock tables. Since this is a widely used table (when users from Twitter are browsing the item) this can be the table that is locked.

To be perfectly honest I suggest you have your hosting provider take a look at this, report any possible spikes in traffic and check the server load. Maybe the VPS you have chosen does not fit your needs.

I have a few issues. In the backed I am trying to add a slide and want to link it via the Joomla Menu Item. However it only shows the first page of menu items and even if I click the paging to go to the next page it still stays on the first page. When I try to filter a menu item I get the following error:

Unknown column 'name' in 'where clause' SQL=SELECT * FROM twlqj_menu WHERE LOWER(name) LIKE '%%' AND client_id = 0 AND id!=1 ORDER BY lft ASC

I'm not sure how to fix either one of these issues but hoping they are caused by the same thing. I am using Joomla 3.1.5 and Front Page 3.5.3

Dear,

I have 2 time, problem with Session ID,

INSERT command denied to user ' ....'@'82.197.130.147' for table 'dsvxi_session' SQL=INSERT INTO `dsvxi_session` (`session_id`, `client_id`, `time`) VALUES ('58f06..37748764cd7e0f', 0, '13.0916')

I have login to phpmyadmin, and repair as suggest from Ms. Ziota..but i can not open my website with error message above.

Thanks in advance.

Dear Kaka Ziota,

Header already ok as your suggest, but after relogin I get error

SQL=INSERT INTO `dsvxi_session` (`session_id`, `client_id`, `time`) VALUES ('4bf40dd8d9200e2d09ee7e24430f53a8', 0, '1381227129')

Please Help

Tks,

Hi everybody!

i have a problem. I use JiFile to index the content of my pdf in the K2 articles.
but what i need to do, is to differentiate the results, depending
on whether the pdf is in an article featured or not.
If it is featured, remove the link to the pdf.

this is the code of the plugin:
Displaying 381 - 400 out of 793 results.

1. Forum
3. Search