Cant add new elements, I get "Unknown column 'introtext' in 'field list' SQL=UPDATE"

I have tried both 3.0.9 and 3.1 on my Joomla 2.5 site and I get the same error when I try and add or update a element/ I get this error:

Code (Text):

Unknown column 'introtext' in 'field list' SQL=UPDATE

See attached file for the complete details. Can someone help me with this?

 

I have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?

 

Hey, fstltna! I have faced the same problem. Investigating issue for now.
It seems like typo mistake somewhere in the code (missing ') but where?

Let as look through the code. In the end of the query we can see
\"show_icon\":[\"0\"]}}',`introtext`='' WHERE

It is obvious, that the last element of the the query ('introtext') is incomplete and therefor we got an sql error.

But I don't know where this query is generating.

 

I have done all of this with latest github update and Joomla 3.3.3 and had no lack.
How introtext could get int this query?

 

Could it be connected with latest Joomla update?

Yes, my platform is: J.3.3.3+latest fabrik.
Fabrik and Joomla debug is off. Gzip compression is off.

It happens when I try to:
1) Create a new element
2) Save any existing element (with or without modification)
3) Unlink one element from another
4) Save any form settings. (Saving list settings is ok)

This is the error message (without code tags because they strip some '):

Unknown column 'introtext' in 'field list' SQL=UPDATE `ronb4_fabrik_elements` SET `name`='name',`group_id`='11',`plugin`='field',`label`='???',`checked_out`='1',`checked_out_time`='2014-07-30 19:03:23',`created`='2012-12-03 09:34:38',`created_by`='966',`created_by_alias`='kadisadm',`modified`='2014-07-30 19:03:30',`modified_by`='1',`width`='40',`height`='0',`default`='',`hidden`='0',`eval`='0',`ordering`='5',`show_in_list_summary`='1',`filter_type`='',`filter_exact_match`='1',`published`='1',`link_to_detail`='0',`primary_key`='0',`auto_increment`='0',`access`='1',`use_in_page_title`='0',`parent_id`='0',`params`='{\"placeholder\":\"\",\"password\":\"0\",\"maxlength\":\"255\",\"disable\":\"0\",\"readonly\":\"0\",\"autocomplete\":\"1\",\"speech\":\"0\",\"bootstrap_class\":\"input-large\",\"text_format\":\"text\",\"integer_length\":\"6\",\"decimal_length\":\"2\",\"field_use_number_format\":\"0\",\"field_thousand_sep\":\",\",\"field_decimal_sep\":\".\",\"text_format_string\":\"\",\"text_input_mask\":\"\",\"render_as_qrcode\":\"0\",\"guess_linktype\":\"0\",\"link_target_options\":\"default\",\"rel\":\"\",\"link_title\":\"\",\"show_in_rss_feed\":\"0\",\"show_label_in_rss_feed\":\"0\",\"use_as_rss_enclosure\":\"0\",\"rollover\":\"\\u041f\\u043e\\u0436\\u0430\\u043b\\u0443\\u0439\\u0441\\u0442\\u0430, \\u0443\\u043a\\u0430\\u0436\\u0438\\u0442\\u0435 \\u0441\\u0432\\u043e\\u0435 \\u0424\\u0418\\u041e!\\r\\n\\r\\n\\u0424\\u043e\\u0440\\u043c\\u0430\\u0442: \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432 \\u0418\\u0432\\u0430\\u043d \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432\\u0438\\u0447.\\r\\n\\r\\n\\u0414\\u043e\\u043f\\u0443\\u0441\\u0442\\u0438\\u043c\\u044b \\u0442\\u043e\\u043b\\u044c\\u043a\\u043e \\u0440\\u0443\\u0441\\u0441\\u043a\\u0438\\u0435 \\u0431\\u0443\\u043a\\u0432\\u044b.\",\"tipseval\":\"0\",\"tiplocation\":\"top\",\"labelindetails\":\"1\",\"labelinlist\":\"0\",\"comment\":\"\",\"edit_access\":\"1\",\"view_access\":\"1\",\"view_access_user\":\"\",\"list_view_access\":\"1\",\"encrypt\":\"0\",\"can_order\":\"1\",\"alt_list_heading\":\"\\u0424\\u0418\\u041e\",\"custom_link\":\"\",\"custom_link_indetails\":\"1\",\"use_as_row_class\":\"0\",\"include_in_list_query\":\"1\",\"always_render\":\"0\",\"icon_folder\":\"0\",\"icon_hovertext\":\"1\",\"icon_file\":\"\",\"filter_length\":\"20\",\"filter_access\":\"1\",\"full_words_only\":\"0\",\"filter_required\":\"0\",\"filter_build_method\":\"0\",\"filter_groupby\":\"text\",\"inc_in_adv_search\":\"1\",\"filter_class\":\"input-medium\",\"filter_responsive_class\":\"\",\"tablecss_header_class\":\"\",\"tablecss_header\":\"\",\"tablecss_cell_class\":\"\",\"tablecss_cell\":\"width:10px;\",\"sum_on\":\"0\",\"sum_label\":\"Sum\",\"sum_access\":\"5\",\"sum_split\":\"\",\"avg_on\":\"0\",\"avg_label\":\"Average\",\"avg_access\":\"5\",\"avg_round\":\"0\",\"avg_split\":\"\",\"median_on\":\"0\",\"median_label\":\"Median\",\"median_access\":\"5\",\"median_split\":\"\",\"count_on\":\"0\",\"count_label\":\"Count\",\"count_condition\":\"\",\"count_access\":\"5\",\"count_split\":\"\",\"custom_calc_on\":\"0\",\"custom_calc_label\":\"Custom\",\"custom_calc_query\":\"\",\"custom_calc_access\":\"5\",\"custom_calc_split\":\"\",\"custom_calc_php\":\"\",\"regex-message\":[\"\\u0412\\u0435\\u0434\\u0435\\u043d\\u043d\\u043e\\u0435 \\u0424\\u0418\\u041e \\u043d\\u0435 \\u0441\\u043e\\u043e\\u0442\\u0432\\u0435\\u0442\\u0441\\u0432\\u0443\\u0435\\u0442 \\u0444\\u043e\\u043c\\u0430\\u0440\\u0442\\u0443!\"],\"regex-validation_condition\":[\"\"],\"regex-expression\":[\"\\/^([\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}|[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\-[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,})\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}$\\/u\"],\"regex-match\":[\"1\"],\"regex-replacestring\":[\"\"],\"tip_text\":[\"\"],\"icon\":[\"\"],\"validations\":{\"plugin\":[\"regex\"],\"plugin_published\":[\"1\"],\"validate_in\":[\"front\"],\"validation_on\":[\"new\"],\"show_icon\":[\"0\"]}}',`introtext`='' WHERE `id`='77'

 

Good news! I have found the cause of our problem! It is the Roost New Article Notification Override plugin, the part of the Roost Web Push for Joomla package.
Disabling Roost New Article Notification Override plugin solves fabrik issue. Not sure why this plugin is affecting fabrik component.
If not fixed, I think that, at least, we should add info about this issue into the Fabrik wiki or somewhere else.

 

Yes, I am running php 5.5.9. And what is your php verison?

 

IMO unlikely to be caused by a PHP version issue.

introtext is a Joomla article field, so my guess is that Roost New Article Notification Override plugin hooks into Joomla's database engine to spot when new articles are being stored, and is mistakenly assuming that this update by fabrik is a new article. Either that or Fabrik is using the default SQL query object which may have had some stuff pushed into it by the above plugin, and Fabrik probably needs either to create a private SQL query object or to clear the default one before it starts to fill it.

But just a guess.

 

Hmmm - I have looked at the plugin code and can't see why it would cause this.

 

Yes, i am using php5.5 too...

I will try disabling roost and see what happens...

 

Ok, i disabled it and no longer get the error, but now adding the fields/validations shows empty fiekds. Will try reinstalling fabrik and see what it does...

 

Ok, i tested it and used fabrik 3.1 and it works on my mac in safari. For some reason it is not working on my ipad. Not sure why...