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 :slight_smile:

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:“altura_ajax”;s:2:“10”;s:11:“delimitador”;s:0:"";s:11:“desl_global”;s:0:"";s:6:“titulo”;s:0:"";s:11:“titulo_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:10:“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_peri_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:“connection”;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:“onFocus”;a:2:{s:11:“usar_campos”;s:1:“N”;s:6:“campos”;a:0:{}}s:6:“onBlur”;a:2:{s:11:“usar_campos”;s:1:“N”;s:6:“campos”;a:0:{}}}s:20:“ajax_dados_usar_ajax”;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:“banco_val_tipo_upd”;s:0:"";s:19:“banco_val_valor_upd”;s:0:"";s:15:“valida_condicao”;s:0:"";s:12:“valida_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_exec_ord”;i:0;s:9:“jump_menu”;s:0:"";s:13:“erro_mensagem”;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_radio”;s:1:“N”;s:11:“exec_submit”;s:4:“SSNN”;s:12:“field_filter”;s:1:“N”;s:13:“form_val_tipo”;s:0:"";s:14:“image_html_img”;s:0:"";s:21:“image_html_img_border”;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:“lookup_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:“fil_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:“liga_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_cons_btn_nav”;s:0:"";s:10:“css_celula”;s:0:"";s:8:“css_form”;s:0:"";s:17:“css_titulo_filtro”;s:0:"";s:16:“css_campo_filtro”;s:0:"";s:17:“css_objeto_filtro”;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_filtro”;s:1:“N”;s:13:“lookup_limite”;i:100;s:13:“lookup_inicio”;s:1:“L”;s:13:“lookup_campos”;s:0:"";s:12:“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_posicao”;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:“image_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:“quebra_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_visu_color”;a:0:{}s:22:“tot_linha_visu_bgcolor”;a:0:{}s:22:“tot_linha_visu_negrito”;a:0:{}s:26:“tot_linha_visu_campo_fonte”;s:0:"";s:25:“tot_linha_visu_campo_size”;s:0:"";s:26:“tot_linha_visu_campo_color”;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_geral_linha_visu_size”;s:0:"";s:26:“tot_geral_linha_visu_color”;s:0:"";s:28:“tot_geral_linha_visu_bgcolor”;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_underline”;s:1:“N”;s:13:“subselect_seq”;i:0;s:16:“subselect_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@bi_este_mes@NM@bi_ult_mes";s:19:“editor_html_toolbar”;s:247:“bold_BT_italic_BT_underline_BT_strikethrough_BT_justifyleft_BT_justifycenter_BT_justifyright_BT_justifyfull_BT_bullist_BT_numlist_BT_undo_BT_redo_BT_fontselect_BT_fontsizeselect_BT_forecolor_BAR_tablecontrols_BT_link_BT_unlink_BT_emotions_BT_image”;s:19:“editor_html_qtd_bar”;i:2;s:19:“editor_html_pos_bar”;s:3:“top”;s:21:“editor_html_align_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_cor_margem”;s:0:"";s:15:“graf_cor_labels”;s:0:"";s:13:“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:11:“graf_angulo”;i:45;s:18:“editor_html_height”;i:0;s:13:“conn_lkp_cons”;s:0:"";s:20:“usar_config_regional”;s:1:“S”;s:16:“simbolo_negativo”;s:1:"-";s:22:“formato_moeda_positivo”;s:1:“3”;s:22:“formato_moeda_negativo”;s:0:"";s:20:“formato_num_negativo”;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:“show_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_param”;s:0:"";s:17:“youtube_exib_mode”;s:5:“modal”;s:18:“youtube_exib_width”;i:0;s:19:“youtube_exib_height”;i:0;s:17:“youtube_link_text”;s:0:"";s:16:“youtube_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_longitude”;s:0:"";s:18:“googlemaps_geocode”;a:0:{}s:20:“googlemaps_exib_mode”;s:5:“modal”;s:16:“googlemaps_width”;i:0;s:17:“googlemaps_height”;i:0;s:15:“googlemaps_zoom”;i:14;s:18:“googlemaps_api_key”;s:0:"";s:20:“googlemaps_link_text”;s:0:"";s:19:“googlemaps_opt_link”;s:3:“txt”;s:20:“googlemaps_mark_desc”;s:0:"";s:26:“group_usar_config_regional”;a:0:{}s:28:“group_format_data_config_reg”;a:0:{}s:26:“group_mascara_grid_detalhe”;a:0:{}s:24:“group_formato_data_outro”;a:0:

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…

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!

[QUOTE=Thomas Soares;28893]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![/QUOTE]

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.

Hi Jamie,

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

regards,
Bernhard Bernsmann