search

ModelSEED / Model-SEED-core

The Model SEED is a tool for building, curating, and analyzing gonome-scale metabolic models. Visit the Model SEED homepage for installation instructions and full feature documentation.
http://bionet.mcs.anl.gov/index.php/Model_SEED_Homepage
Other
19 stars 10 forks source link

mysql:Specified key was too long; max key length is 1000 #12

Closed raphyz closed 13 years ago

raphyz commented 13 years ago

I get the following error when running: CreateDBScheme.sh

PPO Generator: XML definition successfully read. [MySQL.pm 85]Transaction aborted: DBD::mysql::db do failed: Can't create database 'ModelDB'; database exists at /home/raphyz/Desktop/SHARE/phd/ModelSEED/lib/PPO/PPOBackend/MySQL.pm line 78. Creating database for PPO... failed. .. with Unable to connect to database backend. at /home/raphyz/Desktop/SHARE/phd/ModelSEED/lib/PPO/PPOGenerator.pm line 717.

It is probably related to the default charset defined on the machine, and the charset created when opening the connection with the database.

raphyz commented 13 years ago

problem was solved when I have changed the mysql charset from utf8 to latin1 in /eyc/my.cnf