• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

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

fstltna

New Member
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:
Unknown column 'introtext' in 'field list' SQL=UPDATE

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

Screen Shot 2014-07-27 at 12.39.13 AM.png
 
Totally strange (there's no "introtext" element in the element table).
Is this a fresh Joomla/Fabrik installation or did you migrate/copy/whatever something?
Check your Fabrik connection, clear all Joomla and browser cache.
 
I have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?
 
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.
 
Totally strange (there's no "introtext" element in the element table).
Is this a fresh Joomla/Fabrik installation or did you migrate/copy/whatever something?
Check your Fabrik connection, clear all Joomla and browser cache.

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?
 
So @fstitna is getting this on J!2.5 with F3.0 and 3.1?
and Makulia on J!3.3.3 + F3.1 + GitHub?
I can't replicate.

This error is while trying to save a new or existing element?
Any element plugin? or a special one?
With validation(s)....?
Any Joomla cache settings? JS compression components/plugins...?
 
Can you please post the complete error messages, maybe this will give a hint.
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.
 
Makulia: I don't know if this is related, but in an other thread you mentioned you are running php5.5.
@fstitna: are you running php5.5, too?
 
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.
 
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...
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top