Changes to how cxtracker.pl stores sessions in MySQL

[gamelinux]

Change from using:

MERGE and MyISAM
to
VIEW and InnoDB

[wmesser]

See patchfile in Issue #13

[wmesser]

DBD::mysql::st execute failed: Column 'sid' in field list is ambiguous at bin/cxtracker2db.pl line 684, <FILE> line 1.

I think we only get this when having multiple tables. It's got to be something I did wrong in the way the VIEW is created.

Putting it here for easier tracking for the time being.

[wmesser]

This may be a stupid question, but where is that value of 'sid' even coming from? It's not in the stats files. We already have a session ID. Is sid just the hostname? If so, it is definitely not supposed to be numeric.

[wmesser]

I changed it to VARCHAR(255), and it's at least logging the hostname correctly, but it's still 'ambiguous' and bug persists.