-
fstltna New Member
Level: CommunityI 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
fstltna, Jul 27, 2014#1 -
troester Well-Known Member Staff Member
Level: CommunityTotally 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.troester, Jul 27, 2014#2 -
fstltna New Member
Level: CommunityI have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?
fstltna, Jul 28, 2014#3 -
Makulia Member
Level: Community
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.Makulia, Jul 30, 2014#4 -
Makulia Member
Level: Community
How introtext could get int this query?Makulia, Jul 30, 2014#5 -
troester Well-Known Member Staff Member
Level: CommunitySo @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...?troester, Jul 30, 2014#6 -
troester Well-Known Member Staff Member
Level: CommunityCan you please post the complete error messages, maybe this will give a hint.
troester, Jul 30, 2014#7 -
Makulia Member
Level: Community
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'Makulia, Jul 30, 2014#8 -
Makulia Member
Level: CommunityGood 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, Jul 30, 2014#9troester likes this. -
troester Well-Known Member Staff Member
Level: CommunityMakulia: 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?troester, Jul 30, 2014#10 -
Makulia Member
Level: CommunityMakulia, Jul 30, 2014#11 -
troester Well-Known Member Staff Member
Level: CommunityPosts crossing
I'm running php5.4.27 - but I think you've found the issue.troester, Jul 30, 2014#12Makulia likes this. -
Sophist Well-Known Member
Level: CommunityIMO 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.Sophist, Jul 30, 2014#13Makulia likes this. -
Sophist Well-Known Member
Level: CommunityHmmm - I have looked at the plugin code and can't see why it would cause this.
Sophist, Jul 30, 2014#14 -
fstltna New Member
Level: Community
I will try disabling roost and see what happens...fstltna, Jul 30, 2014#15 -
fstltna New Member
Level: CommunityOk, 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...
fstltna, Jul 30, 2014#16 -
fstltna New Member
Level: CommunityOk, 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...
fstltna, Aug 1, 2014#17
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:See attached file for the complete details. Can someone help me with this?Code (Text):
Unknown column 'introtext' in 'field list' SQL=UPDATE