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

May i ask what is GD and where could i find it?

This is the K2 information
Web Server Apache/2.2.27 (Unix) mod_ssl/2.2.27 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
PHP version 5.4.30
MySQL version 5.5.36-cll
GD image library bundled (2.1.0 compatible)
Multibyte string support Enabled
Upload limit 30M
Memory limit 256M
Open remote files (allow url fopen) Yes

[qoute]
Joomla's debug doesn't display debug when I get error 500 page. here is what i found on my logs folder today.

<b>jcontroller.log.php</b>

#<?php die('Forbidden.'); ?>
#Date: 2014-08-05 04:01:30 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority category message
2014-08-05T04:01:30+00:00 INFO controller Holding edit ID com_menus.edit.item.164 Array ( [0] => 164 )
[/qoute]

These are warnings not actual errors.
They will not cause error or alter your site's functionality.

Is there a Fatal Error recorded?

Also since this is a global issue it is probably unrelated to K2.
Is your site experiencing heavy traffic? It could be mySql crashing and causing tables to lock. Have you tried repairing your DB tables?

Yes, i use some derectives from master htaccess protection: docs.joomla.org/Htaccess_examples_%28security%29

No security extensions used by me.

Thx, for fast reply.

Here is the full .htaccess file, failed to put under spoiler sorry:

IndexIgnore *
Options +FollowSymLinks All -Indexes

## Mod_rewrite in use.

RewriteEngine On

########## Begin - File execution order, by Komra.de
DirectoryIndex index.php index.html
########## End - File execution order

## Удаляем .html c конца URL
RewriteRule ^index.html$ / [R=301,L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} \.html$
RewriteRule ^(.*)\.html$ /$1 [R,L]
## Удаляем .html c конца URL

RewriteCond %{HTTP_HOST} ^mysite\.ru
RewriteRule ^(.*)$ www.mysite.ru/$1 [R=permanent,L]

## Фильтруем кавычки в url
RewriteRule ^(.*) /$1 [R=301,L]
## Фильтруем кавычки в url

## Удаляем слеш с конца урл
RewriteCond %{REQUEST_URI} ^.*/$ [NC]
RewriteCond %{REQUEST_URI} !^/administrator
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)/$ /$1 [L,R=301]
## Удаляем слеш с конца урл

<IfModule mod_gzip.c>
mod_gzip_on Yes
mod_gzip_dechunk Yes
mod_gzip_item_include file \.(html?|txt|css|js|php)$
mod_gzip_item_include mime ^text/.*
mod_gzip_item_include mime ^application/x-javascript.*
mod_gzip_item_exclude mime ^image/.*
mod_gzip_item_exclude rspheader ^Content-Encoding:.*gzip.*
</IfModule>

########## Begin - Add optional bad user agent or IP blocking code
#
# If you need to block certain user agents or IP addresses and
# other signatures, place that code here. Ensure the rules use
# the correct RewriteRule syntax and the [F] flag.
#
########## End - Add optional bad user agent or IP blocking code

########## Begin - Rewrite rules to block out some common exploits
## If you experience problems on your site block out the operations listed below
## This attempts to block the most common type of exploit `attempts` to Joomla!
#
# If the request query string contains /proc/self/environ (by SigSiu.net)
RewriteCond %{QUERY_STRING} proc/self/environ [OR]
# Block out any script trying to set a mosConfig value through the URL
# (these attacks wouldn't work w/out Joomla! 1.5's Legacy Mode plugin)
RewriteCond %{QUERY_STRING} mosConfig_[a-zA-Z_]{1,21}(=|\%3D) [OR]
# Block out any script trying to base64_encode or base64_decode data within the URL
RewriteCond %{QUERY_STRING} base64_(en|de)code[^(]*\([^)]*\) [OR]
## IMPORTANT: If the above line throws an HTTP 500 error, replace it with these 2 lines:
# RewriteCond %{QUERY_STRING} base64_encode\(.*\) [OR]
# RewriteCond %{QUERY_STRING} base64_decode\(.*\) [OR]
# Block out any script that includes a <script> tag in URL
RewriteCond %{QUERY_STRING} (<|%3C)([^s]*s)+cript.*(>|%3E) [NC,OR]
# Block out any script trying to set a PHP GLOBALS variable via URL
RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]
# Block out any script trying to modify a _REQUEST variable via URL
RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})
# Return 403 Forbidden header and show the content of the root homepage
RewriteRule .* index.php [F]
#
########## End - Rewrite rules to block out some common exploits

