[GitHub] Basit-qc opened a new issue #5199: template_params is not being migrated in the DB

[GitBox <gi...@apache.org>]

Basit-qc opened a new issue #5199: template_params is not being migrated in the DB
URL: https://github.com/apache/incubator-superset/issues/5199
 
 
   I am adding a new viz and added its data in `data/__init__.py`. I was loading data from console as
   ``` 
   from superset import cli
   cli.load_examples(False)
   ```
   It was working fine few days ago before new field was introduced (https://github.com/apache/incubator-superset/commit/af4dd59661291541a8fa82717d07a3f214c8bd2f). This field is not being migrated automatically. I have tried steps from https://superset.incubator.apache.org/installation.html#upgrading but no luck.
   
   ### Superset version
   0.25.6
   
   ### Expected results
   Example data should be loaded
   
   ### Actual results
   ```
   sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: tables.template_params [SQL: 'SELECT tables.created_on AS tables_created_on, tables.changed_on AS tables_changed_on, tables.id AS tables_id, tables.description AS tables_description, tables.default_endpoint AS tables_default_endpoint, tables.is_featured AS tables_is_featured, tables.filter_select_enabled AS tables_filter_select_enabled, tables."offset" AS tables_offset, tables.cache_timeout AS tables_cache_timeout, tables.params AS tables_params, tables.perm AS tables_perm, tables.table_name AS tables_table_name, tables.main_dttm_col AS tables_main_dttm_col, tables.database_id AS tables_database_id, tables.fetch_values_predicate AS tables_fetch_values_predicate, tables.user_id AS tables_user_id, tables.schema AS tables_schema, tables.sql AS tables_sql, tables.is_sqllab_view AS tables_is_sqllab_view, tables.template_params AS tables_template_params, tables.changed_by_fk AS tables_changed_by_fk, tables.created_by_fk AS tables_created_by_fk \nFROM tables \nWHERE tables.table_name = ?\n LIMIT ? OFFSET ?'] [parameters: ('loads', 1, 0)] (Background on this error at: http://sqlalche.me/e/e3q8)
   ```
   
   ### Steps to reproduce
   Run from command line
   ```
   from superset import cli
   cli.load_examples(False)
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org