Tried installing my 1.5.13 cart with 1.5.2 on my localhost server and after hitting the upgrade button got:
Code: Select all
Could not Execute: CREATE TABLE order_fraud ( order_id int(11) NOT NULL DEFAULT 0 COMMENT '', customer_id int(11) NOT NULL DEFAULT 0 COMMENT '', country_match varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, country_code varchar(2) NOT NULL COMMENT '' COLLATE utf8_bin, high_risk_country varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, distance int(11) NOT NULL DEFAULT 0 COMMENT '', ip_region varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_city varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_latitude decimal(10,6) NOT NULL COMMENT '', ip_longitude decimal(10,6) NOT NULL COMMENT '', ip_isp varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_org varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_asnum int(11) NOT NULL DEFAULT 0 COMMENT '', ip_user_type varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_country_confidence varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, ip_region_confidence varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, ip_city_confidence varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, ip_postal_confidence varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, ip_postal_code varchar(10) NOT NULL COMMENT '' COLLATE utf8_bin, ip_accuracy_radius int(11) NOT NULL DEFAULT 0 COMMENT '', ip_net_speed_cell varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_metro_code int(3) NOT NULL DEFAULT 0 COMMENT '', ip_area_code int(3) NOT NULL DEFAULT 0 COMMENT '', ip_time_zone varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_region_name varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_domain varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_country_name varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, ip_continent_code varchar(2) NOT NULL COMMENT '' COLLATE utf8_bin, ip_corporate_proxy varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, anonymous_proxy varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, proxy_score int(3) NOT NULL DEFAULT 0 COMMENT '', is_trans_proxy varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, free_mail varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, carder_email varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, high_risk_username varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, high_risk_password varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, bin_match varchar(10) NOT NULL COMMENT '' COLLATE utf8_bin, bin_country varchar(2) NOT NULL COMMENT '' COLLATE utf8_bin, bin_name_match varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, bin_name varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin, bin_phone_match varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, bin_phone varchar(32) NOT NULL COMMENT '' COLLATE utf8_bin, customer_phone_in_billing_location varchar(8) NOT NULL COMMENT '' COLLATE utf8_bin, ship_forward varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, city_postal_match varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, ship_city_postal_match varchar(3) NOT NULL COMMENT '' COLLATE utf8_bin, score decimal(10,5) NOT NULL COMMENT '', explanation text NOT NULL COMMENT '' COLLATE utf8_bin, risk_score decimal(10,5) NOT NULL COMMENT '', queries_remaining int(11) NOT NULL DEFAULT 0 COMMENT '', maxmind_id varchar(8) NOT NULL COMMENT '' COLLATE utf8_bin, error text NOT NULL COMMENT '' COLLATE utf8_bin, date_added datetime NOT NULL DEFAULT 0000-00-00 00:00:00 COMMENT '', PRIMARY KEY (order_id) ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-00-00 00:00:00 COMMENT '', PRIMARY KEY (order_id) ) DEFAULT CHARSET=utf8 CO' at line 54
I'm no expert on MYSQL so I have no idea what that means.