Dear all,

I am having the same problem as Linda with a fresh installation of version 20130603.
In the thread of her mail Dannon Baker said :

"That said, this doesn't resolve the mysql index issues, which I'm currently working on.  I hope to have a fix for them available soon, though."

I would like to know if what is the status of this thread. Should I use the solution provided in Linda's mail (CREATE INDEX ix_history_slug ON history (slug(1000));)

Thx a lot for your help

Best

Jean-François

On 06/05/2013 05:12 PM, Linda Cham wrote:

Hi.   I am new to the Galaxy forum and I am trying to setup a new local Galaxy instance with MySQL on RH6.2 x86_64.

On a newly installed OS node, using the hg clone command (hg clone https://bitbucket.org/galaxy/galaxy-dist#stable) which gets the current Galaxy 20130603 image, I am getting the following errors when running run.sh:
  File "build/bdist.linux-x86_64-ucs4/egg/MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)
  File "build/bdist.linux-x86_64-ucs4/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (OperationalError) (1170, "BLOB/TEXT column 'slug' used in key specification without a key length") 'CREATE INDEX ix_history_slug ON history (slug)' ()

Reading the forum, someone stated it can be bypass by running the CREATE INDEX.

mysql> CREATE INDEX ix_history_slug ON history (slug(1000));
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0

-- 
#####################################
Jean-François Taly
Bioinformatician

Bioinformatics Core Facility
http://biocore.crg.cat
CRG - Centre de Regulació Genòmica (Room 439)
Parc de Recerca Biomèdica de Barcelona (PRBB)
Doctor Aiguader, 88
08003 Barcelona
Spain

email: jean-francois.taly@crg.eu
phone: +34 93 316 0202
fax: +34 93 316 0099
#####################################

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/