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 */
got "-bash: !40100: event not found"
Did I misunderstand the query to run?
Thanks to both of you.
Lanny
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.
Change the version, the result will be expect
2010/3/14 Michel Morelli michel@ziobuddalabs.it
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@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@ziobuddalabs.it JABBER: michel@ziobuddalabs.it
-- [ Drupal support list | http://lists.drupal.org/ ]
Lanny Trager wrote:
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 */
I've never used drush but this can be done easily in your SQL client.
$ mysql -u root -p mysql> use mydb mysql> CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL mysql> DEFAULT '', `value` VARCHAR(255) NOT NULL DEFAULT '', `expire` mysql> DOUBLE NOT NULL, PRIMARY KEY (name), INDEX expire (expire) ) /*!40100 mysql> DEFAULT CHARACTER SET UTF8 */;
You can also put the DB command in a sql script, say myscript.sql for example, and then source the script into your sql client.