[support] Failed Upgrade to 6.16

[Luke]

On Sun, 14 Mar 2010, Lanny Trager wrote:

> Maybe I've been at this too long today.  The following is what I'm running:
>
> drush sqlq CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL DEFAULT
> '', `value` VARCHAR(255) NOT NULL DEFAULT '', `expire` DOUBLE NOT NULL,
> PRIMARY KEY (name), INDEX expire (expire) )
>
> It returns, the following:
>
> -bash: syntax error near unexpected token `('
>
> I'm just not seeing the error of my ways.

You've forgotten (or never known?) that the shell processes all of those 
punctuations, before drush ever gets them to pass on.  In this case, all 
of the '' entries would have been skipped, and the `...` items would have 
been tried as commands to run.  However, it also interacts with the (...), 
which it sees as a subshell encapsulation, and that has priority, so it 
bombed at that level.

Try it this way:

drush sqlq 'CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL DEFAULT
"", `value` VARCHAR(255) NOT NULL DEFAULT "", `expire` DOUBLE NOT NULL,
PRIMARY KEY (name), INDEX expire (expire) )'

Luke