chan0019s

How can I export the data from our old installation and import to our new fresh installation? We decided to create a fresh install because our previous worker did many changes on the database.. Thanks!

Okay, thank you very much for your replies..

Can you tell me what are those indices?

Im getting this error message when I run upgrade: - database integrity check detected problems with the database - 2 indexes to remove - 2 indexes to ad Here is the install.log ========================================================================= Attempting to detect an existing Openads (aka. phpAdsNew) installation... PAN not detected Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation... MMM v0.1 not detected Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation... MMM v0.3 not detected Attempting to detect an existing Revive Adserver installation... schema file found: /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml schema definition from cache TRUE successfully parsed the schema schema name: openads schema version: 613 schema status: final running integrity check comparing database rogerb_open791 with schema /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con index missing from table: data_summary_zone_impression_history.operation_interval_id table is not part of schema: banner_vast_element table is not part of schema: data_bkt_a table is not part of schema: data_bkt_a_var table is not part of schema: data_bkt_c table is not part of schema: data_bkt_m table is not part of schema: data_bkt_r table is not part of schema: data_bkt_vast_e table is not part of schema: database_action table is not part of schema: stats_vast table is not part of schema: upgrade_action to version: 613 timing: constructive target database: rogerb_open791 table prefix: ox_ successfully initialised DB Upgrade verifying/creating constructive tasklist task found: doRemoveIndex__data_intermediate_ad_variable_value__data_intermediate_ad_ task found: doRemoveIndex__data_summary_zone_impression_history__operation_interval_i task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id #! database integrity check detected problems with the database #! 2 indexes to remove #! 2 indexes to add Starting file-check for plugins... Finished file-check for plugins Starting file-check for plugins... Finished file-check for plugins Starting file-check for plugins... Finished file-check for plugins Starting file-check for plugins... Finished file-check for plugins ========================================================================= Attempting to detect an existing Openads (aka. phpAdsNew) installation... PAN not detected Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation... MMM v0.1 not detected Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation... MMM v0.3 not detected Attempting to detect an existing Revive Adserver installation... schema file found: /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml schema definition from cache TRUE successfully parsed the schema schema name: openads schema version: 613 schema status: final running integrity check comparing database rogerb_open791 with schema /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con index missing from table: data_summary_zone_impression_history.operation_interval_id table is not part of schema: banner_vast_element table is not part of schema: data_bkt_a table is not part of schema: data_bkt_a_var table is not part of schema: data_bkt_c table is not part of schema: data_bkt_m table is not part of schema: data_bkt_r table is not part of schema: data_bkt_vast_e table is not part of schema: database_action table is not part of schema: stats_vast table is not part of schema: upgrade_action to version: 613 timing: constructive target database: rogerb_open791 table prefix: ox_ successfully initialised DB Upgrade verifying/creating constructive tasklist task found: doRemoveIndex__data_intermediate_ad_variable_value__data_intermediate_ad_ task found: doRemoveIndex__data_summary_zone_impression_history__operation_interval_i task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id #! database integrity check detected problems with the database #! 2 indexes to remove #! 2 indexes to add Starting file-check for plugins... Finished file-check for plugins How can I proceed and complete the upgrade process?