Hi. This query is not part of K2. Check for any K2 related extensions installed on your system. If you enable the system debugger you will see which file is using this query.

Hi. Open the system debugger to see exactly which SQL query fails and what file is generating it.

Hi,

I have a new website with K2 and 1000 imported item from joomla content

Search engine is totally broken. I have this error :

Error: 1214 - The used table type doesn't support FULLTEXT indexes SQL=SELECT i.id, i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM xxx_k2_items AS i INNER JOIN xxx_k2_categories AS c ON c.id=i.catid AND c.access IN(1,1,5) WHERE (MATCH(i.title, i.introtext, i.`fulltext`,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('+android*' IN BOOLEAN MODE) ) AND i.trash = 0 AND i.published = 1 AND i.access IN(1,1,5) AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-09-22 15:18:27' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-09-22 15:18:27' ) GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

website: www.plugngeek.net/newpng/

K2 Version: 2.6.8
Joomla version : 3.3.x

Database is not modified.

Now my site on lifestyle.claire-fisher.net crashed out of the blue.
I have done nothing after succesful installation and was only surfing thorugh your other templates to look which i should apply to 3 different projects.
When I turned back to the frontend of lifestyle... I first got an error page and at reaload nothing anymore. In the backend I got this error message:
0 SQL=SELECT u.id AS value, u.name AS text FROM vtwiq_users AS u INNER JOIN vtwiq_content AS c ON c.created_by = u.id GROUP BY u.id, u.name ORDER BY u.name

It is strange as all my other joomla installations run well on the same server and also the 'native' installations of your template work well.
So what can be the case???

I received the following error when attempting to install K2 on my development server preparing to migrate to Joomla 3.3.3. Any ideas how to resolve to get K2 to install?

1146 Table 'cdmastes.tce_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `tce_k2_categories`

HI thanks for your support. This is what I see:

500 - An error has occurred.
JDatabaseMySQLi::query: 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 'DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name' at line 1 SQL=SELECT DISTINCT i.`id`,DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM sstuwa_k2_items as i LEFT JOIN sstuwa_k2_categories AS c ON c.id = i.catid LEFT JOIN sstuwa_viewlevels AS g ON g.id = i.access LEFT JOIN sstuwa_users AS u ON u.id = i.checked_out LEFT JOIN sstuwa_users AS v ON v.id = i.created_by LEFT JOIN sstuwa_users AS w ON w.id = i.modified_by LEFT JOIN sstuwa_k2_additional_categories AS ca ON ca.`itemID` = i.`id` WHERE i.trash=0 AND (i.catid IN (466,50,73,76,190,250,282,292,302,303,305,317,318,319,320,321,505) OR ca.`catid` IN (466,50,73,76,190,250,282,292,302,303,305,317,318,319,320,321,505)) ORDER BY i.id DESC LIMIT 0, 30

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /home/sstuwa/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/sstuwa/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/sstuwa/public_html/libraries/joomla/application/component/helper.php:348
4 require_once() /home/sstuwa/public_html/libraries/joomla/application/component/helper.php:380
5 JController->execute() /home/sstuwa/public_html/administrator/components/com_k2/k2.php:135
6 K2ControllerItems->display() /home/sstuwa/public_html/libraries/joomla/application/component/controller.php:761
7 K2Controller->display() /home/sstuwa/public_html/administrator/components/com_k2/controllers/items.php:21
8 JController->display() /home/sstuwa/public_html/administrator/components/com_k2/controllers/controller.php:32
9 K2ViewItems->display() /home/sstuwa/public_html/libraries/joomla/application/component/controller.php:722
10 K2ModelItems->getData() /home/sstuwa/public_html/administrator/components/com_k2/views/items/view.html.php:64
11 JDatabase->loadObjectList() /home/sstuwa/public_html/administrator/components/com_k2/models/items.php:128
12 JDatabaseMySQLi->execute() /home/sstuwa/public_html/libraries/joomla/database/database.php:1126
13 JError::raiseError() /home/sstuwa/public_html/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() /home/sstuwa/public_html/libraries/joomla/error/error.php:251

I set up a new installation of K2 on a new Joomla project website. I created a user for each type of user group in Joomla and then I imported them through the K2 User Manager, so all of the user groups would be created in K2. Then I registered a new user through the frontend, which created the new user as a "registered" member. The email was inaccurate though and there didn't appear to be a way to resend to the correct email. So I went to the K2 User Manager and changed the K2 "registered" member that I created to a "Super User" manually and published it . Then I realized the Joomla also had the member as "registered," so I changed it to "Super User" for that newly created member also. This error message came up and now I can not access the K2 User in the Manager section.
This is the error message that is showing, "The ne1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM tyg0j_users as juser LEFT JOIN tyg0j_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN tyg0j_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN tyg0j_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 ..."

