#SET SQL_MODE = "ALLOW_INVALID_DATES";
UPDATE tax_class SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE admin SET pwd_last_change_date = '0001-01-01 00:00:00' WHERE CAST(pwd_last_change_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE admin SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE admin SET last_login_date = '0001-01-01 00:00:00' WHERE CAST(last_login_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE admin SET last_failed_attempt = '0001-01-01 00:00:00' WHERE CAST(last_failed_attempt AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE admin_activity_log SET access_date = '0001-01-01 00:00:00' WHERE CAST(access_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE banners SET expires_date = NULL WHERE CAST(expires_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE banners SET date_scheduled = NULL WHERE CAST(date_scheduled AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE banners SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE banners SET date_status_change = NULL WHERE CAST(date_status_change AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE banners_history SET banners_history_date = '0001-01-01 00:00:00' WHERE CAST(banners_history_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE categories SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE categories SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE configuration SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE configuration SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupon_email_track SET date_sent = '0001-01-01 00:00:00' WHERE CAST(date_sent AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupon_gv_queue SET date_created = '0001-01-01 00:00:00' WHERE CAST(date_created AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupon_redeem_track SET redeem_date = '0001-01-01 00:00:00' WHERE CAST(redeem_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupons SET coupon_start_date = '0001-01-01 00:00:00' WHERE CAST(coupon_start_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupons SET coupon_expire_date = '0001-01-01 00:00:00' WHERE CAST(coupon_expire_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupons SET date_created = '0001-01-01 00:00:00' WHERE CAST(date_created AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE coupons SET date_modified = '0001-01-01 00:00:00' WHERE CAST(date_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE currencies SET last_updated = NULL WHERE CAST(last_updated AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE customers SET customers_dob = '0001-01-01 00:00:00' WHERE CAST(customers_dob AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE customers_info SET customers_info_date_of_last_logon = NULL WHERE CAST(customers_info_date_of_last_logon AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE customers_info SET customers_info_date_account_created = NULL WHERE CAST(customers_info_date_account_created AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE customers_info SET customers_info_date_account_last_modified = NULL WHERE CAST(customers_info_date_account_last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE email_archive SET date_sent = '0001-01-01 00:00:00' WHERE CAST(date_sent AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE featured SET featured_date_added = NULL WHERE CAST(featured_date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE featured SET featured_last_modified = NULL WHERE CAST(featured_last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE featured SET expires_date = '0001-01-01' WHERE CAST(expires_date AS CHAR(10)) = '0000-00-00';
UPDATE featured SET date_status_change = NULL WHERE CAST(date_status_change AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE featured SET featured_date_available = '0001-01-01' WHERE CAST(featured_date_available AS CHAR(10)) = '0000-00-00';
UPDATE geo_zones SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE geo_zones SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE group_pricing SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE group_pricing SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE manufacturers SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE manufacturers SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE manufacturers_info SET date_last_click = NULL WHERE CAST(date_last_click AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE newsletters SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE newsletters SET date_sent = NULL WHERE CAST(date_sent AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE orders SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE orders SET date_purchased = NULL WHERE CAST(date_purchased AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE orders SET orders_date_finished = NULL WHERE CAST(orders_date_finished AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE orders_status_history SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal SET payment_date = '0001-01-01 00:00:00' WHERE CAST(payment_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal_payment_status_history SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal_testing SET payment_date = '0001-01-01 00:00:00' WHERE CAST(payment_date AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal_testing SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE paypal_testing SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE product_type_layout SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE product_type_layout SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE product_types SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE product_types SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE products SET products_date_added = '0001-01-01 00:00:00' WHERE CAST(products_date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE products SET products_last_modified = NULL WHERE CAST(products_last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE products SET products_date_available = NULL WHERE CAST(products_date_available AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE products_notifications SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE project_version SET project_version_date_applied = '0001-01-01 01:01:01' WHERE CAST(project_version_date_applied AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE project_version_history SET project_version_date_applied = '0001-01-01 01:01:01' WHERE CAST(project_version_date_applied AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE reviews SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE reviews SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE salemaker_sales SET sale_date_start = '0001-01-01' WHERE CAST(sale_date_start AS CHAR(10)) = '0000-00-00';
UPDATE salemaker_sales SET sale_date_end = '0001-01-01' WHERE CAST(sale_date_end AS CHAR(10)) = '0000-00-00';
UPDATE salemaker_sales SET sale_date_added = '0001-01-01' WHERE CAST(sale_date_added AS CHAR(10)) = '0000-00-00';
UPDATE salemaker_sales SET sale_date_last_modified = '0001-01-01' WHERE CAST(sale_date_last_modified AS CHAR(10)) = '0000-00-00';
UPDATE salemaker_sales SET sale_date_status_change = '0001-01-01' WHERE CAST(sale_date_status_change AS CHAR(10)) = '0000-00-00';
UPDATE specials SET specials_date_added = NULL WHERE CAST(specials_date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE specials SET specials_last_modified = NULL WHERE CAST(specials_last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE specials SET expires_date = '0001-01-01' WHERE CAST(expires_date AS CHAR(10)) = '0000-00-00';
UPDATE specials SET date_status_change = NULL WHERE CAST(date_status_change AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE specials SET specials_date_available = '0001-01-01' WHERE CAST(specials_date_available AS CHAR(10)) = '0000-00-00';
UPDATE tax_class SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE tax_class SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE tax_rates SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE tax_rates SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE upgrade_exceptions SET errordate = NULL WHERE CAST(errordate AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE zones_to_geo_zones SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE zones_to_geo_zones SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';

UPDATE media_clips SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE media_clips SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE media_manager SET last_modified = '0001-01-01 00:00:00' WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE media_manager SET date_added = '0001-01-01 00:00:00' WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE music_genre SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE music_genre SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_artists SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_artists SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_artists_info SET date_last_click = NULL WHERE CAST(date_last_click AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_company SET date_added = NULL WHERE CAST(date_added AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_company SET last_modified = NULL WHERE CAST(last_modified AS CHAR(19)) = '0000-00-00 00:00:00';
UPDATE record_company_info SET date_last_click = NULL WHERE CAST(date_last_click AS CHAR(19)) = '0000-00-00 00:00:00';