########## Begin - File injection protection, by SigSiu.net
RewriteCond %{REQUEST_METHOD} GET
RewriteCond %{QUERY_STRING} [a-zA-Z0-9_]=http:// [OR]
RewriteCond %{QUERY_STRING} [a-zA-Z0-9_]=(\.\.//?)+ [OR]
RewriteCond %{QUERY_STRING} [a-zA-Z0-9_]=/([a-z0-9_.]//?)+ [NC]
RewriteRule .* - [F]
########## End - File injection protection

########## Begin - Basic antispam Filter, by SigSiu.net
## I removed some common words, tweak to your liking
## This code uses PCRE and works only with Apache 2.x.
## This code will NOT work with Apache 1.x servers.
RewriteCond %{QUERY_STRING} \b(ambien|blue\spill|cialis|cocaine|ejaculation|erectile)\b [NC,OR]
RewriteCond %{QUERY_STRING} \b(erections|hoodia|huronriveracres|impotence|levitra|libido)\b [NC,OR]
RewriteCond %{QUERY_STRING} \b(lipitor|phentermin|pro[sz]ac|sandyauer|tramadol|troyhamby)\b [NC,OR]
RewriteCond %{QUERY_STRING} \b(ultram|unicauca|valium|viagra|vicodin|xanax|ypxaieo)\b [NC]
## Note: The final RewriteCond must NOT use the [OR] flag.
RewriteRule .* - [F]
## Note: The previous lines are a "compressed" version
## of the filters. You can add your own filters as:
## RewriteCond %{QUERY_STRING} \bbadword\b [NC,OR]
## where "badword" is the word you want to exclude.
########## End - Basic antispam Filter, by SigSiu.net

########## Begin - Advanced server protection - query strings, referrer and config
# Advanced server protection, version 3.2 - May 2011
# by Nicholas K. Dionysopoulos

## Disallow PHP Easter Eggs (can be used in fingerprinting attacks to determine
## your PHP version). See www.0php.com/php_easter_egg.php and
## osvdb.org/12184 for more information
RewriteCond %{QUERY_STRING} \=PHP[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12} [NC]
RewriteRule .* - [F]

## SQLi first line of defense, thanks to Radek Suski (SigSiu.net) @
## www.sigsiu.net/presentations/fortifying_your_joomla_website.html
## May cause problems on legitimate requests
RewriteCond %{QUERY_STRING} concat[^\(]*\( [NC,OR]
RewriteCond %{QUERY_STRING} union([^s]*s)+elect [NC,OR]
RewriteCond %{QUERY_STRING} union([^a]*a)+ll([^s]*s)+elect [NC]
RewriteRule .* - [F]

## Referrer filtering for common media files. Replace with your own domain name.
## This blocks most common fingerprinting attacks ;)
## Note: Change www\.example\.com with your own domain name, substituting the
## dots with \. i.e. use www\.example\.com for www.example.com
RewriteRule ^(images/stories/([^.]+)\.(jpe[g2]?|jpg|png|gif|bmp|css|js|swf|ico|html?))$ - [L]
RewriteCond %{HTTP_REFERER} .
RewriteCond %{HTTP_REFERER} !^https?://(www\.)?mysite\.ru [NC]
RewriteCond %{REQUEST_FILENAME} -f
RewriteRule \.(jp(e?g|2)?|png|gif|bmp|css|js|swf|ico)$ - [F]

## Disallow visual fingerprinting of Joomla! sites (module position dump)
## Initial idea by Brian Teeman and Ken Crowder, see:
## www.slideshare.net/brianteeman/hidden-joomla-secrets
## Improved by @nikosdion to work more efficiently and handle template
## and tmpl query parameters
RewriteCond %{QUERY_STRING} (^|&)tmpl=(component|system) [NC]
RewriteRule .* - [L]
RewriteCond %{QUERY_STRING} (^|&)t(p|emplate|mpl)= [NC]
RewriteRule .* - [F]

## Disallow access to htaccess.txt, configuration.php, configuration.php-dist and php.ini
RewriteRule ^(htaccess\.txt|configuration\.php(-dist)?|php\.ini)$ - [F]

########## End - Advanced server protection - query strings, referrer and config

########## Begin - Advanced server protection rules exceptions ####
##
## These are sample exceptions to the Advanced Server Protection 3.1
## rule set further down this file.
##
## Allow UddeIM CAPTCHA
##RewriteRule ^components/com_uddeim/captcha15\.php$ - [L]
## Allow Phil Taylor's Turbo Gears
##RewriteRule ^plugins/system/GoogleGears/gears-manifest\.php$ - [L]
## Allow JoomlaWorks AllVideos
##RewriteRule ^plugins/content/jw_allvideos/includes/jw_allvideos_scripts\.php$ - [L]
## Allow Admin Tools Joomla! updater to run
##RewriteRule ^administrator/components/com_admintools/restore\.php$ - [L]
## Allow Akeeba Backup Professional's integrated restoration script to run
##RewriteRule ^administrator/components/com_akeeba/restore\.php$ - [L]
## Allow Akeeba Kickstart
##RewriteRule ^kickstart\.php$ - [L]

# Add more rules to single PHP files here

## Allow Agora attachments, but not PHP files in that directory!
##RewriteCond %{REQUEST_FILENAME} !(\.php)$
##RewriteCond %{REQUEST_FILENAME} -f
##RewriteRule ^components/com_agora/img/members/ - [L]

# Add more rules for allowing full access (except PHP files) on more directories here

## Uncomment to allow full access to the cache directory (strongly not recommended!)
#RewriteRule ^cache/ - [L]
## Uncomment to allow full access to the tmp directory (strongly not recommended!)
#RewriteRule ^tmp/ - [L]

# Add more full access rules here

########## End - Advanced server protection rules exceptions ####

########## Begin - Advanced server protection - paths and files
# Advanced server protection, version 3.2 - May 2011
# by Nicholas K. Dionysopoulos

## Back-end protection
## This also blocks fingerprinting attacks browsing for XML and INI files
RewriteRule ^administrator/?$ - [L]
RewriteRule ^administrator/index\.(php|html?)$ - [L]
RewriteRule ^administrator/index[23]\.php$ - [L]
RewriteRule ^administrator/(components|modules|templates|images|plugins)/([^/]+/)*([^/.]+\.)+(jp(e?g|2)?|png|gif|bmp|css|js|ico|swf|html?|mp(eg?|[34])|avi|wav|og[gv]|xlsx?|docx?|pptx?|zip|rar|pdf|xps|txt|7z|svg|od[tsp]|flv|mov)$ - [L]
RewriteRule ^administrator/ - [F]

## Explicitly allow access only to XML-RPC's xmlrpc/index.php or plain xmlrpc/ directory
RewriteRule ^xmlrpc/(index\.php)?$ - [L]
RewriteRule ^xmlrpc/ - [F]

## Disallow front-end access for certain Joomla! system directories
RewriteRule ^includes/js/ - [L]
RewriteRule ^(includes|language|libraries|logs|tmp)/ - [F]

## Allow limited access for certain Joomla! system directories with client-accessible content
RewriteRule ^(components|modules|plugins|templates)/([^/]+/)*([^/.]+\.)+(jp(e?g|2)?|png|gif|bmp|css|js|ico|swf|html?|mp(eg?|[34])|avi|wav|og[gv]|xlsx?|docx?|pptx?|zip|rar|pdf|xps|txt|7z|svg|od[tsp]|flv|mov)$ - [L]
## Uncomment this line if you have extensions which require direct access to their own
## custom index.php files. Note that this is UNSAFE and the developer should be ashamed
## for being so lame, lazy and security unconscious.
# RewriteRule ^(components|modules|plugins|templates)/([^/]+/)*(index\.php)?$ - [L]
## Uncomment the following line if your template requires direct access to PHP files
## inside its directory, e.g. GZip compressed copies of its CSS files
# RewriteRule ^templates/([^/]+/)*([^/.]+\.)+php$ - [L]
RewriteRule ^(components|modules|plugins|templates)/ - [F]

## Disallow access to rogue PHP files throughout the site, unless they are explicitly allowed
RewriteCond %{REQUEST_FILENAME} \.php$
RewriteCond %{REQUEST_FILENAME} !/index[23]?\.php$
## The next line is to explicitly allow the forum post assistant(fpa-xx)script to run
RewriteCond %{REQUEST_FILENAME} !/fpa-[a-z]{2}\.php
RewriteCond %{REQUEST_FILENAME} -f
RewriteRule ^([^/]+/)*([^/.]+\.)+php$ - [F]

########## End - Advanced server protection - paths and files

########## Begin - Google Apps redirection, by Komra.de
## Uncomment the following line to enable:
# RewriteRule ^mail mail.google.com/a/example.com [R=301,L]
## If the above doesn't work on your server, try this:
## RewriteRule ^mail mail.google.com/a/example.com [R,L]
########## End - Google Apps redirection

########## Begin - Redirect index.php to /
## Note: Change example.com to reflect your own domain name
RewriteCond %{THE_REQUEST} !^POST
RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /index\.php\ HTTP/
RewriteCond %{SERVER_PORT}>s ^(443>(s)|[0-9]+>s)$
RewriteRule ^index\.php$ http%2://www.mysite.ru/$1 [R=301,L]
## If the above line throws a 500 error, change [R=301,L] to [R,L]
########## End - Redirect index.php to /

########## Begin - Joomla! core SEF Section
#
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
#
# If the requested path and file is not /index.php and the request
# has not already been internally rewritten to the index.php script
RewriteCond %{REQUEST_URI} !^/index\.php
# and the request is for the site root, or for an extensionless URL,
# or the requested URL ends with one of the listed extensions
RewriteCond %{REQUEST_URI} /component/|(/[^.]*|\.(php|html?|feed|pdf|vcf|raw|ini|zip|json|file))$ [NC]
# and the requested path and file doesn't directly match a physical file
RewriteCond %{REQUEST_FILENAME} !-f
# and the requested path doesn't directly match a physical folder
RewriteCond %{REQUEST_FILENAME} !-d
# internally rewrite the request to the index.php script
RewriteRule .* index.php [L]
#
########## End - Joomla! core SEF Section

ServerSignature Off

RewriteCond %{REQUEST_METHOD} ^(HEAD|TRACE|DELETE|TRACK) [NC,OR]
RewriteCond %{THE_REQUEST} (\\r|\\n|%0A|%0D) [NC,OR]

RewriteCond %{HTTP_USER_AGENT} ^$ [OR]
RewriteCond %{HTTP_USER_AGENT} ^(java|curl|wget) [NC,OR]
RewriteCond %{HTTP_USER_AGENT} (winhttp|HTTrack|clshttp|archiver|loader|email|harvest|extract|grab|miner) [NC,OR]
RewriteCond %{HTTP_USER_AGENT} (libwww-perl|curl|wget|python|nikto|scan) [NC,OR]
RewriteCond %{HTTP_USER_AGENT} (<|>|’|%0A|%0D|%27|%3C|%3E|%00) [NC,OR]

#Block mySQL injects
RewriteCond %{QUERY_STRING} (;|<|>|’|”|\)|%0A|%0D|%22|%27|%3C|%3E|%00).*(/\*|union|select|insert|cast|set|declare|drop|update|md5|benchmark) [NC,OR]

RewriteCond %{QUERY_STRING} \.\./\.\. [OR]

RewriteCond %{QUERY_STRING} (localhost|loopback|127\.0\.0\.1) [NC,OR]
RewriteCond %{QUERY_STRING} \.[a-z0-9] [NC,OR]
RewriteCond %{QUERY_STRING} (<|>|’|%0A|%0D|%27|%3C|%3E|%00) [NC]
# Note: The final RewriteCond must NOT use the [OR] flag.

# Return 403 Forbidden error.
RewriteRule .* index.php [F]

AddDefaultCharset utf-8

php_value max_execution_time 180
php_value memory_limit 512M

ErrorDocument 404 www.mysite.ru/error404



########## Block bad user agents
## The following list may include bots that no longer exist or are not a problem
## for your site. The list will always be incomplete and it is therefore wise to
## follow discussions on one of the many "security" mailing lists or on a forum
## such as www.webmasterworld.com/search_engine_spiders/
## It is also unwise to rely on this list as your ONLY security mechanism.
RewriteCond %{HTTP_USER_AGENT} ^BlackWidow [OR]
RewriteCond %{HTTP_USER_AGENT} ^Bot\ This email address is being protected from spambots. You need JavaScript enabled to view it. [OR]
RewriteCond %{HTTP_USER_AGENT} ^ChinaClaw [OR]
RewriteCond %{HTTP_USER_AGENT} ^Custo [OR]
RewriteCond %{HTTP_USER_AGENT} ^DISCo [OR]
RewriteCond %{HTTP_USER_AGENT} ^Download\ Demon [OR]
RewriteCond %{HTTP_USER_AGENT} ^eCatch [OR]
RewriteCond %{HTTP_USER_AGENT} ^EirGrabber [OR]
RewriteCond %{HTTP_USER_AGENT} ^EmailSiphon [OR]
RewriteCond %{HTTP_USER_AGENT} ^EmailWolf [OR]
RewriteCond %{HTTP_USER_AGENT} ^Express\ WebPictures [OR]
RewriteCond %{HTTP_USER_AGENT} ^ExtractorPro [OR]
RewriteCond %{HTTP_USER_AGENT} ^EyeNetIE [OR]
RewriteCond %{HTTP_USER_AGENT} ^FlashGet [OR]
RewriteCond %{HTTP_USER_AGENT} ^GetRight [OR]
RewriteCond %{HTTP_USER_AGENT} ^GetWeb! [OR]
RewriteCond %{HTTP_USER_AGENT} ^Go!Zilla [OR]
RewriteCond %{HTTP_USER_AGENT} ^Go-Ahead-Got-It [OR]
RewriteCond %{HTTP_USER_AGENT} ^GrabNet [OR]
RewriteCond %{HTTP_USER_AGENT} ^Grafula [OR]
RewriteCond %{HTTP_USER_AGENT} ^HMView [OR]
RewriteCond %{HTTP_USER_AGENT} HTTrack [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^Image\ Stripper [OR]
RewriteCond %{HTTP_USER_AGENT} ^Image\ Sucker [OR]
RewriteCond %{HTTP_USER_AGENT} Indy\ Library [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^InterGET [OR]
RewriteCond %{HTTP_USER_AGENT} ^Internet\ Ninja [OR]
RewriteCond %{HTTP_USER_AGENT} ^JetCar [OR]
RewriteCond %{HTTP_USER_AGENT} ^JOC\ Web\ Spider [OR]
RewriteCond %{HTTP_USER_AGENT} ^larbin [OR]
RewriteCond %{HTTP_USER_AGENT} ^LeechFTP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Mass\ Downloader [OR]
RewriteCond %{HTTP_USER_AGENT} ^MIDown\ tool [OR]
RewriteCond %{HTTP_USER_AGENT} ^Mister\ PiX [OR]
RewriteCond %{HTTP_USER_AGENT} ^Navroad [OR]
RewriteCond %{HTTP_USER_AGENT} ^NearSite [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetAnts [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetSpider [OR]
RewriteCond %{HTTP_USER_AGENT} ^Net\ Vampire [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetZIP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Octopus [OR]
RewriteCond %{HTTP_USER_AGENT} ^Offline\ Explorer [OR]
RewriteCond %{HTTP_USER_AGENT} ^Offline\ Navigator [OR]
RewriteCond %{HTTP_USER_AGENT} ^PageGrabber [OR]
RewriteCond %{HTTP_USER_AGENT} ^Papa\ Foto [OR]
RewriteCond %{HTTP_USER_AGENT} ^pavuk [OR]
RewriteCond %{HTTP_USER_AGENT} ^pcBrowser [OR]
RewriteCond %{HTTP_USER_AGENT} ^RealDownload [OR]
RewriteCond %{HTTP_USER_AGENT} ^ReGet [OR]
RewriteCond %{HTTP_USER_AGENT} ^SiteSnagger [OR]
RewriteCond %{HTTP_USER_AGENT} ^SmartDownload [OR]
RewriteCond %{HTTP_USER_AGENT} ^SuperBot [OR]
RewriteCond %{HTTP_USER_AGENT} ^SuperHTTP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Surfbot [OR]
RewriteCond %{HTTP_USER_AGENT} ^tAkeOut [OR]
RewriteCond %{HTTP_USER_AGENT} ^Teleport\ Pro [OR]
RewriteCond %{HTTP_USER_AGENT} ^VoidEYE [OR]
RewriteCond %{HTTP_USER_AGENT} ^Web\ Image\ Collector [OR]
RewriteCond %{HTTP_USER_AGENT} ^Web\ Sucker [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebAuto [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebCopier [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebFetch [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebGo\ IS [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebLeacher [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebReaper [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebSauger [OR]
RewriteCond %{HTTP_USER_AGENT} ^Website\ eXtractor [OR]
RewriteCond %{HTTP_USER_AGENT} ^Website\ Quester [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebStripper [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebWhacker [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebZIP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Widow [OR]
RewriteCond %{HTTP_USER_AGENT} ^WWWOFFLE [OR]
RewriteCond %{HTTP_USER_AGENT} ^Xaldon\ WebSpider [OR]
RewriteCond %{HTTP_USER_AGENT} ^Zeus
## Note: The final RewriteCond must NOT use the [OR] flag.

## Return 403 Forbidden error.
RewriteRule .* - [F]

Hello,

I've got a Joomla 3.3.1 website with K2 2.6.8.

I've got six extra fields, and all but one of them can save without any problems. The one that has a problem saving has 1,400 options in its multi-select setup. When I click Save or Apply I get dumped to the Joomla Dashboard and the save process does not take.

I've already tested a number of scenarios including:

1.) The issue is not with a certain extra field value (such as a character) - it seems to fail if the k2_extra_fields database value is over 44KB in size which is right around 500 extra fields.
2.) I've already changed column value in k2_extra_fields from text to mediumtext and longtext

I'm running PHP 5.3.28, MySQL 5.5.37, 128MB Memory Limit.

Any ideas or pointers? Enabling error reporting at maximum does not product any errors, and there are no errors in error_log in the root of the Joomla installation.