SQL ERROR: Can't find column definitions!

##</code><code>##

# Associate our csv disk file with the table name 'results'
$dbh->{'csv_tables'}->{'info'} = { 'file' => "psinfooutputfile.csv"};
$dbh->{'csv_tables'}->{'disks'} = { 'file' => "disk_results.csv"};
$dbh->{'csv_tables'}->{'hosts'} = { 'file' => "netbiosoutputfile.csv"};
$dbh->{'csv_tables'}->{'hosts'} = { 'file' => "template.csv"};

######
$dbh->do("DROP TABLE IF EXISTS template");

$dbh->do("CREATE TABLE template (IP CHAR(64), ServerName CHAR(64), Domain CHAR(64), DaysUptime CHAR(64), OS CHAR(64), RAM CHAR(64), OSSP CHAR(64), InstallDate CHAR(64), CPUSpeed CHAR(64), CPUCount CHAR(64), CPUType CHAR(64))
        AS SELECT IP, ServerName, Domain, DaysUptime, OS, RAM, OSSP, InstallDate
, CPUSpeed, CPUCount, CPUType
        FROM hosts
        LEFT JOIN info ON hosts.IP = info.IP ");