[support] Failed Upgrade to 6.16

[Michel Morelli]

Lanny Trager ha scritto:
> Jim,
>
> I've run update several times with all but the core modules disabled no 
> luck.
>
> Ernie,
>
> Ran 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) ) /*!40100 DEFAULT 
> CHARACTER SET UTF8 */
>   

You need to use "


"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) ) /*!40100 DEFAULT 
CHARACTER SET UTF8 */"

If this does not works try to substitute !40100 with \!40100

If this does not works try to remove all from /* to */


> got "-bash: !40100: event not found"
>
> Did I misunderstand the query to run?
>   
No, but in unix OS !40100 means "exec the 40100th command in the shell 
history".

M.

-- 
Michel 'ZioBudda' Morelli                       michel at ziobuddalabs.it
Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)
Telefono: 0200619074
Telefono Cell: +39-3939890025 --  Fax: +39-0291390660

http://www.ziobudda.net                         ICQ: 58351764  
http://www.ziobuddalabs.it                      Skype: zio_budda
http://www.ziodrupal.net       			MSN: michel at ziobuddalabs.it                   
						JABBER: michel at ziobuddalabs.it