Date Added

[MGBReg]

Date Added not showing on orders.

No issue showing in error log
1.4.3

Any Ideas?

Many Thanks
Paul

[abolabo]

To solve this issue run this sql in your phpMyAdmin.
Do not forget replace table prefix `ac_ with your's before run.

Code Select Expand

alter table `ac_ant_messages`
    modify `start_date` timestamp null;

alter table `ac_ant_messages`
    modify `viewed_date` timestamp null;

alter table `ac_banner_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_banners`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_block_descriptions`
    modify `date_added` timestamp default current_timestamp() not null;

alter table `ac_block_descriptions`
    modify `date_modified` timestamp default current_timestamp() not null on update current_timestamp();

alter table `ac_block_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_categories`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_collections`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_content_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_contents`
    drop primary key,
    MODIFY COLUMN `content_id` INT AUTO_INCREMENT PRIMARY KEY;

alter table `ac_coupons`
    modify `date_start` date null;

alter table `ac_coupons`
    modify `date_end` date null;

alter table `ac_coupons`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_coupons_categories`
    charset = utf8mb4;

alter table `ac_custom_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_custom_lists`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_transactions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customers`
    modify `telephone` varchar(32) default '' not null,
    modify `date_added` timestamp default current_timestamp() null,
    modify `last_login` timestamp null;
update `ac_customers` SET `date_added` = `date_modified` WHERE `date_added` = '0000-00-00 00:00:00';

alter table `ac_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_email_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_extensions`
    modify `date_installed` timestamp null;

alter table `ac_extensions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_global_attributes_type_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_language_definitions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_layouts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_length_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_locations`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_messages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_online_customers`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data_types`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_history`
    modify `date_added` timestamp default current_timestamp() null;

ALTER TABLE `ac_orders` MODIFY date_added timestamp default current_timestamp();
update `ac_orders` SET date_added = date_modified WHERE date_added = '0000-00-00 00:00:00';

alter table `ac_page_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_pages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_discounts`
    modify `date_start` date null;

alter table `ac_product_discounts`
    modify `date_end` date null;

alter table `ac_product_discounts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_specials`
    modify `date_start` date null;

alter table `ac_product_specials`
    modify `date_end` date null;

alter table `ac_product_specials`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_products`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_library`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_map`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_reviews`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_settings`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_details`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    modify `last_time_run` timestamp null;

alter table `ac_task_steps`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    engine = InnoDB;

alter table `ac_tasks`
    modify `last_time_run` timestamp null;

alter table `ac_tasks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_rates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_groups`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_users`
    modify `last_login` datetime null;

alter table `ac_users`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_weight_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_zones_to_locations`
    modify `date_added` timestamp default current_timestamp() null;

[MGBReg]

Thank You