Table 'ft_module_data_visualizations' doesn't exist

pourfallah commented 7 years ago

when i want to create a visualization, it's make error: Table 'xxx.ft_module_data_visualizations' doesn't exist how i can fix this ?

pourfallah commented 7 years ago

if the table won't created automatically, you can run this query to make that table:


        CREATE TABLE module_data_visualizations (
        vis_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
        vis_name varchar(255) NOT NULL,
        vis_type enum('activity','field') NOT NULL,
        chart_type enum('line_chart','area_chart','column_chart','bar_chart','pie_chart') NOT NULL,
        form_id mediumint(9) NOT NULL,
        view_id mediumint(9) DEFAULT NULL,
        field_id mediumint(9) DEFAULT NULL,
        access_type enum('admin','public','private') NOT NULL DEFAULT 'public',
        access_view_mapping enum('all','except','only') NOT NULL DEFAULT 'all',
        access_views mediumtext NOT NULL,
        cache_update_frequency varchar(8) NOT NULL,
        date_range varchar(20) DEFAULT NULL,
        submission_count_group enum('year','month','week','day') DEFAULT NULL,
        colour varchar(10) DEFAULT NULL,
        line_width tinyint(4) DEFAULT NULL,
        field_chart_ignore_empty_fields enum('yes','no') DEFAULT NULL,
        pie_chart_format enum('2D','3D') DEFAULT NULL,
        include_legend_quicklinks enum('yes','no') DEFAULT NULL,
        include_legend_full_size enum('yes','no') DEFAULT NULL,
        PRIMARY KEY (vis_id)
        ) DEFAULT CHARSET=utf8  

        CREATE TABLE module_data_visualization_cache (
        vis_id mediumint(8) unsigned NOT NULL,
        last_cached datetime NOT NULL,
        data mediumtext NOT NULL,
        PRIMARY KEY (vis_id)
        ) DEFAULT CHARSET=utf8

        CREATE TABLE module_data_visualization_clients (
        vis_id mediumint(8) unsigned NOT NULL,
        account_id mediumint(8) unsigned NOT NULL,
        PRIMARY KEY (vis_id,account_id)
        ) DEFAULT CHARSET=utf8

this queris can find in global/code/module.php file.

pourfallah commented 7 years ago

you must change the folder name of this module to data_visualization before install it. this make module installer make correctly.

benkeen commented 6 years ago

Sorry about the confusion with the folder names. I've updated all the README's on all repos to include a link to the installation instructions. That page mentions you need to rename the folder names.

formtools / module-data_visualization

Table 'ft_module_data_visualizations' doesn't exist #3