Do you know how I can repair this?

I recently updated my joomla from 2.5.52 to Joomla 3.x

Now when I try to access the main site I receive this error:


Fatal error: Call to undefined method JDate::toMySQL() in /home3/mshutejr/public_html/plugins/content/bkauthorlink/bkauthorlink.php on line 43

I've found the file in my cPanel, but I'm not able to fix the problem.

How do you fix this error?

Thank you very much!

@Paul Andrews

This indicates an SQL error. Enable system debugger to see the query that fails.

Joomla 3..3.3
K2 2.6.8
K2/Jomsocial integration.

Whenever I create an author alias the article displays in the category view but not in item view. If I click the article title I get a 1046 error message. If I remove the author alias the individual article displays just fine.

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 'AND field_id=4' at line 1 SQL=SELECT id, user_id,

field_id, value FROM sdc_community_fields_values WHERE user_id= AND

field_id=4

I need author alias feature.

Tell me how to solve this problem?

Hi,
i have often the error (when i search an article on K2 f.ex)
1214 The used table type doesn't support FULLTEXT indexes SQL=SELECT COUNT(*) FROM qao56_k2_items AS i WHERE trash=0 AND MATCH( title ) AGAINST ('+superlight*' IN BOOLEAN MODE)

Could you help me please?

Regards
Patrick

Hey Krikor,
thanks for the quick reply. i made a discovery a few seconds ago. it comes from the size of the picture.

The pic is 1mb (max allowed on server is 24 mb) but 3000px x 1600.

the max_execution_time is at 90. can not be.

so what could force the server force to give error 500 back before? any idea?

here my parameters:

Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen Off Off
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset iso-8859-1 iso-8859-1
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions dl , passthru , pcntl_exec , pfsockopen , popen , posix_kill , posix_mkfifo , posix_setuid ,eproc_c, pr , proc_open , proc_terminate , system , leak , posix_setpgid , posix_setsid , proc_get_status , proc_nice , show_source , escapeshellcmd, pcntl_fork, pcntl_wait, pcntl_alarm, ini_restore, shell_exec, proc_close, leak dl , passthru , pcntl_exec , pfsockopen , popen , posix_kill , posix_mkfifo , posix_setuid ,eproc_c, pr , proc_open , proc_terminate , system , leak , posix_setpgid , posix_setsid , proc_get_status , proc_nice , show_source , escapeshellcmd, pcntl_fork, pcntl_wait, pcntl_alarm, ini_restore, shell_exec, proc_close, leak
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 30719 30711
exit_on_timeout Off Off
expose_php On On

file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors Off Off
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off

log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 90 90
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M

output_buffering 4096 4096
output_handler no value no value
post_max_size 24M 24M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 24M 24M
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.enable_gc On

2.68
Web Server Apache/2.4.7 (Ubuntu)
PHP version 5.5.9-1ubuntu4.3
MySQL version 5.5.38-0ubuntu0.14.04.1
GD image library 2.1.1-dev
Multibyte string support Enabled
Upload limit 20M
Memory limit 512M
Open remote files (allow url fopen) Yes
Joomla! 3.3.3 Stable

This is Joomla 3.3. MySQL, InnoDB engine. Installing K2 gives:

1146 - Table '<dbname>.pc_k2_categories' doesn't exist SQL = SHOW FULL COLUMNS FROM 'pc_k2_categories'

The database shows no K2 tables.

I searched. I do not have any 'News' plugins to interfere.
I've tried reinstalling.

Ideas? Thanks.

Hello,

i need some help with import Joomla Content to K2.

I get this 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 ' 225)' at line 1 SQL=INSERT INTO jos_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 225)

It doesnt imort the categories and most of the articles.
website is www.fretties.de

What can i do?

greetings,
Marco

Hallo,
habe gerade K2 unter Joomla 3.3 installiert.

Wenn ich jetzt die Joomla Inhalte importieren will bekomme ich folgende Fehlermeldung:

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 ' 225)' at line 1 SQL=INSERT INTO jos_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 225)

Es werden keine Kategorien importiert und nur ein Teil der Beiträge.

Was kann ich da machen um alles zu Importieren?

Domain ist www.fretties.de

Gruß,
Marco

Hi all,

After install K2import commercial extension

I have this error code:

k2_categories' doesn't exist SQL=SELECT c.*, g.title AS groupname, exfg.name as extra_fields_group FROM mba3i_k2_categories as c LEFT JOIN mba3i_viewlevels AS g ON g.id = c.access LEFT JOIN mba3i_k2_extra_fields_groups AS exfg ON exfg.id = c.extraFieldsGroup WHERE c.id>0 AND c.trash=0 ORDER BY c.ordering

Anyone help me with this issue,

Regards,


Juan