Announcement

Collapse
No announcement yet.

VERY URGENt PROBLEM RESTORING APP SCRIPTCASE 7

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

  • VERY URGENt PROBLEM RESTORING APP SCRIPTCASE 7

    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:"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:16:"t ext-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_t itle";s:0:"";s:8:"desc_eof";s:0:"";s:12:"date_disp lay";s:1:"S";s:18:"date_display_combo";s:1:"N";s:1 3:"lookup_filtro";s:1:"N";s:13:"lookup_limite";i:1 00;s:13:"lookup_inicio";s:1:"L";s:13:"lookup_campo s";s:0:"";s:12:"cep_onchange";s:1:"N";s:10:"liga_f orca";s:1:"N";s:11:"liga_insert";s:1:"R";s:12:"lig a_tamanho";i:700;s:14:"liga_cabecalho";s:1:"N";s:1 2:"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_s ubmit";s:1:"N";s:21:"show_filter_condition";s:1:"S ";s:23:"quebra_visu_label_fonte";a:0:{}s:22:"quebr a_visu_label_size";a:0:{}s:23:"quebra_visu_label_c olor";a:0:{}s:25:"quebra_visu_label_bgcolor";a:0:{ }s:25:"quebra_visu_label_negrito";a:0:{}s:23:"queb ra_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:"quebr a_visu_campo_negrito";a:0:{}s:20:"tot_linha_visu_f onte";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:"to t_linha_visu_campo_size";s:0:"";s:26:"tot_linha_vi su_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_lin ha_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:1 7:"combine_date_time";s:1:"S";s:18:"validate_with_ mask";s:1:"N";s:13:"disable_field";s:1:"N";s:15:"d ate_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_numb er_week";s:1:"S";s:22:"show_additional_months";s:0 :"";s:21:"show_combo_year_month";s:1:"S";s:19:"opt ion_new_calendar";s:1:"S";s:15:"option_new_calc";s :1:"S";s:19:"option_new_cor_html";s:1:"S";s:16:"op tion_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:"q r_error_level";i:0;s:8:"spin_use";s:1:"N";s:9:"spi n_step";i:1;s:12:"spin_pg_step";i:5;s:22:"use_dd_c heckbox_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_u rl_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_al tura";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:"fl sh_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:"fls h_chrt_barra_agrup";s:6:"Normal";s:21:"flsh_chrt_p izza_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_c hrt_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:"Norma l";s:20:"flsh_chrt_area_forma";s:4:"Area";s:20:"fl sh_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_o utra_pagina";s:0:"";s:13:"moeda_simbolo";s:3:"";s :13:"valor_extenso";s:1:"N";s:21:"valor_extenso_ta manho";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_form ata";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_coluna s";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:"xm l_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:"tex to_valinhamento";s:1:"1";s:12:"imagem_fundo";s:0:" ";s:16:"img_outra_pagina";s:1:"S";s:11:"img_aspect o";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:"ti tulo_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_e xibe";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_b anco";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_gr oup_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:3 0:"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_po s_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

  • #2
    Are you importing and export SC7->SC7? SC7->SC8? It's an export or a bakcup?
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      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.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        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.
        --
        ScriptCase Team

        Comment


        • #5
          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

          Comment


          • #6
            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.

            Comment


            • #7
              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.
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Good advise aducom.

                But i urge scriptcase to look into this matter seriously.

                Comment


                • #9
                  Originally posted by kakibox View Post
                  Good advise aducom.

                  But i urge scriptcase to look into this matter seriously.
                  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.
                  Albert Drent
                  aducom software netherlands
                  scriptcase partner, reseller, support and (turn-key) development
                  www.scriptcase.eu / www.scriptcase.nl

                  Comment


                  • #10
                    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
                    Giorgio Bravi
                    Dolphin Software & Thinkware
                    www.dolphin.it

                    Comment

                    Working...
                    X