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. -- 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
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/ ]
-- Att, João Gustavo Taveira Analista de Sistemas II Peopleware Tecnologia “Tecnologia começa com gente.“ Qualidade | Criatividade | Responsabilidade | Ética | Comprometimento Fone:(21) 8208-4688 / (21) 8160-1302
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. -- Earnie -- http://www.for-my-kids.com
participants (4)
-
Earnie Boyd -
João Gustavo Taveira -
Lanny Trager -
Michel Morelli