Unable to plot additional PIDs

[artesea]

I've enabled PID kff1201 - Miles Per Gallon(Instant). It's being stored in the raw_logs, however it's not available to plot.
Looking at the source code the issue appears to be that the column is created as a VARCHAR(255), whilst get_columns.php is only looking for FLOATS.
Changing the column type to a FLOAT through MySQL fixes this issue, however as there is no Column Comment the description isn't pulled through.
Either the column comment should be added at the same time as the column, or the description should be pulled from the csv each time.

[rcompton]

I've noticed the same thing. Manually entering kff1201 into the url bar works but I don't see MPG in the dropdown menu.

[Coppan]

I changed the type from char to float with phpmyadmin and set "comment" manually. It seems that all new columns are created as chars and dont get listed in the pulldown menu.

[smackYYZ]

TO fix this I altered upload_data.php

I replaced:

$sqlalter = "ALTER TABLE $db_table ADD $key VARCHAR(255) NOT NULL default '0'";

With:

if (preg_match("/^k/", $key)) {
$sqlalter = "ALTER TABLE $db_table ADD $key float NOT NULL default '0' comment '$key'";
} else {
$sqlalter = "ALTER TABLE $db_table ADD $key VARCHAR(255) NOT NULL default '0'";
}

Then when I see a new value in the selector, I just alter and run this query :

alter table raw_logs modify COLUMN columnName comment 'RealName';