ocmaster85

Hmmm thanks for the link Iorro, but still get this:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CREATE TABLE wp_woocommerce_tax_rate_locations ( location_id bigint(20) NOT NUL’ at line 2

What seems to be the problem here.. ? 🙁

USE mydatabase
CREATE TABLE wp_woocommerce_tax_rate_locations (
location_id bigint(20) NOT NULL,
location_code varchar(255) NOT NULL,
tax_rate_id bigint(20) NOT NULL,
location_type varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Same issue…
But when i try to enter the Query into MySQL admin – new Query i get the following error..

Error

SQL query: 

USE [mydatabase] CREATE TABLE wp_woocommerce_tax_rate_locations(

location_id bigint( 20 ) NOT NULL ,

MySQL said: Documentation
 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE wp_woocommerce_tax_rate_locations (
 location_id bigint(20) NOT NU' at line 2

I just did a copy paste of the Query in this tread:

changed to my DB name off course 🙂

USE [mydatabase]
CREATE TABLE <code>wp_woocommerce_tax_rate_locations</code>
(
location_id bigint(20) NOT NULL,
location_code varchar(255) NOT NULL,
tax_rate_id bigint(20) NOT NULL,
location_type varchar(40) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

What am i doing wrong here – please help.. 🙁