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

灰暗的星星灰暗的星星灰暗的星星灰暗的星星灰暗的星星
 
  1. fstltna

    fstltna New Member

    Level: Community
    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?

    Screen Shot 2014-07-27 at 12.39.13 AM.png
     
    fstltna, Jul 27, 2014
    #1
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    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.
     
    troester, Jul 27, 2014
    #2
     
  3. fstltna

    fstltna New Member

    Level: Community
    I have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?
     
    fstltna, Jul 28, 2014
    #3
     
  4. Makulia

    Makulia Member

    Level: Community
    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.
     
    Makulia, Jul 30, 2014
    #4
     
  5. Makulia

    Makulia Member

    Level: Community
    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?
     
    Makulia, Jul 30, 2014
    #5
     
  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    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...?
     
    troester, Jul 30, 2014
    #6
     
  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    Can you please post the complete error messages, maybe this will give a hint.
     
    troester, Jul 30, 2014
    #7
     
  8. Makulia

    Makulia Member

    Level: Community
    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'
     
    Makulia, Jul 30, 2014
    #8
     
  9. Makulia

    Makulia Member

    Level: Community
    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, Jul 30, 2014
    #9
    troester likes this.
  10. troester

    troester Well-Known Member Staff Member

    Level: Community
    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?
     
    troester, Jul 30, 2014
    #10
     
  11. Makulia

    Makulia Member

    Level: Community
    Yes, I am running php 5.5.9. And what is your php verison?
     
    Makulia, Jul 30, 2014
    #11
     
  12. troester

    troester Well-Known Member Staff Member

    Level: Community
    Posts crossing ;)
    I'm running php5.4.27 - but I think you've found the issue.
     
    troester, Jul 30, 2014
    #12
    Makulia likes this.
  13. Sophist

    Sophist Well-Known Member

    Level: Community
    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.
     
    Sophist, Jul 30, 2014
    #13
    Makulia likes this.
  14. Sophist

    Sophist Well-Known Member

    Level: Community
    Hmmm - I have looked at the plugin code and can't see why it would cause this.
     
    Sophist, Jul 30, 2014
    #14
     
  15. fstltna

    fstltna New Member

    Level: Community
    Yes, i am using php5.5 too...

    I will try disabling roost and see what happens...
     
    fstltna, Jul 30, 2014
    #15
     
  16. fstltna

    fstltna New Member

    Level: Community
    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...
     
    fstltna, Jul 30, 2014
    #16
     
  17. fstltna

    fstltna New Member

    Level: Community
    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...
     
    fstltna, Aug 1, 2014
    #17

提交评论


安全码
刷新

 

自1996年以来,公司一直专注于域名注册、虚拟主机、服务器托管、网站建设、电子商务等互联网服务,不断践行"提供企业级解决方案,奉献个性化服务支持"的理念。作为戴尔"授权解决方案提供商",同时提供与公司服务相关联的硬件产品解决方案。
 

联系方式

地址:河南省郑州市经五路2号

电话:0371-63520088 

QQ:76257322

网站:800188.com

电邮:该邮件地址已受到反垃圾邮件插件保护。要显示它需要在浏览器中启用 JavaScript。

微信:用企业微信联系