At the end of the import application, I have this message and nothing is imported
NSERT INTO sc_tbcmp (Cod_Prj, Versao, Cod_Apl, Seq, Login, 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, “;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:16:“text-align:left;”;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:“use_simbolo_moeda”;s:1:“N”;s:27:“usar_config_regional_filter”;s:1:“S”;s:29:“format_data_config_reg_filter”;s:0:"";s:17:“combine_date_time”;s:1:“S”;s:18:“validate_with_mask”;s:1:“N”;s:13:“disable_field”;s:1:“N”;s:15:“date_combo_year”;s:1:“N”;s:19:“date_combo_year_ini”;s:4:“1901”;s:19:“date_combo_year_end”;s:2:“10”;s:21:“simbolo_moeda_usuario”;s:1:"$";s:16:“show_number_week”;s:1:“S”;s:22:“show_additional_months”;s:0:"";s:21:“show_combo_year_month”;s:1:“S”;s:19:“option_new_calendar”;s:1:“S”;s:15:“option_new_calc”;s:1:“S”;s:19:“option_new_cor_html”;s:1:“S”;s:16:“option_calc_type”;s:1:“P”;s:15:“checked_all_col”;s:1:“S”;s:9:“qr_margin”;i:1;s:7:“qr_size”;i:2;s:14:“qr_error_level”;i:0;s:8:“spin_use”;s:1:“N”;s:9:“spin_step”;i:1;s:12:“spin_pg_step”;i:5;s:22:“use_dd_checkbox_jquery”;s:1:“N”;s:14:“use_timepicker”;s:1:“N”;s:18:“dd_checkbox_height”;s:3:“150”;s:15:“ext_permissions”;s:0:"";s:14:“campo_url_link”;s:1:“N”;s:16:“campo_url_target”;s:6:"_blank";s:20:“campo_url_targetname”;s:0:"";s:19:“resumo_formato_graf”;s:0:"";s:9:“graf_tipo”;s:0:"";s:12:“graf_groupby”;s:1:“S”;s:12:“graf_largura”;s:3:“800”;s:11:“graf_altura”;s:3:“600”;s:14:“graf_order_val”;s:0:"";s:11:“chartpallet”;s:1:“1”;s:11:“schemachart”;s:0:"";s:21:“flsh_chrt_barra_orien”;s:8:“Vertical”;s:27:“flsh_chrt_barra_orien_value”;s:10:“Horizontal”;s:30:“flsh_chrt_barra_position_value”;s:5:“acima”;s:21:“flsh_chrt_barra_forma”;s:3:“Bar”;s:21:“flsh_chrt_barra_dimen”;s:2:“3d”;s:21:“flsh_chrt_barra_sobre”;s:2:“No”;s:21:“flsh_chrt_barra_empil”;s:3:“Off”;s:21:“flsh_chrt_barra_inver”;s:6:“Normal”;s:21:“flsh_chrt_barra_agrup”;s:6:“Normal”;s:21:“flsh_chrt_pizza_forma”;s:3:“Pie”;s:21:“flsh_chrt_pizza_dimen”;s:2:“3d”;s:21:“flsh_chrt_pizza_orden”;s:3:“Off”;s:21:“flsh_chrt_pizza_explo”;s:3:“Off”;s:21:“flsh_chrt_pizza_valor”;s:5:“Valor”;s:21:“flsh_chrt_linha_forma”;s:4:“Line”;s:21:“flsh_chrt_linha_inver”;s:6:“Normal”;s:21:“flsh_chrt_linha_agrup”;s:6:“Normal”;s:20:“flsh_chrt_area_forma”;s:4:“Area”;s:20:“flsh_chrt_area_empil”;s:3:“Off”;s:20:“flsh_chrt_area_inver”;s:6:“Normal”;s:20:“flsh_chrt_areta_outro”;s:0:"";s:12:“busca_opcoes”;s:54:“eq,N;ii,N;qp,N;df,N;np,N;gt,N;ge,N;lt,N;le,N;bw,N;in,N”;s:16:“url_outra_pagina”;s:0:"";s:13:“moeda_simbolo”;s:3:"?";s:13:“valor_extenso”;s:1:“N”;s:21:“valor_extenso_tamanho”;s:1:“0”;s:15:“bar_code_altura”;s:1:“0”;s:16:“bar_code_largura”;s:1:“0”;s:14:“bar_code_fonte”;s:1:“0”;s:13:“tipo_password”;s:1:“N”;s:13:“imagem_altura”;s:1:“0”;s:14:“imagem_largura”;s:1:“0”;s:11:“texto_fonte”;s:0:"";s:13:“texto_tamanho”;s:0:"";s:9:“texto_cor”;s:0:"";s:9:“cor_fundo”;s:0:"";s:13:“texto_italico”;s:1:“N”;s:10:“texto_bold”;s:1:“N”;s:17:“texto_alinhamento”;s:1:“1”;s:13:“texto_formata”;s:4:“NADA”;s:12:“texto_nowrap”;s:1:“N”;s:12:“cons_largura”;i:11;s:16:“separador_string”;s:1:";";s:11:“edit_altura”;s:1:“0”;s:14:“edit_multiplas”;s:1:“N”;s:9:“calculado”;s:1:“N”;s:13:“texto_colunas”;s:1:“0”;s:12:“mostra_zeros”;s:1:“S”;s:14:“casas_decimais”;i:0;s:11:“graf_visual”;s:1:“0”;s:14:“xml_formatacao”;s:0:"";s:11:“data_minimo”;s:10:“0000-00-00”;s:11:“data_maximo”;s:10:“0000-00-00”;s:13:“graf_sumariza”;s:1:“N”;s:11:“graf_quebra”;a:0:{}s:17:“lookup_cons_entra”;s:1:“3”;s:18:“texto_valinhamento”;s:1:“1”;s:12:“imagem_fundo”;s:0:"";s:16:“img_outra_pagina”;s:1:“S”;s:11:“img_aspecto”;s:1:“S”;s:12:“imagem_borda”;s:1:“0”;s:11:“cell_height”;s:1:“0”;s:17:“data_minimo_opcao”;s:1:“0”;s:17:“data_maximo_opcao”;s:1:“0”;s:15:“data_minimo_exp”;s:0:"";s:15:“data_maximo_exp”;s:0:"";s:18:“titulo_alinhamento”;s:1:“1”;s:15:“lookup_original”;s:1:“N”;s:18:“lookup_delimitador”;s:3:" - “;s:15:“quebra_sumariza”;a:0:{}s:12:“quebra_count”;a:0:{}s:23:“titulo_alinhamento_vert”;s:1:“2”;s:15:“busca_recarrega”;s:1:“N”;s:14:“liga_busca_apl”;s:0:”";s:14:“liga_busca_cmp”;s:0:"";s:9:“qtd_bytes”;s:1:“0”;s:13:“quebra_pagina”;a:0:{}s:12:“quebra_exibe”;a:0:{}s:16:“char_col_largura”;s:1:“0”;s:12:“completa_esq”;s:0:"";s:17:“campo_relacionado”;s:1:“0”;s:16:“mascara_consulta”;s:0:"";s:13:“tamanho_banco”;i:11;s:14:“variavel_where”;s:1:“N”;s:20:“fld_group_org_campos”;a:0:{}s:14:“fld_group_cols”;a:0:{}s:21:“fld_group_exibe_label”;a:0:{}s:23:“fld_group_linha_sum_res”;a:0:{}s:23:“fld_group_msg_linha_sum”;a:0:{}s:30:“fld_group_graf_group_new_title”;a:0:{}s:35:“fld_group_graf_group_title_show_val”;a:0:{}s:28:“fld_group_quebra_pag_pdf_res”;a:0:{}s:30:“fld_group_quebra_pag_html_cons”;a:0:{}s:29:“fld_group_quebra_pag_html_res”;a:0:{}s:16:“fld_group_campos”;a:0:{}s:20:“show_upload_progress”;s:1:“S”;s:16:“show_upload_zone”;s:1:“S”;s:11:“mu_qtd_cols”;i:1;s:13:“mu_pos_delete”;s:6:“beside”;s:16:“mu_pos_on_upload”;s:5:“above”;s:14:“mu_show_status”;s:7:“img_txt”;s:8:“mu_table”;s:0:"";s:9:“mu_fields”;a:0:{}s:14:“campo_url_link”;s:1:“S”;s:16:“campo_url_target”;s:6:"_blank";s:13:“graf2_aspecto”;s:1:“S”;}’)columns Cod_Prj, Versao, Cod_Apl, Campo are not unique
Are you importing and export SC7->SC7? SC7->SC8? It’s an export or a bakcup??
I think that this is an attempt to restore from backup. Obviously there’s something wrong the the unserialize. But what… Only SC can tell.
Hello Mr,
Can you send the backup with problem to the email: r.alves@scriptcase.net.
I’ll do a verification and tell you a feedback.
Thank you.
Hi Alves,
I got similar problem from restoring my backup file. (7.01.0021)
May i know what’s the solution ? or do you want me to email my backup to you as well ?
Please share if possible so others can benefit.
Thank’s & regards
For my case, importing datas from export project won’t restore it properly.
However, importing datas from export project->export applications is fine.
My advise to everyone is to backup using export project & export applications.
Better be safe than sorry.
I recommend to create a full system (like cobian, or similar) backup including all directories too. Then it’s a matter of a full restore to get things back online, although it has the disadvantage that you will rollback all projects.
Good advise aducom.
But i urge scriptcase to look into this matter seriously.
[QUOTE=kakibox;28195]Good advise aducom.
But i urge scriptcase to look into this matter seriously.[/QUOTE]
No question about that.
As an old guy I have loads of experiences of failing backup procedures. Even in high volume environments. That’s why I only trust a full backup. Scriptcase is storing it’s data in a sqlite database with a lot of serialized data. If that gets broken you are in trouble.
I had the same problem migrating from version 7 to version 8.
You can easily identify the record with the given compromise just reading sequentially the tables “sc_tbapl” and “sc_tbcmp” and trying to execute the command “unserialize” for each field that contains the serialized data.
I use MySql, not SqlLite.
$my_array = array();
if (!$testfield == NULL )
{
$my_array = unserialize($testfield);
if (!is_array($my_array)) {
// qualcosa non ha funzionato, si predispone un array vuoto
{dfCheck} = ‘ERRORE’;
}
}
Hope this help