Announcement

Collapse
No announcement yet.

massive error on form sync....

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • massive error on form sync....

    Have a form when trying to sync it keeps giving me an error.

    its quite long (doesnt fit in here says txt limit reached so had to shorten it) and would love to not have to recreate the form again, but guess I will have too as by the time this is fixed it be xmas 2020..... anyway thought I would share and hope

    an error occurred while accessing the database. near ",": syntax errorINSERT INTO sc_tbcmp ( cod_prj, versao, cod_apl, login, seq, campo, html_tipo, tipo_dado, tipo_dado_filtro, tipo_sql, campo_def, def_campo, label, label_filtro, usar_label_grid, entra_edit, entra_update, entra_sort, entradetalhe, entradetalheord, def_tabela, def_complemento, def_complemento_cons, def_complemento_pesq, texto_xml, xml_subconsulta, ajax_dados, attr1, attr2, attr3, attr4 ) values ( 'clubmbr', 1, 'form_contacts_add', 'admin', 80, 'supplier', 'RADIO', 'RADIO', 'RADIO', 'TINYINT', '', '', '{lang_select_supplier}', 'supplier', '', 'N', 'N', '', '', , '', 'a:6:{s:6:"global";a:18:{s:6:"objeto";s:5:"RADIO"; s:6:"metodo";s:1:"M";s:4:"tipo";s:7:"SIMPLES";s:8: "multipla";s:1:"N";s:6:"altura";s:1:"2";s:11:"altu ra_ajax";s:2:"10";s:11:"delimitador";s:0:"";s:11:" desl_global";s:0:"";s:6:"titulo";s:0:"";s:11:"titu lo_flag";s:1:"N";s:23:"def_ajax_edit_cap_texto";s: 1:"N";s:18:"def_ajax_edit_like";s:7:"qqparte";s:19 :"def_ajax_edit_label";s:0:"";s:21:"def_ajax_edit_ largura";s:2:"30";s:18:"def_ajax_edit_case";s:1:"N ";s:9:"iteracoes";i:1;s:9:"separador";s:0:"";s:5:" entra";N;}s:8:"conteudo";a:2:{i:0;a:5:{s:5:"label" ;s:14:"{lang_peri_no}";s:9:"value_lig";s:1:"0";s:1 0:"value_desl";s:0:"";s:8:"selected";s:1:"S";s:5:" local";s:0:"";}i:1;a:5:{s:5:"label";s:15:"{lang_pe ri_yes}";s:9:"value_lig";s:1:"1";s:10:"value_desl" ;s:0:"";s:8:"selected";s:1:"N";s:5:"local";s:0:""; }}s:8:"relacoes";a:0:{}s:6:"select";s:0:"";s:10:"c onnection";s:0:"";s:16:"chk_opt_mark_all";s:1:"N"; }', '', '', '', '', 'a:2:{s:18:"ajax_dados_eventos";a:4:{s:8:"onChange ";a:2:{s:11:"usar_campos";s:1:"N";s:6:"campos";a:0 :{}}s:7:"onClick";a:3:{s:11:"usar_campos";s:1:"N"; s:6:"campos";a:0:{}s:9:"usar_ajax";s:1:"S";}s:7:"o nFocus";a:2:{s:11:"usar_campos";s:1:"N";s:6:"campo s";a:0:{}}s:6:"onBlur";a:2:{s:11:"usar_campos";s:1 :"N";s:6:"campos";a:0:{}}}s:20:"ajax_dados_usar_aj ax";N;}', 'a:289:{s:12:"autoinc_nome";s:0:"";s:16:"banco_val _forcar";s:1:"N";s:14:"banco_val_tipo";s:0:"";s:15 :"banco_val_valor";s:0:"";s:16:"autoinc_nome_upd"; s:0:"";s:20:"banco_val_forcar_upd";s:1:"N";s:18:"b anco_val_tipo_upd";s:0:"";s:19:"banco_val_valor_up d";s:0:"";s:15:"valida_condicao";s:0:"";s:12:"vali da_valor";i:0;s:15:"valida_mensagem";s:0:"";s:11:" label_texto";s:0:"";s:14:"var_glob_grava";s:1:"N"; s:13:"var_glob_nome";s:0:"";s:12:"campo_padrao";s: 1:"S";s:15:"valida_redirect";s:0:"";s:14:"campo_ex ec_ord";i:0;s:9:"jump_menu";s:0:"";s:13:"erro_mens agem";s:0:"";s:12:"eof_msg_erro";s:0:"";s:15:"eof_ val_default";s:0:"";s:16:"liga_mostra_edit";s:1:"S ";s:15:"acaosql_comando";s:0:"";s:15:"jump_menu_ra dio";s:1:"N";s:11:"exec_submit";s:4:"SSNN";s:12:"f ield_filter";s:1:"N";s:13:"form_val_tipo";s:0:"";s :14:"image_html_img";s:0:"";s:21:"image_html_img_b order";s:1:"0";s:20:"image_html_img_width";s:1:"0" ;s:21:"image_html_img_height";s:1:"0";s:12:"repete _valor";s:1:"S";s:13:"conteudo_html";s:1:"N";s:13: "lookup_tabela";s:1:"N";s:13:"lookup_objeto";s:0:" ";s:21:"lookup_exibe_lab_edit";s:1:"N";s:14:"looku p_tamanho";i:1;s:15:"lookup_tab_nome";s:0:"";s:16: "lookup_cmp_lista";s:0:"";s:15:"label_recarrega";s :1:"N";s:12:"label_ancora";s:0:"";s:9:"help_tipo"; s:1:"3";s:8:"path_sub";s:0:"";s:9:"doc_icone";s:1: "N";s:14:"path_sub_criar";s:1:"N";s:8:"desc_usa";s :1:"N";s:10:"desc_valid";s:1:"N";s:8:"desc_sql";s: 0:"";s:9:"desc_face";s:0:"";s:9:"desc_size";s:0:"" ;s:10:"desc_color";s:0:"";s:9:"desc_tipo";s:1:"A"; s:11:"exec_inicio";s:1:"N";s:17:"usar_autocomplete ";s:1:"S";s:17:"fil_entre_val_pos";s:1:"A";s:17:"f il_entre_val_txt";s:0:"";s:11:"graf_funcao";s:0:"" ;s:12:"graf_percent";s:1:"N";s:13:"graf_user_def"; s:1:"S";s:13:"lookup_mostra";s:1:"N";s:12:"lookup_ delim";s:3:" - ";s:13:"date_calendar";s:1:"N";s:17:"calendar_max_ year";s:2:"10";s:10:"jump_omite";s:1:"N";s:14:"lig a_url_saida";s:0:"";s:21:"liga_cons_mod_inicial";s :0:"";s:18:"liga_cons_qtd_rows";s:0:"";s:18:"liga_ cons_qtd_cols";s:0:"";s:19:"liga_cons_paginacao";s :0:"";s:16:"liga_cons_header";s:0:"";s:17:"liga_co ns_btn_nav";s:0:"";s:10:"css_celula";s:0:"";s:8:"c ss_form";s:0:"";s:17:"css_titulo_filtro";s:0:"";s: 16:"css_campo_filtro";s:0:"";s:17:"css_objeto_filt ro";s:0:"";s:15:"css_titulo_form";s:0:"";s:14:"css _campo_form";s:0:"";s:15:"css_objeto_form";s:0:""; s:11:"label_botao";s:1:"N";s:12:"cor_negativo";s:0 :"";s:8:"tit_bold";s:1:"S";s:9:"tot_title";s:0:""; s:8:"desc_eof";s:0:"";s:12:"date_display";s:1:"S"; s:18:"date_display_combo";s:1:"N";s:13:"lookup_fil tro";s:1:"N";s:13:"lookup_limite";i:100;s:13:"look up_inicio";s:1:"L";s:13:"lookup_campos";s:0:"";s:1 2:"cep_onchange";s:1:"N";s:10:"liga_forca";s:1:"N" ;s:11:"liga_insert";s:1:"R";s:12:"liga_tamanho";i: 700;s:14:"liga_cabecalho";s:1:"N";s:12:"liga_posic ao";s:1:"B";s:12:"liga_largura";i:350;s:6:"hidden" ;s:1:"N";s:11:"campo_label";s:1:"N";s:17:"critica_ sc_submit";s:1:"S";s:11:"image_cache";i:0;s:10:"im age_link";s:1:"N";s:11:"image_popup";s:1:"S";s:11: "doc_db_size";s:0:"";s:15:"onchange_submit";s:1:"N ";s:21:"show_filter_condition";s:1:"S";s:23:"quebr a_visu_label_fonte";a:0:{}s:22:"quebra_visu_label_ size";a:0:{}s:23:"quebra_visu_label_color";a:0:{}s :25:"quebra_visu_label_bgcolor";a:0:{}s:25:"quebra _visu_label_negrito";a:0:{}s:23:"quebra_visu_campo _fonte";a:0:{}s:22:"quebra_visu_campo_size";a:0:{} s:23:"quebra_visu_campo_color";a:0:{}s:25:"quebra_ visu_campo_bgcolor";a:0:{}s:25:"quebra_visu_campo_ negrito";a:0:{}s:20:"tot_linha_visu_fonte";a:0:{}s :19:"tot_linha_visu_size";a:0:{}s:20:"tot_linha_vi su_color";a:0:{}s:22:"tot_linha_visu_bgcolor";a:0: {}s:22:"tot_linha_visu_negrito";a:0:{}s:26:"tot_li nha_visu_campo_fonte";s:0:"";s:25:"tot_linha_visu_ campo_size";s:0:"";s:26:"tot_linha_visu_campo_colo r";s:0:"";s:28:"tot_linha_visu_campo_bgcolor";s:0: "";s:28:"tot_linha_visu_campo_negrito";s:0:"";s:26 :"tot_geral_linha_visu_fonte";s:0:"";s:25:"tot_ger al_linha_visu_size";s:0:"";s:26:"tot_geral_linha_v isu_color";s:0:"";s:28:"tot_geral_linha_visu_bgcol or";s:0:"";s:28:"tot_geral_linha_visu_negrito";s:0 :"";s:25:"formato_data_outro_filtro";s:0:"";s:13:" decimais_pesq";i:0;s:16:"simbolo_agr_pesq";s:1:"." ;s:16:"simbolo_dec_pesq";s:1:",";s:15:"aceita_neg_ pesq";s:1:"N";s:9:"usar_calc";s:1:"N";s:19:"quebra _ini_treeview";a:0:{}s:22:"lkpdef_exib_label_desc" ;s:1:"N";s:11:"subcons_pos";s:1:"M";s:16:"subcons_ treeview";s:1:"N";s:11:"subcons_pdf";s:1:"S";s:14: "quebra_orderby";a:0:{}s:17:"tab_lig_check_all";s: 1:"N";s:9:"pdf_pos_x";s:0:"";s:9:"pdf_pos_y";s:0:" ";s:14:"pdf_inc_height";s:2:"20";s:15:"texto_under line";s:1:"N";s:13:"subselect_seq";i:0;s:16:"subse lect_fields";s:0:"";s:16:"fil_date_esp_opt";i:1;s: 17:"fil_date_esp_cond";s:146:"bi_todo_periodo_@NM@ _bi_hoje_@NM@_bi_ontem_@NM@_bi_ult_7_dias_@NM@_bi_ sem_pas_seg_dom_@NM@_bi_ult_sem_com_seg_sex_@NM@_b i_este_mes_@NM@_bi_ult_mes";s:19:"editor_html_tool bar";s:247:"bold_BT_italic_BT_underline_BT_striket hrough_BT_justifyleft_BT_justifycenter_BT_justifyr ight_BT_justifyfull_BT_bullist_BT_numlist_BT_undo_ BT_redo_BT_fontselect_BT_fontsizeselect_BT_forecol or_BAR_tablecontrols_BT_link_BT_unlink_BT_emotions _BT_image";s:19:"editor_html_qtd_bar";i:2;s:19:"ed itor_html_pos_bar";s:3:"top";s:21:"editor_html_ali gn_bar";s:6:"center";s:18:"editor_html_status";s:0 :"";s:12:"graf_tp_graf";s:98:"1_@NM@_4_@NM@_2_@NM@ _5_@NM@_3_@NM@_8_@NM@_6_@NM@_7_@NM@_20_@NM@_21_@NM @_26_@NM@_27_@NM@_28_@NM@_29";s:13:"graf_tp_flash" ;s:0:"";s:14:"graf_cor_fundo";s:0:"";s:15:"graf_co r_margem";s:0:"";s:15:"graf_cor_labels";s:0:"";s:1 3:"graf_cor_vals";s:0:"";s:14:"graf_preen_esp";s:1 :"N";s:14:"graf_show_vals";s:1:"S";s:16:"graf_show _marcas";s:1:"N";s:14:"graf_tp_marcas";s:1:"Q";s:1 1:"graf_angulo";i:45;s:18:"editor_html_height";i:0 ;s:13:"conn_lkp_cons";s:0:"";s:20:"usar_config_reg ional";s:1:"S";s:16:"simbolo_negativo";s:1:"-";s:22:"formato_moeda_positivo";s:1:"3";s:22:"form ato_moeda_negativo";s:0:"";s:20:"formato_num_negat ivo";s:0:"";s:8:"sep_data";s:1:"/";s:8:"sep_hora";s:1:":";s:22:"format_data_config_ reg";s:0:"";s:13:"reload_locale";s:1:"N";s:18:"sho w_img_url_email";s:1:"S";s:16:"qtd_decimais_sec";i :0;s:13:"prim_dia_sema";s:2:"SU";s:14:"bar_code_pa ram";s:0:"";s:17:"youtube_exib_mode";s:5:"modal";s :18:"youtube_exib_width";i:0;s:19:"youtube_exib_he ight";i:0;s:17:"youtube_link_text";s:0:"";s:16:"yo utube_opt_link";s:3:"txt";s:18:"googlemaps_tp_orig ";s:7:"geocode";s:14:"googlemaps_url";s:0:"";s:19: "googlemaps_latitude";s:0:"";s:20:"googlemaps_long itude";s:0:"";s:18:"googlemaps_geocode";a:0:{}s:20 :"googlemaps_exib_mode";s:5:"modal";s:16:"googlema ps_width";i:0;s:17:"googlemaps_height";i:0;s:15:"g ooglemaps_zoom";i:14;s:18:"googlemaps_api_key";s:0 :"";s:20:"googlemaps_link_text";s:0:"";s:19:"googl emaps_opt_link";s:3:"txt";s:20:"googlemaps_mark_de sc";s:0:"";s:26:"group_usar_config_regional";a:0:{ }s:28:"group_format_data_config_reg";a:0:{}s:26:"g roup_mascara_grid_detalhe";a:0:{}s:24:"group_forma to_data_outro";a:0:

  • #2
    Well, there's something wrong in the packed array, but you probabely have expected that. If sync doesn't work, try to add a custom field and the resync. Sometimes adding a field recovers the wrong entry. It worked for me once...
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Hello,

      Which database you used for this error to occur? Could you provide the step by step of the synchronization (like simulating the error).

      Thank you!
      Best regards,
      Thomas Soares.
      ScriptCase International.

      Email: t.soares@scriptcase.net
      Visit our Blog: http://www.scriptcase.net/blog/
      Visit out fan page: http://www.facebook.com/Scriptcase

      Comment


      • #4
        Originally posted by Thomas Soares View Post
        Hello,

        Which database you used for this error to occur? Could you provide the step by step of the synchronization (like simulating the error).

        Thank you!
        The DB is mysql, sorry but I ended up starting a new form, was a very important form within the project and had spent so much time trying to resolve it.
        Kinda seems like a waste now as I cant even deploy the dam project.

        Comment


        • #5
          Hi Jamie,

          Why are you unable to deploy? Have you tried to deploy to a zip file?

          regards,
          Bernhard Bernsmann

          Comment

          Working...
          X